PSTREEBRANCH

Return to Index

  • Parent record: PSTREEDEFN
  • PeopleSoft Field NameField TypeDescription
    SETIDVARCHAR2(5) NOT NULLSetID

    Prompt Table: SETID_NOMETA_VW

    SETCNTRLVALUEVARCHAR2(20) NOT NULLTree Definition User Key Value
    TREE_NAMEVARCHAR2(18) NOT NULLTree Name

    Prompt Table: PSTREEDEFN

    EFFDTDATE NOT NULLEffective Date
    TREE_BRANCHVARCHAR2(20) NOT NULLTree Branch Name
    VERSIONDECIMAL(10) NOT NULLVersion
    PARENT_BRANCHVARCHAR2(20) NOT NULLParent Branch Name
    BRANCH_LEVEL_NUMSMALLINT NOT NULLBranch Level Number
    PARENT_NODE_NUMDECIMAL(10) NOT NULLParent Node Number
    TREE_LEVEL_NUMSMALLINT NOT NULLParent tree level if this is a part of the PSTREEBRANCH record
    TREE_NODE_NUMDECIMAL(10) NOT NULLInternal beginning node range number
    TREE_NODE_NUM_ENDDECIMAL(10) NOT NULLInternal ending node range number
    NODE_COUNTDECIMAL(10) NOT NULLTree Definition Node Count
    LEAF_COUNTDECIMAL(10) NOT NULLLeaf Count
    BRANCH_IMAGEVARCHAR2(30) NOT NULLBranched Tree Image Name

    Author: PeopleTools 8.52

    Return to Index

    © David Kurtz  Last updated 01 August 2015