Onboarding-Employee Central Personal Information Field Mapping

Introduction

I was recently involved with an implementation that involved integration between Onboarding and Employee Central. While most fields are easy to map using the field-mapping tool for Onboarding EC integration, there were fields from the Personal Information Portlet that required additional configuration for the integration to be successful. In this post I will outline the steps necessary to integrate personal information fields, such as gender and marital status, between Onboarding and Employee Central.

Overview

Unlike most fields mapped from Onboarding to Employee Central, some fields in the Personal Information Portlet cannot be mapped using a picklist in the panel and a picklist in the data dictionary. If you are not able to map a field using standard picklist integration, you can choose to integrate the fields using one of the following methods:

1. Using a dropdown in the panel and a picklist in the data dictionary
2. Using a dropdown in the panel and look up in the data dictionary

Using a dropdown in the panel and a picklist in the data dictionary

The first option you have is to use a dropdown in the panel configuration and reference a picklist in the data dictionary. The first step in doing this is creating a drop down for the field in your panel configuration. As seen below, you can create a dropdown in the panel or reference an existing list. It is important to keep in mind that the code in the data list must be mapped to the external code in your picklist file.

After you have created the drop down in your panel, it is time to complete the configuration in the Data Dictionary. To do this, navigate to Data Dictionary and select the field you created in the panel (in my example MaritalStatus). Once you have done that, map the field to the HCM picklist being used in Employee Central. Make sure you select the following: Type: SF HCM Picklist, Integration Type: Code Based, SFHCM Picklist: *match to your EC picklist*.

Now that you have completed the configuration you are ready to map the fields using the Onboarding EC field mapping tool.

Using a dropdown in the panel and look up in the data dictionary

The second option you have is to use a dropdown in the panel and look up in the Data Dictionary. Similar to the previous process, you will begin by creating your dropdown in the in the panel.

Once you have completed this step you are ready to complete the configuration in the Data Dictionary. To do this, navigate to Data Dictionary and select the field you created in the panel. Once you have done that, select the following: Type: Lookup, Lookup Name: match to field from rcm2kmslookup mapping file, Lookup Key: Code

Now that you have completed the configuration you are ready to map the fields using the Onboarding EC field mapping tool.

After completing one of the above processes, your personal information fields should flow directly into the EC Personal Information Portlet without error.