SETIDPrompt Table: SETID_NOMETA_VW
SETCNTRLVALUETREE_NAMEEFFDTDefault: %date
Prompt Table: PSTREESTRCT
N=Saved As Draft
Y=Saved As Valid Tree
PSTREEDEFQRYPVW |
| Platform | View Text |
|---|---|
| Default | SELECT A.SETID ,A.SETCNTRLVALUE ,A.TREE_NAME ,A.EFFDT ,A.TREE_STRCT_ID ,A.VALID_TREE ,A.DESCR FROM PSTREEDEFN A WHERE A.TREE_STRCT_ID <> 'ACCESS_GROUP' |
| PeopleSoft Field Name | Description |
|---|---|
| SETID | SetID Prompt Table: SETID_NOMETA_VW |
| SETCNTRLVALUE | Tree Definition User Key Value |
| TREE_NAME | Tree Name |
| EFFDT | Effective Date Default: %date |
| TREE_STRCT_ID | Tree Structure Name Prompt Table: PSTREESTRCT |
| VALID_TREE | Valid Tree N=Saved As Draft Y=Saved As Valid Tree |
| DESCR | Description |
Author: PeopleTools | |
| Return to Index | © Go-Faster Consultancy Ltd. Last updated 24 July 2010 |