How to map Workday AD Template Division to Active Directory Company attribute?

[nandini29]

Hi, 

We have a Workday → ServiceNow → Active Directory provisioning process.

During provisioning, Workday sends an AD Template Division value to ServiceNow. We need ServiceNow to use this value to determine and populate the appropriate Company value in Active Directory.

We have a mapping in a spreadsheet where:

• Column A = AD Template Division value received from Workday

• Column B = corresponding Company value that should be populated in Active Directory

For example, if Workday sends a particular AD Template Division value, ServiceNow should identify the

corresponding value from Column B and populate it in the AD Company attribute.

Is this type of mapping possible in ServiceNow? If so, where we can fine this information in ServiceNow? 

below is the example of col A and col B

Workday Division Code	Active Directory Company Name
Alliance United CA	Auto
NSA	Auto
Corporate Services	Corporate Services
Home Service Companies	Life
Reliable	Life
Union National Life	Life
United	Life
Direct	Personal Insurance
Preferred	Personal Insurance
Services Group	Property and Casualty
UBI	Property and Casualty