GPFR_DUCS_RUN_1(SQL Table) |
Index Back |
|---|---|
Run Control RecordRun Control Record for DUCS Extraction |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPERATOR_VW |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | GPFR_DUCS_CD |
Character(10) | VARCHAR2(10) NOT NULL |
GPFR: DUCS Code
Prompt Table: GPFR_DUCS_VW |
| 4 | GPFR_DUCS_TYPE |
Character(3) | VARCHAR2(3) NOT NULL |
GPFR: DUCS Type
Prompt Table: GPFR_DUCS |
| 5 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 6 | LANGUAGE_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Language Option
O=Specified Language R=Recipient's Language Default Value: O |
| 7 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 8 | GPFR_DUCS_DEB_TEST | Character(1) | VARCHAR2(1) NOT NULL |
On the DEB record, Space means it's a real declaration, '1' means it's a try.
1=Try |
| 9 | GPFR_DUCS_GEN_FMT1 | Character(3) | VARCHAR2(3) NOT NULL |
This field indicates the period type (year, quater, month) to be processed. It is written on the GEN record. For the Urssaf Ducs, the period type is always set to 'Period' in the file. On the DUCS extraction page, the 'Period' value is not relevant.
602=Yearly Declaration 608=Quarterly Declaration 610=Monthly Declaration 900=Period Declaration |
| 10 | BGN_DT | Date(10) | DATE NOT NULL | Begin Date |
| 11 | END_DT | Date(10) | DATE | end date |
| 12 | GPFR_DUCS_PAI_DT | Date(10) | DATE | GPFR: Payment Date |
| 13 | GPFR_DUCS_REG_SW | Character(1) | VARCHAR2(1) NOT NULL |
Field for DUCS Regularization
Y/N Table Edit Default Value: Y |