SETIDTREE_NAMETREE_NODEEFFDTNVS_SCOPENODEVW |
index back |
|---|---|
XX |
| SELECT A.SETID ,A.TREE_NAME ,A.TREE_NODE ,A.EFFDT FROM PSTREENODE A ,PSTREEDEFN B WHERE B.SETID = A.SETID AND B.SETCNTRLVALUE = A.SETCNTRLVALUE AND B.TREE_NAME = A.TREE_NAME AND B.EFFDT = A.EFFDT AND ( A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PSTREENODE A_ED WHERE A.SETID = A_ED.SETID AND A.SETCNTRLVALUE = A_ED.SETCNTRLVALUE AND A.TREE_NAME = A_ED.TREE_NAME AND A_ED.EFFDT <= %CurrentDateIn ) AND B.EFF_STATUS = 'A' ) |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| TREE_NAME |
Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| TREE_NODE |
Character(20) | VARCHAR2(20) NOT NULL | Node name |
| EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |