| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 GPES_RTR_OVRD_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Retro override definition ID
Prompt Table:
GPES_PMTRTO_DEF
|
| 2 |
GPES_RTO_DT_FROM |
Date(10) |
DATE NOT NULL |
FAN file retro override date from
|
| 3 |
GPES_RTO_DT_TO |
Date(10) |
DATE NOT NULL |
FAN file retro override date to
|
| 4 |
GPES_RTO_PAYMNT |
Character(3) |
VARCHAR2(3) NOT NULL |
FAN file retro override payment type
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/Surcharge new Slices
V03=Retro wo/ Surcharge Vacations
V90=Retro w/ Surcharge Vacations
|
| 5 |
GPES_SSTC_OVR_PMT |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Social Security payment
Y/N Table Edit
Default Value: N
|
| 6 |
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
|
| 7 |
GPES_SSTC_CNTRL_DT |
Date(10) |
DATE |
Social Security TCs control date
|
| 8 |
GPES_RTO_CFG_VAL1 |
Character(18) |
VARCHAR2(18) NOT NULL |
FAN retro override value 1
Prompt Table:
%GP_EDIT_FLD1
|
| 9 |
GPES_RTO_CFG_VAL2 |
Character(18) |
VARCHAR2(18) NOT NULL |
FAN retro override value 2
Prompt Table:
%GP_EDIT_FLD2
|
| 10 |
GPES_RTO_CFG_VAL3 |
Character(18) |
VARCHAR2(18) NOT NULL |
FAN retro override value 3
Prompt Table:
%GP_EDIT_FLD3
|
| 11 |
GPES_RTO_CFG_VAL4 |
Character(18) |
VARCHAR2(18) NOT NULL |
FAN retro override value 4
Prompt Table:
%GP_EDIT_FLD4
|
| 12 |
GPES_RTO_CFG_VAL5 |
Character(18) |
VARCHAR2(18) NOT NULL |
FAN retro override value 5
Prompt Table:
%GP_EDIT_FLD5
|
| 13 |
GPES_RTO_CFG_VAL6 |
Character(18) |
VARCHAR2(18) NOT NULL |
FAN retro override value 6
Prompt Table:
%GP_EDIT_FLD6
|
| 14 |
GPES_SSTC_CAUSE |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment type override cause
1=1 - Labor Agreement
2=2 - Law Change
3=3 - Conciliation
4=4 - Sentence
5=5 - Other
|
| 15 |
DUMMY_FIELD |
Character(1) |
VARCHAR2(1) NOT NULL |
Dummy Field
|