PSTREESTRCT

Return to Index

  • Related language record: PSTREESTRCTLANG
  • PeopleSoft Field NameField TypeDescription
    TREE_STRCT_IDVARCHAR2(18) NOT NULLTree Structure Name
    VERSIONDECIMAL(10) NOT NULLVersion
    DESCRVARCHAR2(30) NOT NULLDescription
    DYNAMIC_RANGEVARCHAR2(1) NOT NULLTree Leaf Dynamic detail range flag
    LEVEL_RECNAMEVARCHAR2(15) NOT NULLTree Structure Level Record name

    Prompt Table: PSRECDEFNPVW

    LEVEL_PNLGRPNAMEVARCHAR2(50) NOT NULLLevel Component Name

    Prompt Table: PSTREECMPLVLVW

    LEVEL_PNLNAMEVARCHAR2(18) NOT NULLTree Structure Level Panel/Page name

    Prompt Table: PSTREEPAGEVW

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

    Default: S

    SETCNTRL_COUNTSMALLINT NOT NULLSet Control Field Count
    NODE_RECNAMEVARCHAR2(15) NOT NULLTree Structure Node Record name

    Prompt Table: PSRECDEFNPVW

    NODE_FIELDNAMEVARCHAR2(18) NOT NULLTree Structure Node Field name

    Prompt Table: PSTREEFLDNODVW

    SETCNTRLFLDVARCHAR2(18) NOT NULLTree Structure Node User Key Field Name

    Prompt Table: PSTREEFLDNODVW

    NODE_PNLGRPNAMEVARCHAR2(50) NOT NULLNode Component Name

    Prompt Table: PSTREECMPNODVW

    NODE_PNLNAMEVARCHAR2(18) NOT NULLTree Structure Node Panel/Page name

    Prompt Table: PSTREEPAGEVW

    DTL_RECNAMEVARCHAR2(15) NOT NULLTree Structure Detail Record name

    Prompt Table: PSRECDEFNPVW

    DTL_FIELDNAMEVARCHAR2(18) NOT NULLTree Structure Detail Record name

    Prompt Table: PSTREEFLDDTLVW

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

    Prompt Table: PSTREECMPDTLVW

    DTL_PNLNAMEVARCHAR2(18) NOT NULLTree Structure Detail Panel/Page name

    Prompt Table: PSTREEPAGEVW

    NODE_MENUNAMEVARCHAR2(30) NOT NULLTree Structure Node Menu name

    Prompt Table: PSTREEMENUNODVW

    DTL_MENUNAMEVARCHAR2(30) NOT NULLTree Structure Detail Menu name

    Prompt Table: PSTREEMENUDTLVW

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

    Default: D

    DTL_SETIDVARCHAR2(5) NOT NULLTree Structure Summary Detail Tree SetId

    Prompt Table: PSTREEDEFDSETVW

    SETCNTRLVALUEVARCHAR2(20) NOT NULLTree Definition User Key Value
    DTL_TREE_NAMEVARCHAR2(18) NOT NULLTree Structure Summary Detail Tree Name

    Prompt Table: PSTREEDEFDTLVW

    DTL_TREE_LEVEL_NUMINTEGER NOT NULLTree Structure Summary Detail Tree Level Number

    Prompt Table: PSTREELVLNUMVW

    LEVEL_MENUNAMEVARCHAR2(30) NOT NULLTree Structure Level Menu name

    Prompt Table: PSTREEMENULVLVW

    LEVEL_BARNAMEVARCHAR2(30) NOT NULLTree Structure Level Menu Bar name

    Prompt Table: PSTREEMNBRLVLVW

    NODE_BARNAMEVARCHAR2(30) NOT NULLTree Structure Node Menu Bar name

    Prompt Table: PSTREEMNBRNODVW

    DTL_BARNAMEVARCHAR2(30) NOT NULLTree Structure Detail Menu Bar name

    Prompt Table: PSTREEMNBRDTLVW

    LEVEL_ITEMNAMEVARCHAR2(30) NOT NULLMenu Item Name for Tree Levels

    Prompt Table: PSTREEMNITLVLVW

    NODE_ITEMNAMEVARCHAR2(30) NOT NULLMenu Item Name for Tree Nodes

    Prompt Table: PSTREEMNITNODVW

    DTL_ITEMNAMEVARCHAR2(30) NOT NULLMenu Item Name for Tree Details (Leafs)

    Prompt Table: PSTREEMNITDTLVW

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

    Y/N Table Edit

    Default: N

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

    Y/N Table Edit

    Default: N

    LASTUPDDTTMDATESpecifies 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.
    LASTUPDOPRIDVARCHAR2(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.

    Author: PeopleTools 8.52

    Return to Index

    © David Kurtz  Last updated 01 August 2015