| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 2 |
GPES_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Year
|
| 3 |
GPES_MONTH |
Number(2,0) |
SMALLINT NOT NULL |
Month
|
| 4 |
SSN_EMPLOYER |
Character(13) |
VARCHAR2(13) NOT NULL |
Employer Social Security number
|
| 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_SS_CRA_CODE |
Character(4) |
VARCHAR2(4) NOT NULL |
Concept code for Social Security CRA report
|
| 8 |
GPES_SS_CRA_CNTRB |
Character(1) |
VARCHAR2(1) NOT NULL |
Contribution for CRA report (Y/N)
|
| 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_SS_CRA_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
CRA Action code:
'M' - Modify
'C' - Complementary
'B' - Delete
|