GPMX_OVR_DAILY

#	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: GPMX_OVRTME_CAL
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 Rcd Nbr
7	GPMX_OVT_DT	Date(10)	DATE NOT NULL	Overtime Date GP Mexico
8	GPMX_HR	Number(5,2)	DECIMAL(4,2) NOT NULL	Overtime Worked Hours GP Mexico
9	GPMX_HOL	Number(5,2)	DECIMAL(4,2) NOT NULL	Worked Holiday GP Mexico
10	GPMX_RESTDAY	Number(5,2)	DECIMAL(4,2) NOT NULL	Worked Day Off GP Mexico
11	OVERRIDE_HOURLY_RT	Character(1)	VARCHAR2(1) NOT NULL	OverRide Hourly Rate Indicator Y/N Table Edit Default Value: N
12	HOURLY_RT	Number(19,6)	DECIMAL(18,6) NOT NULL	Hourly Rate
13	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: BUS_UNIT_TBL_HR
14	GPMX_OVRD_JOBCODE	Character(1)	VARCHAR2(1) NOT NULL	Override Job Code Flag Y/N Table Edit Default Value: N
15	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code Prompt Table: JOBCODE_TBL_VW
16	GPMX_OVRD_DEPTID	Character(1)	VARCHAR2(1) NOT NULL	Override by Department Flag Y/N Table Edit Default Value: N
17	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPT_TBL_VW
18	GPMX_DBL_HRS	Number(6,2)	DECIMAL(5,2) NOT NULL	Double Hours Total GP Mexico
19	GPMX_DBL_AMT	Number(11,2)	DECIMAL(10,2) NOT NULL	Double Hours Total Amount GP Mexico
20	GPMX_TRIPLE_HRS	Number(6,2)	DECIMAL(5,2) NOT NULL	Triple Total Hours GP Mexico
21	GPMX_TRIPLE_AMT	Number(11,2)	DECIMAL(10,2) NOT NULL	Triple Total Hours Amount GP Mexico
22	GPMX_HOL_HRS	Number(6,2)	DECIMAL(5,2) NOT NULL	Holiday Hours Total GP Mexico
23	GPMX_HOL_AMT	Number(11,2)	DECIMAL(10,2) NOT NULL	Holiday Hours Total Amount GP Mexico
24	GPMX_REST_HRS	Number(6,2)	DECIMAL(5,2) NOT NULL	Worked Day Off Hours Total GP Mexico
25	GPMX_REST_AMT	Number(11,2)	DECIMAL(10,2) NOT NULL	Rest Day Hours Total Amount GP Mexico
26	GPMX_DBL_IN_HRS	Number(6,2)	DECIMAL(5,2) NOT NULL	In Excess Hours Total GP Mexico
27	GPMX_DBL_IN_AMT	Number(11,2)	DECIMAL(10,2) NOT NULL	In Excess Hours Total Amount GP Mexico
28	GPMX_DBL_HRS_TXBL	Number(6,2)	DECIMAL(5,2) NOT NULL	Double Hours Taxable
29	GPMX_DBL_AMT_TXBL	Number(11,2)	DECIMAL(10,2) NOT NULL	Double Hours Taxable Amount
30	GPMX_HRLY_BASED_ON	Character(1)	VARCHAR2(1) NOT NULL	Hourly Basen On for Overtime - Mex 1=Hourly Rate 2=Shift Default Value: 1
31	GPMX_SHIFT	Character(1)	VARCHAR2(1) NOT NULL	Shift Prompt Table: GPMX_OVRSHIFT_V
32	GPMX_SHIFT_HOURS	Number(5,2)	DECIMAL(4,2) NOT NULL	Shift Hours
33	DAILY_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Daily Rate