GPES_CRT_SS_DTL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	SSN_EMPLOYER	Character(13)	VARCHAR2(13) NOT NULL	Employer Social Security number
4	GPES_YEAR	Number(4,0)	SMALLINT NOT NULL	Year
5	GPES_MONTH	Number(2,0)	SMALLINT NOT NULL	Month
6	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
7	GPES_YEAR_RECALC	Number(4,0)	SMALLINT NOT NULL	Retro year
8	GPES_MONTH_RECALC	Number(2,0)	SMALLINT NOT NULL	Retro month
9	SLICE_BGN_DT	Date(10)	DATE	Element Slice Begin Date
10	GPES_CRT_CODE	Character(3)	VARCHAR2(3) NOT NULL	Code for Creta reporting
11	GPES_SSTC_CNTRL_DT	Date(10)	DATE	Social Security TCs control date
12	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.
13	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.
14	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.
15	GPES_SSTC_CT_TT	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Employer Social Security Total Contributions.
16	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