GP_CAL_RUN_OFF (SQL Table)	Index Back
Off cycle grp in Calendar Grp Child table of GP CAL RUN listing off-cycle groups associated with a given Calendar Group

GP_CAL_RUN_OFF

(SQL Table)

Off cycle grp in Calendar Grp

Child table of GP CAL RUN listing off-cycle groups associated with a given Calendar Group

Parent record: GP_CAL_RUN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 CAL_SEQ_NUM Number(8,0) INTEGER NOT NULL Calendar Sequence Number

3 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
Prompt Table: GP_OFFCYCLE1_VW

4 CAL_PRD_ID Character(10) VARCHAR2(10) NOT NULL Calendar Period ID
Prompt Table: GP_OFFCYCLE2_VW

5 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
Prompt Table: GP_OFFCYCLE3_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
2	CAL_SEQ_NUM	Number(8,0)	INTEGER NOT NULL	Calendar Sequence Number
3	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group Prompt Table: GP_OFFCYCLE1_VW
4	CAL_PRD_ID	Character(10)	VARCHAR2(10) NOT NULL	Calendar Period ID Prompt Table: GP_OFFCYCLE2_VW
5	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 Prompt Table: GP_OFFCYCLE3_VW