Lookup tables in Compensation Planning

September 18, 2026
Compensation Planning

Bonus multipliers by level and location, eligibility by country, targets by zone and job family. Lookup tables keep these complex mappings in one table, so every formula in the cycle pulls from the same source.

Visual

Bonus multipliers by level and location. Eligibility rules by country. Tiers by job family and level. Enterprise cycles depend on dozens of mappings like these, and they usually end up hardcoded into long nested formulas. When a value changes, someone has to track down every formula that uses it and rewrite each one by hand.

Lookup tables move those mappings into a table. Upload a CSV, choose the columns to match on, and reference the table from any formula in your cycle. Match on several columns at once, like level and location, and Pave returns the right value for each employee. Change a value in the table and every formula that uses it picks up the change.

Good for:

  • Bonus multipliers by level and location
  • Bonus eligibility by country or pay zone
  • Equity targets by job level and pay zone
  • Level-to-tier mappings shared across several columns

Find it in your cycle under Configuration > Data upload > Lookup tables.

Configure lookup tables

Book a demoAll product updates

See what’s new on your own comp data.

Real-time market data, an end-to-end comp platform and the Pave Agent, on your own numbers.

Book a demo