TREE_NAMEEFFDTVC_TREE_DEFN_VW(SQL View) |
Index Back |
|---|---|
Group Tree ViewVariable Comp: this view returns tree defined for variable comp. |
| SELECT A3.TREE_NAME , A3.EFFDT , A3.DESCR FROM PSTREEDEFN A3 WHERE A3.SETID = ' ' AND A3.SETCNTRLVALUE = ' ' AND A3.EFF_STATUS = 'A' AND A3.VALID_TREE = 'Y' AND A3.TREE_STRCT_ID = 'VC_GROUP_STRUCT' AND A3.EFFDT = ( SELECT MAX(EFFDT) FROM PSTREEDEFN WHERE A3.TREE_NAME = TREE_NAME AND A3.SETID = SETID AND A3.SETCNTRLVALUE = SETCNTRLVALUE AND EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TREE_NAME |
Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 2 | EFFDT |
Date(10) | DATE | Effective Date |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |