GPES_PMTRTOH_VW(SQL View) |
Index Back |
|---|---|
FAN retro override headerFAN payment retro override header information |
| SELECT DISTINCT GPES_RTR_OVRD_ID ,GPES_RTO_DT_FROM ,GPES_RTO_DT_TO ,GPES_RTO_PAYMNT ,GPES_SSTC_OVR_PMT ,GPES_SSTC_OUTOF_DT ,GPES_SSTC_CNTRL_DT ,DUMMY_FIELD FROM PS_GPES_PMTRTR_OVR |
| # | 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 | DUMMY_FIELD | Character(1) | VARCHAR2(1) NOT NULL | Dummy Field |