GP_CS_PAY_VW (SQL View)	Index Back
Payroll Calendar ID Prompt Payroll Calendar ID Prompt

GP_CS_PAY_VW

SELECT A.CAL_ID FROM PS_GP_CAL_RUN_DTL A , PS_GP_CAL_RUN B WHERE A.CAL_RUN_ID = B.CAL_RUN_ID AND A.CALC_TYPE = 'P' AND B.RUN_FINALIZED_IND = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id