GPES_PMTRTR_OVR

(SQL Table)
Index Back

FAN payment retro override

FAN 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