GPES_SS_CRA_RPT (SQL Table)	Index Back
Social Security CRA report Record containing the last generated CRA report for a year/month. Having this information, the report can identify whether a piece of data changed from one sent report respect with the following to be sent.

GPES_SS_CRA_RPT

(SQL Table)

Social Security CRA report

Record containing the last generated CRA report for a year/month. Having this information, the report can identify whether a piece of data changed from one sent report respect with the following to be sent.

# 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_YEAR_RECALC Number(4,0) SMALLINT NOT NULL Retro year

5 GPES_MONTH_RECALC Number(2,0) SMALLINT NOT NULL Retro month

6 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

7 GPES_SS_CRA_CODE Character(4) VARCHAR2(4) NOT NULL Concept code for Social Security CRA report
0001=Base Salary, Others
0002=Non Structural Overtime
0003=Structural Overtime
0004=Prorated Extra Pay
0005=Prorrated Extra Pay
0006=Paid Vacation
0007=Job Litigation Salary
0013=In Kind Income. Others
0018=Company Car
0021=In Kind Loan
0032=Transport
0033=Pension Plan
0034=Stock Options
0043=Domestic Overnight Expenses
0044=Internanl Overnight Expenses
0045=Domestic Maintenace
0046=International Maintenance
0047=Domestic Maint. Flght Staff
0048=Interntl Maint. Flight Staff
0050=Mileage
0051=Compensation for Death
0052=Transfer Compensation
0053=Suspension Compensation
0054=Termination Indemnity
0055=IT Complementary Benefit
0056=No IT Complementary Benefit

8 GPES_SS_CRA_CNTRB Character(1) VARCHAR2(1) NOT NULL Contribution for CRA report (Y/N)
E=Excluded from SS Base
I=Included

9 GPES_SS_CRA_ACTION Character(1) VARCHAR2(1) NOT NULL CRA Action code: 'M' - Modify 'C' - Complementary 'B' - Delete
B=Erase
C=Add
M=Modify

10 GPES_SS_CRA_AMT Signed Number(19,2) DECIMAL(17,2) NOT NULL CRA amount

11 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

#	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_YEAR_RECALC	Number(4,0)	SMALLINT NOT NULL	Retro year
5	GPES_MONTH_RECALC	Number(2,0)	SMALLINT NOT NULL	Retro month
6	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
7	GPES_SS_CRA_CODE	Character(4)	VARCHAR2(4) NOT NULL	Concept code for Social Security CRA report 0001=Base Salary, Others 0002=Non Structural Overtime 0003=Structural Overtime 0004=Prorated Extra Pay 0005=Prorrated Extra Pay 0006=Paid Vacation 0007=Job Litigation Salary 0013=In Kind Income. Others 0018=Company Car 0021=In Kind Loan 0032=Transport 0033=Pension Plan 0034=Stock Options 0043=Domestic Overnight Expenses 0044=Internanl Overnight Expenses 0045=Domestic Maintenace 0046=International Maintenance 0047=Domestic Maint. Flght Staff 0048=Interntl Maint. Flight Staff 0050=Mileage 0051=Compensation for Death 0052=Transfer Compensation 0053=Suspension Compensation 0054=Termination Indemnity 0055=IT Complementary Benefit 0056=No IT Complementary Benefit
8	GPES_SS_CRA_CNTRB	Character(1)	VARCHAR2(1) NOT NULL	Contribution for CRA report (Y/N) E=Excluded from SS Base I=Included
9	GPES_SS_CRA_ACTION	Character(1)	VARCHAR2(1) NOT NULL	CRA Action code: 'M' - Modify 'C' - Complementary 'B' - Delete B=Erase C=Add M=Modify
10	GPES_SS_CRA_AMT	Signed Number(19,2)	DECIMAL(17,2) NOT NULL	CRA amount
11	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