GPMX_FORM37_ADD

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: EMPLMT_SRCH_GBL Set Control Field: EMPLID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL_MEX
4	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
5	GPMX_BALANCE_YEAR	Number(4,0)	SMALLINT NOT NULL	Balance Year GP Mexico
6	GPMX_MAR_VAL_SHARE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Share Market Value
7	GPMX_OPT_PRICE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Share Option Price
8	GPMX_ISR_RET	Signed Number(17,3)	DECIMAL(15,3) NOT NULL	Annual Adjust Tax retained during the year
9	GPMX_TRAVEL_EXPENS	Number(19,6)	DECIMAL(18,6) NOT NULL	Used to store travel expenses used in form 37
10	GPMX_IDE_TAX	Number(19,6)	DECIMAL(18,6) NOT NULL	IDE Tax
11	GPMX_AMT_CONTR	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Voluntary Contributions Amount
12	GPMX_CONTR_APPL	Character(1)	VARCHAR2(1) NOT NULL	Already considered during Tax Y/N Table Edit Default Value: N
13	GPMX_EE_DED_CONTR	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Employee Deductible Amount
14	GPMX_ER_DED_CONTR	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Eemployeer Deductible Amount