| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: GPES_RC_SS.OPRID
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
Default Value: GPES_RC_SS.RUN_CNTL_ID
|
| 3 |
SSN_EMPLOYER |
Character(13) |
VARCHAR2(13) NOT NULL |
Employer Social Security number
Prompt Table:
GPES_SS_WC_VW
|
| 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/Surcharge Bases Increa
L91=Retro w/Surchage new Slices
|
| 5 |
GPES_YEAR_RECALC |
Number(4,0) |
SMALLINT NOT NULL |
Retro year
Default Value: GPES_RC_SS.YEARCD
|
| 6 |
GPES_MONTH_RECALC |
Number(2,0) |
SMALLINT NOT NULL |
Retro month
Default Value: GPES_RC_SS.GPES_MONTHCD
|
| 7 |
GPES_SSTC_CNTRL_DT |
Date(10) |
DATE |
Social Security TC�s control date
|
| 8 |
GPES_OOD_PYMT_SUR |
Number(2,0) |
SMALLINT NOT NULL |
FAN surcharge because of an out of date payment
|
| 9 |
GPES_OOD_PYSUR_OVR |
Number(2,0) |
SMALLINT NOT NULL |
FAN surcharge override
|
| 10 |
GPES_SSTC_OUTOF_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Out of date indicator. This field is used to populate the GP Write Array, which is used to generate the FAN File.
0=Payment in Period
3=Payment Out of Period
Default Value: 0
|
| 11 |
THRU_MONTH |
Number(2,0) |
SMALLINT NOT NULL |
Process Thru Month
|