PSTREENAMEVW

(SQL View)
 Index Back

Distinct List of Tree Names


SELECT DISTINCT A.TREE_NAME , A.DESCR ,A.TREE_STRCT_ID FROM PSTREEDEFN A WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PSTREEDEFN A1 WHERE A.SETID = A1.SETID AND A.TREE_NAME = A1.TREE_NAME AND A.SETCNTRLVALUE = A1.SETCNTRLVALUE) AND A.TREE_STRCT_ID <> 'ACCESS_GROUP'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 TREE_STRCT_ID Character(18) VARCHAR2(18) NOT NULL Tree Structure Name (see PSTREESTRCT).