PSTREEDEFDTLVW

(SQL View)
 Index Back

Tree Defn Prompt - No Branches


SELECT DISTINCT DEFN.TREE_NAME ,STRCT.DTL_RECNAME FROM PSTREEDEFN DEFN ,PSTREESTRCT STRCT WHERE DEFN.TREE_STRCT_ID <> 'ACCESS_GROUP' AND DEFN.TREE_STRCT_ID = STRCT.TREE_STRCT_ID AND STRCT.SETCNTRL_IND IN ('S','N') AND STRCT.TREE_STRCT_TYPE = 'D'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
2 DTL_RECNAME Character(15) VARCHAR2(15) NOT NULL Tree Structure Detail Record name

Prompt Table: PSTREESTRCTDTVW