GPFR_DUCS_AET(SQL Table) |
Index Back |
|---|---|
State record for the DUCS AEState record for the DUCS AppEngine |
| # | 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 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 4 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 5 | JOBINSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Job Instance |
| 6 | GPFR_DUCS_CD | Character(10) | VARCHAR2(10) NOT NULL | GPFR: DUCS Code |
| 7 | GPFR_DUCS_TYPE | Character(3) | VARCHAR2(3) NOT NULL | GPFR: DUCS Type |
| 8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 9 | 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 |
| 10 | 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 |
| 11 | BGN_DT | Date(10) | DATE | Begin Date |
| 12 | END_DT | Date(10) | DATE | end date |
| 13 | GPFR_DUCS_PAI_DT | Date(10) | DATE | GPFR: Payment Date |
| 14 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 15 | GPFR_DUCS_DEST | Character(10) | VARCHAR2(10) NOT NULL | GPFR: DUCS Addressee |
| 16 | GPFR_ROW_NUM | Number(5,0) | INTEGER NOT NULL | Used as counter for row or column number |
| 17 | GPFR_DUCS_MR1 | Character(10) | VARCHAR2(10) NOT NULL | Contact code for the Urssaf, Assedic, agirc/Arrco which will receive the Ducs file |
| 18 | GPFR_DUCS_FR1 | Character(10) | VARCHAR2(10) NOT NULL | FR record in DUCS |
| 19 | GPFR_DUCS_DT1 | Character(10) | VARCHAR2(10) NOT NULL | DT record in DUCS |
| 20 | GPFR_DUCS_AE1 | Character(10) | VARCHAR2(10) NOT NULL | AE record in DUCS |
| 21 | GPFR_DUCS_SLIP_TYP | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Slip Type |
| 22 | GPFR_DUCS_PAI_MD | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Payment Type |
| 23 | GPFR_PAR1_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
GPFR: Identifier Type
2=Establishment 3=Other Identifier |
| 24 | IF_FLAG | Character(1) | VARCHAR2(1) NOT NULL | If flag |
| 25 | GPFR_DUCS_FLAG_NB | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Declaration Number |
| 26 | GPFR_DUCS_EN1 | Character(10) | VARCHAR2(10) NOT NULL | GPFR: Establishment |
| 27 | GPFR_DUCS_FZ1 | Character(1) | VARCHAR2(1) NOT NULL | Flag for VLU : Main establishment or not |
| 28 | GPFR_ROW_NUM2 | Number(5,0) | INTEGER NOT NULL | Used as counter for row or column number (level2). Used in the DUCS/BDA/TRC reports. |
| 29 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 30 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 31 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 32 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 33 | CAL_ID | Character(18) | VARCHAR2(18) NOT NULL | calendar id |
| 34 | RSLT_SEG_NUM | Number(4,0) | SMALLINT NOT NULL | Result Segment Number |
| 35 | GPFR_PAR3_CONT_FAM | Character(3) | VARCHAR2(3) NOT NULL |
GPFR: Contribution Family
Prompt Table: GPFR_DUCS_P3_VW |
| 36 | GPFR_DUCS_CON_TYP1 | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Contribution Type |
| 37 | RSLT_VER_NUM | Number(4,0) | SMALLINT NOT NULL | Result Version Number |
| 38 | RSLT_REV_NUM | Number(4,0) | SMALLINT NOT NULL | Result Revision Number |
| 39 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 40 | ESTABID | Character(12) | VARCHAR2(12) NOT NULL | Establishment ID |
| 41 | GPFR_DUCS_CON_TRS | Character(1) | VARCHAR2(1) NOT NULL | GPFR: Transportation Contribution |
| 42 | GPFR_DUCS_WA_SAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | DUCS WA |
| 43 | GPFR_DUCS_WA_A_EE | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | GPFR: Employee Amount |
| 44 | GPFR_DUCS_WA_BAS | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Contribution Base in the DUCS WA |
| 45 | GPFR_DUCS_WA_CNT1 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | GPFR: Employee Number |
| 46 | GPFR_DUCS_WA_CNT2 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | GPFR: Employee Nbr, sum lump |
| 47 | GPFR_DUCS_WA_CSC | Character(3) | VARCHAR2(3) NOT NULL | GPFR: CSC Code |
| 48 | GPFR_DUCS_WA_EN2 | Character(22) | VARCHAR2(22) NOT NULL | Contract number |
| 49 | GPFR_DUCS_WA_EN3 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Amount 3 in the DUCS WA |
| 50 | GPFR_DUCS_WA_EN4_1 | Number(1,0) | SMALLINT NOT NULL | Coming from payroll (via an Array and a Writeable Array) |
| 51 | GPFR_DUCS_WA_EN4_2 | Number(1,0) | SMALLINT NOT NULL | 1 for man, 0 for woman |
| 52 | GPFR_DUCS_WA_EN4_3 | Number(1,0) | SMALLINT NOT NULL | 1 for apprentice, zero else |
| 53 | GPFR_DUCS_WA_EN4_4 | Number(1,0) | SMALLINT NOT NULL | 1 if under Assedic insurance, zero else |
| 54 | GPFR_DUCS_WA_EN4_5 | Number(1,0) | SMALLINT NOT NULL | 1 if older than 65, zero else |
| 55 | GPFR_DUCS_WA_EN4_6 | Number(1,0) | SMALLINT NOT NULL | 1 if CES, zero else |
| 56 | GPFR_DUCS_WA_IRC1 | Character(10) | VARCHAR2(10) NOT NULL | GPFR: Institution Code |
| 57 | GPFR_DUCS_WA_IRC2 | Character(10) | VARCHAR2(10) NOT NULL | GPFR: Institution Code |
| 58 | GPFR_DUCS_WA_PERD | Character(22) | VARCHAR2(22) NOT NULL | Period |
| 59 | GPFR_DUCS_WA_PROF | Character(10) | VARCHAR2(10) NOT NULL | GPFR: Socio professional group |
| 60 | GPFR_DUCS_WA_REF1 | Character(3) | VARCHAR2(3) NOT NULL | COT Record, reference qualifier 1 |
| 61 | GPFR_DUCS_WA_REF2 | Character(3) | VARCHAR2(3) NOT NULL | COT Record, reference qualifier 2 |
| 62 | GPFR_DUCS_WA_R_AT | Number(9,4) | DECIMAL(8,4) NOT NULL | GPFR: AT Rate |
| 63 | GPFR_DUCS_WA_R_EE | Number(9,4) | DECIMAL(8,4) NOT NULL | GPFR: Employee Rate |
| 64 | GPFR_DUCS_WA_TYP | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Contribution Type |
| 65 | GPFR_DUCS_WA_R_ER | Number(9,4) | DECIMAL(8,4) NOT NULL | GPFR: Employer Rate |
| 66 | GPFR_DUCS_WA_A_ER | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Employer Amount in the DUCS WA |
| 67 | GPFR_DUCS_WA_MR | Character(10) | VARCHAR2(10) NOT NULL | Organism which will receive the Ducs file |
| 68 | GPFR_CONT_OPS_SIRT | Character(12) | VARCHAR2(12) NOT NULL | Establishment for DUCS |
| 69 | GPFR_DUCS_COT_NBR1 | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Payees Number 1 in the COT DUCS Record |
| 70 | GPFR_DUCS_COT_NBR2 | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Payees Number 2 in the COT DUCS Record |
| 71 | GPFR_DUCS_PAI_AMT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Amount in the PAI DUCS Record |
| 72 | GPFR_DUCS_CON_T11 | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Positive Contribution Type 1 |
| 73 | GPFR_DUCS_CON_T12 | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Negative Contribution Type 1 |
| 74 | GPFR_DUCS_CON_T21 | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Positive Contribution Type 2 |
| 75 | GPFR_DUCS_CON_T22 | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Negative Contribution Type 2 |
| 76 | SRC_BANK_ID | Character(8) | VARCHAR2(8) NOT NULL | Source Bank ID |
| 77 | LAST_SEG_IND | Character(1) | VARCHAR2(1) NOT NULL | Last Segment Ind |
| 78 | GPFR_DUCS_R4_QTY01 | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Quantity 1 for the DUCS EN4 Record |
| 79 | GPFR_DUCS_R4_QTY02 | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Quantity 2 for the EN4 DUCS Record |
| 80 | GPFR_DUCS_R4_QTY03 | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Quantity 3 for the EN4 DUCS Record |
| 81 | GPFR_DUCS_R4_QTY04 | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Quantity 4 for the EN4 DUCS Record |
| 82 | GPFR_DUCS_R4_QTY05 | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Quantity 5 for the EN4 DUCS Record |
| 83 | GPFR_DUCS_R4_QTY06 | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Quantity 6 for the EN4 DUCS Record |
| 84 | GPFR_DUCS_R4_QTY07 | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Quantity 7 for the EN4 DUCS Record |
| 85 | GPFR_DUCS_R4_QTY08 | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Quantity 8 for the EN4 DUCS Record |
| 86 | GPFR_DUCS_R4_QTY09 | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Quantity 9 for the EN4 DUCS Record |
| 87 | GPFR_DUCS_R4_QTY10 | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Quantity 10 for the EN4 DUCS Record |
| 88 | GPFR_DUCS_R4_QTY11 | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Quantity 11 for the EN4 DUCS Record |
| 89 | GPFR_DUCS_R4_QTY12 | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Quantity 12 for the EN4 DUCS Record |
| 90 | GPFR_DUCS_R4_QTY13 | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Quantity 13 for the EN4 DUCS Record |
| 91 | GPFR_DUCS_R4_QTY14 | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Quantity 14 for the EN4 DUCS Record |
| 92 | GPFR_DUCS_ADJ_MEN | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Adjusted number of men |
| 93 | GPFR_DUCS_ADJ_WOME | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Adjusted number of women |
| 94 | GPFR_ASS_DATETIME | DateTime(26) | TIMESTAMP | GPFR: DateTime |
| 95 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 96 | PYMT_DT | Date(10) | DATE | Payment Date |
| 97 | GPFR_DUCS_WA_GRPBY | Character(50) | VARCHAR2(50) NOT NULL | Concatenation field used for the GPFR_DUCS_WA1 table and the GPFR_DUCS_WA_VW view. |
| 98 | GPFR_DUCS_NUMBER2 | Number(10,0) | DECIMAL(10) NOT NULL | DUCS Process Instance |
| 99 | GPFR_DUCS_R1_ID | Character(35) | VARCHAR2(35) NOT NULL | Identification Number |
| 100 | GPFR_DUCS_R3_AMT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Amount 1 for the EN3 DUCS Record. Used in the SUM record. |
| 101 | GPFR_DUCS_R3_CUR | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Currency |
| 102 | GPFR_DUCS_REFPER | Character(6) | VARCHAR2(6) NOT NULL | TRC Reference Period |
| 103 | GPFR_PAR2_MULT_EST | Character(1) | VARCHAR2(1) NOT NULL |
GPFR: Multi Establishments
Y/N Table Edit Default Value: N |
| 104 | GPFR_DUCS_PAI1 | Character(10) | VARCHAR2(10) NOT NULL | Glopal Payroll France DUCS Payment Field |
| 105 | ROWSECCLASS | Character(30) | VARCHAR2(30) NOT NULL | The class used to determine row level security |
| 106 | GPFR_DUCS_COT_CD | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Coded Instruction |
| 107 | GPFR_DUCS_COT_INST | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Detailed Coded Instruction |
| 108 | GPFR_DUCS_COT_LINE | Character(6) | VARCHAR2(6) NOT NULL | GPFR: Lines Number |
| 109 | GPFR_DUCS_COT_DATE | Character(35) | VARCHAR2(35) NOT NULL | GPFR: Reference Period |
| 110 | GPFR_DUCS_COT_FMT | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Period Type |
| 111 | GPFR_DUCS_COT_PCT | Character(8) | VARCHAR2(8) NOT NULL | GPFR: Contribution Rate |
| 112 | GPFR_DUCS_RECORD | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Record Code |
| 113 | GPFR_DUCS_COT_TYP1 | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Amount Type 1 |
| 114 | GPFR_DUCS_COT_TYP2 | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Amount Type 2 |
| 115 | GPFR_DUCS_COT_KEY | Character(50) | VARCHAR2(50) NOT NULL | Concatenation field used for the GPFR_DUCS_COT table, because the number of keys is greater than 16 (technical limit) |
| 116 | GPFR_DUCS_COT_CUR1 | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Currency 1 |
| 117 | GPFR_DUCS_COT_CUR2 | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Currency 2 |
| 118 | GPFR_DUCS_COT_RCD1 | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Reference Code 1 |
| 119 | GPFR_DUCS_COT_RCD2 | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Reference Code 2 |
| 120 | GPFR_DUCS_COT_REF1 | Character(35) | VARCHAR2(35) NOT NULL | GPFR: Reference Family 1 |
| 121 | GPFR_DUCS_COT_REF2 | Character(35) | VARCHAR2(35) NOT NULL | GPFR: Reference Family 2 |
| 122 | GPFR_DUCS_COT_TYPE | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Contribution Type |
| 123 | GPFR_DUCS_REGULS | Character(1) | VARCHAR2(1) NOT NULL |
DUCS Regularizations
A=Additive R=Rectificative |
| 124 | GPFR_DUCS_REG_SW | Character(1) | VARCHAR2(1) NOT NULL |
Field for DUCS Regularization
Y/N Table Edit |
| 125 | GPFR_DUCS_REG_FLG | Character(1) | VARCHAR2(1) NOT NULL | DUCS Regularization Flag |
| 126 | GPFR_DUCS_RTRO_FLG | Number(6,0) | INTEGER NOT NULL | DUCS Retro Flag 0 - Retro 1 - Current |
| 127 | GPFR_DUCS_OVR_RATE | Number(9,4) | DECIMAL(8,4) NOT NULL | DUCS Overriden Rate |
| 128 | GPFR_DUCS_DEB_REGN | Character(1) | VARCHAR2(1) NOT NULL | DUCS DEB Regularization Number |
| 129 | GPFR_DUCS_CON_TAT | Character(1) | VARCHAR2(1) NOT NULL | DUCS Additional Transportation |
| 130 | GPFR_DUCS_WA_RTDT | Date(10) | DATE | DUCS Rate Change Effective Date |