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
Load a UK Worker File with a TRU Defined for Assignment
For a new work relationship, you must only include the earliest assignment in a Worker file for one specific TRU.
Later, you can load multiple assignments in another file for the person for the same TRU. They must be associated with the existing Statutory Deductions card.
When loading an assignment in a Worker file for another TRU, if an active Statutory Deductions card already exists for that TRU, ensure the assignments are automatically associated with the Statutory Deductions card. Otherwise, they need to be associated with a card after the loading is completed.
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.