Configure cycle columns
The Columns page controls what data planners see in the worksheet, how it's displayed, who can see each column, and who can edit it. Planners work with these columns every day of a cycle, so it's worth setting them up carefully before launch.
Pre-configured and custom columns
You can add columns from Pave's library of pre-configured columns or create your own custom columns.
- Pre-configured columns have fixed data sources and settings. For example, Current Salary comes from your HRIS integration, band columns come from your compensation bands, and raise columns are either editable for planners or synced to recommendations.
- Custom columns let you choose what the column holds, where its data comes from, how it's displayed, and how planners interact with it.
The column picker groups pre-configured columns by topic:
| Group | Columns |
|---|---|
| Approval Chains | Status, Approval Chain, Current Planner |
| Demographic Data | Gender, Ethnicity |
| Job Data | Employee, Tenure, Performance, Employee ID, Manager Name, Department, Division, Family, Team, Metro, Location, Country, Job Code, Title, Level, Start Date, Paid Hourly? |
| Current Pay | Current Salary, Variable Pay, Current Bonus, Current Total Annual Cash, Current Total Annual Compensation, Last Salary Change, Last Compensation Adjustment Date |
| Pay Increase | Salary Raise, Variable Raise, Market Adjustment, On-target Earnings (OTE), New Annual Bonus, One Time Payment, Target One Time Payment |
| Promotion Data | Promotion, Reward Letter Job Title, Promotion Cash Raise, Equity Promotion Grant |
| New Pay | New Salary, New Variable, New Total Annual Cash, New Total Annual Compensation, New Total Annual Compensation With One Time Payment |
| Equity Data | Current Equity, New Equity Impact, Vesting Summary, Vested Percentage, Equity Refresher Grant, Equity Performance Grant |
| Band Data | Comp Band Min/Mid/Max Salary, Comp Band Min/Mid/Max Total Cash, Equity Band, New Hire Equity Band, Target Variable Pay Percent |
| Compensation Metrics | Pay Mix, New Pay Mix, Salary Impact, Total Cash Impact, Current/New Compa Ratio, Current/New Total Cash Compa Ratio, Current/New Range Penetration (Salary and Total Cash) |
| Reward Letter Data | Full Name, Current Hourly Pay Rate, Raise Base Percent, New Hourly Pay Rate, Total Equity Grant |
| Smart Flags | Smart Flags, Key Talent |
Note: The Tenure column shows the time between an employee's job start date (from your HRIS) and today, written as calendar time like "2 years, 8 months" or "First day."
Add a column
Add a pre-configured column
- On the Columns page, click New column.
- Under Column, pick a column from the grouped picker.
- Fill in the column settings.
- In the Permissions section, set which roles can see and edit the column. New columns are hidden for every role, including Admin, until you set access.
- Click Create.
Add a custom column
-
On the Columns page, click New column, then choose Create a Custom Column at the bottom of the picker.
-
Choose a data category and answer whether the column is a compensation award being decided in this cycle. Click Next.
-
Name the column. For award columns, choose how planners interact with it:
- Editable for planners: planners enter values, and you can add recommendation logic.
- Synced to recommendations: the column always shows the latest recommended value, and planners can't edit it.
-
Fill in the remaining column settings.
-
In the Permissions section, set which roles can see and edit the column. New columns are hidden for every role, including Admin, until you set access.
-
Click Create.
Choose a data category
Every custom column needs a data category, which tells Pave what the column holds. Pick the closest one. Most categories only help Pave understand your data, but a few change how the column works.
For cash, equity, and performance rating categories, Pave also asks Is this a compensation award being decided in this cycle?
- Answer Yes when planners decide the value in this cycle, like a retention bonus. Then pick what the award is for, like Merit or Refresh. This choice only labels the column.
- Answer No when the column is a reference value, like current salary.
| When a column is | What changes |
|---|---|
| A cash compensation award being decided in this cycle | Supports recommendation logic, with optional target prefill. Planners enter cash or percent, in cycle or local currency. Can be added to cash budgets, and hard and soft stops apply. |
| An equity compensation award being decided in this cycle | Supports recommendation logic, with optional target prefill. Planners enter shares or cash value. Can be added to equity budgets, and hard and soft stops apply. |
| Any Equity awards and data column | Can be locked in cycle currency with the Lock equity currency setting. Values only show to users whose equity permission covers the employee. |
| Employee performance ratings | Lets you define and rank rating values in a dropdown. |
| Not a compensation award being decided in this cycle | View-only for planners. Values come from a formula or integration. |
Column settings
Which settings you see depends on the column and its data category.
| Setting | Applies to | What it does |
|---|---|---|
| Name | All columns | The label planners see in the worksheet header |
| Description | All columns (optional) | Shown as a tooltip when planners hover over the header |
| Default column display | All columns | Visible, Pinned, or Hidden. Pin up to four columns per cycle. The Employee column is always pinned. This sets the default layout only, not access. |
| Data display type | Some columns | Checkbox, Currency, Date, Number, Percentage, Text, Time from Cycle Start, or Yes/No. The data category limits which are available. Can't be changed once an employee group filters on the column. |
| Dropdown values | Text columns | Answer Yes to define and order the values planners pick from |
| Performance values | Performance rating columns | Use a dropdown you define, or values from your performance integration |
| Shares or currency | Equity grant columns | Shared by every equity grant column in the cycle. See Equity settings. |
| Percentage raise base | Raise and cash award columns (optional) | The column percentages are calculated from. Defaults to current base pay. |
| Budget calculation | Custom formula columns | Connects the column to cash or equity budget tracking |
| Promotion options | Promotion columns | What a promotion is based on (Job Title; Job Title and Job Level; Job Family and Job Level; or Job Code), plus optional view-only columns from your bands |
| OTE options | OTE columns | Whether to include Market Adjustment and Promotion Cash Raise |
| New annual bonus | New annual bonus columns | Set the increase from current bonus, a new annual bonus value, or a percentage of base |
Add recommendations to award columns
Award columns show up on the Recommendations page as soon as you create them, listed under their type, like Equity raises. You don't need a separate column to display recommendations.
- Go to the Recommendations page and open the award column.
- Add your logic with a Handlebars formula. Custom columns use the advanced setup.
- Optional: turn on Prefill target recommendations to fill the column with the target value.
- Click Save.
Planners then see a recommended range or target above the input field.
Tip: If you used extra custom columns in past cycles just to display recommendations, remove them and add the logic to the award column itself. Your worksheet will have fewer columns to manage.
Column permissions
Note: The new column permission UI is rolling out now, and every company will be moved over before the end of 2026. If you have questions, reach out to your account team.
Each role has one setting on every column: Can edit, Can view, or Hidden.
To change column permissions, you need a role with edit access to the Cycle configuration permission in Compensation Planning.
How access is decided
- There are no defaults. A role with no setting on a column can't see it. New columns are hidden for every role, including Admin, and a new role can't see any columns until you give it access.
- Roles need product and cycle access. A role's column settings only count if it has Compensation Planning access, plus cycle access if the cycle restricts it. Roles missing either are listed under Roles without cycle access in the column's Permissions section. You can still set them, and their settings take effect once the role gets access.
- Roles combine. A user gets the most access given by any of their eligible roles. A Hidden setting on one role won't hide a column that another of their roles can view.
- The Employee column is always visible. Every role can view it, and its permissions can't be changed.
- Some columns are always view-only. Columns that get their values from your HRIS, a formula, bands, or a performance integration can't be set to Can edit, and neither can date, percentage, or time from cycle start columns. If you change a column so planners can no longer edit it, roles set to Can edit switch to Can view when you save.
- Equity and band data has a second layer. A user who can see an equity or band column only sees values for employees their equity or compensation bands permission covers.
Note: A hidden column still feeds any visible columns calculated from it, so planners may be able to work out its value.
Note: If you hide or remove the Promotion? column for a role, promotion-related columns become view-only for that role.
Change permissions for many columns
- On the Columns page, select the columns.
- Click Change column permissions.
- Pick the roles, or choose All roles, and pick the access level. Click Apply.
- Review the roles listed in the confirmation, then click Save. Changes save right away, with no separate page save.
If you choose Can edit and some of the selected columns can't be edited, the confirmation lists them and leaves them unchanged.
Change permissions for one column
- Open the column and go to Permissions. Roles are grouped into Roles with cycle access and Roles without cycle access.
- Change roles one at a time, or select several, click Set access, pick a level, and click Apply.
- Click Save.
To check what specific roles can see, select them in View columns by role on the Columns page. The list shows only the columns at least one of those roles can view or edit.
Permission changes can take a few minutes to show in planners' worksheets.
Reorder, edit, and delete columns
Change the column order
Planners see columns in the same left-to-right order as the table on the Columns page.
- Click Edit Column Order in the page header.
- Drag rows by their handles.
- Click Save. If you leave with unsaved changes, Pave asks you to confirm.
The Employee column always stays first.
Edit a column
Click the pencil icon on the column. To change a custom column's data category, click Edit on the column. In a finalized cycle, the column opens read-only with an eye icon instead.
If an employee group or smart flag filters on the column, an alert in the Permissions section lists them.
Delete a column
Click the trash icon and confirm. Deleting can't be undone, so you'd need to recreate the column from scratch.
Pave blocks the delete if the column is:
- A filter in a smart flag
- Used to calculate a budget
- Used in the cycle dashboard configuration
- A priority sort factor
- Referenced by active recommendation logic
- Referenced in another column's definition
Deleting one part of a compound column (Promotion, OTE, or New Annual Bonus) deletes every column in that group. The Employee column can't be deleted.
Equity settings
Equity grant columns follow your cycle's currency and equity settings, including Lock equity currency and whether new grants are entered in shares or cash value.
Shares or cash value applies to every equity grant column in the cycle at once. If you change it on one column while others exist, Pave asks you to confirm and then updates them all. Existing values aren't converted, so change this before planners enter values. The setting locks once the cycle is active or finalized and other equity grant columns exist.
Add categories to columns from a duplicated cycle
If you duplicate a cycle created before data categories, its custom columns copy over without a category. They're highlighted in red on the Columns page, and their settings stay locked until you add one. Pre-configured columns already have categories.
You only do this once. Cycles you duplicate later keep your categories.
- In the new cycle, click Configurations, then Columns.
- Open a red row with the expand icon and click Add category now.
- Pick a category and answer the award question. If you answer Yes, pick what the award is for.
- Click Add, then Save. The row is no longer red and its settings unlock.
A few things to know:
- Columns with a formula or synced to recommendations only show the categories that fit.
- You can launch before every column has a category, but those columns stay locked and miss the new features.
- While you're here, remove any custom columns you only used to display recommendations. See Add recommendations to award columns.
Your existing column permissions carry over to the new cycle, so you don't need to set them up again.
For a walkthrough, watch the Data Categories video on the setup tutorials page, also available under Setup Tutorials in your cycle configurations.
Audit log and cycle status
Audit log
Click View Audit Log in the page header to see every column change in the cycle and who made it. The button is hidden while you're viewing columns by role.
Editing during an active or finalized cycle
- Active cycle: you can still edit columns. A banner warns that changes may disrupt planners who are working.
- Finalized cycle: columns are locked and open read-only. Columns set to Can edit become view-only for planners. Your original permissions are kept and come back if you unfinalize the cycle.
Troubleshooting
| Issue | What to check |
|---|---|
| A user can't see a new column | New columns are hidden for every role, including Admin. Give their role access in the column's Permissions section. |
| Can edit isn't available for a column | The column gets its values from your HRIS, a formula, bands, or a performance integration, or its display type can't be edited by planners. Use Can view instead. |
| A role is set to Can view or Can edit, but the user still can't see the column | The role is missing Compensation Planning access or cycle access. Check Roles without cycle access in the column's Permissions section. |
| A user sees a column that's hidden for their role | Another of their roles can view it. Check every role on the user. |
| A column shows, but some values are blank | The user's equity or compensation bands permission doesn't cover those employees. |
| A column is red and its settings are locked | It came from a cycle created before data categories. Add a category to unlock it. |
| A category you want isn't listed | Columns with a formula or synced to recommendations only show the categories that fit. |
| You can't change a column's display type | An employee group filters on the column. Remove it from the group's filters first. |
| You can't delete a column | Something else uses it, like a budget, smart flag, or recommendation logic. The alert lists what to remove first. |
