EMPLIDEMPL_RCDPrompt Table: EMPLMT_SRCH_GBL
ABS_ESP_VW(SQL View) |
Index Back |
|---|---|
Employees with IT/AT/MT/REGeneric view that shows employees with absence event of IT/AT/MT/RE |
| SELECT A.EMPLID , A.EMPL_RCD , B.ABS_TYPE_OPTN , A.BGN_DT , A.END_DT FROM PS_GP_ABS_EVENT A , PS_GP_ABS_TAKE B , PS_INSTALLATION C WHERE B.PIN_NUM = A.PIN_TAKE_NUM AND B.EFFDT = ( SELECT MAX(ED.EFFDT) FROM PS_GP_ABS_TAKE ED WHERE ED.PIN_NUM = A.PIN_TAKE_NUM AND ED.EFFDT <= A.END_DT) AND B.EFF_STATUS = 'A' AND C.INSTALLED_GP_ESP = 'Y' UNION SELECT A.EMPLID , A.EMPL_RCD , D.ABSENCE_CLASS , A.BEGIN_DT , A.RETURN_DT FROM PS_ABSENCE_HIST A , PS_ABS_TYPE_TBL B , PS_ABS_CLASS_TBL D , PS_INSTALLATION C WHERE B.ABSENCE_TYPE = A.ABSENCE_TYPE AND B.SETID = D.SETID AND B.SETID = 'ESP' AND B.ABSENCE_CLASS = D.ABSENCE_CLASS AND C.INSTALLED_GP_ESP = 'N' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL |
Empl Record
Prompt Table: EMPLMT_SRCH_GBL |
| 3 | ABS_TYPE_OPTN | Character(3) | VARCHAR2(3) NOT NULL | Absence Type |
| 4 | BGN_DT | Date(10) | DATE | Begin Date |
| 5 | END_DT | Date(10) | DATE | end date |