SETID_DEPTDEPTIDLANGUAGE_CDCS_DEPT_LANG(SQL View) |
Index Back |
|---|---|
View of all Departments RLR |
| SELECT A.setid , A.DEPTID , L.LANGUAGE_CD , L.descr , A.manager_name FROM PS_DEPT_TBL A ,PS_DEPT_TBL_LANG L WHERE A.effdt = ( SELECT MAX(B.effdt) FROM PS_DEPT_TBL B WHERE A.setid = B.setid AND A.DEPTID = B.DEPTID) AND L.SETID = A.SETID AND L.DEPTID = A.DEPTID AND L.EFFDT = A.EFFDT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID_DEPT |
Character(5) | VARCHAR2(5) NOT NULL | Department SetID |
| 2 | DEPTID |
Character(10) | VARCHAR2(10) NOT NULL | Department |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | MANAGER_NAME | Character(30) | VARCHAR2(30) NOT NULL | Identifies the name of the manager of a specified department. |