GM_TREE_NAME_VW

(SQL View)
 Index Back

Grants Tree Name View


SELECT DISTINCT A.SETID ,A.TREE_NAME ,A.TREE_STRCT_ID ,A.DESCR FROM PSTREEDEFN A

  • Related Language Record: GM_TREE_N_LG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TREE_SETID Character(5) VARCHAR2(5) NOT NULL Tree SetID

    Prompt Table: SETID_NOMETA_VW

    2 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
    3 TREE_STRCT_ID Character(18) VARCHAR2(18) NOT NULL Tree Structure Name (see PSTREESTRCT).

    Prompt Table: PSTREESTRCT

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description