Setting Up DUCS and DADS Reporting

This chapter provides overviews of Déclaration Unifiée des Cotisations Sociales (DUCS) reporting, Déclaration Automatisée des Données Sociales (DADS) reporting, Global Payroll rules for DADS, and DADS data structures, and discusses how to:

Set up DUCS information.
Set up DADS extraction.

Note. The DUCS and DADS data norms change frequently. The sample DUCS and DADS data structures and records in this PeopleBook are valid as of late 2006. They may be superseded by future updates to the DUCS and DADS data norms.

Understanding DUCS Reporting

Global Payroll for France enables you to create files following the DUCS norm (V4.2 COPLAT) for submitting social security contribution information to government agencies. With Global Payroll for France, you can generate the following reports, declarations, and payments:

URSSAF monthly, quarterly, and yearly declarations—Tableau Récaptiulatif des Cotisations (TRC)—including Versement en Lieu Unique (VLU).
ASSEDIC monthly, quarterly, and yearly declarations—Bordereau de Déclaration Annuelle (BDA)—including Paiement Groupe (PG).
ARRCO and AGIRC monthly, quarterly, and annual reports.
Electronic payments for each declaration.

Rather than having each establishment declare and pay its contributions to the URSSAF offices in each of its locations, a company can arrange to file the VLU. That way, a company can submit one report to the URSSAF office near its headquarters, on behalf of its establishments. Similarly, a company can arrange to file PG with ASSEDIC.

Note. To conform with the DUCS norm, these declarations are submitted in electronic files—with the exception of the annual BDA and TRC, which are paper reports.

Understanding Global Payroll Rules for DUCS

The DUCS extraction is based on amounts calculated in Global Payroll. At the end of the payroll calculation process, the REP AR DU COTI array reads the DUCS contributions setup information and runs the REP FM DU COTI formula for each contribution included in the DUCS contributions setup information. Upon resolution, it writes the data to the REP WA DU COTI writable array. This data is used in the DUCS extraction that uses the GPFR_DUCS_WA1 record.

You can populate some elements stored in the writable arrays with some specific values you calculate or to override some elements populated by the PeopleSoft system. To modify the results stored in the REP WA DU COTI writable array, two formulas are called by the REP FM DU COTI formula. These formulas—which are delivered with the PeopleSoft system but not maintained by it—are:

REP FM DU UTI 1 R.

It is defined as Always Recalculate. It's recalculated for each contribution processed by the REP AR DU COTI array.
REP FM DU UTI 2 NR.

It is defined as Not Recalculate. It's only calculated for the first contribution processed by the array.

These formulas can be adapted to meet your needs.

Understanding DADS Reporting

The PeopleSoft system provides the means for preparing DADS. DADS setup is based on the rules delivered in Global Payroll for France and following the Unified DADS (DADS-U) norm, and it can be modified to fit your particular needs.

The DADS-U norm is accepted by most French organizations accredited to receive the DADS declaration. It replaced the other existing DADS-TDS and DADS-CRC norms of declaration for the 2005 declarations (effective on January 31, 2006).

The different DADS-U partners include the social security organizations (such as ACOSS, CNAV, and CRAM), the tax services (DGI), the INSEE, the unemployment organizations (UNEDIC and ASSEDIC), and the majority of retirement funds (AGIRC and ARRCO organizations), as well as the contingency funds. Unlike the DADS-TDS, there is no mandatory membership needed for DADS-U.

To obtain information regarding the DADS-U norm and the particular data to declare, contact your CRAM organization, retirement fund organization, contingency fund organization, or TDS center before declaring your DADS-U.

CNAV and Net-Entreprises provide Web sites that can pre-validate DADS-U files. Contact these organization for additional information. Depending on the receiving organization, DADS-U files can be sent on a CD-ROM, floppy disk, or magnetic tape, or they can be electronically transmitted over the internet.

Understanding Global Payroll Rules for DADS

The amounts to be declared in the DADS file must be stored in Global Payroll results. Some elements—those beginning with the prefix DAS—have been created for the DADS (for example, DAS VR BASE TAX SAL1) and are stored in the payroll results. Some elements, already present in the payroll results, are declared in the DADS, for example, URS FM BASE A, which retrieves the URSSAF funding base limited to the A ceiling. The structure definition of these elements links them to DADS records.

Some DADS-related elements must be identified in the report by a particular code, with a declared amount related to the code. These elements can be repeated in the report with different codes and values. For example, the record S41.G01.02.001 indicates the code of the specific gross funding base and the record S41.G01.02.002 indicates the amount of this specific gross funding base. Therefore, these two records are related. Several specific gross funding bases and amounts can be declared for the same employee and for the same period. For managing such cases, the PeopleSoft system provides accumulators that have the codes as user keys and the amounts as the accumulators' values. In the preceding example, you can use the accumulator DAS AC BASE BRT SPE. The user keys of this accumulator are COMPANY and the variable is DAS VR CD BASE SPE. The member of this accumulator is the variable DAS VR BASE SPE. In the payroll calculation, the system determines the specific gross funding bases and then populates the key and the member of the accumulator. The same task is repeated for each specific gross funding base to declare.

The same logic is used by the elements listed in this table:

