Connecting bands to jobs

After you create compensation bands, you can assign each job in your organization to a band by uploading a spreadsheet that maps your existing employees to the band to which they belong. This method allows you to map all of your jobs to bands at the same time.

Alternatively, you can associate an individual job with a band by selecting Edit Job, selecting the Compensation tab, and selecting a band from the dropdown list.

Create a job-band mapping spreadsheet

You'll need a list of the work emails associated with each job you want to map, as well as which band applies to each job. You can also map to a job ID instead of a work email if you want to add a band to an unfilled job.

To create your spreadsheet:

1. Create a spreadsheet (.csv or .xlsx) that includes the following two columns:
   • An identifier column (for example, work email or job ID)
   • A column named compBand
2. Add a row for each job you want to connect to a band and add values for both the job (work email or job ID) and the compBand.

Upload your spreadsheet

After you've created a spreadsheet to help you map your jobs to the bands you created, upload the spreadsheet to ChartHop to complete the mapping. You can make any individual changes by editing the respective job.

1. From the left sidebar, select More and select Compensation bands.
2. Click Edit in the top right corner.
3. In the Map your jobs to your band levels section, select Upload mapping.
4. Select Save Settings.

Verify that your bands are mapped

You can use the Data Sheet to verify that you've mapped your bands to their respective jobs.

To verify bands are mapped:

1. From the left sidebar, select Data Sheet.
2. Select Select columns.
3. In the Select columns dialog, select the checkbox for the Comp Band field.
4. Select Apply. This displays compensation bands on the Data Sheet as a column.
5. Review the rows to view band information for employees and open jobs.