PROCESS_INSTANCEGPFR_DUCS_NUMBERGPFR_DUCS_CDGPFR_DUCS_TYPEGPFR_ROW_NUMGPFR_DUCS_REG_FLGY/N Table Edit
Default Value: N
602=Yearly Declaration
608=Quarterly Declaration
610=Monthly Declaration
900=Period Declaration
GPFR_DUCS_GEN(SQL Table) |
Index Back |
|---|---|
Result DUCS GEN SegmentResult DUCS GEN Segment |
| # | 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_NUMBER |
Number(10,0) | DECIMAL(10) NOT NULL | DUCS Process Instance |
| 3 | GPFR_DUCS_CD |
Character(10) | VARCHAR2(10) NOT NULL | GPFR: DUCS Code |
| 4 | GPFR_DUCS_TYPE |
Character(3) | VARCHAR2(3) NOT NULL | GPFR: DUCS Type |
| 5 | GPFR_ROW_NUM |
Number(5,0) | INTEGER NOT NULL | Used as counter for row or column number |
| 6 | GPFR_DUCS_REG_FLG |
Character(1) | VARCHAR2(1) NOT NULL |
DUCS Regularization Flag
Y/N Table Edit Default Value: N |
| 7 | GPFR_DUCS_RECORD | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Record Code |
| 8 | GPFR_DUCS_GEN_DAT1 | Character(35) | VARCHAR2(35) NOT NULL | GPFR: Reference Period |
| 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 | GPFR_DUCS_GEN_DAT2 | Character(35) | VARCHAR2(35) NOT NULL | GPFR: Period 2 |
| 11 | GPFR_DUCS_GEN_FMT2 | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Format 2 |
| 12 | GPFR_DUCS_GEN_NBR | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Number of employees in the GEN DUCS Record |
| 13 | GPFR_DUCS_GEN_CD | Character(35) | VARCHAR2(35) NOT NULL | In table PS_COMPANY_TBL, field LEGAL_TYPE |
| 14 | GPFR_DUCS_GEN_AMT1 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Amount 1 in the GEN DUCS Record |
| 15 | GPFR_DUCS_GEN_CUR1 | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Currency |
| 16 | GPFR_DUCS_GEN_TYP1 | Character(3) | VARCHAR2(3) NOT NULL | DUCS GEN Amount Type 1 |
| 17 | GPFR_DUCS_GEN_AMT2 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Amount 2 in the GEN DUCS Record |
| 18 | GPFR_DUCS_GEN_CUR2 | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Currency 2 |
| 19 | GPFR_DUCS_GEN_TYP2 | Character(3) | VARCHAR2(3) NOT NULL | DUCS GEN Amount Type 2 |
| 20 | GPFR_DUCS_GEN_AMT3 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Amount 3 in the GEN DUCS Record |
| 21 | GPFR_DUCS_GEN_CUR3 | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Currency 3 |
| 22 | GPFR_DUCS_GEN_TYP3 | Character(3) | VARCHAR2(3) NOT NULL | DUCS GEN Amount Type 3 |
| 23 | GPFR_DUCS_GEN_LINE | Number(5,0) | INTEGER NOT NULL | Line Number in the GEN DUCS Record |
| 24 | GPFR_DUCS_GEN_AUTH | Character(35) | VARCHAR2(35) NOT NULL | GPFR: Authentication |
| 25 | GPFR_DUCS_GEN_CUR | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Currency |