GPES_NSS_ABS_VW

(SQL View)
Index Back

NSS absence data in period

Non Social Security absence data in period

SELECT A.EMPLID , A.CAL_RUN_ID , A.EMPL_RCD , A.GP_PAYGROUP , A.CAL_ID , A.PRD_BGN_DT , B.BGN_DT , B.END_DT , %DateAdd(B.BGN_DT, -1) FROM PS_GP_PYE_PRC_STAT A , PS_GP_ABS_EVENT B , PS_GP_ABS_TAKE C WHERE A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND B.END_DT >= A.PRD_BGN_DT AND B.BGN_DT <= A.PRD_END_DT AND C.PIN_NUM = B.PIN_TAKE_NUM AND C.EFFDT = ( SELECT MAX(EFFDT) FROM PS_GP_ABS_TAKE WHERE PIN_NUM = C.PIN_NUM AND EFFDT <= A.PRD_END_DT) AND C.EFF_STATUS <> 'I' AND C.ABS_TYPE_OPTN IN ('NSS') AND B.PRC_EVT_ACTN_OPTN = 'N' AND B.VOIDED_IND = 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
4 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
5 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
6 PRD_BGN_DT Date(10) DATE Period Begin Date
7 BGN_DT Date(10) DATE Begin Date
8 END_DT Date(10) DATE end date
9 GPES_D_WO_NSS_ABS Date(10) DATE Day without Non Social Security absence