PSTREESTRCT

index back

Tree Structure


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

    Prompt Table: PSRECDEFNPVW

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

    Prompt Table: PSTREECMPLVLVW

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

    Prompt Table: PSTREEPAGEVW

    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: S

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

    Prompt Table: PSRECDEFNPVW

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

    Prompt Table: PSTREEFLDNODVW

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

    Prompt Table: PSTREEFLDNODVW

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

    Prompt Table: PSTREECMPNODVW

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

    Prompt Table: PSTREEPAGEVW

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

    Prompt Table: PSRECDEFNPVW

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

    Prompt Table: PSTREEFLDDTLVW

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

    Prompt Table: PSTREECMPDTLVW

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

    Prompt Table: PSTREEPAGEVW

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

    Prompt Table: PSTREEMENUNODVW

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

    Prompt Table: PSTREEMENUDTLVW

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

    Default: D

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

    Prompt Table: PSTREEDEFDSETVW

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

    Prompt Table: PSTREEDEFDTLVW

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

    Prompt Table: PSTREELVLNUMVW

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

    Prompt Table: PSTREEMENULVLVW

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

    Prompt Table: PSTREEMNBRLVLVW

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

    Prompt Table: PSTREEMNBRNODVW

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

    Prompt Table: PSTREEMNBRDTLVW

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

    Prompt Table: PSTREEMNITLVLVW

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

    Prompt Table: PSTREEMNITNODVW

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

    Prompt Table: PSTREEMNITDTLVW

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

    Y/N Table Edit

    Default: N

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

    Y/N Table Edit

    Default: N

    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.
    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.
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19