GP_OFFCYCL_SRCH (SQL View)	Index Back
Off Cycle Search Search view for off cycle payment entry interface

GP_OFFCYCL_SRCH

(SQL View)

Off Cycle Search

Search view for off cycle payment entry interface

SELECT GP_PAYGROUP , CAL_PRD_ID , OFF_CYCLE_ID , CAL_RUN_ID , GP_RUN_STATUS FROM PS_GP_OFFCYCLE

# 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_PRD_ID Character(10) VARCHAR2(10) NOT NULL Calendar Period ID
Prompt Table: GP_CAL_PRD

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

4 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

5 GP_RUN_STATUS Character(1) VARCHAR2(1) NOT NULL Processing Status; initial use to reflect the status of an Off-cycle group as to whether processing has been initiated or finalized
A=Calculation Successful
C=Cancelled
E=Calculated with Errors
F=Processing finalized
I=Process initiated
U=Unprocessed

#	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_PRD_ID	Character(10)	VARCHAR2(10) NOT NULL	Calendar Period ID Prompt Table: GP_CAL_PRD
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
4	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
5	GP_RUN_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Processing Status; initial use to reflect the status of an Off-cycle group as to whether processing has been initiated or finalized A=Calculation Successful C=Cancelled E=Calculated with Errors F=Processing finalized I=Process initiated U=Unprocessed