EMPLIDDEPTIDSRVC_HOLDSVW_FL(SQL View) |
Index Back |
|---|---|
Selects Department ID's |
| SELECT DISTINCT A.EMPLID ,A.INSTITUTION ,A.DEPTID ,A.DESCR3 FROM PS_SRVCIND_HOLD_VW A WHERE EXISTS ( SELECT 'X' FROM PS_SRVC_IND_CD_TBL B WHERE B.EFFDT=( SELECT MAX(B1.EFFDT) FROM PS_SRVC_IND_CD_TBL B1 WHERE B1.INSTITUTION=B.INSTITUTION AND B1.SRVC_IND_CD=B.SRVC_IND_CD AND B1.EFFDT<=%CurrentDateIn) AND B.EFF_STATUS='A' AND B.SRVC_IND_CD=A.SRVC_IND_CD AND B.INSTITUTION=A.INSTITUTION AND B.SCC_HOLD_DISPLAY='Y') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 3 | DEPTID |
Character(10) | VARCHAR2(10) NOT NULL | Department |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |