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 NameField TypeColumn TypeDescription
DTL_SETIDCharacter(5)VARCHAR2(5) NOT NULLTree Structure Summary Detail Tree SetId
DTL_TREE_NAMECharacter(18)VARCHAR2(18) NOT NULLTree Structure Summary Detail Tree Name
TREE_LEVEL_NUMNumber(3,0)SMALLINT NOT NULLParent tree level if this is a part of the PSTREEBRANCH record
TREE_LEVELCharacter(10)VARCHAR2(10) NOT NULLTree Level Number
DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19