GP_OFFCYCLE1_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. Lists only Off-Cycle groups not already associated with another run.

GP_OFFCYCLE1_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. Lists only Off-Cycle groups not already associated with another run.

SELECT PE.COUNTRY , PG.GP_PAYGROUP FROM PS_GP_PYENT PE , PS_GP_PYGRP PG WHERE PE.PAY_ENTITY = PG.PAY_ENTITY AND EXISTS ( SELECT 1 FROM PS_GP_OFFCYCLE O WHERE O.GP_PAYGROUP = PG.GP_PAYGROUP AND GP_RUN_STATUS<>'F')

# 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

#	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