GP_CS_CALID_AVW

(SQL View)
 Index Back

CalRunDtl view for Statistics

View used to display Calendar Run ID Statistics

SELECT DISTINCT A.GP_PAYGROUP , A.CAL_ID FROM PS_GP_CAL_RUN_DTL A , PS_GP_CAL_RUN_DTL B WHERE A.GP_PAYGROUP = B.GP_PAYGROUP AND A.COUNTRY = B.COUNTRY AND A.CALC_TYPE = B.CALC_TYPE AND A.CALC_TYPE = 'A' AND A.CAL_FINAL_TS <= ( SELECT MAX(C.CAL_FINAL_TS) FROM PS_GP_CAL_RUN_DTL C , PS_GP_CAL_RUN D WHERE (C.CAL_FINAL_TS < B.CAL_FINAL_TS AND B.CAL_RUN_ID = D.CAL_RUN_ID AND C.GP_PAYGROUP = B.GP_PAYGROUP AND C.COUNTRY = B.COUNTRY AND C.CALC_TYPE = B.CALC_TYPE AND D.RUN_FINALIZED_IND = 'Y') OR (C.CAL_FINAL_TS < B.CAL_IDNT_TS AND B.CAL_RUN_ID = D.CAL_RUN_ID AND C.GP_PAYGROUP = B.GP_PAYGROUP AND C.COUNTRY = B.COUNTRY AND C.CALC_TYPE = B.CALC_TYPE AND D.RUN_FINALIZED_IND = 'N'))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
2 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id