GPMX_ABS_EVT_VW(SQL View) |
Index Back |
---|---|
GP Mexico Absence Event ViewGP Mexico Absence Event View |
SELECT A.EMPLID , A.EMPL_RCD , A.BGN_DT , A.END_DT FROM PS_GP_ABS_EVENT A WHERE A.PIN_TAKE_NUM NOT IN ( SELECT B.PIN_NUM FROM PS_GP_ABS_TAKE B WHERE B.ABS_TYPE_OPTN IN ('OPA','RET','VAC') AND B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_GP_ABS_TAKE WHERE PIN_NUM = B.PIN_NUM AND EFFDT <= A.BGN_DT)) AND A.VOIDED_IND = '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 |
3 | BGN_DT | Date(10) | DATE | Begin Date |
4 | END_DT | Date(10) | DATE | end date |