DEPT_TBRANCH_VW

(SQL View)
 Index Back

Tree Branch


SELECT SETID , SETCNTRLVALUE , TREE_NAME , EFFDT , TREE_BRANCH , VERSION , PARENT_BRANCH , BRANCH_LEVEL_NUM , PARENT_NODE_NUM , TREE_LEVEL_NUM , TREE_NODE_NUM , TREE_NODE_NUM_END , NODE_COUNT , LEAF_COUNT , BRANCH_IMAGE FROM PSTREEBRANCH WHERE TREE_NAME='DEPT_SECURITY'

  • Parent record: PSTREEDEFN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SETID_NOMETA_VW

    2 SETCNTRLVALUE Character(20) VARCHAR2(20) NOT NULL Tree Definition User Key Value
    3 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name

    Prompt Table: PSTREEDEFN

    4 EFFDT Date(10) DATE NOT NULL Effective Date
    5 TREE_BRANCH Character(20) VARCHAR2(20) NOT NULL Tree Branch Name
    6 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    7 PARENT_BRANCH Character(20) VARCHAR2(20) NOT NULL Parent Branch Name
    8 BRANCH_LEVEL_NUM Number(3,0) SMALLINT NOT NULL Branch Level Number
    9 PARENT_NODE_NUM Number(10,0) DECIMAL(10) NOT NULL Parent Node Number
    10 TREE_LEVEL_NUM Number(3,0) SMALLINT NOT NULL Parent tree level if this is a part of the PSTREEBRANCH record
    11 TREE_NODE_NUM Number(10,0) DECIMAL(10) NOT NULL Internal beginning node range number
    12 TREE_NODE_NUM_END Number(10,0) DECIMAL(10) NOT NULL Internal ending node range number
    13 NODE_COUNT Number(10,0) DECIMAL(10) NOT NULL Tree Definition Node Count
    14 LEAF_COUNT Number(10,0) DECIMAL(10) NOT NULL Leaf Count
    15 BRANCH_IMAGE Character(30) VARCHAR2(30) NOT NULL Branched Tree Image Name