PSTREESTRCTMVW

(SQL View)
 Index Back

Tree Structure Maint View

View used to populate Tree Structure Maintenance Page

SELECT TREE_STRCT_ID ,DESCR ,TREE_STRCT_TYPE ,NODE_RECNAME ,DTL_RECNAME ,'N' FROM PSTREESTRCT WHERE TREE_STRCT_ID <> 'ACCESS_GROUP'

  • Related Language Record: PSTREESTRMVWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TREE_STRCT_ID Character(18) VARCHAR2(18) NOT NULL Tree Structure Name (see PSTREESTRCT).
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 TREE_STRCT_TYPE Character(1) VARCHAR2(1) NOT NULL Tree Structure Type: "D" = detail or "S" = summary
    D=Detail
    S=Summary
    4 NODE_RECNAME Character(15) VARCHAR2(15) NOT NULL Tree Structure Node Record name
    5 DTL_RECNAME Character(15) VARCHAR2(15) NOT NULL Tree Structure Detail Record name

    Prompt Table: PSRECDEFNPVW

    6 BTN_SELECT Character(1) VARCHAR2(1) NOT NULL Select