PSTREEMOVLEAFVW

index back

SELECT SETID , SETCNTRLVALUE , TREE_NAME , EFFDT ,TREE_NODE_NUM , RANGE_FROM , RANGE_TO , DYNAMIC_RANGE , LEAF_IMAGE FROM PSTREELEAF

PeopleSoft Field NameField TypeColumn TypeDescription
SETIDCharacter(5)VARCHAR2(5) NOT NULLSetID
SETCNTRLVALUECharacter(20)VARCHAR2(20) NOT NULLTree Definition User Key Value
TREE_NAMECharacter(18)VARCHAR2(18) NOT NULLTree Name
EFFDTDate(10)DATE NOT NULLEffective Date

Default: %date

TREE_NODE_NUMNumber(10,0)DECIMAL(10) NOT NULLInternal beginning node range number
RANGE_FROMCharacter(30)VARCHAR2(30) NOT NULLLower boundary for detail value that contains a range of values
RANGE_TOCharacter(30)VARCHAR2(30) NOT NULLUpper boundary for detail value that contains a range of values
DYNAMIC_RANGECharacter(1)VARCHAR2(1) NOT NULLTree Leaf Dynamic detail range flag
LEAF_IMAGECharacter(30)VARCHAR2(30) NOT NULLName of image that is used for leaf , i.e. detail values in tree
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19