GP_OFF_ADV_WRK (SQL Table)	Index Back
Off cycle Advance Identify Building block for creating PYE PRC STAT from advances in identify. Built from the GP PYE CAL transaction and the associated calendar being advanced. Result is used in join to JOB and other requirement records alongside normal selection criteria in creating GP PYE PRC STAT

GP_OFF_ADV_WRK

(SQL Table)

Off cycle Advance Identify

Building block for creating PYE PRC STAT from advances in identify. Built from the GP PYE CAL transaction and the associated calendar being advanced. Result is used in join to JOB and other requirement records alongside normal selection criteria in creating GP PYE PRC STAT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

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

3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

4 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

5 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id

6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

7 RUN_TYPE Character(10) VARCHAR2(10) NOT NULL Run Type Name

8 CAL_PRD_ID Character(10) VARCHAR2(10) NOT NULL Calendar Period ID

9 PRD_BGN_DT Date(10) DATE Period Begin Date

10 PRD_END_DT Date(10) DATE Pay Period End Date

11 PRC_BGN_DT Date(10) DATE The Processing Begin Date is the Beginning Date of the Period when Processing is taking place. It usually is the same as the Period Begin Date (PRD_BGN_DT), except in cases of Advance Payment.

12 PRC_END_DT Date(10) DATE The Processing End Date is the End Date of the Period when Processing is taking place. It usually is the same as the Period End Date (PRD_END_DT), except in cases of Advance Payment.

13 PYMT_DT Date(10) DATE Payment Date

14 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity

15 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

16 CALC_TYPE Character(1) VARCHAR2(1) NOT NULL Calculation Process Type. Identifies a run as either absence run or payroll run
A=Absence Calculation
B=All Calculations
P=Payroll Calculation

17 CALC_FROM_DT Date(10) DATE Calculate From Date. Used to aid in calculating only a partial pay period

18 CALC_THRU_DT Date(10) DATE Calculate Thru Date

19 GP_NO_REG_RES_IND Character(1) VARCHAR2(1) NOT NULL Used to indicate that no element resolution is to take place except the processing of retro adjustment and PI. Introduced with Offcycle

20 PIN_ELEM_GRP_NUM Number(8,0) INTEGER NOT NULL PIN Number for Element Group

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
4	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
5	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
6	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
7	RUN_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Run Type Name
8	CAL_PRD_ID	Character(10)	VARCHAR2(10) NOT NULL	Calendar Period ID
9	PRD_BGN_DT	Date(10)	DATE	Period Begin Date
10	PRD_END_DT	Date(10)	DATE	Pay Period End Date
11	PRC_BGN_DT	Date(10)	DATE	The Processing Begin Date is the Beginning Date of the Period when Processing is taking place. It usually is the same as the Period Begin Date (PRD_BGN_DT), except in cases of Advance Payment.
12	PRC_END_DT	Date(10)	DATE	The Processing End Date is the End Date of the Period when Processing is taking place. It usually is the same as the Period End Date (PRD_END_DT), except in cases of Advance Payment.
13	PYMT_DT	Date(10)	DATE	Payment Date
14	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
15	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
16	CALC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Calculation Process Type. Identifies a run as either absence run or payroll run A=Absence Calculation B=All Calculations P=Payroll Calculation
17	CALC_FROM_DT	Date(10)	DATE	Calculate From Date. Used to aid in calculating only a partial pay period
18	CALC_THRU_DT	Date(10)	DATE	Calculate Thru Date
19	GP_NO_REG_RES_IND	Character(1)	VARCHAR2(1) NOT NULL	Used to indicate that no element resolution is to take place except the processing of retro adjustment and PI. Introduced with Offcycle
20	PIN_ELEM_GRP_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number for Element Group