GP_CALENDAR4_VW (SQL View)	Index Back
Pay Calendars Not in RUN DTL prompted by country as first key

GP_CALENDAR4_VW

(SQL View)

Pay Calendars Not in RUN DTL

prompted by country as first key

SELECT A.COUNTRY , 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 WHERE A.PAY_ENTITY = B.PAY_ENTITY AND B.GP_PAYGROUP = CAL.GP_PAYGROUP AND CAL.CAL_PRD_ID=PRD.CAL_PRD_ID 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)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

2 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
Prompt Table: %GP_EDIT_FLD2

3 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
Prompt Table: GP_CALENDAR

4 PRD_BGN_DT Date(10) DATE Period Begin Date

5 PRD_END_DT Date(10) DATE Pay Period End Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
2	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group Prompt Table: %GP_EDIT_FLD2
3	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id Prompt Table: GP_CALENDAR
4	PRD_BGN_DT	Date(10)	DATE	Period Begin Date
5	PRD_END_DT	Date(10)	DATE	Pay Period End Date