index back

Tree Node Level View

Includes Set IDs. Used for prompting when a user specifies a level in the page.
select c.setid, a.tree_name, a.tree_level, c.tree_node, a.effdt, c.descr from pstreelevel a, pstreenode b, ps_tree_node_tbl c where a.setid = b.setid and a.setid = c.setid and a.tree_name = b.tree_name and a.tree_level_num = b.tree_level_num and a.effdt = b.effdt and b.tree_node = c.tree_node and c.eff_status = 'A' and c.effdt = (select max(d.effdt) from ps_tree_node_tbl d where d.setid = c.setid and d.tree_node = c.tree_node and d.effdt <= a.effdt)

PeopleSoft Field Name Field Type Column Type Description
SETCNTRLVALUE Character(20) VARCHAR2(20) NOT NULL Tree Definition User Key Value
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
DESCR Character(30) VARCHAR2(30) NOT NULL Description
index back (c)David Kurtz 2019, PeopleTools 8.54
PTRef generated on 09-JUN-19