GPES_PMTRTR_OVR(SQL Table) |
Index Back |
---|---|
FAN payment retro overrideFAN payment retro override data |
# | 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 |
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 TC�s 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 | DUMMY_FIELD | Character(1) | VARCHAR2(1) NOT NULL | Dummy Field |