GP_UDLT_CALID_V

(SQL View)
Index Back

Unprocessed Deltas-Calendar ID

This view selects calendar ids that has payees with unprocessed retro deltas

SELECT DISTINCT A.EMPLID , A.EMPL_RCD , A.GP_PAYGROUP , A.CAL_ID , C.NAME FROM PS_GP_RSLT_DELTA A , PS_GP_CAL_RUN B , PS_PERSON_NAME C , PS_GP_CALENDAR D WHERE A.CAL_RUN_ID = B.CAL_RUN_ID AND B.RUN_FINALIZED_TS IS NOT NULL AND A.FORWARD_IND = 'Y' AND A.FWD2_CAL_RUN_ID = ' ' AND A.RTO_MATCH_ACTN <> 'N' AND A.EMPLID = C.EMPLID AND A.GP_PAYGROUP = D.GP_PAYGROUP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: GP_UDELT_EMP_VW

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
4 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
5 NAME Character(50) VARCHAR2(50) NOT NULL Name