Thank you for your feedback.
Form temporarily unavailable. Please try again or contact docfeedback@servicenow.com to submit your comments.

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.
    Service mapping Name of the HR service mapping.
    Mandatory Check box to enable a mandatory field value.
    • If selected, the value from the third-party system cannot be null. If the record is null, then the record it originates from is ignored and not placed into the staging table.
    • If cleared, then any field value from the third-party system is accepted.
    Use script Check box to enable use of source scripts. If selected, provide the source script to use in the Source script field.
    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.
    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.
Feedback