TREE_NAMETC_TREE_VW(SQL View) |
Index Back |
|---|---|
TC Tree Name ViewTC Tree Name View |
| SELECT DISTINCT B.TREE_NAME FROM PSTREEDEFN B WHERE B.TREE_STRCT_ID = 'DEPARTMENT' AND B.EFFDT = ( SELECT MAX(A.EFFDT) FROM PSTREEDEFN A WHERE A.SETID = B.SETID AND A.SETCNTRLVALUE = B.SETCNTRLVALUE AND A.TREE_NAME = B.TREE_NAME AND A.EFFDT <= %CurrentDateIn ) AND B.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TREE_NAME |
Character(18) | VARCHAR2(18) NOT NULL | Tree Name |