GPAU_CALPTD_VW

(SQL View)
 Index Back

Processed Cal Run ID

This View retrieves processed cal run id. Used as prompt record in STP PTD Override

SELECT DISTINCT A.PAY_ENTITY , CAL.CAL_RUN_ID FROM PS_GP_PYE_PRC_STAT A , PS_GP_CAL_RUN CAL , PS_GPAU_STP_PAYSTG B WHERE A.CAL_RUN_ID = CAL.CAL_RUN_ID AND B.CAL_RUN_ID = A.CAL_RUN_ID AND B.PAY_ENTITY = A.PAY_ENTITY AND B.GP_PAYGROUP = A.GP_PAYGROUP AND B.PYMT_DT = A.PYMT_DT AND (CAL.RUN_OPEN_IND = 'Y' OR CAL.RUN_FINALIZED_IND = 'Y') AND CAL.COUNTRY = 'AUS' AND A.CAL_RUN_ID = A.ORIG_CAL_RUN_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
2 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id