Importing Workforce Data

You can download Workforce data import templates from within the application. The templates are generated based on the features you’ve enabled and the custom dimensions that you added when you enabled features. See Importing Data.

Note:

If you want to load only changed and new Workforce data since the last load, you can improve load performance using Data Management. See Loading and Calculating Incremental Workforce Data.

Note:

As of the February, 2020 Release, Workforce supports a new Start Date property. The data import templates include headers and examples for loading data such as Hire Date to OWP_Start Date rather than to OWP_Start Month. You can still load data to Start Month, and the Process Loaded Data rules convert the data to Start Date using the first of the month provided in the Start Month account. So, existing data integrations based on Start Month data continue to work. You'll get more accurate calculations, however, if you load data into Start Date.

The templates reflect the CurYr that you set in the Planning and Forecast Preparation configuration task. After importing your data and refreshing the cube, run the rule Process Loaded Data to copy the data to the necessary periods in the planning year range.

The prefix of each template name depends on the application's granularity:

  • EJ_ precedes template names for Employee and Job applications. For example: EJ_EmployeePropertiesDataLoad_Plan.csv.
  • EO_ precedes template names for Employee-only applications. For example: EO_EmployeePropertiesDataLoad_Plan.csv.
  • JO_ precedes template names for Job-only applications. For example: JO_JobOtherCompensationDataLoad_Plan.csv.

Importing Employee Properties

Use these templates to import properties for existing employees:

  • EmployeePropertiesDataLoad_Plan.csv—Import plan properties for employees. (You don't need to load Headcount and Partial Payment Factor unless you want to explicitly set these values. If you don't load Headcount and Partial Payment values, they're set to 1 and 100% respectively for every employee.)

    Note:

    For the EJ_EmployeePropertiesDataLoad_Plan.csv template, don't load to No Union Code or to OWP_All Union Code. Instead add and use new child metadata member of Total Union Code. Otherwise, the synchronize rules may not work properly.

  • EmployeePropertiesDataLoad_Actuals.csv—Import actual properties for employees.

Importing Employee Compensation

Use EmployeeSalaryDataLoad_Plan.csv to import data used to calculate salary.

Importing Actual Employee Compensation

Use EmployeeCompensationDataLoad_Actuals.csv to import actual compensation data for employees.

To use this template, set these Data Load Settings:

  1. From the Home page, click Navigator Navigator icon, and then under Integration, click Data Load Settings.

  2. Set these parameters for importing data:

    • Data Load Dimension: Account
    • Driver Dimension: Period. Member: BegBalance,ILvl0Descendants(YearTotal)
    • Data Load Dimension Parent:
      • OWP_Total Earnings. Driver Dimension Unique Identifier: BegBalance
      • OWP_Total Benefits. Driver Dimension Unique Identifier: BegBalance
      • OWP_Total Taxes. Driver Dimension Unique Identifier: BegBalance

Importing Employee Other Compensation Data

Use EmployeeOtherCompensationDataLoad_Plan.csv to import other compensation data—benefits, taxes, and additional earnings—for employees.

OWP_Value is an optional field. If you include the rate value in the template, that rate is copied to the planning year range for the specified employee.

Importing Salary Grades

Use Salary Grade-Basis.csv and Salary Grade-Value.csv to import salary grades into Assumptions.

Importing Properties and Rates for Additional Earnings, Benefits, and Taxes

Use these templates as examples when importing properties and rates for additional earnings, benefits, and taxes into the Benefits and Taxes Wizard.

  • Earnings,Benefits and Taxes-Properties.csv—Import properties for additional earnings, benefits, and taxes.
  • Earnings,Benefits and Taxes-Rates.csv—Import rates for additional earnings, benefits, and taxes.

Importing Job Properties

Use JobPropertiesDataLoad_Plan.csv to import job properties.

Importing Job Salaries

Use JobSalaryDataLoad_Plan.csv to import salaries for jobs.

Importing Job Other Compensation Data

Use JobOtherCompensationDataLoad_Plan.csv to import other compensation data for jobs: benefits, taxes, and additional earnings.