Element	Description	DADS Structure
DAS AC BASE BR EXO	Gross submitted to exemptions.	S41.G01.06
DAS AC BASE BRT SP	Specific gross funding base.	S41.G01.02
DAS AC BASE PL EXO	Exempted gross limited to a ceiling.	S41.G01.06
DAS AC BASE PLF SP	Specific gross funding base limited to a ceiling.	S41.G01.03
DAS AC CSG SPECIF	Specific CSG funding base. The accumulator DAS AC CSG SPECIF is not populated by the PeopleSoft system. You can populate it by using the same logic described previously: update the user keys and then the accumulator member.	S41.G01.05
DAS AC RETR COMP**	Supplementary pension fund information. The accumulator DAS AC RETR COMP is populated in the formula DAS FM GENERAL, which is maintained by the PeopleSoft system.	S41.G01.01
DAS AC SI BRUTES	Gross isolated amounts (three user keys for this accumulator).	S41.G01.04
DAS AC SI PLAFONNE	Isolated amounts limited to a ceiling (three user keys for this accumulator).	S41.G01.04

You can update the provided Not Maintained formulas to populate these accumulators in situations not managed by the PeopleSoft system. This table lists the formulas to populate these accumulators that are delivered with the PeopleSoft system but not maintained:

PeopleSoft Formula	Customer Formula	Function
DAS FM BASE EXO	DAS FM BASE EX UTI	Used to update the accumulators DAS AC BASE BR EXO and DAS AC BASE PL EXO.
DAS FM BASE PL SPE	DAS FM BASE PL UTI	Used to update the accumulator DAS AC BASE PLF SP.
DAS FM BASE SPECIF	DAS FM BASE SP UTI	Used to update the accumulator DAS AC BASE BRT SP.
DAS FM SOMMES ISOL	DAS FM SOM ISO UTI	Used to update the accumulators DAS AC SI BRUTES and DAS AC SI PLAFONNE.

Important! Because the elements declared (variables, formulas, and accumulators) are read in the payroll results, it is important to set up these essential elements during implementation, before Global Payroll for France is used in a production environment. Some elements may already exist in the payroll calculation; you then only need to modify their store option in order to retrieve them in the DADS extraction. Some specific elements may need to be specifically created to be stored and declared in the DADS.

Once the payroll elements have been created or stored, you then link them to the DADS-U records on the Structure Definition page. This step must be performed before the first DADS extraction. The payroll elements that can be used in the DADS records setup are variables, formulas, accumulators (values and keys) and system elements; earnings and deductions can't be used directly in the DADS setup. It is necessary to use to intermediate elements specifically dedicated to the DADS to declare Earnings or Deductions in the DADS file.

Writable Arrays Used to Support DADS

Two writable arrays are delivered by PeopleSoft: DAS WA SITUAT S41 and DAS WA SITUAT S45.

DAS WA SITUAT S41

This writable array is used for determining the changes in S41 situations. The S41 situations in the DADS file correspond to periods of time during which the employee parameters remain identical. For each payroll segment calculated, an entry is created in the WA record. If a value stored in the writable array changes from one segment to the next, it may cause a change of situation in the DADS declaration.

DAS WA SITUAT S45

This writable array is used to prepare the declarations for contingency funds. The values stored in the array are used to populate the S45.G01.01 records. The writable array is populated based on the mandatory contingency contributions calculated for Executive and Acting Executive. For specific contingency contributions implemented by customers, the logic implemented for the mandatory contributions must also be implemented. The different elements stored in the writable array must be populated based on the contingency contributions parameter. Once these elements are populated, DAS WA SITUAT S45 must be called in order to store the information for the later extraction. Users must ensure that this array is called for each contingency fund to be declared for one employee. This can be set up by using a post-process formula that calls DAS WA SITUAT S45 in the definition of the contingency contributions or by inserting the writable array in a section, after each contingency contribution.

Understanding DADS Data Structures

The PeopleSoft system provides all the structures and records included in the DADS-U requirement book. Some of these structures or records apply to unsupported industries or rules; they are defined as inactive. The inactive records (included in active structures) can be modified and declared depending on the setup that you create to populate them. The population of the records depends on several data sources. Some are directly computed by the DADS processes, while some others come from the Global Payroll Results table.

DADS structures are identified by a 3.3.2 character code; for example, S10.G01.00. The DADS file contains the following Active structures provided by the PeopleSoft system based on the V08R000 norm:

S10.G01.00 and S10.G01.01: Transmitter—the organization that transmits the declaration. It can be different from the company being declared. This structure is populated on the DADS Sending References page and on the DADS Reporting Establishment page.

S20.G01.00: Company—the company for which the declaration is done. This structure is populated on the Sending Reference page.

S30.G01.00: Payee's Identification—groups some general information about the employee.

S41.G01.00 to S41.G01.06, and Employee Situation—groups some professional information and paid salaries by homogeneous period. For example, if an employee changes categories from nonmanager to manager during the declared period, two different structure 41s are created for the employee with the declaration of the begin and end date and begin and end reason for each structure 41.

S41.G02.01 Labor Board Relation election. This structure is used for preparing the list of electors for the Labor Board Relation elections Elections Prud'homales.

S44.G01.00 Supplementary Information—related to the ARRCO and AGIRC for one activity period defined in structure 41.

S45.G01.00and S45.G01.01, Supplementary Information—related to contingency funds for one activity period defined in structure 41.

S46.G01.00and S46.G01.01, Work Leave—used for the declaring illness, maternity, paternity, or work accident leave occurring during the declared period.

S70.G01.00 and S70.G01.01: Fees—used for the declaring fees. This structure must be populated manually by using the update process.

S80.G01.00: Establishments—INSEE identification of establishments.

S90.G01.00: Totals—computed totals and information used for statistics and controls.

Setting Up DUCS Information

