GPMX_ABS_EVT_VW

(SQL View)
Index Back

GP Mexico Absence Event View

GP 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