GPMX_DIG_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
4	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
5	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
6	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
7	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
8	GPMX_STAMP	Long Character(800)	VARCHAR2(800)	Digital Stamping Value
9	GPMX_ID_CERT	Character(50)	VARCHAR2(50) NOT NULL	Digital Certificate
10	GPMX_DATE_STAMP	Character(30)	VARCHAR2(30) NOT NULL	Stamping Date
11	GPMX_FISCAL_FOLIO	Character(50)	VARCHAR2(50) NOT NULL	Fiscal Folio (UUID) SAT
12	GPMX_ID_CERT_GOV	Character(40)	VARCHAR2(40) NOT NULL	Digital Certificate Goverment
13	GPMX_STAMP_GOV	Long Character(800)	VARCHAR2(800)	Digital Stamping Value Goverment
14	GPMX_VERSION	Character(5)	VARCHAR2(5) NOT NULL	Version
15	GPMX_FILE_NAME	Character(250)	VARCHAR2(250) NOT NULL	Name of a file, with full path, according to the process scheduler server.
16	METHODNAME	Character(32)	VARCHAR2(32) NOT NULL	Method Name
17	FORMID	Character(70)	VARCHAR2(70) NOT NULL	Form ID
18	GPMX_NID_RFC	Character(20)	VARCHAR2(20) NOT NULL	National ID: RFC
19	REP_RFC_MEX	Character(16)	VARCHAR2(16) NOT NULL	Legal Representative RFC
20	CALC_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
21	FILE_NAME	Character(80)	VARCHAR2(80) NOT NULL	File Name
22	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
23	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
24	GPMX_XML_PAYSLIP	Long Character(32700)	CLOB	XML Payslip
25	GPMX_VER_RECEIPT	Character(5)	VARCHAR2(5) NOT NULL	Version Receipt
26	GPMX_CD_REGIME	Character(2)	VARCHAR2(2) NOT NULL	Labor regimen code 1=Similar to Salary 10=Income Stock or Bond 11=Similar Others 12=Retired 13=Severance 2=Salaries and Wages 3=Retirees 4=Pensioners 5=Similar to Salary Cooperative 6=Similar to Salary Civil Associ 7=Members of Council Directors 8=Similar to Salary Business Act 9=Salary and Serv Fees Assim 99=Other Default Value: 2
27	GPMX_LOCATION_DESC	Character(250)	VARCHAR2(250) NOT NULL	Location
28	GPMX_PAID_DAYS	Signed Number(4,0)	DECIMAL(3) NOT NULL	Paid Days
29	GPMX_COMP_ACTIVITY	Character(2)	VARCHAR2(2) NOT NULL	Company Settings 1=Class I 2=Class II 3=Class III 4=Class IV 5=Class V 99=Not Applicable
30	TP_CONTRACT_FROM	Character(25)	VARCHAR2(25) NOT NULL	Contract Num From
31	GPMX_JOURNAL_TYPE	Character(30)	VARCHAR2(30) NOT NULL	Journal Type Description MEX
32	GPMX_EMP_TAX_TREAT	Character(3)	VARCHAR2(3) NOT NULL	Employee Tax Treatment MEX 605=Wages & Salaries & Assimilated
33	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
34	GPMX_TAX_TREATMENT	Character(3)	VARCHAR2(3) NOT NULL	Tax Treatment MEX 601=General of Law Moral Persons 603=Non-Profit Moral Persons 605=Wages & Salaries & Assimilated 606=Lease 607=Disposal/Acquisition of Goods 608=Other income 609=Consolidation 610=Residents Abroad w/o Permanent 611=Income from Dividends 612=Physical Persons w/Business 614=Interest income 615=Income for getting prizes 616=Without tax obligations 620=Cooperative Production Comp 621=Tax Incorporation 622=Agricultural, Livestock, Fores 623=Optional for Groups of Comp 624=Coordinated