HR Integration Service

HR Integration Services defines what information you want to pull from a third-party HR application and the staging tables to place the information.

About this task

Staging tables ensure that the correct information is pulled before moving to the HRSM core tables.
Note: The base system provides the HR information, staging tables, and order for integration with Workday. Only edit when pulling additional information not provided.
By default, the following information is pulled:
  • Departments
  • Locations
  • Job Profiles
  • Worker Profiles
  • Effective Worker Profiles
  • Future Worker Profiles


  1. Navigate to HR Integrations > HR Integration Service.
  2. Click New or an existing record.
    Field Description
    Name The name of the HR data to be pulled from the third-party HR application.
    Staging Table The staging table pulled information is written to. Staging tables ensure that correct data is pulled.
    Note: All staging tables extend the HR Integrations Staging [sn_hr_integrations_staging] table.
    Active Indicates that the integration service is available to use.
    Order The order in which data is pulled. Some tables are dependent upon others, so the order dependency must be accurate.

    For example, the Worker Profiles table depends on Job Profiles. Job Profiles is required to be pulled before Worker Profiles.

  3. Click Submit or Update.