GP_OFFCYCLE3_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 Off cycle Group after Pay Group and calendar period has been chosen

GP_OFFCYCLE3_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 Off cycle Group after Pay Group and calendar period has been chosen

SELECT GP_PAYGROUP , CAL_PRD_ID , OFF_CYCLE_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

3 OFF_CYCLE_ID Character(18) VARCHAR2(18) NOT NULL Off-Cycle Group or Request ID. ID field used to identify, group and manage a set of payments requested to be made as Off-cycle payments

#	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
3	OFF_CYCLE_ID	Character(18)	VARCHAR2(18) NOT NULL	Off-Cycle Group or Request ID. ID field used to identify, group and manage a set of payments requested to be made as Off-cycle payments