TREE_NAMETREE_EFFDTSSR_TST_ID_NLDSSR_TREEVAV_VW2(SQL View) |
Index Back |
|---|---|
Test Admin Vavo View |
| SELECT DISTINCT A.TREE_NAME , A.EFFDT , %Substring(B.TREE_NODE, 1, 8) , D.DESCR FROM PSTREEDEFN A , PSTREENODE B , PS_SSR_TST_CAT_NLD D WHERE A.TREE_CATEGORY = 'TEST_ADMIN' AND A.SETID = B.SETID AND A.TREE_NAME = B.TREE_NAME AND B.EFFDT = A.EFFDT AND D.SSR_TST_EXAMTP_NLD = 'E' AND D.SSR_TST_ID_NLD = %Substring(B.TREE_NODE, 1, 8) AND D.EFFDT = ( SELECT MAX(D1.EFFDT) FROM PS_SSR_TST_CAT_NLD D1 WHERE D.SSR_TST_ID_NLD = D1.SSR_TST_ID_NLD AND D1.EFFDT <= %CurrentDateIn) AND D.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TREE_NAME |
Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 2 | TREE_EFFDT |
Date(10) | DATE | Effective date of the Tree |
| 3 | SSR_TST_ID_NLD |
Character(8) | VARCHAR2(8) NOT NULL | Test ID |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |