GPES_CRT_LQ_ERR

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SSN_EMPLOYER	Character(13)	VARCHAR2(13) NOT NULL	Employer Social Security number
2	GPES_YEAR	Number(4,0)	SMALLINT NOT NULL	Year
3	GPES_MONTH	Number(2,0)	SMALLINT NOT NULL	Month
4	GPES_SSTC_PAYMNT	Character(3)	VARCHAR2(3) NOT NULL	Payment Type. This field is used to populate the GP Write Array, which is used to generate the FAN File. L00=Regular L02=Litigation Salary L03=Retroactivity wo/Surcharge L04=Reductions Payback L09=Retroactivity w/Surcharge L13=Vacations L90=Retro w/Surcharge Bases Increa L91=Retro w/Surchage new Slices
5	GPES_YEAR_RECALC	Number(4,0)	SMALLINT NOT NULL	Retro year
6	GPES_MONTH_RECALC	Number(2,0)	SMALLINT NOT NULL	Retro month
7	GPES_ERROR_CODE	Character(5)	VARCHAR2(5) NOT NULL	Error Code
8	GPES_ERROR_DESC	Character(50)	VARCHAR2(50) NOT NULL	Error Code
9	GPES_LQ_NUMBER	Character(17)	VARCHAR2(17) NOT NULL	Error Code
10	GPES_FILE_NAME	Character(250)	VARCHAR2(250) NOT NULL	Name of a file, according to the process scheduler server.
11	GPES_CRT_DATA_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Type of Data for Creta reporting: C-concept, H-hours, I-Identifier C=Amount H=Hour I=Indicator
12	GPES_CRT_CODE	Character(3)	VARCHAR2(3) NOT NULL	Code for Creta reporting 01=Part Time Contract Hours 02=Complementary Hours 03=Presential Training Hours 04=Distance Training Hours 05=Part Time Coefficient in ERE 500=General Contingencies Base 501=Structural Overtime 502=Non-structural Overtime 509=CC Base for Maternity/Risk 51=Salary Modality 52=Option 126 Epigraph 535=CC Base for Maternity/Risk 536=CC Base for Maternity/Risk 537=Complementary Hours 563=IT Illness & Accident 601=Professional Contingences Base 603=CP Base for Maternity/Risk 611=Professional Contingences Base 613=Professional Contingences Base 634=CP Base for Maternity/Risk 635=CP Base for Maternity/Risk 636=CP Base for Maternity/Risk 637=CP Base for Maternity/Risk 663=IT by IA and PI 763=Bonif. INEM Cont. Form.
13	GPES_CRT_VALUE	Character(11)	VARCHAR2(11) NOT NULL	Value for Creta reporting