GPMX_CFDI_WA

#	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 Rcd Nbr
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	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
9	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
10	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
11	DAYS	Number(3,0)	SMALLINT NOT NULL	Days
12	YEARS	Number(3,0)	SMALLINT NOT NULL	for app engine fghr002b
13	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
14	PERIOD_DEFN	Character(1)	VARCHAR2(1) NOT NULL	Period Definition
15	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department SetID
16	SETID_JOBCODE	Character(5)	VARCHAR2(5) NOT NULL	Job Code SetID
17	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location SetID
18	JOB_EFFDT	Date(10)	DATE	Job Effective Date
19	JOB_EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Job Effective Sequence
20	GPMX_JOURNAL_TYPE	Character(30)	VARCHAR2(30) NOT NULL	Journal Type Description MEX
21	REG_TEMP	Character(1)	VARCHAR2(1) NOT NULL	Regular/Temporary R=Regular T=Temporary
22	SENIORITY_PAY_DT	Date(10)	DATE	Seniority Pay Calc Date
23	SEG_BGN_DT	Date(10)	DATE	Payee Process Segment's Begin Date
24	SEG_END_DT	Date(10)	DATE	Payee Process Segment's End Date
25	PYMT_DT	Date(10)	DATE	Payment Date
26	DAILY_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Daily Rate
27	TERMINATIONS	Number(3,0)	SMALLINT NOT NULL	TERMINATIONS
28	PT_RECFIELDVALUE	Character(100)	VARCHAR2(100) NOT NULL	Parameter Value