GPMX_INTERC_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
5	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
6	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
7	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
8	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
9	GPMX_PREV_COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Previous Company
10	GPMX_PREV_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Inter-company Previous Pay Group
11	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
12	USER_KEY1	Character(25)	VARCHAR2(25) NOT NULL	User Key 1
13	CALC_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
14	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
15	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
16	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action
17	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code
18	GPMX_SELECT_ALL1	Character(1)	VARCHAR2(1) NOT NULL	Select All Elements
19	RFC_ER_ID_MEX	Character(16)	VARCHAR2(16) NOT NULL	RFC ID Number
20	GPMX_OTH_ER_NAME	Character(30)	VARCHAR2(30) NOT NULL	Annual Adjust Other Employer Name
21	PYMT_DT	Date(10)	DATE	Payment Date
22	SEG_END_DT	Date(10)	DATE	Payee Process Segment's End Date
23	GPMX_BALANCE_YEAR	Number(4,0)	SMALLINT NOT NULL	Balance Year GP Mexico
24	START_DT	Date(10)	DATE	Start Date
25	END_DT	Date(10)	DATE	end date
26	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
27	AMOUNT	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Commuting Allowance Paid Per Cycle.
28	GPMX_DELETE_DATA	Character(1)	VARCHAR2(1) NOT NULL	Delete Data
29	REASON	Character(30)	VARCHAR2(30) NOT NULL	Reason
30	GPMX_CAL_ID_A	Character(18)	VARCHAR2(18) NOT NULL	Active Payees Calendar Id
31	GPMX_UPDATE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Update Process
32	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
33	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section