PSTREESTRCTPVW

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 Field Type Column Type Description
    TREE_STRCT_ID Character(18) VARCHAR2(18) NOT NULL Tree Structure Name (see PSTREESTRCT).
    DESCR Character(30) VARCHAR2(30) NOT NULL Description
    TREE_STRCT_TYPE Character(1) VARCHAR2(1) NOT NULL Tree Structure Type: "D" = detail or "S" = summary
    D=Detail
    S=Summary

    Default: D

    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20