CS_SETIDDEPTIDLANGUAGE_CDCS_DEPT2_LVW(SQL View) |
Index Back |
|---|---|
View of all Departments RLR |
| SELECT A.CS_SETID , B.DEPTID , L.LANGUAGE_CD , L.descr , B.manager_name FROM PS_CS_DOC_HDR A , ps_dept_tbl B ,PS_DEPT_TBL_LANG L WHERE A.CS_SETID = B.SETID AND B.effdt = ( SELECT MAX(C.effdt) FROM ps_dept_tbl C WHERE B.setid = C.setid AND B.DEPTID = C.DEPTID AND C.EFF_STATUS = 'A') AND L.SETID = A.CS_SETID AND L.DEPTID = B.DEPTID AND L.EFFDT = B.EFFDT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CS_SETID |
Character(5) | VARCHAR2(5) NOT NULL | setid for the document objects |
| 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. |