GPES_SS_CRA_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	SSN_EMPLOYER	Character(13)	VARCHAR2(13) NOT NULL	Employer Social Security number
3	GPES_YEAR	Number(4,0)	SMALLINT NOT NULL	Year
4	GPES_MONTH	Number(2,0)	SMALLINT NOT NULL	Month
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	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
8	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
9	GPES_SS_CRA_CNTRB	Character(1)	VARCHAR2(1) NOT NULL	Contribution for CRA report (Y/N) E=Excluded from SS Base I=Included
10	GPES_SS_CRA_AMT	Signed Number(19,2)	DECIMAL(17,2) NOT NULL	CRA amount
11	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