PSTREEDEFNVW |
| Platform | View Text |
|---|---|
| Default | SELECT A.TREE_NAME ,A.SETID ,A.SETCNTRLVALUE ,A.EFFDT ,A.EFF_STATUS ,A.TREE_STRCT_ID ,A.DESCR ,A.TREE_CATEGORY ,A.VALID_TREE ,STRCT.NODE_RECNAME ,STRCT.DTL_RECNAME ,STRCT.LEVEL_RECNAME FROM PSTREEDEFN A ,PSTREESTRCT STRCT WHERE A.TREE_STRCT_ID <> 'ACCESS_GROUP' AND A.TREE_STRCT_ID = STRCT.TREE_STRCT_ID |
| PeopleSoft Field Name | Description |
|---|---|
 TREE_NAME | Tree Name |
| SETID | SetID Prompt Table: SETID_NOMETA_VW |
| SETCNTRLVALUE | Tree Definition User Key Value |
| EFFDT | Effective Date |
| 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 |
| VALID_TREE | Valid Tree N=Saved As Draft Y=Saved As Valid Tree |
| NODE_RECNAME | Tree Structure Node Record name Prompt Table: PSTREESTRCTNDVW |
| DTL_RECNAME | Tree Structure Detail Record name Prompt Table: PSTREESTRCTDTVW |
| LEVEL_RECNAME | Tree Structure Level Record name Prompt Table: PSTREESTRCTLVVW |
Author: PeopleTools | |
| Return to Index | © Go-Faster Consultancy Ltd. Last updated 24 July 2010 |