GPMX_PAY_CAL_VW

(SQL View)
 Index Back

Pay Calendars

Payroll Calendars IDs

SELECT B.GP_PAYGROUP ,CAL.CAL_ID ,PRD.PRD_BGN_DT ,PRD.PRD_END_DT FROM PS_GP_PYENT A , PS_GP_PYGRP B , PS_GP_CALENDAR CAL , PS_GP_CAL_PRD PRD , PS_GP_RUN_TYPE RNT WHERE A.PAY_ENTITY = B.PAY_ENTITY AND B.GP_PAYGROUP = CAL.GP_PAYGROUP AND CAL.CAL_PRD_ID=PRD.CAL_PRD_ID AND CAL.RUN_TYPE = RNT.RUN_TYPE AND RNT.CALC_TYPE = 'P' AND A.COUNTRY = 'MEX' AND NOT EXISTS ( SELECT 'X' FROM PS_GP_CAL_RUN_DTL D WHERE D.GP_PAYGROUP = CAL.GP_PAYGROUP AND D.CAL_ID = CAL.CAL_ID AND D.CAL_FINAL_TS IS NOT NULL)

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

Prompt Table: %GP_EDIT_FLD2

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

Prompt Table: GP_CALENDAR

3 PRD_BGN_DT Date(10) DATE Period Begin Date
4 PRD_END_DT Date(10) DATE Pay Period End Date