Overview of HCM Data Loader Extracts

HCM Extracts provides four extracts for HCM Data Loader, as shown in this table.

Extract Name

Description

HCM Data Loader Data Set Summary

Provides status values and record counts for both a specified data set and each business object in the data set. It reports all error messages and identifies all records affected by each error.

Compensation Changes Extract

For a specified compensation run, extracts assignment, salary, and bonus changes made by the run. This extract is most useful if you're implementing a coexistence scenario.

Integration Object User Key Refresh

Retrieves latest user key values. Run this extract before running the Integration Object User Key Map Extract.

Integration Object User Key Map Extract

Extracts GUIDs, source keys, surrogate IDs, and user keys for a specified business object hierarchy.

The output from all extracts is in XML format by default. You can provide a BI Publisher layout to reformat the output. You can also define options to automate delivery of the output.

Before users can run any of these extracts, you:

  1. Copy the predefined extract, specify a delivery option, and compile the formulas for your copy of the extract.

  2. Configure your copy of the extract.

Once the extract is configured, users can run it and view the output.

To learn how to create a HCM Extract delivery option to format your output into a HDL file and define a payroll flow pattern to initiate the extract and submit HDL, see the tutorial: Initiate HCM Data Loader for HCM Extract Generated Files