GPES_CRT_SS_LQ

#	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/Surch. Base Incr. L91=Retro w/Surch. New Slices V03=Retro wo/ Surcharge Vacations V90=Retro w/ Surcharge Vacations
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_CRT_CODE	Character(3)	VARCHAR2(3) NOT NULL	Code for Creta reporting
8	GPES_SSTC_CNTRL_DT	Date(10)	DATE	Social Security TCs control date
9	GPES_SSTC_AMOUNT	Signed Number(11,2)	DECIMAL(9,2) NOT NULL	Amount of the element.(Entire part). This field is used to populate the GP Write Array, which is used to generate the FAN File.
10	GPES_SSTC_CT_EE	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Employee Social Security Contributions. This field is used to populate the GP Write Array, which is used to generate the FAN File.
11	GPES_SSTC_CT_ER	Signed Number(15,2)	DECIMAL(13,2) NOT NULL	Employer Social Security Contributions. This field is used to populate the GP Write Array, which is used to generate the FAN File.
12	GPES_SSTC_CT_TT	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Employer Social Security Total Contributions.
13	GPES_FILENAME	Character(8)	VARCHAR2(8) NOT NULL	FDI File Name or EFT File Name
14	GPES_CRT_SOURCE	Character(3)	VARCHAR2(3) NOT NULL	CRET@ source calculation type file C=Calculation S=Slices of Employees
15	GPES_CRT_STAT_VAL	Character(1)	VARCHAR2(1) NOT NULL	CRET@ Social Security calculation verification status. 0=Matched 1=Mismatch 3=Not Verified Default Value: 3