PSTREENODE

Return to Index

  • Parent record: PSTREEDEFN
  • PeopleSoft Field NameField TypeDescription
    SETIDVARCHAR2(5) NOT NULLSetID
    SETCNTRLVALUEVARCHAR2(20) NOT NULLTree Definition User Key Value
    TREE_NAMEVARCHAR2(18) NOT NULLTree Name
    EFFDTDATE NOT NULLEffective Date
    TREE_NODE_NUMDECIMAL(10) NOT NULLInternal beginning node range number
    TREE_NODEVARCHAR2(20) NOT NULLNode name
    TREE_BRANCHVARCHAR2(20) NOT NULLTree Branch Name
    TREE_NODE_NUM_ENDDECIMAL(10) NOT NULLInternal ending node range number
    TREE_LEVEL_NUMSMALLINT NOT NULLParent tree level if this is a part of the PSTREEBRANCH record
    TREE_NODE_TYPEVARCHAR2(1) NOT NULLFlag to indicate whether node represents a Group (G) or a Record (R) in a Query Access Group Tree,
    PARENT_NODE_NUMDECIMAL(10) NOT NULLParent Node Number
    PARENT_NODE_NAMEVARCHAR2(20) NOT NULLName of parent node
    OLD_TREE_NODE_NUMVARCHAR2(1) NOT NULLOld Tree Node
    NODECOL_IMAGEVARCHAR2(30) NOT NULLCollapsed Node Image Field
    NODEEXP_IMAGEVARCHAR2(30) NOT NULLExpanded Node Image Field

    Author: PeopleTools 8.52

    Return to Index

    © David Kurtz  Last updated 01 August 2015