If compensation bands are part of your compensation review process, they need to be set up in Lattice and have employees assigned individually or in bulk before creating a compensation cycle.
Bulk upload compensation bands
There are two locations in Lattice that allow admins to bulk upload compensation bands:
- Compensation Bands page
- Compensation Settings page
- Admin > Compensation > Compensation Bands.
- Select Create band > Upload from CSV.
OR
- Navigate to Admin > Compensation > Settings.
- Under Compensation bands, select Upload CSV.
- Download the Compensation bands CSV template and input the necessary data.
The following fields are included:
- Job level
- Job function
- Job type
- Currency
- Min, Mid, and Max base pay (salary)
- Mid, Mid, and Max variable pay
- Bonus target
- Award type (ISO, NSO, RSU, or RSA)
- Min, Mid, and Max Equity (new hire)
Note: Base salary ranges need to be broken out for each job function.
- Upload the CSV.
- Select Save.