PSTREESTRCTMVW

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 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
    NODE_RECNAME Character(15) VARCHAR2(15) NOT NULL Tree Structure Node Record name
    DTL_RECNAME Character(15) VARCHAR2(15) NOT NULL Tree Structure Detail Record name

    Prompt Table: PSRECDEFNPVW

    BTN_SELECT Character(1) VARCHAR2(1) NOT NULL Select
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19