GPFR_DUCS_ORATE(SQL Table) |
Index Back |
|---|---|
DUCS Override RatesDUCS Override Rates |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  GPFR_DUCS_CD |
Character(10) | VARCHAR2(10) NOT NULL | GPFR: DUCS Code |
| 2 | GPFR_DUCS_TYPE |
Character(3) | VARCHAR2(3) NOT NULL | GPFR: DUCS Type |
| 3 | GPFR_DUCS_CON_TYP1 |
Character(3) | VARCHAR2(3) NOT NULL |
GPFR: Contribution Type
Prompt Table: GPFR_DUCS_TYPVW |
| 4 | GPFR_DUCS_OVR_RATE |
Number(9,4) | DECIMAL(8,4) NOT NULL | DUCS Overriden Rate |
| 5 | GPFR_DUCS_USE_RATE | Number(9,4) | DECIMAL(8,4) NOT NULL | DUCS Overriding Rate |
| 6 | GPFR_DUCS_RATE_TYP | Character(2) | VARCHAR2(2) NOT NULL |
DUCS Rate Type (AT, non AT)
AT=AT NA=Non AT Default Value: NA |
| 7 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: GPFR_DUCS_CCYVW |
| 8 | ESTABID | Character(12) | VARCHAR2(12) NOT NULL |
Establishment ID
Prompt Table: GPFR_DUCS_CESVW |
| 9 | GPFR_DUCS_MR1 | Character(10) | VARCHAR2(10) NOT NULL |
Contact code for the Urssaf, Assedic, agirc/Arrco which will receive the Ducs file
Prompt Table: GPFR_DUCS_MR1VW |
| 10 | GPFR_DUCS_EN1 | Character(10) | VARCHAR2(10) NOT NULL |
GPFR: Establishment
Prompt Table: GPFR_DUCS_EN1VW |
| 11 | GPFR_DUCS_YEAR | Character(4) | VARCHAR2(4) NOT NULL | DUCS Year |
| 12 | GPFR_DUCS_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
DUCS Status
A=Active I=Inactive Default Value: A |