PeopleSoft Enterprise Global Payroll for France 9.1 PeopleBook

Setting Up DADS Reporting

This chapter provides an overview of Déclaration Automatisée des Données Sociales Unifiée (DADS-U) reporting, Global Payroll rules for DADS, and DADS data structures, and discusses how to set up DADS extraction.

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

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.

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.

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.

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.

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), DADS Situations FRA (GPFR_DA_SIT), and DADS Sending References FRA (GPFR_DA_SNDREF) 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.
Define reporting establishments.
Define sending references.

Pages Used to Set Up DADS Extraction

Page Name	Definition Name	Navigation	Usage
DADS Data Types FRA	GPFR_DA_DATTYP	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, DADS Data Types FRA, DADS Data Types FRA	View data types and translate values. This list contains information for each data type defined by unified DADS requirements.
DADS Situations FRA	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.
DADS Reporting Estabs FRA (reporting establishment)	GPFR_DA_ESTREP	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, DADS Reporting Estabs FRA, DADS Reporting Estabs FRA	Define reporting establishments and contacts.
DADS Sending References FRA	GPFR_DA_SNDREF	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, DADS Sending References FRA, DADS Sending References FRA	Define the layout of the output file. One file is a set of declared companies, which comprise groups of employees called establishments.
Application Definition	GPFR_AF_APPL	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Define Application/NodeSet FRA, Application Definition	Define the labels for node sets, nodes and attributes for a given Application Framework application.
Define Parameter Template	GPFR_AF_PRM_TEMPLT	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Define Application/NodeSet FRA, Define Parameter Template	Define parameters, grouped into functions, for a given application.
Node Set Definition	GPFR_AF_NODE_SET	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Define Application/NodeSet FRA, Node Set Definition	Lists all possible node sets, such as DADS-U messages.
Security Record List	GPFR_AF_APP_SECRTY	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Define Application/NodeSet FRA, Security Record List	In the event of incorrect setup, this transaction avoids the accidental deletion of important tables, such as the JOB table, while executing Data Object Names.
Node Set Nodes	GPFR_AF_NODE_SET_N	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Define Node Set Details FRA, Node Set Nodes	Displays the list of node sets defined in the Define Application / Node Set component, on the Node Set Definition page, and the list of structures associated with each node set.
Node Set Attributes	GPFR_AF_NODE_SET_A	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Define Node Set Details FRA, Node Set Attributes	Provides another view of the records associated with a node set, which enables you to see all of the records, for all structures.
Define Node FRA	GPFR_AF_NODE	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Define Node FRA	Contains all of the data used for the processing of structures and records. However, you can override some parameters at the Run Control stage.
SQL Entity Definition/Mapping	GPFR_AF_SQL_ENTITY	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Define SQL Entity FRA, SQL Entity Definition/Mapping	Define an SQL entity for a given application.
SQL Entity Template	GPFR_AF_SQL_TMPLT	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Define SQL Entity FRA, SQL Entity Template	Define an SQL entity template.
Define Data Object Name FRA	GPFR_AF_DON	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Define Data Object Name FRA	Define a data object name, which is the final object executed to populate a given record. A DON is composed of one or more SQL sequences.
Define Mapping Code FRA	GPFR_AF_MAPCODE_PG	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Define Mapping Code FRA	Defines the one-to-one mappings between HRMS data and DADS-U official codes. Complex relationships between HRMS data and DADS-U codes must be managed through a Data Object Name.
View SQL/DON Relationship FRA	GPFR_AF_SQLDON_REL	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, View SQL/DON Relationship FRA	View the relationships between SQL and data object names.
View DON/Attr Relationship FRA (view data object name/attribute relationship FRA)	GPFR_AF_DONATR_REL	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, View DON/Attr Relationship FRA	View the records that use a data object name.
Duplicate Objects FRA	GPFR_AF_DUP_DATA	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Duplicate Objects FRA	Duplicate SQL entities and DONs, for customization purposes.

Defining Data Types

Access the DADS Data Types FRA page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, DADS Data Types FRA, DADS Data Types FRA).

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.

Defining Situations

Access the DADS Situations FRA page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, DADS Situations FRA, DADS Situations FRA).

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 DADS Situations FRA 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.

Defining Reporting Establishments

Access the DADS Reporting Estabs FRA page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, DADS Reporting Estabs FRA, DADS Reporting Estabs FRA).

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 DADS Sending References FRA page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, DADS Sending References FRA, DADS Sending References FRA).

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.