Extracting DUCS Data Using Application Framework

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

Page Name

Definition Name

Usage

Define Extraction Data Page

GPFR_AF_EXTR_DEFN

Define an Extraction ID.

Parameters Page

GPFR_AF_EXTR_PRM

Enter a sending reference and the frequency code for the extraction data.

Run Extraction FRA Page

GPFR_AF_EXTR_RUN

Run the DUCS extraction process.

Use the Define Extraction Data page (GPFR_AF_EXTR_DEFN) to .

Navigation:

Global Payroll & Absence Mgmt > Absence & Payroll Processing > Define Calendars > Define Extraction Data FRA

This example illustrates the fields and controls on the Define Extraction Data page. You can find definitions for the fields and controls later on this page.

 Define Extraction Data page

Field or Control

Description

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.

Use the Parameters page (GPFR_AF_EXTR_PRM) to enter a sending reference and the frequency code for the extraction data.

Navigation:

Global Payroll & Absence Mgmt > Absence & Payroll Processing > Define Calendars > Define Extraction Data FRA > Parameters

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

 Parameters page

Use the Run Extraction FRA page (GPFR_AF_EXTR_RUN) to run the DUCS extraction process.

Navigation:

Global Payroll & Absence Mgmt > Social Security / Insurance > Run Extraction FRA

This example illustrates the fields and controls on the Run Extraction FRA page (1 of 2). You can find definitions for the fields and controls later on this page.

 Run Extraction FRA page (1 of 2)

This example illustrates the fields and controls on the Run Extraction FRA page (2 of 2). You can find definitions for the fields and controls later on this page.

 Run Extraction FRA page (2 of 2)

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

Field or Control

Description

Extraction ID

Select an Extraction ID to determine which nodes are displayed.

Debug 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.