TREE_SETIDFIELDNAME1TREE_NAMETREE_EFFDTLANGUAGE_CDFLDRQTREELNG_VW(SQL View) |
Index Back |
|---|---|
Field Request Tree ViewField Request Tree View - Rel Lang Use TREE_SETID instead of SETID in this tree prompting view, to avoid the PeopleTools' auto SetID indirect prompting. A work record field, FLD_REQ_OTH_WRK.TREE_SETID, has to be added to the page and assigned value for the direct prompting. |
| SELECT A.SETID , B.DTL_FIELDNAME , A.TREE_NAME , A.EFFDT , L.LANGUAGE_CD , L.DESCR FROM PSTREEDEFN A , PSTREESTRCT B , PSTREEDEFNLANG L WHERE A.TREE_STRCT_ID=B.TREE_STRCT_ID AND A.SETID<>' ' AND B.DTL_FIELDNAME<>' ' AND L.SETID = A.SETID AND L.TREE_NAME = A.TREE_NAME AND L.EFFDT = A.EFFDT UNION SELECT A1.SETID , B1.NODE_FIELDNAME , A1.TREE_NAME , A1.EFFDT , L1.LANGUAGE_CD , L1.DESCR FROM PSTREEDEFN A1 , PSTREESTRCT B1 , PSTREEDEFNLANG L1 WHERE A1.TREE_STRCT_ID=B1.TREE_STRCT_ID AND A1.SETID<>' ' AND B1.DTL_FIELDNAME=' ' AND B1.NODE_FIELDNAME<>' ' AND L1.SETID = A1.SETID AND L1.TREE_NAME = A1.TREE_NAME AND L1.EFFDT = A1.EFFDT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TREE_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Tree SetID |
| 2 | FIELDNAME1 |
Character(18) | VARCHAR2(18) NOT NULL | Field Name 1 |
| 3 | TREE_NAME |
Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 4 | TREE_EFFDT |
Date(10) | DATE | Effective date of the Tree |
| 5 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 6 | TREE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Tree Description |