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 Name Field Type Column Type Description
TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
TREE_LEVEL Character(10) VARCHAR2(10) NOT NULL Tree Level Number
TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name
EFFDT Date(10) DATE NOT NULL Effective Date
index back (c)David Kurtz 2019, PeopleTools 8.54
PTRef generated on 09-JUN-19