PSTREESTRCTPVW

(SQL View)
 Index Back

Tree Struct Prompt View

List of tree structures

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

  • Related Language Record: PSTREESTRPVWLAN

    • # 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

    Default Value: D