GPCH_RP_YEAR_VW (SQL View)	Index Back
Valid Swiss Payroll Years Valid Swiss Payroll Years View

GPCH_RP_YEAR_VW

(SQL View)

Valid Swiss Payroll Years

Valid Swiss Payroll Years View

SELECT DISTINCT TO_CHAR(CI.PRD_END_DT , 'YYYY') FROM PS_GP_CAL_RUN CPS ,PS_GP_CAL_RUN_DTL CI WHERE CPS.CAL_RUN_ID = CI.CAL_RUN_ID AND CI.CALC_TYPE = 'P' AND (CPS.RUN_FINALIZED_IND = 'Y' OR CPS.RUN_OPEN_IND = 'Y') AND CI.COUNTRY = 'CHE'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 YEAR Character(4) VARCHAR2(4) NOT NULL Character field to represent a year