index back

Tree Level View - No Setids

SELECT a.tree_name , a.tree_level , b.tree_node , a.effdt FROM pstreelevel a , pstreenode b WHERE a.setid = b.setid AND a.tree_name = b.tree_name AND a.tree_level_num = b.tree_level_num AND a.effdt = b.effdt

PeopleSoft Field NameField TypeColumn TypeDescription
TREE_NAMECharacter(18)VARCHAR2(18) NOT NULLTree Name
TREE_LEVELCharacter(10)VARCHAR2(10) NOT NULLTree Level Number
TREE_NODECharacter(20)VARCHAR2(20) NOT NULLNode name
EFFDTDate(10)DATE NOT NULLEffective Date
index back(c)David Kurtz 2019, 8.54
PTRef generated on 09-JUN-19