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 | Character(8) | VARCHAR2(8) NOT NULL |
Retro override definition ID
Prompt Table: GPES_PMTRTO_DEF |
|
2 | Date(10) | DATE NOT NULL | FAN file retro override date from | |
3 | Date(10) | DATE NOT NULL | FAN file retro override date to | |
4 | 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 | Character(1) | VARCHAR2(1) NOT NULL |
Override Social Security payment
Y/N Table Edit Default Value: N |
|
6 | 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 | Date(10) | DATE | Social Security TC�s control date | |
8 | Character(18) | VARCHAR2(18) NOT NULL |
FAN retro override value 1
Prompt Table: %GP_EDIT_FLD1 |
|
9 | Character(18) | VARCHAR2(18) NOT NULL |
FAN retro override value 2
Prompt Table: %GP_EDIT_FLD2 |
|
10 | Character(18) | VARCHAR2(18) NOT NULL |
FAN retro override value 3
Prompt Table: %GP_EDIT_FLD3 |
|
11 | Character(18) | VARCHAR2(18) NOT NULL |
FAN retro override value 4
Prompt Table: %GP_EDIT_FLD4 |
|
12 | Character(18) | VARCHAR2(18) NOT NULL |
FAN retro override value 5
Prompt Table: %GP_EDIT_FLD5 |
|
13 | 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 |