PSTREELVLNUMVW

index back

Tree Mgr Level Page


SELECT DISTINCT LVL.SETID ,LVL.TREE_NAME , LVL.TREE_LEVEL_NUM , LVL.TREE_LEVEL , LVL_VW.DESCR FROM PSTREELEVEL LVL , PS_TREE_LEVEL_VW LVL_VW WHERE LVL_VW.TREE_LEVEL = LVL.TREE_LEVEL

PeopleSoft Field Name Field Type Column Type Description
DTL_SETID Character(5) VARCHAR2(5) NOT NULL Tree Structure Summary Detail Tree SetId
DTL_TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Structure Summary Detail Tree Name
TREE_LEVEL_NUM Number(3,0) SMALLINT NOT NULL Parent tree level if this is a part of the PSTREEBRANCH record
TREE_LEVEL Character(10) VARCHAR2(10) NOT NULL Tree Level Number
DESCR Character(30) VARCHAR2(30) NOT NULL Description
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19