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 NameField TypeColumn TypeDescription
    TREE_STRCT_IDCharacter(18)VARCHAR2(18) NOT NULLTree Structure Name (see PSTREESTRCT).
    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    TREE_STRCT_TYPECharacter(1)VARCHAR2(1) NOT NULLTree Structure Type: "D" = detail or "S" = summary
    D=Detail
    S=Summary

    Default: D

    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19