How to Configure Data Mapper Table for Workday - Inbound in the Tenant Admin Portal

​

Introduction

This document provides instructions on how to configure a Data Mapper Table for Workday - Inbound in the Tenant Admin Portal.

​

Prerequisites

• Data Mapper Table for Workday - Inbound must be created.
• You must have access to the Tenant Admin Portal.

​

Steps to Configure Data Mapper Table for Workday Inbound

1. Log in to the Tenant Admin Portal.
2. On the home page of the portal, go to Agents > Data Tables. The Data Tables page is displayed.
3. Click preferred data table. The data table details page is displayed.
4. Do the Following:
   1. Configure Details Tab
   2. Setup Configure Tab After saving your changes, the Data Mapper Table for Workday – Inbound is configured successfully.

​

Configure Details Tab

This tab is used to view and edit basic information about the data mapper table. Do the following:

1. Update the Table Name (if required).
2. Enter Description (Optional).
3. Click Save. The details tab is configured successfully.

​

Setup Configure Tab

This tab is used to configure data field mappings between Workday and Oloid. Do one of the following:

• Inline OR
• Upload File The Configure tab is set up successfully.

​

Inline

In the Inline section, do the following:

1. Source / Expression: Enter the Workday field name or expression that provides the source value.
2. Destination – Oloid Field: Enter the Oloid field name to which the source value is mapped.
3. Data Type: Select the data type from the drop-down.
4. Click Add field to add more fields.
   Note: For mapping the table, refer Data mapper Table.
5. Click Save. The Inline section is configured successfully.

​

Upload File

In the Upload File section, do the following:

1. Select Upload File and upload the mapping file.
   Note: The file format must be in .XLSX or .CSV.
2. Click Save. The Upload File section is configured successfully. The Configure tab is set up successfully.

​

Additional Information

​

Data Mapping Table

Use the following fields to define data mappings when configuring the Data Mapper Table. Workday Use Field Oloid User Field Data Type { Schedule_Blocks.map(b => (([, r]) => (([s, e]) => ({ start: s.trim(), end: e.trim() }))(r.split(”–”)))(b.scheduleBlock.descriptor.split(” : ”))) } {UserMetadata.Shifts} JSON costCenter {UserMetadata.CostCenter } JSON employeeID PrimaryID String {worker.descriptor} Display Name String {worker.descriptor} FullName String email_Work Email String {activeStatus == true ? ‘Active’ : ‘Inactive’} {Status} String Schedule_Blocks {UserMetadata.WorkdaySchedule} JSON {worker.id} ExternalID1 String

Related Article

How to Create Data Mapper Table for Workday - Inbound in the Tenant Admin Portal