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 Unifiée (DADS-U) reporting, Global Payroll rules for DADS, and DADS data structures, and discusses how to:

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 2009. They may be superseded by future updates to the DUCS and DADS data norms.

Click to jump to parent topicUnderstanding 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:

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.

See Also

Defining ARRCO, AGIRC, and Contingency Fund Contributions

Defining URSSAF Contributions

Defining ASSEDIC Contributions

Click to jump to top of pageClick to jump to parent topicUnderstanding 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 CONTS array reads the DUCS contributions setup information and runs the REP FM DU CONTS formula for each contribution included in the DUCS contributions setup information. Upon resolution, it writes the data to the REP WA DU CONTS writable array. This data is used in the DUCS extraction that uses the GPFR_DUCS_WA record.

Click to jump to parent topicUnderstanding 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.

Click to jump to parent topicUnderstanding 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.

Click to jump to top of pageClick to jump to parent topicWritable 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.

Click to jump to parent topicUnderstanding 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.

Click to jump to parent topicSetting Up DUCS Information

To set up DUCS information, use the DUCS Definitions FRA (GPFR_DUCS), DUCS Contacts FRA (GPFR_DUCS_CONTACT), AF DUCS Contributions FRA (GPFR_DUCS_CONTS), 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:

Click to jump to top of pageClick to jump to parent topicUnderstanding 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 flat file and a control report. If needed, you can change the payment before posting the file.

There are three kinds of setup:

Click to jump to top of pageClick to jump to parent topicPages Used to Set Up DUCS Information

Page Name

Definition Name

Navigation

Usage

DUCS Types FRA

GPFR_DUCS_PARAM0

Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, DUCS Types FRA, DUCS Types FRA

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 FRA

GPFR_DUCS_COT

Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, DUCS Contributions FRA, DUCS Contributions FRA

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.

Address Mapping FRA

GPFR_DUCS_ADDRESS

Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Address Mapping FRA, Address Mapping FRA

Define a correspondence between PeopleSoft address fields and DUCS address records.

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 Definitions FRA

GPFR_DUCS

Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, DUCS Definitions FRA, DUCS Definitions FRA

Define how establishments are used in creating DUCS.

DUCS Override Rates FRA

GPFR_DUCS_OVR_RATE

Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, DUCS Override Rates FRA, DUCS Override Rates FRA

Override a DUCS rate.

Click to jump to top of pageClick to jump to parent topicReviewing Declaration Codes for DUCS Types

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

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.

Click to jump to top of pageClick to jump to parent topicReviewing Identifier Qualification Parameters

Access the DUCS Parameters FRA - Identifier Code page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, DUCS Parameters FRA, Identifier Code).

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.

Click to jump to top of pageClick to jump to parent topicReviewing Declaration Type Parameters for DUCS Types

Access the DUCS Parameters FRA - Declaration Type page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, DUCS Parameters FRA, Declaration Type).

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

Click to jump to top of pageClick to jump to parent topicReviewing Contribution Family Parameters

Access the DUCS Parameters FRA - Contributions page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, DUCS Parameters FRA, Contributions).

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

Click to jump to top of pageClick to jump to parent topicReviewing Amount Contribution Type Parameters

Access the DUCS Parameters FRA - Amounts Types page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, DUCS Parameters FRA, Amounts Types).

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)

Click to jump to top of pageClick to jump to parent topicReviewing Pay Mode, Bank Account, and Reference Type Parameters

Access the DUCS Parameters FRA - Pay Informations page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, DUCS Parameters FRA, Pay Informations).

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.

Click to jump to top of pageClick to jump to parent topicViewing Contribution Specifics

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

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.

See Also

Defining ARRCO, AGIRC, and Contingency Fund Contributions

Defining URSSAF Contributions

Click to jump to top of pageClick to jump to parent topicMapping Address Fields

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

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 Setting Up DADS Extraction.

Click to jump to top of pageClick to jump to parent topicRecording DUCS Contacts

Access the DUCS Contacts - Contact Definition page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, DUCS Contacts FRA, Contact Definition).

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.

Click to jump to top of pageClick to jump to parent topicEntering Address and Phone Information for DUCS Contacts

Access the DUCS Contacts - Address and Phone page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, DUCS Contacts FRA, Address and Phone).

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.

Click to jump to top of pageClick to jump to parent topicDefining the DUCS Structure

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

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.

See Also

Reviewing Declaration Type Parameters for DUCS Types

Reviewing Pay Mode, Bank Account, and Reference Type Parameters

Defining Banking Instructions

Click to jump to top of pageClick to jump to parent topicOverriding DUCS Rates

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

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.

Click to jump to parent topicSetting 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:

Click to jump to top of pageClick to jump to parent topicPages 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.

Click to jump to top of pageClick to jump to parent topicDefining 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.

Click to jump to top of pageClick to jump to parent topicDefining 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.

Click to jump to top of pageClick to jump to parent topicDefining 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.

Click to jump to top of pageClick to jump to parent topicDefining 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.