PSTREEDEFDTLVW

Platform	View Text
Default	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	Description
TREE_NAME	Tree Name
DTL_RECNAME	Tree Structure Detail Record name Prompt Table: PSTREESTRCTDTVW

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