GPMX_PTU

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %DATE
3	GPMX_BALANCE_YEAR	Number(4,0)	SMALLINT NOT NULL	Balance Year GP Mexico
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
6	GPMX_DATE	Date(10)	DATE NOT NULL	Date - Mexico
7	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
8	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
9	GPMX_INSTANCE_DAY	Number(3,0)	SMALLINT NOT NULL	Instance Day
10	GPMX_INSTANCE_SAL	Number(3,0)	SMALLINT NOT NULL	Instance Salary
11	GPMX_TOT_DAY	Number(11,6)	DECIMAL(10,6) NOT NULL	Total Days PTU
12	GPMX_CEIL_DAY	Number(11,6)	DECIMAL(10,6) NOT NULL	Ceiling Days GP Mexico
13	GPMX_TOT_SALARY	Number(15,6)	DECIMAL(14,6) NOT NULL	Total salary GP Mexico
14	GPMX_CEIL_SALARY	Number(15,6)	DECIMAL(14,6) NOT NULL	Ceiling Salary
15	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action Prompt Table: ACTION_TBL
16	REG_TEMP	Character(1)	VARCHAR2(1) NOT NULL	Regular/Temporary R=Regular T=Temporary
17	CALC_RSLT2_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Mobile Epay
18	NEW_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Equivalent to CALC_RSLT_VAL. Used when processing retro and prior and current results are both present.