PSTREEDEFMVW |
| Platform | View Text |
|---|---|
| Default | SELECT 'N' ,DEFN.TREE_NAME ,DEFN.SETID ,DEFN.SETCNTRLVALUE ,DEFN.EFFDT ,DEFN.EFF_STATUS ,DEFN.DESCR ,DEFN.TREE_CATEGORY ,DEFN.VALID_TREE ,STRCT.TREE_STRCT_ID ,STRCT.SETCNTRL_IND ,STRCT.NODE_FIELDNAME ,STRCT.DTL_FIELDNAME ,STRCT.NODE_RECNAME ,STRCT.DTL_RECNAME ,STRCT.LEVEL_RECNAME FROM PSTREEDEFN DEFN ,PSTREESTRCT STRCT WHERE DEFN.TREE_STRCT_ID <> 'ACCESS_GROUP' AND DEFN.TREE_STRCT_ID = STRCT.TREE_STRCT_ID |
| PeopleSoft Field Name | Description |
|---|---|
| BTN_SELECT | Select |
 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 |
| DESCR | Description |
| TREE_CATEGORY | Category name for the Tree Default: DEFAULT Prompt Table: PSTREECATGVW |
| VALID_TREE | Valid Tree N=Saved As Draft Y=Saved As Valid Tree |
| TREE_STRCT_ID | Tree Structure Name Prompt Table: PSTREESTRCT |
| SETCNTRL_IND | Tree Structure User Key Field Type Indicator B=Business Unit N=None S=SetId Indirection U=User Defined |
| 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 |