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
1. Admin > Compensation > Compensation Bands.
2. Select Create band > Upload from CSV.
OR
1. Navigate to Admin > Compensation > Settings.
2. Under Compensation bands, select Upload CSV.
3. 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.
4. Upload the CSV.
5. Select Save.