GP_OFFCYCLE2_VW (SQL View)	Index Back
Unprocessed Off Cycle Groups View used for prompting of Off-Cycle groups when setting up to run the Absence and Payroll process. View is used for prompting on Calendar Period after Pay Group has been chosen

GP_OFFCYCLE2_VW

(SQL View)

Unprocessed Off Cycle Groups

View used for prompting of Off-Cycle groups when setting up to run the Absence and Payroll process. View is used for prompting on Calendar Period after Pay Group has been chosen

SELECT DISTINCT GP_PAYGROUP , CAL_PRD_ID FROM PS_GP_OFFCYCLE WHERE GP_RUN_STATUS<>'F'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

2 CAL_PRD_ID Character(10) VARCHAR2(10) NOT NULL Calendar Period ID

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