Technical Articles
Syncing your Onboarding Corporate Structure & Integrating with Position Management Part 3
Today, Position Management integrates to Recruiting Management through Requisitions however only field values captured on the Requisition can be mapped to Onboarding. Wouldn’t it be nice if all we needed to map from REC to ONB was the Position ID and all other field values would default? This includes values on the requisition and values not on the requisition but on the Position MDF. Like in my previous blogs, Syncing your Onboarding Corporate Structure & Syncing your Onboarding Corporate Structure Relationships, using the integration center makes this is possible.
For example, you send Name, Position ID, and Email from Recruiting.Based on the Position ID, the position attributes are auto populated.
The below example will walk you through the steps for syncing positions and position attributes to Onboarding.
Adding a New Corporate Structure Level and Level Properties
1. Go to Admin Center > Employee Files > Manage Position. Take note of all of the fields you want to sync.2. In ONB Super Admin, go to Corporate Structure and click Add Level under Tasks.
Add a level for Position3. Once the new level is created, click Level Properties under the See Also menu header on the left side.
4. Add a new property for each of the Position fields you want to sync.
**Make sure to check the checkbox next to Map to Key and enter a key. If you receive a message saying the key doesn’t exist in onboarding and asking if you want to continue and create the key, click OK. **
Creating the Integration Center Reports
1. Go to Admin Tools > Company Settings > Integration Center and select click My Integrations
2. Click the Create button and then select Scheduled Flat File Output Integration
3. Search for “Position” and select Position
4. Select Position Code (code) and Position Title (externalName_defaultValue)6. Uncheck Start Date
7. Select all of the position fields you are syncing to Onboarding
8. Click Select
9. Enter Integration Details
Integration Name: Onboarding Position Export
Output File Type: csv
Header Type: Simple
10. Click Next
11. Click Position Code and change the label to ClientID
12. Click Position Title and change the label to Name
13. Click Position Code and select Insert Field > Insert Fixed Value Field (You can create a calculated field to calculate count but for demo purposes, we will use a fixed value field)
Default Value: 5

14. Click OK

15. Repeat steps to create OrgLevel
16. Click OK

Your report should now look like this:

18. Expand the Advanced Filters section and click Browse
19. Search and select ‘Status (effectiveStatus) in Position’
20. Click Change Association to “Status”

21. Enter A in the Value field to only include Active Positions

22. Click Next
23. Enter Destination Settings
File Folder: /ONB/Inbound

Modify the Import Files
Location Import File
**Like in my previous 2 blogs, I am using the location import file to sync all levels of my corporate structure. It is very important that all of the field names match exactly or the sync will fail.**
1. In Super Admin, Go to Integration > Import/Export Settings
2. Under the Integration section, export the ImportLocation file.
3. Save a backup of the file
4. Update the xslt file to the following code and make sure to use the onboarding keys for the field names.
**The code below includes syncing Location and Position. You can add or remove levels from the ‘Otherwise’ section depending on how many levels you’re syncing. **5. Save as a new file
6. Return to Import/Export Settings in Super Admin and import the new location import file
Foundation Import File
1. In Super Admin, Go to Integration > Import/Export Settings
2. Under the Integration section, export the FoundationImport file.
3. Save a backup of the file
4. Update the location fields and add the section for position.
**Make sure to use the Onboarding keys for the field names. **
5. Save as a new file
6. Return to Import/Export Settings in Super Admin and import the new foundation import file
Foundation Import Field Mapping File
1. In Super Admin, Go to Integration > Import/Export Settings
2. Under the Integration section, export the FoundationImportFieldMapping file.
3. Save a backup of the file
4. Modify the fields under Location and add the Position section (The key is the Onboarding key and the value is the header from the sync file)
5. Save as a new file
6. Return to Import/Export Settings in Super Admin and import the new foundation import field mapping file
Run the Integration Center Reports
1. In Provisioning, go to Manage Scheduled Jobs
2. Find your Position Sync Report and select Run Now from the Actions drop down
Check Import Status in Onboarding Audit Report
1. Once your report has been picked up from the ftp site, the file should no longer be listed in the inbound folder.
2. Other than checking your corporate structure, you can determine the status of the import by going to Onboarding > Settings > Audit Report
3. Select the blank option from the Type dropdown, enter INTEGRATION in the Event Code textbox and click filter
4. Find the import file and see if it is complete
Once your report runs successfully and is processed by Onboarding, your corporate structure will be available in Onboarding.
By syncing position to Onboarding, it reduces the number of fields you have to sync from recruiting, the number of fields you have to update manually, and the time spent on manually maintaining your corporate structure.
Hi Kayla,
Thanks for the article .This is very help full . can you please put some light on the panel design . How to configure the fields on panel so that based on the Position ID, the position attributes are auto populated. I have added the field with the type of corporate structure list , for all the position attributes (with same keys defined in super admin), but when i enter the position id it is not auto populating the attributes automatically.
Thanks in advance.
Hi,
Make sure the key on the panel matches what is in super admin and I would put position ID on a different panel. I have it setup so you select the position on the first panel and then when you go to the next panel, all of the attributes are populated.
Many thanks Kayla for sharing your knowledge, this is indeed very helpful
hi Kayla,
Its a very nice document. what my question is i have followed all your steps position data is now there in reference files corporate structure but the data is not Auto-populating on panels for feilds related to position. Please can you elaborate more on the same.
Thanks
Manish
Hi Manish Angane
To have the fields auto-populate, make sure to have the position field on a panel prior to the fields that need to auto populate. If you've already done that, make sure the keys match on the panel and position corporate structure.
Hope this helps!
Thanks, this is very helpful.
Regarding properties , say if for company country and EIN has to be synced and they are added in integration center, could you please provide details on the code structure. the following code used