Import Compensation Market Data

Important: You can import a new market data file at any time, however, when you do so, it overwrites any data that was previously imported. If you want to import new market data without overwriting the previous data, you can create a data set using the same market data definition. For example, if you have a 2018 data set, you can create a set for 2019 rather than overwriting the existing data for 2018.

You can import the data supplied to you by your market data service provider in Market Pricing > Compensation Market Data. After importing market data, it can be added to compensation cycles in the Details tab of Compensation Setup > Compensation Cycles.

Currently, the maximum size of this file is 20MB which could accommodate 50 -70 thousand records depending on the number of columns and the length of the job descriptions. If the file size exceeds 20 MB, it’s recommended that you remove the data for jobs that don’t apply to your organization.

To import market data:

1. Go to Market Pricing > Compensation Market Data.
2. Click the name of the market data set that you want to import data for. The market data slide-out panel opens.
3. (Optional) In the Import drop-down list, click Create Column Reference to download a reference sheet that provides a description, as well as the expected format, for each column included in the market data definition.
4. In the Import drop-down list, click Create Import Template to download a template for the import.
5. In the template, enter the information supplied by your market data service provider, and then save the template as a CSV file on your computer.
6. Important: The columns included in this file must exactly match the columns in the template provided. Don't add or remove columns from the template. Further, each value that you enter must match the format defined for the associated column in the column reference sheet.
6. In the Import drop-down list, click Import File.
7. In the Import File wizard, enter a name for the import set in the field provided, and then click Next. This name will appear in the import history for the market data set.
8. Click Browse for file and select the file, or drag and drop the file into the file window.
9. Click Upload and view the imported data in the slide-out panel.

You can view the status of your import by clicking Import History in the Import drop-down list. Dayforce opens a dialog box in which you can view the status of your past imports. If any errors occurred, Dayforce displays a problems icon, a count of the number of errors, and an export icon for the import set in this list.

You can click the export icon to download a list of the errors that includes more detail. After you fix these errors, you can reimport the entire file using the Import File option.