HR Transform Maps

Use to move pulled (inbound) data from the staging tables to the ServiceNow core tables.

About this task

Each HR service created in HR Integration Service has a corresponding transform map job. These jobs determine the source staging table, the target core table, the field-to-field mapping, and a script that defines the process.

Procedure

  1. Navigate to HR Integrations > HR Transform Maps.
  2. Click New or an existing record.
    Field Description
    Name Enter a user-friendly label for identifying the transform map.
    Source table Select the import table containing the raw import set data. An import table is any table that extends the Import Set Row [sys_import_set_row] table. You can select only tables within the currently selected application scope.
    Active Select this check box to make the transform map available for use.
    Run Business Rules Select this check box to run business rules, workflows, approval engines, auditing, and field normalization while the transformation inserts or updates data into the target table. Clearing this check box runs GlideRecord.setWorkflow() with a value of false.
    Enforce Mandatory Fields Choose whether to enforce mandatory fields on the target table.
    Copy Empty Fields Select this check box to clear fields with existing values when an incoming field contains an empty value. See Using NULL as a Field Value for information on how to import empty values.
    Created Shows the transform map creation date. This field is automatically populated.
    Target table Select the table where you want transformed data to be placed. You can select only tables within the currently selected application scope, the global scope, or tables that grant write access to other applications
    Order Enter the order in which to apply transform maps in the event that more than one map fits the conditions. ServiceNow runs transform maps from lowest to highest Order.
    Run Script Select this check box to display the Script field.
    Script Enter the transform map script you want to use to transform field values in the source table to the target table. ServiceNow runs the transform map script in addition to any Field Maps.
    Field Maps Use this related list to add one or more field maps. ServiceNow runs the transform Field Maps in addition to any transform script.
    Transform scripts Use this related list to add one or more transform map scripts. A transform script allows you to apply extra business logic at a specified stage of the transformation.
  3. Click Save. The Field Maps and Transform Scripts tabs display.
  4. Click Update.