PSTREENAMEVW

Platform	View Text
Default	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	Description
TREE_NAME	Tree Name
DESCR	Description
TREE_STRCT_ID	Tree Structure Name

Author: PeopleTools
Return to Index	© Go-Faster Consultancy Ltd.  Last updated 24 July 2010