Thank you for your feedback.
Form temporarily unavailable. Please try again or contact docfeedback@servicenow.com to submit your comments.
Versions
  • Madrid
  • London
  • Kingston
  • Jakarta
  • Istanbul
  • Helsinki
  • Geneva
  • Store
Close

Configure HR schema mappings for an HR management system

Log in to subscribe to topics and get notified when content changes.

Configure HR schema mappings for an HR management system

Create or modify the HR schema mappings to map the data fields from the third-party HR management system to the appropriate fields in the staging tables.

Before you begin

Role required: sn_hr_integrations.admin

Procedure

  1. Navigate to HR Integrations > HR Schema Mapping.
  2. Click New or open a record.
  3. Fill in the fields on the form.
    Table 1. HR Integrations Schema Mapping form
    Field Description
    Source Name of the third-party system.
    Source version Version of the third-party system, if applicable.
    Staging Table Name of the staging table that the data from the third-party system is pulled to.
    Staging table column Name of the column in the staging table that the data from the third-party system is pulled to.
    Service mapping Name of the HR service mapping.
    Type Value type of the column: XPath (variable), constant, or JSON.
    External Entity Column Key Value (XPath, constant, or JSON) to insert into the corresponding column of the HR staging table.
    • If the Type is set to XPath, then provide the XPath so that HR Service Delivery can parse the XML response, get the respective value, and insert it into the corresponding column in the HR staging table. For example, the preconfigured SuccessFactors integration uses XPaths for data being pulled into the HR Integrations Worker Profile [sn_hr_integrations_work_profile] staging table.
    • If the Type is set to Constant, then provide the text value so that HR Service Delivery can copy it into the corresponding column in the HR staging table.
    • If the Type is set to JSON, then provide the JSON path so that HR Service Delivery can extract the JSON response, get the respective value, and insert it into the corresponding column in the HR staging table. For example, the preconfigured SuccessFactors integration uses JSON for data being pulled into the HR Integrations Department Staging [sn_hr_integrations_dept_staging] table.
  4. Click Submit or Update to return to the HR Integrations Schema Mapping list.
  5. In the HR Integrations Schema Mapping list, locate the current record, double-click the Mandatory field, and select true or false.
    • If true, then the field value from the third-party system cannot be null. If the value is null, then the record it originates from is ignored and not placed into the staging table.
    • If false (default), then any field value from the third-party system is accepted.
Feedback