RSF_ACC_TREE2

(SQL Table)
Index Back

Tree Temp Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
2 SETCNTRLVALUE Character(20) VARCHAR2(20) NOT NULL Tree Definition User Key Value
3 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
4 EFFDT Date(10) DATE Effective Date

Default Value: %date

5 PARENT_NODE_NAME Character(20) VARCHAR2(20) NOT NULL Name of parent node
6 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name
7 TREE_NODE_NUM Number(10,0) DECIMAL(10) NOT NULL Internal beginning node range number
8 TREE_LEVEL_NUM Number(3,0) SMALLINT NOT NULL Parent tree level if this is a part of the PSTREEBRANCH record
9 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance