RB_CUST_TREE1

(SQL Table)
Index Back

Customer Tree Temp Table

Used by Customer Flattener - RB_CUST_FLAT

# 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 BO_ID_PARENT Number(31,0) DECIMAL(31) NOT NULL Business Object ID of the Parent Company.
3 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
4 PARENT_NODE_NAME Character(20) VARCHAR2(20) NOT NULL Name of parent node
5 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name
6 TREE_NODE_NUM Number(10,0) DECIMAL(10) NOT NULL Internal beginning node range number
7 TREE_LEVEL_NUM Number(3,0) SMALLINT NOT NULL Parent tree level if this is a part of the PSTREEBRANCH record
8 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance