GPMX_OVR_WEEKLY

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
2	GPMX_BALANCE_YEAR	Number(4,0)	SMALLINT NOT NULL	Balance Year GP Mexico Prompt Table: GPMX_OVRTME_CAL
3	GPMX_WKN	Number(2,0)	SMALLINT NOT NULL	Week GP Mexico Prompt Table: GPMX_OVRTME_CAL
4	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
5	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: GPMX_OVR_EMP_VW
6	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record Prompt Table: GPMX_EMPL_RCD
7	HOURLY_RT	Number(19,6)	DECIMAL(18,6) NOT NULL	Hourly Rate
8	GPMX_DBL_HRS	Number(6,2)	DECIMAL(5,2) NOT NULL	Double Hours Total GP Mexico
9	GPMX_DBL_AMT	Number(11,2)	DECIMAL(10,2) NOT NULL	Double Hours Total Amount GP Mexico
10	GPMX_TRIPLE_HRS	Number(6,2)	DECIMAL(5,2) NOT NULL	Triple Total Hours GP Mexico
11	GPMX_TRIPLE_AMT	Number(11,2)	DECIMAL(10,2) NOT NULL	Triple Total Hours Amount GP Mexico
12	GPMX_HOL_HRS	Number(6,2)	DECIMAL(5,2) NOT NULL	Holiday Hours Total GP Mexico
13	GPMX_HOL_AMT	Number(11,2)	DECIMAL(10,2) NOT NULL	Holiday Hours Total Amount GP Mexico
14	GPMX_REST_HRS	Number(6,2)	DECIMAL(5,2) NOT NULL	Worked Day Off Hours Total GP Mexico
15	GPMX_REST_AMT	Number(11,2)	DECIMAL(10,2) NOT NULL	Rest Day Hours Total Amount GP Mexico
16	GPMX_DBL_IN_HRS	Number(6,2)	DECIMAL(5,2) NOT NULL	In Excess Hours Total GP Mexico
17	GPMX_DBL_IN_AMT	Number(11,2)	DECIMAL(10,2) NOT NULL	In Excess Hours Total Amount GP Mexico
18	GPMX_OVR_NONTAX	Number(3,0)	SMALLINT NOT NULL	Non Taxable Overtime
19	GPMX_DBL_HRS_TXBL	Number(6,2)	DECIMAL(5,2) NOT NULL	Double Hours Taxable
20	GPMX_DBL_AMT_TXBL	Number(11,2)	DECIMAL(10,2) NOT NULL	Double Hours Taxable Amount
21	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: BUS_UNIT_TBL_HR
22	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code Prompt Table: JOBCODE_TBL_VW
23	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPT_TBL_VW
24	GPMX_WEEKLY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Weekly Overtime Flag Y/N Table Edit Default Value: N
25	GPMX_SHIFT	Character(1)	VARCHAR2(1) NOT NULL	Shift Prompt Table: GPMX_OVRSHIFT_V
26	GPMX_SHIFT_HOURS	Number(5,2)	DECIMAL(4,2) NOT NULL	Shift Hours Prompt Table: GPMX_OVRSHIFT_V
27	DAILY_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Daily Rate
28	GPMX_DBL_DAYS	Number(3,0)	SMALLINT NOT NULL	Double Days Total GP Mexico
29	GPMX_DBL_DAYS_TXBL	Number(3,0)	SMALLINT NOT NULL	Double Days Taxable
30	GPMX_DBL_IN_DAYS	Number(3,0)	SMALLINT NOT NULL	In Excess Days Total GP Mexico
31	GPMX_HOL_DAYS	Number(3,0)	SMALLINT NOT NULL	Holiday Days Total GP Mexico
32	GPMX_REST_DAYS	Number(3,0)	SMALLINT NOT NULL	Worked Day Off Days Total GP Mexico
33	GPMX_TRIPLE_DAYS	Number(3,0)	SMALLINT NOT NULL	Triple Total Days GP Mexico