GPMX_OTH_ER_DET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	RFC_ER_ID_MEX	Character(16)	VARCHAR2(16) NOT NULL	RFC ID Number
4	GPMX_BALANCE_YEAR	Number(4,0)	SMALLINT NOT NULL	Balance Year GP Mexico
5	START_DT	Date(10)	DATE NOT NULL	Start Date
6	END_DT	Date(10)	DATE NOT NULL	end date
7	GPMX_ERNDED_CD	Character(4)	VARCHAR2(4) NOT NULL	Earning or Deduction Code for Other Employer Table 0010=Total Earnings 0020=Non Taxable Christmas Bonus 0030=Non Taxable Vacation Premium 0040=Non Taxable Profit Sharing 0050=Other Non Taxable 0060=Creditable Subsidy Portion 0070=Subsidy 0080=Subsidy NA 0090=Withheld Tax 0100=Cash Salary Credit 0110=Termination Earnings 0120=Non Taxable Termination 0130=Taxable Termination Earnings 0140=Withheld Termination Tax 0170=Employment Subsidy
8	AMOUNT	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Commuting Allowance Paid Per Cycle.