GPMX_CF_OPM_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
4	INSTANCE	Number(3,0)	SMALLINT NOT NULL	Instance Number
5	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
6	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
7	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
8	GPMX_CFDI_OPM_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Other Payment Type Codes for CFDI 001=ISR Devolution 002=Employment Subsidy 003=Travel Expenses 004=Positive Balance Application 005=Refund Prev ISR Over-Withheld 006=Work Canteen Serv Art 94 LISR 007=ISR Adjusted by Subsidy 008=Overpaid Subsidy 009=INFONAVIT Paid In Excess 999=Other Payments
9	PIN_NM	Character(18)	VARCHAR2(18) NOT NULL	Element Name field
10	GPMX_NID_RFC	Character(20)	VARCHAR2(20) NOT NULL	National ID: RFC
11	PIN_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Element Type Prompt Table: GP_PIN_TYPE
12	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
13	GPMX_RSLT_NO_TAX	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Results Deductions Non Taxable
14	GPMX_TOT_ERN_NOTAX	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Total Earning Non Taxable
15	GPMX_TOT_DED_NOTAX	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Total Deductions Non Taxable
16	GPMX_BALANCE_YEAR	Number(4,0)	SMALLINT NOT NULL	Balance Year GP Mexico
17	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog. Default Value: 0
18	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog. Default Value: 0
19	GPMX_SUB_EMP_PAID	Character(1)	VARCHAR2(1) NOT NULL	Employment Subsidy Effective Paid