Generating DADS

This chapter discusses how to:

• Extract DADS data.

• View and update extracted DADS data.

• Generate DADS files.

Extracting DADS Data

After you complete the DADS setup pages, you can extract DADS information from the payroll tables.

This section discusses how to:

• Define extraction IDs.

• Enter extraction parameters

• Launch the Run Extraction process

extract DADS data.

Pages Used to Extract DADS Data

Extraction ID Definition

Access the Define Extraction Data page (Global Payroll & Absence Mgmt, Absence & Payroll Processing, Define Calendars, Define Extraction Data FRA).

Period Format	Values are Month, Other, Quarter, Year.
Declared Year	Specify a value in this field only when the Period Format is Year.
Used Dates	These are the processed payroll results whose Payment Dates or Payroll Segment End Dates are within the Declaration Period.
Period Begin Date and Period End Date	Specify the dates of the declaration period.

Pay Groups

You must enter at least one paygroup in this region of the page. If you have a single extraction ID for all of your paygroups, you should list them all in this region.

Entering Extraction Parameters

Access the Parameters Page, (Global Payroll & Absence Mgmt, Absence & Payroll Processing, Define Calendars, Define Extraction Data FRA, Parameters).

On the Parameters Page, enter a previously defined sending reference and the frequency code A00 for DADS-U,

Launching the Run Extraction Process

Access the Run Extraction FRA Page (Global Payroll & Absence Mgmt, Social Security / Insurance, Run Extraction FRA).

When the process has successfully completed, the GPFR_AF_EXTRACT table is populated based on the Extraction ID definition and the Run Control parameters.

Viewing and Updating Extracted DADS Data

This section provides an overview of extracting DADS data and discusses how to:

• Select structures to view.

• Apply additional filters.

• Update data.

Understanding Viewing and Updating Extracted DADS Data

Use the Update Extraction Data FRA Component to view and update the extraction results and identify possible issues.

You can then update any incorrect data in the Human Resources application and selectively rerun any employees or records that need to be updated. The system enables you to perform as many runs as you need for an Extraction ID, until the results in the GPFR_AF_EXTRACT table are correct. Each time the incorrect data is deleted, replaced by the new extracted data, and then inserted into any previously extracted data according to the DADS-U norm sorting rules.

Important! If you update any data through this component, and then re-run the process, your manual input is overridden. Both manual updates and Extraction ID runs populate the same extraction table, so manual updates are not stored separately. Therefore, if you need to make manual updates, you should perform them after the last run of a given Extraction ID.

Since there may be a large number of rows generated in the GPFR_AF_EXTRACT table, and checked by many different users, this component offers various levels of filtering, to enable you to easily view the data you need.

Pages Used to View and Update DADS Data

Selecting Structures to View

Access the Node/Attr Filter page (Global Payroll & Absence Mgmt, Social Security / Insurance, Update Extraction Data FRA, Node/Attr Filter).

Applying Additional Filters

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

Use the Other Filters page to select other filters that are displayed based on the structures and records previously selected. For example, if only S10 and S20 structures have been selected, the Employee ID, Employee Record Number and Group List ID filters are not editable on the Other Filters page.

Updating Data

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

The Update Data page displays the results related to the filters you selected on the two first pages. You can then refine the data display by entering data in the Company, Estab ID (establishment ID), Empl ID, Empl Record, Structure, and Rubrique fields, then clicking the Filter button.

An export to Excel process is available, which shows the data displayed on the Update Data page.

Important! For technical reasons, regardless of the filters selected, the number of rows displayed on the Update Data page is limited to 5000. You may change this limit in PeopleTools, although you may then experience downgraded performance.

Node Data

The Node Data tab enables you to view the structure and record names and values used to produce the final file. However, the values displayed here come from the HRMS application in a raw format. These values are formatted according to the DADS-U norm at the file generation step.

Details

The Details tab displays data that helps you check the extracted data, even though all of the displayed data is not required in each row of the final file. The Details tab displays the following information:

• Company

• Establishment ID

• Employee ID

• Employee Record Number

• S41 Situation Begin Date

• S41 Situation End Date

Generating DADS Files

This section discusses how to generate DADS files

Page Used to Generate DADS files

Generating the Final DADS File

Once the content of the GPFR_AF_EXTRACT table is complete and correct, use the Create File FRA page to generate the final file.

Enter the following information on the run control page:

• Select an Extraction ID

• Select a test indicator, Test or Real.

• Select the DADS-U File field to produce the final DADS-U file.

• Indicate the path to the location of the generated file.

• Select the Descriptive Report checkbox to produce a PDF report with the generated DADS-U file.

  The content of this PDF document is the same as the generated DADS-U file, with additional record descriptions.

The flat file is generated by a SQR program, which contains all of the DADS-U norm formatting rules.