TREE_MAINT_AET

index back

Tree Utilities State Record

Tree Utilities State Record

PeopleSoft Field Name Field Type Column Type Description
PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
FUNCLIB Character(1) VARCHAR2(1) NOT NULL Function Library
LOCK_ACQUIRED Character(1) VARCHAR2(1) NOT NULL Lock Acquired

Y/N Table Edit

Default: N

VERSION_UPDATED Character(1) VARCHAR2(1) NOT NULL Version Number Updated
ABORT_PROCESS_FLAG Character(1) VARCHAR2(1) NOT NULL Abort Processing Flag
VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
TREE_UTILITY_TYPE Character(2) VARCHAR2(2) NOT NULL Tree 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_FLAG Character(1) VARCHAR2(1) NOT NULL All Trees

Y/N Table Edit

Default: N

REPORT_ONLY_FLAG Character(1) VARCHAR2(1) NOT NULL Report Only

Y/N Table Edit

Default: N

ALLOW_SKIP_LEVELS Character(1) VARCHAR2(1) NOT NULL Allow Skip Levels

Y/N Table Edit

Default: N

SETID Character(5) VARCHAR2(5) NOT NULL SetID
SETCNTRLVALUE Character(20) VARCHAR2(20) NOT NULL Tree Definition User Key Value
TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
EFFDT Date(10) DATE Effective Date
TREE_BRANCH Character(20) VARCHAR2(20) NOT NULL Tree Branch
VALID_TREE Character(1) VARCHAR2(1) NOT NULL Valid Tree
N=Draft Tree
Y=Valid Tree
FIRST_CHILD_FLAG Character(1) VARCHAR2(1) NOT NULL First Child
NODE_COUNT Number(10,0) DECIMAL(10) NOT NULL Tree Definition Node Count
TREE_MAX_NODE_NUM Number(10,0) DECIMAL(10) NOT NULL Maximum Node Number
TREE_GAP_SIZE Number(10,0) DECIMAL(10) NOT NULL Tree Gap Size
TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name
TREE_NODE_NUM Number(10,0) DECIMAL(10) NOT NULL Internal beginning node range number
TREE_NODE_NUM_END Number(10,0) DECIMAL(10) NOT NULL Internal ending node range number
NEW_TREE_NODE_NUM Number(10,0) DECIMAL(10) NOT NULL Internal beginning node range number
OLD_PARENT_NODE Character(20) VARCHAR2(20) NOT NULL Parent Node Name
OLD_PARENT_NUM Number(10,0) DECIMAL(10) NOT NULL Old Parent Node Num
ROOT_NODE_NUM Number(10,0) DECIMAL(10) NOT NULL Root Node Number
PARENT_NODE_NUM Number(10,0) DECIMAL(10) NOT NULL Parent Node Number
PARENT_NODE_END Number(10,0) DECIMAL(10) NOT NULL Parent Node End Number
PARENT_NODE_NAME Character(20) VARCHAR2(20) NOT NULL Name of parent node
BASE_NODE_END Number(10,0) DECIMAL(10) NOT NULL Base Node End Number
NODE_INDEX Number(10,0) DECIMAL(10) NOT NULL Internal beginning node range number
LEVELS Number(3,0) SMALLINT NOT NULL Number of Levels
TREE_LEVEL_NUM Number(3,0) SMALLINT NOT NULL Parent tree level if this is a part of the PSTREEBRANCH record
PARENT_LEVEL_NUM Number(3,0) SMALLINT NOT NULL Parent tree level if this is a part of the PSTREEBRANCH record
NEW_LEVEL_NUM Number(3,0) SMALLINT NOT NULL Parent tree level if this is a part of the PSTREEBRANCH record
RANGE_FROM Character(30) VARCHAR2(30) NOT NULL Lower boundary for detail value that contains a range of values
RANGE_TO Character(30) VARCHAR2(30) NOT NULL Upper boundary for detail value that contains a range of values
MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
TOTAL_ROW_COUNT Number(8,0) INTEGER NOT NULL Total Row Count
RANGE_FROM_PREV Character(30) VARCHAR2(30) NOT NULL Previous range from value
RANGE_TO_PREV Character(30) VARCHAR2(30) NOT NULL Range To
RANGE_FROM_30 Character(30) VARCHAR2(30) NOT NULL Range From
ALL_VALUES Character(1) VARCHAR2(1) NOT NULL Tree Level All Values flag
DUPLICATE_LEAF Character(1) VARCHAR2(1) NOT NULL Tree Definition allow duplicate leaf flag
TREEEDITSTATUS Character(1) VARCHAR2(1) NOT NULL Tree Reservation Status
E=Editable
N=Not Used
R=Reserved
U=UnReserved

Default: N

AUDIT_ASOFDATE Character(1) VARCHAR2(1) NOT NULL As of Date Operator
A=All Trees
C=As of Current Date
E=Effective Date of Tree
S=As of Specific Date
TREE_AUDIT_SCOPE Character(1) VARCHAR2(1) NOT NULL Audit Scope
M=Multiple Trees
S=Single Tree
ASOFDATE Date(10) DATE As of Date
AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
AE_APPSTATUS Number(1,0) SMALLINT NOT NULL AE Application Warning Status
SQLTEXT Long Character(14000) CLOB SQL Statement Text
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19