| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
GPFR_DUCS_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
GPFR: DUCS Code
|
| 3 |
GPFR_DUCS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
GPFR: DUCS Type
|
| 4 |
GPFR_DUCS_REG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
DUCS Regularization Flag
|
| 5 |
GPFR_DUCS_NUMBER |
Number(10,0) |
DECIMAL(10) NOT NULL |
DUCS Process Instance
|
| 6 |
GPFR_PAR3_CONT_FAM |
Character(3) |
VARCHAR2(3) NOT NULL |
GPFR: Contribution Family
|
| 7 |
GPFR_DUCS_CON_TYP1 |
Character(3) |
VARCHAR2(3) NOT NULL |
GPFR: Contribution Type
|
| 8 |
ESTABID |
Character(12) |
VARCHAR2(12) NOT NULL |
Establishment ID
|
| 9 |
GPFR_DUCS_WA_MR |
Character(10) |
VARCHAR2(10) NOT NULL |
Organism which will receive the Ducs file
|
| 10 |
GPFR_DUCS_WA_EN2 |
Character(22) |
VARCHAR2(22) NOT NULL |
Contract number
|
| 11 |
GPFR_DUCS_WA_R_EE |
Number(9,4) |
DECIMAL(8,4) NOT NULL |
GPFR: Employee Rate
|
| 12 |
GPFR_DUCS_WA_R_AT |
Number(9,4) |
DECIMAL(8,4) NOT NULL |
GPFR: AT Rate
|
| 13 |
GPFR_DUCS_WA_A_EE |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
GPFR: Employee Amount
|
| 14 |
GPFR_DUCS_WA_BAS |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Contribution Base in the DUCS WA
|
| 15 |
GPFR_DUCS_CON_T11 |
Character(3) |
VARCHAR2(3) NOT NULL |
GPFR: Positive Contribution Type 1
|
| 16 |
GPFR_DUCS_CON_T12 |
Character(3) |
VARCHAR2(3) NOT NULL |
GPFR: Negative Contribution Type 1
|
| 17 |
GPFR_DUCS_CON_T21 |
Character(3) |
VARCHAR2(3) NOT NULL |
GPFR: Positive Contribution Type 2
|
| 18 |
GPFR_DUCS_CON_T22 |
Character(3) |
VARCHAR2(3) NOT NULL |
GPFR: Negative Contribution Type 2
|
| 19 |
GPFR_DUCS_CON_TRS |
Character(1) |
VARCHAR2(1) NOT NULL |
GPFR: Transportation Contribution
|
| 20 |
GPFR_DUCS_CON_TAT |
Character(1) |
VARCHAR2(1) NOT NULL |
DUCS Additional Transportation
|
| 21 |
GPFR_DUCS_WA_CSC |
Character(3) |
VARCHAR2(3) NOT NULL |
GPFR: CSC Code
|
| 22 |
GPFR_DUCS_WA_REF1 |
Character(3) |
VARCHAR2(3) NOT NULL |
COT Record, reference qualifier 1
|
| 23 |
GPFR_DUCS_WA_REF2 |
Character(3) |
VARCHAR2(3) NOT NULL |
COT Record, reference qualifier 2
|
| 24 |
GPFR_DUCS_WA_IRC1 |
Character(10) |
VARCHAR2(10) NOT NULL |
GPFR: Institution Code
|
| 25 |
GPFR_DUCS_WA_PROF |
Character(10) |
VARCHAR2(10) NOT NULL |
GPFR: Socio professional group
|
| 26 |
PYMT_DT |
Date(10) |
DATE |
Payment Date
|
| 27 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 28 |
GPFR_DUCS_OVR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
DUCS Override Flag
|