PSTREENAMEVW

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 NameField TypeColumn TypeDescription
TREE_NAMECharacter(18)VARCHAR2(18) NOT NULLTree Name
DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
TREE_STRCT_IDCharacter(18)VARCHAR2(18) NOT NULLTree Structure Name (see PSTREESTRCT).
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19