Triggering Events for Conditions of Dynamic Columns and Alerts

You specify when to evaluate the conditions of dynamic columns and alerts by selecting one or more of these triggering events:

Triggering Event	Description	Dynamic Column Example	Alerts Example
Start compensation cycle	When the Start Workforce Compensation Cycle process runs, it calculates the results for all dynamic column and alert conditions.	Calculate the eligible salaries that managers use during the cycle.	Let the worksheet managers know that an individual got a recent pay increase and isn't eligible.
Refresh data	When the Refresh Workforce Compensation Data process runs, it re-evaluates all dynamic conditions, fast formulas, and the HR data used in dynamic conditions. It also re-evaluates all alert conditions.	Re-evaluate people's eligibility for the workforce compensation plan and worksheet compensation components.	Let the worksheet manager know that performance management ratings were updated and target ranges were adjusted.
Change worksheet data	When managers enter or change the value and leave the field, the worksheet re-evaluates the condition and corresponding results. This trigger might slow worksheet performance. The more dynamic columns you use or the more conditions for the dynamic column, the longer the worksheet takes to respond. For example, you select this option on four dynamic columns, each with five conditions. When the manager tabs out of a worksheet field, the worksheet evaluates all 20 conditions, regardless of whether the column has dynamic column settings. Use it for only column results that depend on data that changes in the worksheet.	Calculate people's total compensation amount after managers make changes to current salary amounts.	Let the worksheet manager know that they're giving an individual more than the target and they need to provide a justification.

Triggering Event

Description

Dynamic Column Example

Alerts Example

Start compensation cycle

When the Start Workforce Compensation Cycle process runs, it calculates the results for all dynamic column and alert conditions.

Calculate the eligible salaries that managers use during the cycle.

Let the worksheet managers know that an individual got a recent pay increase and isn't eligible.

Refresh data

When the Refresh Workforce Compensation Data process runs, it re-evaluates all dynamic conditions, fast formulas, and the HR data used in dynamic conditions. It also re-evaluates all alert conditions.

Re-evaluate people's eligibility for the workforce compensation plan and worksheet compensation components.

Let the worksheet manager know that performance management ratings were updated and target ranges were adjusted.

Change worksheet data

When managers enter or change the value and leave the field, the worksheet re-evaluates the condition and corresponding results.

This trigger might slow worksheet performance. The more dynamic columns you use or the more conditions for the dynamic column, the longer the worksheet takes to respond. For example, you select this option on four dynamic columns, each with five conditions. When the manager tabs out of a worksheet field, the worksheet evaluates all 20 conditions, regardless of whether the column has dynamic column settings. Use it for only column results that depend on data that changes in the worksheet.

Calculate people's total compensation amount after managers make changes to current salary amounts.

Let the worksheet manager know that they're giving an individual more than the target and they need to provide a justification.