GPES_PMT_RTO_VW(SQL View) |
Index Back |
|---|---|
FAN payment type overrideFAN Payment type override data for FAN file (Global Payroll Spain process) |
| SELECT B.GPES_RTO_DT_FROM ,B.GPES_RTO_DT_TO ,A.GPES_RTR_OVRD_PRTY ,A.GPES_PIN_RO1_NUM ,B.GPES_RTO_CFG_VAL1 ,A.GPES_PIN_RO2_NUM ,B.GPES_RTO_CFG_VAL2 ,A.GPES_PIN_RO3_NUM ,B.GPES_RTO_CFG_VAL3 ,A.GPES_PIN_RO4_NUM ,B.GPES_RTO_CFG_VAL4 ,A.GPES_PIN_RO5_NUM ,B.GPES_RTO_CFG_VAL5 ,A.GPES_PIN_RO6_NUM ,B.GPES_RTO_CFG_VAL6 ,B.GPES_RTO_PAYMNT ,B.GPES_SSTC_OUTOF_DT ,B.GPES_SSTC_OVR_PMT ,B.GPES_SSTC_CNTRL_DT ,B.GPES_SSTC_CAUSE FROM PS_GPES_PMTRTO_DEF A ,PS_GPES_PMTRTR_OVR B WHERE A.GPES_RTR_OVRD_ID = B.GPES_RTR_OVRD_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPES_RTO_DT_FROM | Date(10) | DATE | FAN file retro override date from |
| 2 | GPES_RTO_DT_TO | Date(10) | DATE | FAN file retro override date to |
| 3 | GPES_RTR_OVRD_PRTY | Number(3,0) | SMALLINT NOT NULL | FAN file payment type override priority |
| 4 | GPES_PIN_RO1_NUM | Number(8,0) | INTEGER NOT NULL | Retro override value 1 |
| 5 | GPES_RTO_CFG_VAL1 | Character(18) | VARCHAR2(18) NOT NULL | FAN retro override value 1 |
| 6 | GPES_PIN_RO2_NUM | Number(8,0) | INTEGER NOT NULL | Retro override value 2 |
| 7 | GPES_RTO_CFG_VAL2 | Character(18) | VARCHAR2(18) NOT NULL | FAN retro override value 2 |
| 8 | GPES_PIN_RO3_NUM | Number(8,0) | INTEGER NOT NULL | Retro override value 3 |
| 9 | GPES_RTO_CFG_VAL3 | Character(18) | VARCHAR2(18) NOT NULL | FAN retro override value 3 |
| 10 | GPES_PIN_RO4_NUM | Number(8,0) | INTEGER NOT NULL | Retro override value 4 |
| 11 | GPES_RTO_CFG_VAL4 | Character(18) | VARCHAR2(18) NOT NULL | FAN retro override value 4 |
| 12 | GPES_PIN_RO5_NUM | Number(8,0) | INTEGER NOT NULL | Retro override value 5 |
| 13 | GPES_RTO_CFG_VAL5 | Character(18) | VARCHAR2(18) NOT NULL | FAN retro override value 5 |
| 14 | GPES_PIN_RO6_NUM | Number(8,0) | INTEGER NOT NULL | Retro override value 6 |
| 15 | GPES_RTO_CFG_VAL6 | Character(18) | VARCHAR2(18) NOT NULL | FAN retro override value 6 |
| 16 | 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 |
| 17 | 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 |
| 18 | GPES_SSTC_OVR_PMT | Character(1) | VARCHAR2(1) NOT NULL | Override Social Security payment |
| 19 | GPES_SSTC_CNTRL_DT | Date(10) | DATE | Social Security TCs control date |
| 20 | 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 |