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 transform maps for an HR management system

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

Configure HR transform maps for an HR management system

Create or modify the HR transform maps to map the staging tables to the appropriate target tables.

Before you begin

Role required: sn_hr_integrations.admin

Procedure

  1. Navigate to HR Integrations > HR Transform Maps.
  2. Click New or open a record.
  3. Fill in the fields on the form.
    Table 1. Table Transform Map form
    Field Description
    Name Name of the HR transform map.
    Source table Name of the staging table.
    Active Check box to activate the transform map for use.
    Run business rules Check box to enable business rules to run.
    Enforce mandatory fields Enforcement type for the fields: no mandatory fields, only mapped fields, or all fields.
    Copy empty fields Check box to enable copying of empty fields.
    Application This field is automatically set to Human Resources: Integrations.
    Created This field is automatically set to the date of creation.
    Target table Name of the target table.
    Order Order number for when transform maps are applied. Lower numbered transform maps are applied before higher numbered transform maps.
    Run script Check box to enable scripts to run. If selected, provide the script to run in the Script field.
  4. Right-click the form header and click Save.
  5. In the Field Maps related list, create one or more field mappings to map fields from the staging table to the appropriate fields in the target table.
    1. Click New or open a record.
    2. Fill in the fields on the form.
      Table 2. Field Map form
      Field Description
      Map Name of the HR transform map.
      Source table Name of the HR staging table.
      Source field Name of the field in the HR staging table.
      Use source script Check box to enable use of source scripts.
      Application This field is automatically set to Human Resources: Integrations.
      Target table Name of the HR target table.
      Target field Name of the field in the HR target table.
      Coalesce Check box to enable coalesces.
    3. Right-click the form header and click Save.
  6. In the Transform Scripts related list, create one or more transform scripts.
    1. Click New or open a record.
    2. Fill in the fields on the form.
      Table 3. Transform Script form
      Field Description
      When When the transform script is run: onAfter, onBefore, onChoiceCreate, onComplete, onForeignInsert, onReject, onStart.
      Application This field is automatically set to Human Resources: Integrations.
      Active Check box to activate the transform script for use.
      Order Order number for when transform scripts are applied. Lower numbered transform scripts are applied before higher numbered transform scripts.
      Script Function of the transform script.
    3. Click Submit or Update.
Feedback