Setting Up DSN Reporting

As the monthly DSN report generation follows the monthly payroll process, all the payroll related set ups such as OPS set ups, payroll & absence element setups etc. are prerequisites for DSN data extraction.

To set up DSN extraction, use Define Data Types FRA and DSN Sending Reference FRA components.

This diagram shows how the data is extracted in DSN Reporting process.

DSN Reporting Process

Note: From DSN 3.3 version onwards the DUCS Contacts and DUCS Definition components are not used for DSN.

Page Name

Definition Name

Usage

Define Data Types FRA Page

GPFR_DT_VALUES

Define and view data types for DSN application.

Sending Reference Page

GPFR_DSN_SNDREF

Create a sending reference that defines the transmitter and receiver of the DSN file.

Company Establishment Setup Page

GPFR_DSN_SNDREF1

Identify the companies and establishments that are grouped for a DSN file.

Define OPS Page

OPS_SETUP_FRA

List all OPS and its delegates

Define OPS by Establishment Page

OPS_ESTAB_SETUP

Define OPS (those that are not bound by a contract) parameters for each establishment within a company.

Institution Type Page

FUND_INST_FRA

Define pension/contingency institutions. Specify the institution type, and the fund code, DADS and DUCS codes associated with the institution.

Pension/Contingency Contracts Page

CNTRCT_FUND_FRA

Set up contract information for pension/contingency contracts. Define your fund codes and institutions before you set up contract information.

Deposit Schedules Page

DEP_SCHED

Identify dates when payments are debited from the source bank account.

Job Information Page

JOB_DATA_JOBCODE

Use the Job Information page to enter information about a person's job, including status, employee class, shift, or standard hours.

Contract Type/Clauses Page

CONTRACT2

Add or update any special contract clause information to the standard contract language for this worker.

Deduction Name Page

GP_PIN

Name the element and define its basic parameters.

Element Group Members Page

GP_ELEMENT_GROUP

Insert elements into element groups.

Define List Set Page

GP_ELN_SET

Assign element groups to an application.

Element Group Attributes Page

GP_ELN_SET_SEC

Enter the element and element group attribute values for a list set.

Use the Define Data Types FRA page (GPFR_DT_VALUES) to define and view data types with list of codes for specific attributes based on DSN technical book and its translate values. For a specific data type you can define multiple data type codes.

Navigation:

Set Up HCM > Product Related > Global Payroll & Absence Mgmt > Social Security Insurance > Define Data Types FRA

This example illustrates the fields and controls on the DSN Data Types FRA page. You can find definitions for the fields and controls later on this page.

 Define Data Types FRA Page

Click the View Data Types link to view the list of codes and versions defined against the selected data type.

Field or Control

Description

Code

Enter a DSN code. These are the codes defined in the DSN technical book for specific attributes.

Version

Select the application version to be used. This version corresponds to the technical book version released by the French Government. Based on the version selected here, the extraction process identifies the data type codes to be considered for reporting.

Read Code

Maps the field value to the DSN code specified in the associated Code field. The field value is extracted from the PeopleSoft application.

Use the Sending Reference page (GPFR_DSN_SNDREF) to create a sending reference that defines the transmitter and receiver of the DSN file. It is also used to identify the establishments to be included in the DSN declaration

Navigation:

Set Up HCM > Product Related > Global Payroll & Absence Mgmt > Social Security Insurance > DSN Sending Reference FRA

This example illustrates the fields and controls on the Sending Reference page. You can find definitions for the fields and controls later on this page.

 Sending Reference Page

Sending Reference

Field or Control

Description

Monthly DSN

Select the checkbox if the DSN file needs to be sent monthly.

Event DSN

Select the checkbox if the DSN file needs to be sent on occurrence of an event.

Fraction Number

Enter a fraction number. This is to identify the fraction of the DSN file if there are multiple files generated by multiple systems. This information is fed into the attribute S20.G00.05.003

Transmitter

Field or Control

Description

Transmitter Establishment

Select an establishment defined in the PeopleSoft HR Establishment table. The transmitter establishment is the establishment corresponding to the selected company that sends the DSN information.

Receiver

Field or Control

Description

Reporting Definition

Select an entry defined on the Reporting Establishment page. It is the establishment to which the DSN information is reported. For each company, a Reporting Establishment must be indicated.

Email of receiver

Enter the email id of the receiver.

Use the Company Establishment Setup page (GPFR_DSN_SNDREF1) to select the companies / establishments to be grouped for the DSN output file.

Multiple companies/establishments can be selected and grouped under a single sending reference.

This example illustrates the fields and controls on the Company Establishment Setup page. You can find definitions for the fields and controls later on this page

 Company Establishment Setup Page

Navigation:

Set Up HCM > Product Related > Global Payroll & Absence Mgmt > Social Security Insurance > DSN Sending Reference FRA > Company Establishment Setup Page

Company

You can define multiple companies and corresponding parameters under a single sending reference.

Field or Control

Description

Company

Select the company that generates DSN file for the defined sending reference.

Foreign Establishment

To identify if the company is:

  • Foreign company with establishment in France

  • Foreign company outside EU without establishment in France

  • Foreign Company in the EU without establishment in France

Main Establishment

Select the main establishment that handles the regulatory requirements of the selected company.

IJSS Receiving Establishment

Select the establishment that handles the IJSS related information of the selected company.

Fraction Number

Enter a fraction number. This is to identify the fraction of the DSN file if there are multiple files generated by multiple systems. This information is fed into the attribute S20.G00.05.003. Note that this precedes the one defined under Sending Reference level.

Employee Count

Enter the number of employees included in the DSN process from the selected company.

DUCS Code

Select the DUCS code associated with the company.

These are defined under DUCS Definition FRA component, which is used only for DSN version 2.5 and not used thereafter.

Contact by DSN

For each company selected, you can enter the contact information based on the DSN file type. You can add multiple DSN types and corresponding contact details for the selected company.

Field or Control

Description

DSN Type

Select the type of DSN file based on the information to be reported.

Contact Type

Select the type of the contact to be used based on the information to be reported.

Establishment

For the selected company, you can add multiple establishments and corresponding contact details. Note that only these establishments will be considered for DSN Reporting.

Field or Control

Description

Establishment

Select the establishment corresponding to the selected company.

Subrogation

Select the checkbox if subrogation facility needs to be enabled.

Contact DSN

The Contact Information Defined here precedes the Contact Information provided at Company level.