E-TR: What are the names of the Tree tables?
Names of Tree Tables and relationship parent/child
PeopleSoft Tables – Tree Manager
Table Name Table Description
PSTREEDEFN Stores valid tree definitions. Updated by the Tree Manager. Non English stored in PSTREEDEFNLANG.
PSTREENODE Contains one entry per tree node / deptid. Defines relationships
between nodes. Updated by the Tree Manager.
PSTREEBRANCH Stores tree branches.
PSTREESTRCT Defines the different records and fields that control the tree attributes.
Updated by the Tree Manager.
PSTREELEVEL Validation table for tree levels. Updated by Tree Manager.
PS_ACCESS_GRP_TBL Stores defined Access Groups. Used for Query Security
PSTREESELCTL Control table for PSTREESELECT## tables. Also: PSTREESELNUM.
PSTREESELECT01-30 Stores tree leaf information (one table for every possible length of a chart field 1-30 characters).Work table for optimization purposes.
PSTREELEAF Contains ranges of field values that are associated with a node of a tree.
PSTREEPROMPT (Specific to 8.x and up only) Stores similar information as PSTREEDEFN and is needed for trees to be viewed through PIA
Parent/Child relationship: The range of nodes from PSTREENODE.TREE_NODE_NUM to TREE_NODE_NUM_END
represents all the nodes in the sub-tree headed by this node. So the Tree Manager uses these fields to determine parent-child relationships.
Tree_Node_Num The node number of this node.
Tree_Node_Num_End The node number of the last child of this node. The range of nodes from Tree_Node_Num through Tree_Node_Num_End
represents all the nodes in the sub-tree headed by this node.