Generating DUCS

This chapter provides an overview of DUCS processing and discusses how to produce DUCS files and DUCS reports.

Click to jump to parent topicUnderstanding DUCS Processing

After you run the payroll process, the system has most of the data that you need to produce the DUCS file and the DUCS report. You must enter only the information that is unique to your process setup. You must also specify which data the process must select, where it must place the results, and what alterations to this data, if any, you want to make.

Note. The DUCS is a norm for declaring contributions. Contact the appropriate organization, such as URSSAF or ASSEDIC, to obtain the technical requirements book for the DUCS. This technical requirements book contains the description of the norm and stipulates the membership conditions.

When you are finished setting up DUCS information, use the Create DUCS Data FRA page to run the process on specific populations and organizations, during a specific period. This sets up the tables needed to create the DUCS file and the DUCS report.

If needed, use the Update DUCS Data FRA page to adjust the data in the DUCS file and report before it is generated. You can change the amount paid and the authentication. For AGIRC and ARRCO, you can also change the credit or debit.

Use the Create DUCS/TRC/DRA File FRA page to create the DUCS information. You also use this page to select a destination for the data and an output type—that is, a file, a report, or both.

Click to jump to parent topicPrerequisites

Before you can produce the DUCS file or the DUCS report, you must set up DUCS information for the organization.

See Also

Setting Up DUCS Information

Click to jump to parent topicProducing DUCS Files and Reports

This section discusses how to:

See Also

Defining Banking Instructions

Click to jump to top of pageClick to jump to parent topicPages Used to Produce DUCS Files and Reports

Page Name

Definition Name

Navigation

Usage

Create DUCS Data FRA

GPFR_DUCS_RUNCNTL

Global Payroll & Absence Mgmt, Social Security / Insurance, Create DUCS Data FRA, Create DUCS Data FRA

Run the DUCS Preparation Application Engine process (GPFR_DUC_AE). This process creates the work tables that the system needs to produce the DUCS files and reports.

Update DUCS Data FRA

GPFR_DUCSF_UPDT

Global Payroll & Absence Mgmt, Social Security / Insurance, Update DUCS Data FRA, Update DUCS File

Update data that appears in DUCS files and reports.

Create DUCS/TRC/DRA File FRA

GPFR_DUCS_FILE

Global Payroll & Absence Mgmt, Social Security / Insurance, Create DUCS/TRC/DRA File FRA, Create DUCS/TRC/DRA File FRA

Generate a DUCS file or report. Run this process for each file or report that you want to generate.

Click to jump to top of pageClick to jump to parent topicExtracting Data for DUCS Files and Reports

Access the Create DUCS Data FRA page (Global Payroll & Absence Mgmt, Social Security / Insurance, Create DUCS Data FRA, Create DUCS Data FRA).

The DUCS Preparation process extracts data from the PeopleSoft Enterprise Human Resources Management system, the GP Results tables, and the DUCS setup tables, and writes the data to specific DUCS tables.

Declared Period

Period Format

Select the period format. Options are Monthly Declaration, Quarterly Declaration, and Yearly Declaration.

Other Information

Test Indicator

Select Try if the generated file is a technical test. The information is sent to the addressee to verify that the file is correct. It is not used as a real declaration.

Payment Date

Enter the appropriate payment date. This is used to generate payment order.

Pay Groups

Pay Group

Select the pay groups for which the system generates a DUCS file or report.

Click to jump to top of pageClick to jump to parent topicUpdating DUCS File and Report Data

Access the Update DUCS Data FRA page (Global Payroll & Absence Mgmt, Social Security / Insurance, Update DUCS Data FRA, Update DUCS Data FRA).

GEN Segments

Declaration Number

Displays the declaration number.

Click the Show Next Row button to view multiple declaration numbers for the same DUCS code and DUCS type.

Identification

Displays the identification number that is set up in the DUCS Contacts FRA (GPFR_DUCS_CONTACT) component for the company of the declaration.

Reference Period

Displays the reference period.

Declaration Amount

Displays the declaration amount.

Credit to Subtract

Enter the amount to be subtracted from the ARRCO or AGIRC declaration, if applicable.

Debit to Add

Enter the amount to add to the ARRCO or AGIRC declaration, if applicable.

Authentification

Enter the authentification code.

PAI Segments

Bank Number

Displays the bank number that you selected on the DUCS Definition page.

Bank Office Number

Displays the bank office number that corresponds to the bank number that you selected.

Bank Account Number

Displays the bank account number that corresponds to the account that you selected.

Amount

Displays the amount to be transferred to the bank. This field is populated by the extraction process and is equal to the contributions to be paid for the DUCS. You can modify this amount if necessary.

Click to jump to top of pageClick to jump to parent topicGenerating DUCS Files or Reports

Access the Create DUCS/TRC/DRA File FRA page (Global Payroll & Absence Mgmt, Social Security / Insurance, Create DUCS/TRC/DRA File FRA, Create DUCS/TRC/DRA File FRA).

Use this run control page to generate DUCS files and reports. This process uses the DUCS-specific tables that are generated during the extraction process.

DUCS

DUCS Code

Select the DUCS code that you want to process.

DUCS Type

Select the DUCS type that you want to process.

Output Information

Output

Select an output type. Options are File, Report, and Both.

File Name

To create a DUCS file or report, enter a complete valid path and file name; for example, C:\temp\fichier.txt. If you want to create a new report without writing over old ones, or if you are running a new process, use a new file name. Use a new file name for each DUCS process that you run; otherwise, you might inadvertently delete existing information that you need.

Run

Click to launch the DUCS file generation process. The Process Scheduler Request page appears. Select one of the following report options: DUCS File Generation, ASSEDIC Contributions Report, and URSSAF Contributions Report.