PSTREEDEFVWR_VW(SQL View) |
Index Back |
---|---|
Prompt View for Tree View |
SELECT DISTINCT A.TREE_NAME ,A.SETID ,A.SETCNTRLVALUE ,A.EFFDT ,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 |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | TREE_NAME | Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
2 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SETID_NOMETA_VW |
3 | SETCNTRLVALUE | Character(20) | VARCHAR2(20) NOT NULL | Tree Definition User Key Value |
4 | EFFDT | Date(10) | DATE | Effective Date |
5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
7 | TREE_CATEGORY | Character(18) | VARCHAR2(18) NOT NULL |
Category name for the Tree
Default Value: DEFAULT Prompt Table: PSTREECATGVW |
8 | TREE_STRCT_ID | Character(18) | VARCHAR2(18) NOT NULL |
Tree Structure Name (see PSTREESTRCT).
Prompt Table: PSTREESTRCTMVW |
9 | VALID_TREE | Character(1) | VARCHAR2(1) NOT NULL |
Valid Tree
N=Draft Tree Y=Valid Tree |
10 | NODE_FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Tree Structure Node Field name
Prompt Table: PSTREESTRCTNFVW |
11 | DTL_FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Tree Structure Detail Record name
Prompt Table: PSTREESTRCTDFVW |
12 | NODE_RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Tree Structure Node Record name
Prompt Table: PSTREESTRCTNDVW |
13 | DTL_RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Tree Structure Detail Record name
Prompt Table: PSTREESTRCTDTVW |
14 | LEVEL_RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Tree Structure Level Record name
Prompt Table: PSTREESTRCTLVVW |