To set up DUCS information, use the DUCS Definitions FRA (GPFR_DUCS), DUCS Contacts FRA (GPFR_DUCS_CONTACT), DUCS Contributions FRA (GPFR_DUCS_COT), DUCS Override Rates FRA (GPFR_DUCS_OVR_RATE), DUCS Types FRA (GPFR_DUCS_PARAM0), and DUCS Parameters FRA (GPFR_DUCS_PARAM1) components.

This section provides an overview of DUCS setup and discusses how to:

Review declaration codes for DUCS types.
Review identifier qualification parameters.
Review declaration type parameters for DUCS types.
Review contribution family parameters.
Review amount contribution type parameters.
Review pay mode, bank account, and reference type parameters.
View contribution specifics.
Map address fields.
Record DUCS contacts.
Enter address and phone information for DUCS contacts.
Define the DUCS structure.
Override DUCS rates.

Understanding DUCS Setup

Create a DUCS file by running a batch program, in which the system searches and compiles relevant data, writes it to a specific table, and then creates a magnetic file and a control report. If needed, you can change the payment before posting the file.

There are three kinds of setup:

Basic setup.

For this setup, you use the delivered DUCS Types page and the DUCS Parameters component as follows:
- Define each DUCS type on the DUCS Types page.
- Define DUCS parameters in the DUCS Parameters component.
Contributions setup.

The DUCS Contributions page shows which elements are calculated during the payroll process and then applied to the writable array. The table created contains the elements needed for each payee and segment. The PeopleSoft system comes with this component, but you must update it in the PeopleSoft-delivered deductions setup if you make any additions.
Organization setup.

This setup involves the DUCS Contacts component and the DUCS Definition page. The PeopleSoft system does not provide this data because it depends on the organization of each company.
- Define all DUCS contacts, recipients, transmitters, informants, editors, and establishments in the DUCS Contacts component.
- Assign these contacts their specific roles on the DUCS Definition page.
  
  This is where the report information is connected with the transmission and banking information. Transmission of payment is done using the source bank information that you establish in the system.

Pages Used to Set Up DUCS Information

Page Name	Object Name	Navigation	Usage
DUCS Types	GPFR_DUCS_PARAM0	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, DUCS Types FRA, DUCS Types	View declaration codes for each DUCS type in the system and establish new ones. Reference these DUCS types when preparing and generating DUCS files. The information on this page is delivered and maintained by the PeopleSoft system.
Identifier Code	GPFR_DUCS_PARAM1	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, DUCS Parameters FRA, Identifier Code	View the parameters of the identifier qualification code used in the Contact table. The information on this page is delivered and maintained by the PeopleSoft system.
Declaration Type	GPFR_DUCS_PARAM2	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, DUCS Parameters FRA, Declaration Type	Set declaration type parameters for each DUCS type. The information on this page is delivered and maintained by the PeopleSoft system.
Contributions	GPFR_DUCS_PARAM3	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, DUCS Parameters FRA, Contributions	Set parameters for the contribution family. The information on this page is delivered and maintained by the PeopleSoft system.
Amounts Types	GPFR_DUCS_PARAM4	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, DUCS Parameters FRA, Amounts Types	Set the parameters for the amount contribution type. The information on this page is delivered and maintained by the PeopleSoft system.
Pay Informations	GPFR_DUCS_PARAM5	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, DUCS Parameters FRA, Pay Informations	Set the parameters for pay mode, bank account, and reference type. The information on this page is delivered and maintained by the PeopleSoft system.
DUCS Contributions	GPFR_DUCS_COT	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, DUCS Contributions FRA, DUCS Contributions	View the contribution specifics for each recipient: URSSAF, ASSEDIC, and AGIRC or ARRCO. The PeopleSoft system provides contribution information for these contribution families. If you create or remove contributions to the payroll calculation, you need to modify the DUCS contribution setup. This page does not apply to contingency contributions.
Contact Definition	GPFR_DUCS_CONTACT	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, DUCS Contacts FRA, Contact Definition	Record the list of contacts for DUCS. Specify the role of these contacts on the DUCS Definition page.
Address and Phone	GPFR_DUCS_CONTACT1	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, DUCS Contacts FRA, Address and Phone	Enter address and phone information for DUCS contacts.
DUCS Definition	GPFR_DUCS	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, DUCS Definitions FRA, DUCS Definition	Define how establishments are used in creating DUCS.
Override DUCS Rates	GPFR_DUCS_OVR_RATE	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, DUCS Override Rates FRA, Override DUCS Rate	Override a DUCS rate.

Reviewing Declaration Codes for DUCS Types

Access the DUCS Types page.

Declaration Code

Displays the declaration code. Valid values are 901 for URSSAF, 902 for ASSEDIC, and 903 for AGIRC and ARRCO.

Description

Displays the description associated with the declaration code.

Regularizations

Select the type of method to use for retroactive changes. Values are:

Additive: The regularization amount is added to the current declaration period. The retroactively recalculated period is not changed.

