GPFR_CAL_VW (SQL View)	Index Back
Calendar Dates View Calendar Dates View by Paygroup

GPFR_CAL_VW

(SQL View)

Calendar Dates View

Calendar Dates View by Paygroup

SELECT A.GP_PAYGROUP , A.CAL_ID , A.PYMT_DT , B.PRD_BGN_DT , B.PRD_END_DT FROM PS_GP_CALENDAR A , PS_GP_CAL_PRD B , PS_GP_RUN_TYPE C WHERE A.CAL_PRD_ID = B.CAL_PRD_ID AND A.RUN_TYPE = C.RUN_TYPE AND C.CALC_TYPE = 'P'

# 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_PYGRP

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

3 PYMT_DT Date(10) DATE Payment Date

4 PRD_BGN_DT Date(10) DATE NOT NULL Period Begin Date

5 PRD_END_DT Date(10) DATE NOT NULL Pay Period End Date

#	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_PYGRP
2	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
3	PYMT_DT	Date(10)	DATE	Payment Date
4	PRD_BGN_DT	Date(10)	DATE NOT NULL	Period Begin Date
5	PRD_END_DT	Date(10)	DATE NOT NULL	Pay Period End Date