This chapter discusses how to:
Extract DADS data.
View and update extracted DADS data.
Generate DADS files.
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.
Page Name |
Definition Name |
Navigation |
Usage |
GPFR_AF_EXTR_DEFN |
Global Payroll & Absence Mgmt, Absence & Payroll Processing, Define Calendars, Define Extraction Data FRA |
Define an Extraction ID |
|
GPFR_AF_EXTR_PRM |
Global Payroll & Absence Mgmt, Absence & Payroll Processing, Define Calendars, Define Extraction Data FRA, Parameters |
Enter a sending reference and the frequency code for the extraction data. |
|
GPFR_AF_EXTR_RUN |
Global Payroll & Absence Mgmt, Social Security / Insurance, Run Extraction FRA |
Run the DADS extraction process. |
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.
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,
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.
Extraction ID |
Select an Extraction ID to determine which nodes are displayed. |
Degub Mode |
Select to generate a log file with the extraction run. |
Group List ID |
Use this option when you generate test files, or corrective files. |
This section provides an overview of extracting DADS data and discusses how to:
Select structures to view.
Apply additional filters.
Update 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.
Page Name |
Definition Name |
Navigation |
Usage |
GPFR_DA_RUNCNTL |
Global Payroll & Absence Mgmt, Social Security / Insurance, Update Extraction Data FRA, Node/Attr Filter |
Select the structures and records you want to view. |
|
GPFR_AF_UPDT_2 |
Global Payroll & Absence Mgmt, Social Security / Insurance, Update Extraction Data FRA, Other Filters |
Select other filters that are displayed based on the structures and records previously selected. |
|
GPFR_AF_UPDT_FINAL |
Global Payroll & Absence Mgmt, Social Security / Insurance, Update Extraction Data FRA, Update Data |
Displays the results related to the filters selected on the Node/Attr Filter and the Other Filters pages. |
Access the Node/Attr Filter page (Global Payroll & Absence Mgmt, Social Security / Insurance, Update Extraction Data FRA, Node/Attr Filter).
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.
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.
Check Done |
Select to indicate that the data has been checked. The Check Done field is automatically deselected if you re-run the process on the same data. |
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
This section discusses how to generate DADS files
Page Name |
Definition Name |
Navigation |
Usage |
GPFR_AF_RUNFILE |
Global Payroll & Absence Mgmt > Social Security / Insurance > Create File FRA |
Generate 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.