Rectificative: The regularization amount is declared in a separate record in the DUCS`declaration..

Note. The regularization method to be used is defined by each organization. You must contact the organizations receiving these declarations to determine which method to use. The rectificative declaration is only available with DUCS norm 4.2.

See Understanding Retroactive Processing.

Reviewing Identifier Qualification Parameters

Access the DUCS Parameters FRA - Identifier Code page.

Identifier Qualification

Identifier Type

Displays the identifier types:

SIRET: References a previously set up establishment.

Other: References any other legal entity.

Identifier Code

Displays the identifier code: 5 for SIRET, and ZZZ for other.

Reviewing Declaration Type Parameters for DUCS Types

Access the DUCS Parameters FRA - Declaration Type page.

DUCS File Type

Multi Establishments (multiple establishments)

This option is selected if multiple establishments are allowed. This occurs for VLU filed with URSSAF and PG filed with ASSEDIC.

This table lists the combinations of DUCS type and file type that the PeopleSoft system provides:

DUCS Type	File Type	Description
URSSAF	913	BRC with no VLU
URSSAF	914	BRC with VLU
URSSAF	915	TRC with no VLU
URSSAF	916	TRC with VLU
ASSEDIC	920	ADV for one establishment
ASSEDIC	921	ADV for several establishments
ASSEDIC	922	BDA for one establishment
ASSEDIC	923	BDA for multiple establishments
AGIRC/ARRCO/Other	930	Quarterly declaration
AGIRC/ARRCO/Other	931	Monthly declaration
AGIRC/ARRCO/Other	932	Annual declaration

Reviewing Contribution Family Parameters

Access the DUCS Parameters FRA - Contributions page.

This table lists the combinations of DUCS type and Contribution Family that the PeopleSoft system provides:

DUCS Type	Contribution Family	Description
URSSAF	905	URSSAF
ASSEDIC	906	ASSEDIC
AGIRC/ARRCO/Other	907	AGIRC
AGIRC/ARRCO/Other	908	ARRCO
AGIRC/ARRCO/Other	912	AGFF
AGIRC/ARRCO/Other	950	APEC

Reviewing Amount Contribution Type Parameters

Access the DUCS Parameters FRA - Amounts Types page.

This table lists the Contribution Type values that the PeopleSoft system provides:

Contribution Type	Description
920	URSSAF Gross
921	URSSAF A-Ceiling
925	URSSAF Gross Minus (negative value)
926	URSSAF A-Ceiling Minus (negative value)
930	ASSEDIC Gross Plus (positive value)
931	ASSEDIC Lump-Sum Plus (positive value)
932	ASSEDIC Gross Minus (negative value)
933	ASSEDIC Lump-Sum Minus (negative value)
940	IRC Gross Plus (positive value)
941	IRC Plus (positive value)
942	IRC Lump-Sum Plus (positive value)
948	IRC Fictitious Plus (positive value)
950	IRC Gross Minus (negative value)
951	IRC Minus (negative value)
952	IRC Lump-Sum Minus (negative value)
958	IRC Fictitious Minus (negative value)

Reviewing Pay Mode, Bank Account, and Reference Type Parameters

Access the DUCS Parameters FRA - Pay Informations page.

Pay Mode

Displays the pay mode. Valid payment descriptions are 20 (Check), 30 (Transfer), 31 (Automatic Deduction), and Z10 (Telepayment).

Bank Account Type

Displays the bank account type and description. Values are: BF (Recipient bank account) and OR (Declarant bank account).

Reference Type

Displays the reference type: PQ for payment by check or transfer or CR for payment by telepayment or automatic deduction.

Viewing Contribution Specifics

Access the DUCS Contributions page.

Contribution Type Tab

Displays the contribution type and order number.

Contribution Type	Displats the type of contribution.
Type	Displays the character value for the character contribution type.
Name	Displays the name of the element for the contribution type.
Description	Displays the description of the contribution type.
Order Number	Displays the order number of the contribution type.

Base Tab

Base	Displays the element type used for the base. The row number corresponds to the contribution type listed on the Contribution Type tab.
Element Name and Description	Displays the element used for the base and its description.

Rate Tab

Employee, Column Element 1, and Name	Displays the element and element type used for the employee contribution rate. The row number corresponds to the contribution type listed on the Contribution Type tab.
Employer, Column Element 2, and Description	Displays the element and element type used for the employer contribution rate. The row number corresponds to the contribution type listed on the Contribution Type tab.
AT, Column Element 3, and Description	Displays the element and element type used for the work accident. This element is used to group together URSSAF contributions for identical work accident (AT) rates. (There are several URSSAF contributions to be paid, and these contributions are grouped on the report. The sum is provided for contributions calculated for employees having the same AT rate.) The row number corresponds to the contribution type listed on the Contribution Type tab.

Amount Tab

Employee, Column Element 1, and Name	Displays the element and element type used for the employee contribution amount. The row number corresponds to the contribution type listed on the Contribution Type tab.
Employer, Column Element 2, and Description	Displays the element and element type used for the employer contribution amount. The row number corresponds to the contribution type listed on the Contribution Type tab.

Payee FTE Tab

Payee FTE, Column Element 1, and Name	Displays the element used to determine headcounts. The row number corresponds to the contribution type listed on the Contribution Type tab.
Payee FTE, lump sum cont (lump-sum contributions), Column Element 2, and Description	Displays the element that is used to calculate headcounts contributing to a lump-sum contribution (for example, the APEC lump-sum contribution).
Transportation	Select if the element is an URSSAF transportation contribution. When selected, the DUCS norm indicates that the contribution generates a TRS record instead of a COT record.
Additional Transportation	Select if the element is an URSSAF additional transportation contribution. When selected, the DUCS norm indicates that the contribution generates a TAT record instead of a COT record.

Amount Type 1 Tab

Positive	As required, each contribution is assigned an amount type 1, as defined in the DUCS requirements. Once the total of contributions is calculated, the Positive amount type is reported in the DUCS file if this sum is positive.
Negative	As required, each contribution is assigned an amount type 1, as defined in the DUCS requirements. Once the total of contributions is calculated, the Negative amount type is reported in the DUCS file if this sum is negative.

Amount Type 2 Tab

Positive	As required, each contribution is assigned an amount type 2, as defined in the DUCS requirements. Once the total of contributions is calculated, the Positive amount type is reported in the DUCS file if this sum is positive.
Negative	As required, each contribution is assigned an amount type 2, as defined in the DUCS requirements.

Mapping Address Fields

Access the DUCS Address Mapping page.

This page allows users to define a correspondence between PeopleSoft address fields and DUCS address records. This mapping is recommended to extract the INSEE code declared in transportation and additional transportation contributions for each establishment.

See Mapping Address Fields.

Recording DUCS Contacts

Access the DUCS Contacts - Contact Definition page.

OPS Identification

DUCS Type	Select the DUCS type. Valid values are determined by what is established on the DUCS Types page.
Identifier Type	Select Other, SIREN, or SIRET.
Establishment ID	Enter the identification number, as requested in the DUCS requirements.
Reference 1	Enter the reference 1, as requested in the DUCS requirements. This field is specific for ARRCO, AGIRC, or contingency fund. Enter the number communicated by your retirement and contingency fund organizations.

Contact Type

Use this group box to define whether a DUCS contact is a recipient or sender for DUCS type 903 (Agirc Arrco Other).

Sender	Select to indicate that the contact is a sender of DUCS.
Recipient	Select to indicate that the contact is a recipient of DUCS.

Entering Address and Phone Information for DUCS Contacts

Access the DUCS Contacts - Address and Phone page.

Address Definition

Address Type

Select Company Address, Establishment Address, or Other.

Address

Enter the address. If the address type is:

Other: Click this link to access the secondary page for the address.

Company Address: Enter the company SIREN number.

Establishment Address: Enter the establishment SIRET number.

Phone Definition

Service / Correspondent	Enter the service or correspondent.
Contact Type	Select Company Phone, Establishment Phone, or Other.
Establishment ID (Phone)	Depending upon the contact type, the phone number may be hidden.

Label

Email Address

Enter the email address of the contact.

Defining the DUCS Structure

Access the DUCS Definition page.

DUCS Addressee

Select the addressee from the DUCS Contact Definition component. This information is for your information only; it’s not a DUCS requirement.

Declaration Definition

Recipient Name (“MR”)	Select the recipient of the DUCS file. The Contact Definition field on the Contact Definition page determines available values. The recipient name corresponds to the recipient of the DUCS declaration as defined in the DUCS requirement book.
Transmitter Name (“FR”)	Select the transmitter name. The Contact Definition field on the Contact Definition page determines available values. In general, it is the establishment responsible for sending the DUCS file.
Informant Name (“DT”)	Select the informant name. The Contact Definition field on the Contact Definition page determines available values. You must indicate here the legal declaring entity (Entité Juridique Déclarante) as defined in the DUCS requirement book. For URSSAF and ASSEDIC, the informant should be companies, while for ARRCO, AGIRC, and contingency funds, it is the member.
Editor Name (“AE”)	Select the editor name. The Contact Definition field on the Contact Definition page determines available values. You must indicate here the name of the party preparing the declaration for you.
Payment Name (“PAI”)	Select the payment name. The payment name is the name of the contact who is in charge of the payment of the contributions. The Contact Definition field on the Contact Definition page determines available values.
File Type	Select a file type from the DUCS Parameters - Declaration Type page. Available values correspond to the relevant DUCS type.
Payment Type	Select a payment mode or method. Valid values are determined by the Pay Mode field on the DUCS Parameters - Pay Information page: Check, Transfer, Automatic Deduction, and Telepayment.
Source Bank ID	Select the bank account to be debited. You must have established a source bank account.

Establishments List

Establishment	Select the declared entities. For the URSSAF and the ASSEDIC, it is Establishments; for ARRCO, AGIRC, and contingency funds, it is the payment center (centre payeur). If you are setting up VLU or PG, enter at least two establishments; otherwise, enter one establishment. The Contact Definition field on the Contact Definition page determines available values.
Main Establ. (main establishment)	If you are setting up VLU or PG, select this check box to indicate the main establishment, as defined by the DUCS requirements. This information produce a type FZ record as defined in the DUCS requirement book.

Overriding DUCS Rates

Access the Override DUCS Rate page.

Use this page to override rates that have been incorrectly used and declared in a previous DUCS declaration.

Contribution	Enter the contribution type for which a rate override is necessary.
Year	Enter the year for which the override must apply.
Company and Establishment ID	Enter the company and establishment to which the override applies if the DUCS type is equal to 901 (URSSAF) or 902 (ASSEDIC).
Recipient Name (“MR”) and Establishment	Enter the recipient name and establishment to which the override applies if the DUCS type is equal to 903 (AGIRC, ARRCO, or OTHER).
Rate Type	For URSSAF contribution type, select Non AT to override the global contribution type rate, or AT rate to override the work accident rate related to the contribution type you selected.
Rate to Override	Enter the current rate used for the contribution, year, company, and establishment.
Rate to Use	Enter the new rate to use.
Status	Select whether the rate override is Active or Inactive.

Setting Up DADS Extraction

To set up DADS extraction, use the DADS Data Types FRA (GPFR_DA_DATTYP), DADS Reporting Estabs FRA (GPFR_DA_ESTREP), DADS Recipients FRA (GPFR_DA_RECIP), Address Mapping FRA (GPFR_DA_REC_ADDRES), DADS Situations FRA (GPFR_DA_SIT), DADS Sending References FRA (GPFR_DA_SNDREF), DADS Structures FRA (GPFR_DA_STRUCT), and DADS Output Report FRA (GPFR_DA_REPDFN) components.

Use the CI_GPFR_DA_DATTYP component interface to import data into the tables for the DADS Data Types FRA component. Use the CI_GPFR_DA_SIT component interface to import data into the tables for the DADS Situations FRA component.

This section discusses how to:

Define data types.
View structures and records.
Set up elements.
Define situations.
Select records for file generation.
Map address fields.
Define reporting establishments.
Define sending references.
Define DADS summary reporting.

Prerequisites

Establish the following information in the system before processing DADS:

The organization to be declared.
The DADS output structure.
The codes that are usable during the DADS process and the links between the payroll elements and the output structure.

Pages Used to Set Up DADS Extraction

Page Name	Object Name	Navigation	Usage
Data Type	GPFR_DA_DATTYP	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, DADS Data Types FRA, Data Type	View data types and translate values. This list contains information for each data type defined by unified DADS requirements.
Structure	GPFR_DA_STRUCT	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, DADS Structures FRA, Structure	View DADS structures and records. A structure is a set of records.
Elements	GPFR_DA_STRUCT2	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, DADS Structures FRA, Elements	View and modify DADS element details. This setup page enables you to link records with Global Payroll elements stored in the results tables.
DADS Situations	GPFR_DA_SIT	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, DADS Situations FRA, DADS Situations	Define the DADS beginning and end situation codes.
Recipient	GPFR_DA_RECIP	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, DADS Recipients FRA, Recipient	Select records for file generation.
DADS Address Mapping	GPFR_DA_REC_ADDRES	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Address Mapping FRA, DADS Address Mapping	Define mapping between address fields used in the application and DADS address structure.
Reporting Estab (reporting establishment)	GPFR_DA_ESTREP	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, DADS Reporting Estabs FRA, Reporting Estab	Define reporting establishments and contacts.
Sending Reference	GPFR_DA_SNDREF	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, DADS Sending References FRA, Sending Reference	Define the layout of the output file. One file is a set of declared companies, which comprise groups of employees called establishments.
DADS Output	GPFR_DA_REP_DFN	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, DADS Output Report FRA, DADS Output	Define DADS structures to include in DADS output report.

Defining Data Types

Access the Data Type page.

Use data types to translate DADS records used in the report. When you add or modify a DADS data record, data types provide a view of the description instead of only the DADS record code number.

Read Code	Maps the field value to the DADS structure code that you specify in the associated Code field. The field value is extracted from the PeopleSoft application.
Code	DADS structure code translated from the Read Code field.

Viewing Structures and Records

Access the Structure page.

Structure

Displays a DADS structure.

User Option

Specify how the DADS structure is to be managed after the extraction process. Possible values are EDIT, meaning that the structure can be displayed added or removed in one of the DADS Update page. Display Only means that the structure can be displayed or added in one of the DADS update page. Invisible means that the structure can be viewed in one of the DADS page.

Select from these values:

Edit: The structure can be displayed, added, or removed, in one of the DADS update pages.

Display Only: The structure can be displayed or added in one of the DADS update pages.

Invisible: The structure can be viewed in one of the DADS pages.

Components

Select to open a page used to enter components where the structure can be displayed.

Records

PeopleSoft Maintained and Customer Maintained	Select Customer Maintained to modify the DADS record definition.
Status	Select the record status. Values are: Active:An active structure must include at least one active record. Inactive:An inactive structure may include only inactive records.
Type	Select Fixed, Monetary, Numeric, or Text. The system can calculate only currency conversions for monetary amounts. The system cannot convert numeric entries to monetary amounts or convert currencies in the DADS process. The length of Fixed values declared in the record must correspond exactly to the length indicated for the record. Text values must be shorter than or equal to the record length definition.
Data Source	Indicate how the system retrieves data: Computed: The retrieval process is hard-coded in the Application Engine. Fixed Text: Value in the Fixed Text field is used. Not Computed: Data or retrieval process is not defined in the application. Result: Data comes from the Global Payroll result tables. User Key 1-4: Data comes from the Global Payroll Accumulator Result table.
Considered Value	Select whether the system uses the value in the first segment, the last segment, or the sum of all segments.
Mandatory	Select to specify a mandatory field. The data appears in the update pages and in the file generation process. The system displays a message when a mandatory field is not populated during the update process. When a record is defined as mandatory in the definition, it is written in the DADS file as soon as the structure it belongs to is populated. The mandatory record written without corresponding data will bring to have the DADS file rejected by the receiver organizations.
AE Section (Application Engine section)	When the data source is Computed, specifies the Application Engine section used to determine the DADS structure record. If the DADS structure record is customer-maintained, the PeopleSoft application creates an empty section in the Custom DADS Application Engine, GPFR_DA_CUST. You must then write custom code in this empty section to create the required data.
Fixed Text	When the data source is Fixed Text, enter text to specify the DADS structure value to be used. For some records delivered by PeopleSoft, the value “BY FILE” appears in this Fixed Text field. In this case, it means that the record can't be computed during the DADS extraction but will be filed when the DADS file is generated. This behavior is particularly true for some records that are populated based on the file generation option as the S20.G01.00.004.001 (Nature Code of the Declaration) record.
Sign Indicator	Indicates that this record stores the sign of the previous record. In the DADS structure format, most numeric amounts are stored without showing if the amounts are positive or negative. To indicate if a numeric amount is positive or negative, you store the positive or negative sign in the record that immediately follows the numeric amount. An empty record indicates a positive amount, a value of N indicates a negative amount. PeopleSoft provides a generic Application Engine section SIGN that can be used for Customer Maintained defined records.

Label Source

Label Source

Select a source. The system uses this field to manage the prompts associated with a code on the update pages. Possible values are:

Data Type: Possible code values are given by a data type. Select the data type name in the Data Type field.

Record: Possible code values are given by a record. Select the name of the record in the Edit Table field, the description of the record in the Prompt Label Field Name field, and the key field for the record in the Prompt Key Field Name field.

Xlat Value: Possible code values are given by the translate table. Enter the name of the field that contains the valid translate values in the Field Name field.

Setting Up Elements

Access the Elements page.

Entry Type

This field is available only if you are defining a custom DADS record. Defines the type of payroll element. Values are:

Accumulatr (Payroll accumulator).

Formula.

SystemElem (System element).

Variable.

Element Name

Payroll element to be mapped. Available values vary depending on the entry type that you select.

Record

Displays the record code populated by the payroll element setup. Available record values are for records defined with a Data Source equal to Result or User Key 1 to 4.

Defining Situations

Access the Situation page.

In the DADS report, structure S41 contains social and fiscal data as well as gross salary, net salary, contribution funding base, and so forth. A new S41 is created each time an employee DADS situation changes. Using the Situation page, you can link PeopleSoft employee record changes to corresponding DADS situation changes.

Action	Enter the action that triggers the situation change.
Reason Code	Enter the reason for the action that triggers the DADS situation change.
Situation Change	Enter the type of situation change. Values vary depending on the employee record. Values are stored in the DADS writable array DAS WA SITUAT S41.
Reason Begin	Enter the reason corresponding to the new DADS situation. Values are defined in the STREAS data type. The code corresponding to the Reason Begin is declared in the record S41.G01.00.002.001
Reason End	Select the reason corresponding to the end of the previous DADS situation. Values are defined in the ENDREAS data type. If no value is selected in the Reason Begin field, this field corresponds to the end reason of the current DADS situation. The code corresponding to the Reason End will be declared in the record S41.G01.00.004.001. Note. The latest DADS norm provides up to 5 records for declaring the situation change code– S41.G01.00.002.001 to 005 for the Reason Begin code and S41.G01.00.004.001 to 005 for the Reason End code. The different records and codes are used when there are several changes that occur on the same date. For example, if an employee is promoted to manager and transfered to a new establishment on the same date, those two actions can be declared using situation change codes. However, PeopleSoft only populates one reason begin and reason end code. The reason for this is that the codes 002 to 005 are optional and informational. PeopleSoft records only one code based on the sequence order used to record the situation change. In the example above, if the sequence order for the employee category change (from non-manager to manager) is 100 and the sequence order for the establishment transfer is 200, then only the category change reason codes will be declared.

Selecting Records for File Generation

Access the Recipient page.

Use this page to define, by declaration nature, the content of the file declared. PeopleSoft delivers several Recipients based on the definition of the file content provided in the DADS-U norm.

Refresh Structure Definition	Select to retrieve all Active structures and update the Include and Mandatory option based on the records definition. All changes to Include and Mandatory options are overridden. If a structure initially defined as Inactive is changed to Active, the recipient definition must be refreshed in order to have this structure included in the file generated by the DADS program. The Min/Max values must be entered for the structure added after the refresh to the recipient definition.
Declaration Nature	Select to indicate the type of DADS declaration.
Min (minimum)	Select the minimum number of occurrences of the DADS structure in the DADS declaration file. Minimum values are defined in the DADS norm. Available values are: 0: The structure is optional. 1: The structure is mandatory. 3 N
Max (maximum)	Select the maximum number of occurrences of the DADS structure in the DADS declaration file. Maximum values are defined in the DADS norm. Available values are: 0: If the Min field is also set to 0, the structure is not declared. 1 3 N

Mapping Address Fields

Access the DADS Address Mapping page.

This page allows users to define a correspondence between PeopleSoft address fields and DADS address records.

Default Address	Select this check box to indicate that this address mapping is used as the default address. The application uses the default address if no country mapping exists.
Record	This field corresponds to the address record ID. Values available are: 001: Address complement. 003: Street number. 004: Bis or Ter. 006: Street name. 009: Town name. 010: Postal code. 012: City. 013: Country code.
Address Field 1–3	Select the address field that you want to map to the address record. Note. If you map two or three address fields, the PeopleSoft system's address fields are concatenated in the address. The norm defines maximum allowable lengths for address records. If the concatenated address fields value exceeds the maximum allowed length, the excess characters ise truncated. The address might then be rejected by the receiving organization.
Substring Type	Select the segment of the address character string that you want to map. Values available are: No: The feature is disabled and the entire string is used without modification. St Nbr: The system extracts the street number by selecting the first number found in the address. B/T: The system extracts the Bis or Ter string from the address by selecting any combination of lowercase and uppercase letters. Delimited: The system extracts a character string from the address according to rules you specify in the Delimiter and Selection fields.
Delimiter	Select to indicate which character is used as the starting point of the substring. This field is required if the Substring Type field is set to Delimited. Values available are: Comma: The first comma is used as the starting point. Space: The first space is used as the starting point. Space/Comma: The first space or comma is used as the starting point. None: This value is selected automatically if the value in the Substring Type field is No.
Selection	Indicate the direction, from the delimiter, that the substring should be extracted from the address. This field is required if Substring Type is set to Delimited. Values available are: Left: Selects all characters to the left of the delimiter. Right: Selects all characters to the right of the delimiter. None: This value is selected automatically if the value in the Substring Type field is No.

Address Mapping Example

This example shows a DADS address extraction using the FRA address mapping provided with Global Payroll for France. The default settings are shown in the Address Mapping page illustration above. In this example, the following Address Record is extracted:

Field Label	Entered Value
Country	FRA
Address 1	5 bis, Rue de la Paix
Address 2	Res. Le Dome
Address 3	Bat. B - 2ème étage
Post Office	(Null)
City	PARIS
Postal	75001
Department	75

The DADS extract creates the following DADS structures from the address record:

DADS Structure	Value	Comments
S30.G01.00.008.001	Bat. B - 2ème étage	Entire Address 3 field value is mapped.
S30.G01.00.008.003	5	First number is extracted from Address 1 field.
S30.G01.00.008.004	B	String bis is extracted from Address 1 field
S30.G01.00.008.006	Rue de la Paix Res. Le Dom	Text string after the comma is extracted from Address 1. All text fromAddress 2 is extracted. The two text strings are concatenated into the DADS structure. The maximum allowed length is 26 characters; the last character is truncated (“Dome” becomes “Dom”).
S30.G01.00.008.009	(Null)	This optional structure is not mapped.
S30.G01.00.008.010	75001	Entire Postal field value is mapped.
S30.G01.00.008.012	PARIS	Entire City field value is mapped.
S30.G01.00.008.013	FRA	Entire Country field value is mapped.

Defining Reporting Establishments

Access the Reporting Estab page.

DADS Reporting Establishment page allows defining the reporting establishments and the contacts within these establishments. The reporting establishments created are referenced in the Sending Reference setup.

Reporting Establishment	Enter the establishment code. One reporting establishment must be set up for each declared company. Use this page to define the reporting establishment and the information related to the establishment (such as people to contact and communication mode with DADS) that is used in structure 10.
Communication Mode	Enter the transmission method for the DADS log file. Valid values are Electronic Mail andPostal Mail.
Communication Detail	Values vary depending on the communication mode: Electronic Mail: Enter the email address. Postal Mail: Enter specific contact data, such as a phone number.
Name Prefix	Enter the name prefix for person who can be contacted by the DADS organization representatives.
Name	Enter the name of the person who can be contacted by the DADS organization representatives.

Contacts

Name Prefix	Enter the name prefix for the contact.
Name	Enter up to three active contacts for each reporting establishment.
Status	Select a status. A status of Active indicates that a contact must be used.
Intervention Domain	Select Administrative, Computing, or Other.
Contact Email	Enter the email address of the contact. Note. The underscore character “_” may be used in this field.
Contact Phone	Enter the phone number of the contact.
Contact Fax	Enter the fax number of the contact.

Defining Sending References

Access the Sending Reference page.

Sending reference information is used in structures S10 and S20 to identity the transmitter and company of the declaration. It is also used in structure S80 to identify establishments to be included in the declaration.

Transmitter Establishment	Enter an establishment defined in the PeopleSoft Enterprise Human Resources Establishment table. The transmitter establishment is declared in record S10.G01.00.001 and S10.G01.00.001.002 (transmitter SIREN plus NIC number).
Reporting Definition Contact	Select an entry defined on the Reporting Establishment page. The reporting establishment contact must be indicated for the sending reference. A reporting establishment contact can be used several times for different sending references. Data from the reporting definition populates the records S10.G01.00.013.001 and S10.G01.00.013.002 (log file recipient SIREN and NIC) as well as the transmitter contact information (S10.G01.01 structure).
No Employee	Select if there are no employees to declare for the report. If selected, all the establishments in the Establishment List in the page must have employed no staff during the declared year. The file generated must have a recipient type of None. No S30 structure must be present in the file; the record S20.G01.00.004.001 is equal to the code 05 for DADS-U empty and the record S20.G01.00.004.002 is equal to the code 55 for Code Type declaration None.
Company	Enter the company that is part of the DADS file for the defined sending reference. The company is declared in the record S20.G01.00.001 (SIREN number).
Main Establishment	Enter a main establishment. For each declared company, the main establishment must appear on the establishments list. The main establishment is declared in the record S20.G01.00.008 (main establishment NIC).
Declaring Establishment	Enter a declaring establishment. You can use the value that appears in the Main Establishment field. The declaring establishment is reported in the record S20.G01.00.010 (NIC number).
Reporting Definition	Select an entry defined on the Reporting Establishment page. The Reporting Establishment must be indicated for each company. The reporting definition information is used to declare the records S20.G01.00.014.001 to S20.G01.00.016 (SIREN plus NIC numbers).
Client Number	Optional. Enter a client number. The client number is declared in the record S20.G01.00.013. This field can be used when the transmitter of the DADS attributes a client to the companies he declares, for example for accounting firms performing declarations for their clients.
All	Select to declare all establishments.
Include	Select to declare only the establishments displayed on the page.
Exclude	Select to declare all establishments except those listed on the page.
Establishment and Description	Enter at least one establishment. The establishment lists the employees to be processed.

Defining DADS Summary Reporting

Access the DADS Output page.

This page displays the default DADS structures included with each DADS report produced using this report definition. To customize the report definition, add or remove DADS structure- and-record combinations.

Structure	DADS structure ID. Available structures are S41.G01,00 to S41.G01.06 (except S41.G01.01), S45.G01.01, S70.G01.00 and S70.G01.01.
Record	DADS structure record number. Available records are Monetary or Numeric.

Pay Mode	Displays the pay mode. Valid payment descriptions are 20 (Check), 30 (Transfer), 31 (Automatic Deduction), and Z10 (Telepayment).
Bank Account Type	Displays the bank account type and description. Values are: BF (Recipient bank account) and OR (Declarant bank account).
Reference Type	Displays the reference type: PQ for payment by check or transfer or CR for payment by telepayment or automatic deduction.