Installing the Workday Reports app
This section covers setting up the Workday Reports integration app, which allows you to sync your employee roster to ChartHop.
Your ChartHop payroll app syncs your employee data from your payroll system and builds your org chart in ChartHop. Once your Org Chart is created, you can start using ChartHop.
ChartHop recommends reviewing the data in your payroll system to ensure it is what you expect before you sync it to ChartHop. For example, if an employee has multiple system IDs in your payroll system, that employee’s data won’t sync properly. You should also be sure that your payroll system reflects an accurate view of your organization, including reporting structures, employee locations, and compensation.
Create or identify the report that contains the information you want to sync to ChartHop. For details on the structure of this report, see Setting up your Workday Report.
Once the report is ready, obtain its link:
- Enable the Webservice URL for the report
- Copy the corresponding URL for the JSON format
After you obtain your Workday instance URL and name, you need to create an Integration System User and enable specific permissions. This will allow ChartHop to read the contents of your report.
To create a Workday Integration System User:
- Login to Workday, and create an Integration System User (ISU).
- Ensure that the user has read access all fields contained in the report. If the report contains calculated / compound fields, make sure the ISU also has access to the upstream fields used in the calculations.
After you have your report URL and have created your Integration System User, you can install the Workday Reports app in ChartHop.
- Navigate to Apps from the settings (gear) menu in the left sidebar.
- Select the All Apps tab.
- Scroll to your payroll app and select Install on the far right of the respective app's row.
When you select Install, you'll be prompted to walk through configuring the payroll app.
- Enter your Workday Reports URL
- Enter your Instance System User name and password in the provided fields.
Data sync settings control how and what data is synced to ChartHop from your payroll system. For example, you can choose whether or not to create a backfill position in ChartHop when you have a departure in your payroll system. Other advanced settings allow you to exclude certain employees.
- Select one of the two options:
- Automatically create backfills - This option creates a backfill position in ChartHop (open job) when an employee is marked as departed in your payroll system.
- Sync departures only - This option removes the departed employee from ChartHop. The employee's job history remains in ChartHop.
Advanced settings allow you to better control how your payroll data syncs to ChartHop.
ChartHop recommends accepting the default values for these settings. Please get in touch with ChartHop Support or your Customer Success Manager for assistance if needed.
- Expand the Advanced settings section.
- Use the following table to guide you through advanced settings decisions.
- When finished, select Next step.
Setting | Description |
Missing location information
| Select one of the two options for what should happen if location information is set for an employee.
|
Advanced sync options | Select the data changes you want to include in your sync. You can include some or all of the following employee data:
|
Overwrite person fields
| ChartHop recommends using this setting to avoid needing to update both ChartHop and your payroll system when a change is made to any field value that is synced from your payroll system. When you choose this option, your payroll system remains the source of truth for the following fields in ChartHop: birthdate, gender, home address, and so on. Any edits you or an employee make to this data in ChartHop are overwritten during synchronization. This can pose an issue when someone uses ChartHop to update employee fields in ChartHop, without requesting an update in the source system. |
Exclude IDs | To exclude specific individuals from the sync, enter their unique payroll system IDs here, separated by commas. |
When you first configure your payroll app, you should run a one-time sync to verify that the sync is operating as you expect it to and that your data is what you expect.
To run a one-time sync:
- In the setup wizard, select the Run one-time sync option.
- Select Finish setup.
After running your first sync, you can use the Data Sheet and Org Chart pages to spot-check your data. You can use the Sync History page to verify when the sync was run and if it encountered any issues.
You should spot-check your ChartHop org for the following:
- Correct management reporting lines
- Compensation data
- Employee information on profiles (names, addresses, and so on)
- Job titles
- Departments
- Locations
Remember that most issues with your synced data originate in your payroll system. ChartHop allows you to visualize your employee data to make finding these discrepancies easier. Still, you’ll need to fix any data discrepancies in your payroll system and rerun the sync to view the fixes in ChartHop.
After you’ve synced your data for the first time and verified your Org Chart, you should configure a daily sync. The value of syncing your payroll data to ChartHop is that it ensures that your employee data is always up to date.
- Navigate to Apps from the settings (gear) menu on the left side.
- Select the My Apps and Bundles tab.
- Scroll to your payroll app and select the gear (settings) icon on the far right of the row to view app settings.
- Within the App status & sync settings section, select the Edit (pencil) icon.
- Toggle the auto-sync option to on.
- Select Save.
