PSTREESTRCT

(SQL Table)
 Index Back

Tree Structure

  • Related Language Record: PSTREESTRCTLANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TREE_STRCT_ID Character(18) VARCHAR2(18) NOT NULL Tree Structure Name
    2 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DYNAMIC_RANGE Character(1) VARCHAR2(1) NOT NULL Tree Leaf Dynamic detail range flag
    5 LEVEL_RECNAME Character(15) VARCHAR2(15) NOT NULL Tree Structure Level Record name

    Prompt Table: PSRECDEFNPVW

    6 LEVEL_PNLGRPNAME Character(50) VARCHAR2(50) NOT NULL Level Component Name

    Prompt Table: PSTREECMPLVLVW

    7 LEVEL_PNLNAME Character(18) VARCHAR2(18) NOT NULL Tree Structure Level Panel/Page name

    Prompt Table: PSTREEPAGEVW

    8 SETCNTRL_IND Character(1) VARCHAR2(1) NOT NULL Tree Structure User Key Field Type Indicator
    B=Business Unit
    N=None
    S=SetId Indirection
    U=User Defined

    Default Value: S

    9 SETCNTRL_COUNT Number(3,0) SMALLINT NOT NULL Set Control Field Count
    10 NODE_RECNAME Character(15) VARCHAR2(15) NOT NULL Tree Structure Node Record name

    Prompt Table: PSRECDEFNPVW

    11 NODE_FIELDNAME Character(18) VARCHAR2(18) NOT NULL Tree Structure Node Field name

    Prompt Table: PSTREEFLDNODVW

    12 SETCNTRLFLD Character(18) VARCHAR2(18) NOT NULL Tree Structure Node User Key Field Name

    Prompt Table: PSTREEFLDNODVW

    13 NODE_PNLGRPNAME Character(50) VARCHAR2(50) NOT NULL Node Component Name

    Prompt Table: PSTREECMPNODVW

    14 NODE_PNLNAME Character(18) VARCHAR2(18) NOT NULL Tree Structure Node Panel/Page name

    Prompt Table: PSTREEPAGEVW

    15 DTL_RECNAME Character(15) VARCHAR2(15) NOT NULL Tree Structure Detail Record name

    Prompt Table: PSRECDEFNPVW

    16 DTL_FIELDNAME Character(18) VARCHAR2(18) NOT NULL Tree Structure Detail Record name

    Prompt Table: PSTREEFLDDTLVW

    17 DTL_PNLGRPNAME Character(50) VARCHAR2(50) NOT NULL Component Name used to maintain detail values in tree

    Prompt Table: PSTREECMPDTLVW

    18 DTL_PNLNAME Character(18) VARCHAR2(18) NOT NULL Tree Structure Detail Panel/Page name

    Prompt Table: PSTREEPAGEVW

    19 NODE_MENUNAME Character(30) VARCHAR2(30) NOT NULL Tree Structure Node Menu name

    Prompt Table: PSTREEMENUNODVW

    20 DTL_MENUNAME Character(30) VARCHAR2(30) NOT NULL Tree Structure Detail Menu name

    Prompt Table: PSTREEMENUDTLVW

    21 TREE_STRCT_TYPE Character(1) VARCHAR2(1) NOT NULL Tree Structure Type: "D" = detail or "S" = summary
    D=Detail
    S=Summary

    Default Value: D

    22 DTL_SETID Character(5) VARCHAR2(5) NOT NULL Tree Structure Summary Detail Tree SetId

    Prompt Table: PSTREEDEFDSETVW

    23 SETCNTRLVALUE Character(20) VARCHAR2(20) NOT NULL Tree Definition User Key Value
    24 DTL_TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Structure Summary Detail Tree Name

    Prompt Table: PSTREEDEFDTLVW

    25 DTL_TREE_LEVEL_NUM Number(5,0) INTEGER NOT NULL Tree Structure Summary Detail Tree Level Number

    Prompt Table: PSTREELVLNUMVW

    26 LEVEL_MENUNAME Character(30) VARCHAR2(30) NOT NULL Tree Structure Level Menu name

    Prompt Table: PSTREEMENULVLVW

    27 LEVEL_BARNAME Character(30) VARCHAR2(30) NOT NULL Tree Structure Level Menu Bar name

    Prompt Table: PSTREEMNBRLVLVW

    28 NODE_BARNAME Character(30) VARCHAR2(30) NOT NULL Tree Structure Node Menu Bar name

    Prompt Table: PSTREEMNBRNODVW

    29 DTL_BARNAME Character(30) VARCHAR2(30) NOT NULL Tree Structure Detail Menu Bar name

    Prompt Table: PSTREEMNBRDTLVW

    30 LEVEL_ITEMNAME Character(30) VARCHAR2(30) NOT NULL Menu Item Name for Tree Levels

    Prompt Table: PSTREEMNITLVLVW

    31 NODE_ITEMNAME Character(30) VARCHAR2(30) NOT NULL Menu Item Name for Tree Nodes

    Prompt Table: PSTREEMNITNODVW

    32 DTL_ITEMNAME Character(30) VARCHAR2(30) NOT NULL Menu Item Name for Tree Details (Leafs)

    Prompt Table: PSTREEMNITDTLVW

    33 NODE_MULTINAVIGATE Character(1) VARCHAR2(1) NOT NULL Node Multi-Navigate Flag: "N" = No or "Y" = Yes

    Y/N Table Edit

    Default Value: N

    34 DTL_MULTINAVIGATE Character(1) VARCHAR2(1) NOT NULL Detail Multi-Navigate Flag: "N" = No or "Y" = Yes

    Y/N Table Edit

    Default Value: N

    35 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    36 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.