TREE_MAINT_AET

index back

Tree Utilities State Record

Tree Utilities State Record

PeopleSoft Field NameField TypeColumn TypeDescription
PROCESS_INSTANCENumber(10,0)DECIMAL(10) NOT NULLProcess Instance
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
FUNCLIBCharacter(1)VARCHAR2(1) NOT NULLFunction Library
LOCK_ACQUIREDCharacter(1)VARCHAR2(1) NOT NULLLock Acquired

Y/N Table Edit

Default: N

VERSION_UPDATEDCharacter(1)VARCHAR2(1) NOT NULLVersion Number Updated
ABORT_PROCESS_FLAGCharacter(1)VARCHAR2(1) NOT NULLAbort Processing Flag
VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference
RUN_CNTL_IDCharacter(30)VARCHAR2(30) NOT NULLRun Control ID
TREE_UTILITY_TYPECharacter(2)VARCHAR2(2) NOT NULLTree Utility
00=Tree Audits
01=Correct Parent Node Numbers
02=Reset Tree Node Gaps
03=Correct Level Numbers
04=Delete Orphan Tree Objects
05=Remove Tree Branches
06=Update Tree Table Statistics
07=Remove Tree Reservations
ALL_TREES_FLAGCharacter(1)VARCHAR2(1) NOT NULLAll Trees

Y/N Table Edit

Default: N

REPORT_ONLY_FLAGCharacter(1)VARCHAR2(1) NOT NULLReport Only

Y/N Table Edit

Default: N

ALLOW_SKIP_LEVELSCharacter(1)VARCHAR2(1) NOT NULLAllow Skip Levels

Y/N Table Edit

Default: N

SETIDCharacter(5)VARCHAR2(5) NOT NULLSetID
SETCNTRLVALUECharacter(20)VARCHAR2(20) NOT NULLTree Definition User Key Value
TREE_NAMECharacter(18)VARCHAR2(18) NOT NULLTree Name
EFFDTDate(10)DATEEffective Date
TREE_BRANCHCharacter(20)VARCHAR2(20) NOT NULLTree Branch
VALID_TREECharacter(1)VARCHAR2(1) NOT NULLValid Tree
N=Draft Tree
Y=Valid Tree
FIRST_CHILD_FLAGCharacter(1)VARCHAR2(1) NOT NULLFirst Child
NODE_COUNTNumber(10,0)DECIMAL(10) NOT NULLTree Definition Node Count
TREE_MAX_NODE_NUMNumber(10,0)DECIMAL(10) NOT NULLMaximum Node Number
TREE_GAP_SIZENumber(10,0)DECIMAL(10) NOT NULLTree Gap Size
TREE_NODECharacter(20)VARCHAR2(20) NOT NULLNode name
TREE_NODE_NUMNumber(10,0)DECIMAL(10) NOT NULLInternal beginning node range number
TREE_NODE_NUM_ENDNumber(10,0)DECIMAL(10) NOT NULLInternal ending node range number
NEW_TREE_NODE_NUMNumber(10,0)DECIMAL(10) NOT NULLInternal beginning node range number
OLD_PARENT_NODECharacter(20)VARCHAR2(20) NOT NULLParent Node Name
OLD_PARENT_NUMNumber(10,0)DECIMAL(10) NOT NULLOld Parent Node Num
ROOT_NODE_NUMNumber(10,0)DECIMAL(10) NOT NULLRoot Node Number
PARENT_NODE_NUMNumber(10,0)DECIMAL(10) NOT NULLParent Node Number
PARENT_NODE_ENDNumber(10,0)DECIMAL(10) NOT NULLParent Node End Number
PARENT_NODE_NAMECharacter(20)VARCHAR2(20) NOT NULLName of parent node
BASE_NODE_ENDNumber(10,0)DECIMAL(10) NOT NULLBase Node End Number
NODE_INDEXNumber(10,0)DECIMAL(10) NOT NULLInternal beginning node range number
LEVELSNumber(3,0)SMALLINT NOT NULLNumber of Levels
TREE_LEVEL_NUMNumber(3,0)SMALLINT NOT NULLParent tree level if this is a part of the PSTREEBRANCH record
PARENT_LEVEL_NUMNumber(3,0)SMALLINT NOT NULLParent tree level if this is a part of the PSTREEBRANCH record
NEW_LEVEL_NUMNumber(3,0)SMALLINT NOT NULLParent tree level if this is a part of the PSTREEBRANCH record
RANGE_FROMCharacter(30)VARCHAR2(30) NOT NULLLower boundary for detail value that contains a range of values
RANGE_TOCharacter(30)VARCHAR2(30) NOT NULLUpper boundary for detail value that contains a range of values
MESSAGE_SET_NBRNumber(5,0)INTEGER NOT NULLMessage Set Number. This field refers to the Message Set Number in the Message Catalog.
MESSAGE_NBRNumber(5,0)INTEGER NOT NULLMessage Number. This field refers to the Message Number in the Message Catalog.
TOTAL_ROW_COUNTNumber(8,0)INTEGER NOT NULLTotal Row Count
RANGE_FROM_PREVCharacter(30)VARCHAR2(30) NOT NULLPrevious range from value
RANGE_TO_PREVCharacter(30)VARCHAR2(30) NOT NULLRange To
RANGE_FROM_30Character(30)VARCHAR2(30) NOT NULLRange From
ALL_VALUESCharacter(1)VARCHAR2(1) NOT NULLTree Level All Values flag
DUPLICATE_LEAFCharacter(1)VARCHAR2(1) NOT NULLTree Definition allow duplicate leaf flag
TREEEDITSTATUSCharacter(1)VARCHAR2(1) NOT NULLTree Reservation Status
E=Editable
N=Not Used
R=Reserved
U=UnReserved

Default: N

AUDIT_ASOFDATECharacter(1)VARCHAR2(1) NOT NULLAs of Date Operator
A=All Trees
C=As of Current Date
E=Effective Date of Tree
S=As of Specific Date
TREE_AUDIT_SCOPECharacter(1)VARCHAR2(1) NOT NULLAudit Scope
M=Multiple Trees
S=Single Tree
ASOFDATEDate(10)DATEAs of Date
AE_APPLIDCharacter(12)VARCHAR2(12) NOT NULLProgram Name (see PSAEAPPLDEFN).
AE_SECTIONCharacter(8)VARCHAR2(8) NOT NULLSection
AE_APPSTATUSNumber(1,0)SMALLINT NOT NULLAE Application Warning Status
SQLTEXTLong Character(14000)CLOBSQL Statement Text
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19