SETIDNL_DEPTID_ROOTPrompt Table: DEPT_TBL
DEPTIDDEPT_SEC_VW_NLD(SQL View) |
Index Back |
|---|---|
Department Hierarchy View NLDDepartment Hierarchy View used for Dutch Absence History Reporting |
| SELECT A.SETID , %Substring(A.TREE_NODE,1,10) , %Substring(B.TREE_NODE,1,10) FROM PSTREENODE A , PSTREENODE B WHERE A.SETID = B.SETID AND A.TREE_NAME = 'DEPT_SECURITY' AND A.TREE_NAME = B.TREE_NAME AND A.EFFDT= ( SELECT MAX(C.EFFDT) FROM PSTREEDEFN C WHERE C.SETID = A.SETID AND C.TREE_NAME = A.TREE_NAME AND C.EFFDT <= %CurrentDateIn) AND A.EFFDT = B.EFFDT AND A.TREE_BRANCH = B.TREE_BRANCH AND B.TREE_NODE_NUM BETWEEN A.TREE_NODE_NUM AND A.TREE_NODE_NUM_END |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | NL_DEPTID_ROOT |
Character(10) | VARCHAR2(10) NOT NULL |
Department ID
Prompt Table: DEPT_TBL |
| 3 | DEPTID |
Character(10) | VARCHAR2(10) NOT NULL | Department |