Update User in Users Table activity

The Update User in Users Table activity uses the employee information returned from Workday to update an existing user record in the ServiceNow sys_user table.

When the ServiceNow instance receives a notification from Workday that a new employee has been hired, Orchestration runs a workflow called Employee On/Off Boarding to retrieve additional information about the new employee. This workflow runs an activity called Check User Exists that determines if the ServiceNow sys_user table already has a record for this employee. If a record exists, the Update User in Users Table activity updates the record, if necessary.

Input variables

Table 1. Update User in Users Table input variables
Variable Description
first_name First name of the new Workday employee.
last_name Last name of the new Workday employee.
employee_number Employee ID in the ServiceNow sys_user table.
user_name User name in the appropriate format, such as jacinto.gawron.
email Email address of the new Workday employee.

Output variables

Table 2. Update User in Users Table output variables
Variable Description
sys_id Unique reference ID of the sys_user record in the ServiceNow instance.

Conditions

Table 3. Update User in Users Table conditions
Condition Description
Success Activity updated the ServiceNow sys_user table.
Failure Activity failed to update the ServiceNow sys_user table.