Overview of Loading Objects with HCM Data Loader

Use HCM Data Loader for bulk-loading and maintaining payroll data. You can navigate to the HCM Data Loader pages directly from the Payroll Checklist page. On the Checklist page, select the Initiate Data Loader task to open the HCM Data Loader object status page.

You can use HCM Data Loader to load these payroll objects.

  • Payroll Relationship

  • Object Groups

  • Payroll Consolidation Groups

  • Payroll Definitions and Time Periods

  • Time Definitions

  • Payroll Element Run Usage

  • User-Defined Tables

  • Wage Basis Rules

  • Payroll Elements

  • Element Entries

  • Balance Definitions

  • Organization Payment Method

  • Personal Payment Method

  • Payroll Costing

Payroll Transformation Formula for HCM Data Loader

Your existing data or the data that you upload might not be in the format recognized by HCM Data Loader. In such cases, use the Payroll Transformation formula for HCM Data Loader to transform your data into a format that's supported by HCM Data Loader.

Payroll Transformation Formula for HCM Spreadsheet Data Loader

You can use HCM Spreadsheet Data Loader to load all payroll objects that HCM Data Loader supports. As the first step, you create a spreadsheet template for the required object from the Data Exchange Work area and further download the template in CSV format. The Payroll Transformation Formula for HCM Spreadsheet Data Loader transforms the raw delimited file to a format that suits the template.