TREE_LEVEL_VW

Platform	View Text
Default	select b.setid, a.tree_name, a.tree_level, a.effdt, b.descr from PSTREELEVEL a, ps_tree_level_tbl b where b.setid = a.setid and b.tree_level = a.tree_level and b.eff_status = 'A' and b.effdt = (select max(c.effdt) from ps_tree_level_tbl c where c.setid = b.setid and c.tree_level = b.tree_level and c.effdt <= a.effdt)

PeopleSoft Field Name	Description
TREE_NAME_SETID	TableSet
TREE_NAME	Tree Name Prompt Table: PT_TREEDEFN_VW
TREE_LEVEL	Tree Level Number Prompt Table: TREE_LEVEL_TBL
EFFDT	Effective Date
DESCR	Description

Author: PeopleTools
Return to Index	© Go-Faster Consultancy Ltd.  Last updated 24 July 2010