PSTREEDEFBVW |
| Platform | View Text |
|---|---|
| Default | SELECT A.TREE_NAME ,A.SETID ,A.SETCNTRLVALUE ,A.EFFDT ,A.TREE_BRANCH ,B.EFF_STATUS ,B.DESCR ,B.TREE_CATEGORY ,B.TREE_STRCT_ID ,B.VALID_TREE ,STRCT.NODE_FIELDNAME ,STRCT.DTL_FIELDNAME ,STRCT.NODE_RECNAME ,STRCT.DTL_RECNAME ,STRCT.LEVEL_RECNAME FROM PSTREEPROMPT A ,PSTREEDEFN B ,PSTREESTRCT STRCT 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' AND B.TREE_STRCT_ID = STRCT.TREE_STRCT_ID AND A.TREE_BRANCH <> ' ' |
| 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 Name |
| EFF_STATUS | Effective Status A=Active I=Inactive |
| DESCR | Description |
| TREE_CATEGORY | Category name for the Tree Default: DEFAULT Prompt Table: PSTREECATGVW |
| TREE_STRCT_ID | Tree Structure Name Prompt Table: PSTREESTRCT |
| VALID_TREE | Valid Tree N=Saved As Draft Y=Saved As Valid Tree |
| NODE_FIELDNAME | Tree Structure Node Field name Prompt Table: PSTREESTRCTNFVW |
| DTL_FIELDNAME | Tree Structure Detail Record name Prompt Table: PSTREESTRCTDFVW |
| 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 |