GP_CL_RN_OF_HST (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_CL_RN_OF_HST

(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 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).

2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number

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

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

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

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

7 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	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
4	CAL_SEQ_NUM	Number(8,0)	INTEGER NOT NULL	Calendar Sequence Number
5	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group Prompt Table: GP_OFFCYCLE1_VW
6	CAL_PRD_ID	Character(10)	VARCHAR2(10) NOT NULL	Calendar Period ID Prompt Table: GP_OFFCYCLE2_VW
7	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