TREE_LVL_VW

index back

Tree Level View


select distinct TREE_NAME, TREE_LEVEL_NUM, TREE_LEVEL from PSTREELEVEL

PeopleSoft Field NameField TypeColumn TypeDescription
TREE_NAMECharacter(18)VARCHAR2(18) NOT NULLTree 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
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19