PSTREEDEFNKVW

Platform	View Text
Default	SELECT A.TREE_NAME ,A.SETID ,A.SETCNTRLVALUE ,A.EFFDT ,A.TREE_BRANCH ,B.EFF_STATUS ,B.TREE_STRCT_ID ,B.DESCR ,B.TREE_CATEGORY FROM PSTREEPROMPT A ,PSTREEDEFN B WHERE A.SETID = B.SETID AND A.SETCNTRLVALUE = B.SETCNTRLVALUE AND A.TREE_NAME = B.TREE_NAME AND A.EFFDT = B.EFFDT AND B.TREE_STRCT_ID <> 'ACCESS_GROUP'

PeopleSoft Field Name	Description
TREE_NAME	Tree Name
SETID	SetID Prompt Table: SETID_NOMETA_VW
SETCNTRLVALUE	Tree Definition User Key Value
EFFDT	Effective Date
TREE_BRANCH	Tree Branch
EFF_STATUS	Effective Status A=Active I=Inactive
TREE_STRCT_ID	Tree Structure Name Prompt Table: PSTREESTRCT
DESCR	Description
TREE_CATEGORY	Category name for the Tree Default: DEFAULT

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