DEPT_TLEAF_VW

index back

Tree Leaf


SELECT SETID , SETCNTRLVALUE , TREE_NAME , EFFDT , TREE_NODE_NUM , RANGE_FROM , RANGE_TO , TREE_BRANCH , DYNAMIC_RANGE , OLD_TREE_NODE_NUM , LEAF_IMAGE FROM PSTREELEAF WHERE TREE_NAME='DEPT_SECURITY'

  • Parent record: PSTREEDEFN
  • 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
    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
    TREE_BRANCHCharacter(20)VARCHAR2(20) NOT NULLTree Branch Name
    DYNAMIC_RANGECharacter(1)VARCHAR2(1) NOT NULLTree Leaf Dynamic detail range flag
    OLD_TREE_NODE_NUMCharacter(1)VARCHAR2(1) NOT NULLOld Tree Node
    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