PSTREESTRCT

index back

Tree Structure


  • Related language record: PSTREESTRCTLANG
  • PeopleSoft Field NameField TypeColumn TypeDescription
    TREE_STRCT_IDCharacter(18)VARCHAR2(18) NOT NULLTree Structure Name
    VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    DYNAMIC_RANGECharacter(1)VARCHAR2(1) NOT NULLTree Leaf Dynamic detail range flag
    LEVEL_RECNAMECharacter(15)VARCHAR2(15) NOT NULLTree Structure Level Record name

    Prompt Table: PSRECDEFNPVW

    LEVEL_PNLGRPNAMECharacter(50)VARCHAR2(50) NOT NULLLevel Component Name

    Prompt Table: PSTREECMPLVLVW

    LEVEL_PNLNAMECharacter(18)VARCHAR2(18) NOT NULLTree Structure Level Panel/Page name

    Prompt Table: PSTREEPAGEVW

    SETCNTRL_INDCharacter(1)VARCHAR2(1) NOT NULLTree Structure User Key Field Type Indicator
    B=Business Unit
    N=None
    S=SetId Indirection
    U=User Defined

    Default: S

    SETCNTRL_COUNTNumber(3,0)SMALLINT NOT NULLSet Control Field Count
    NODE_RECNAMECharacter(15)VARCHAR2(15) NOT NULLTree Structure Node Record name

    Prompt Table: PSRECDEFNPVW

    NODE_FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLTree Structure Node Field name

    Prompt Table: PSTREEFLDNODVW

    SETCNTRLFLDCharacter(18)VARCHAR2(18) NOT NULLTree Structure Node User Key Field Name

    Prompt Table: PSTREEFLDNODVW

    NODE_PNLGRPNAMECharacter(50)VARCHAR2(50) NOT NULLNode Component Name

    Prompt Table: PSTREECMPNODVW

    NODE_PNLNAMECharacter(18)VARCHAR2(18) NOT NULLTree Structure Node Panel/Page name

    Prompt Table: PSTREEPAGEVW

    DTL_RECNAMECharacter(15)VARCHAR2(15) NOT NULLTree Structure Detail Record name

    Prompt Table: PSRECDEFNPVW

    DTL_FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLTree Structure Detail Record name

    Prompt Table: PSTREEFLDDTLVW

    DTL_PNLGRPNAMECharacter(50)VARCHAR2(50) NOT NULLComponent Name used to maintain detail values in tree

    Prompt Table: PSTREECMPDTLVW

    DTL_PNLNAMECharacter(18)VARCHAR2(18) NOT NULLTree Structure Detail Panel/Page name

    Prompt Table: PSTREEPAGEVW

    NODE_MENUNAMECharacter(30)VARCHAR2(30) NOT NULLTree Structure Node Menu name

    Prompt Table: PSTREEMENUNODVW

    DTL_MENUNAMECharacter(30)VARCHAR2(30) NOT NULLTree Structure Detail Menu name

    Prompt Table: PSTREEMENUDTLVW

    TREE_STRCT_TYPECharacter(1)VARCHAR2(1) NOT NULLTree Structure Type: "D" = detail or "S" = summary
    D=Detail
    S=Summary

    Default: D

    DTL_SETIDCharacter(5)VARCHAR2(5) NOT NULLTree Structure Summary Detail Tree SetId

    Prompt Table: PSTREEDEFDSETVW

    SETCNTRLVALUECharacter(20)VARCHAR2(20) NOT NULLTree Definition User Key Value
    DTL_TREE_NAMECharacter(18)VARCHAR2(18) NOT NULLTree Structure Summary Detail Tree Name

    Prompt Table: PSTREEDEFDTLVW

    DTL_TREE_LEVEL_NUMNumber(5,0)INTEGER NOT NULLTree Structure Summary Detail Tree Level Number

    Prompt Table: PSTREELVLNUMVW

    LEVEL_MENUNAMECharacter(30)VARCHAR2(30) NOT NULLTree Structure Level Menu name

    Prompt Table: PSTREEMENULVLVW

    LEVEL_BARNAMECharacter(30)VARCHAR2(30) NOT NULLTree Structure Level Menu Bar name

    Prompt Table: PSTREEMNBRLVLVW

    NODE_BARNAMECharacter(30)VARCHAR2(30) NOT NULLTree Structure Node Menu Bar name

    Prompt Table: PSTREEMNBRNODVW

    DTL_BARNAMECharacter(30)VARCHAR2(30) NOT NULLTree Structure Detail Menu Bar name

    Prompt Table: PSTREEMNBRDTLVW

    LEVEL_ITEMNAMECharacter(30)VARCHAR2(30) NOT NULLMenu Item Name for Tree Levels

    Prompt Table: PSTREEMNITLVLVW

    NODE_ITEMNAMECharacter(30)VARCHAR2(30) NOT NULLMenu Item Name for Tree Nodes

    Prompt Table: PSTREEMNITNODVW

    DTL_ITEMNAMECharacter(30)VARCHAR2(30) NOT NULLMenu Item Name for Tree Details (Leafs)

    Prompt Table: PSTREEMNITDTLVW

    NODE_MULTINAVIGATECharacter(1)VARCHAR2(1) NOT NULLNode Multi-Navigate Flag: "N" = No or "Y" = Yes

    Y/N Table Edit

    Default: N

    DTL_MULTINAVIGATECharacter(1)VARCHAR2(1) NOT NULLDetail Multi-Navigate Flag: "N" = No or "Y" = Yes

    Y/N Table Edit

    Default: N

    LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies 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.
    LASTUPDOPRIDCharacter(30)VARCHAR2(30) NOT NULLSpecifies 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.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19