Sample Compensation Default and Override Formulas

You can test setting default values for worksheet columns in a workforce compensation plan using these sample formulas of type Compensation Default and Override. You can also use these sample formulas to create your own versions.

CMP_ELIGIBLE_SALARY_PRORATION_DAILY_AVERAGE

Calculates the eligible salary by averaging the daily salary. The formula accounts for number of days that a salary is in effect during the evaluation period of the workforce compensation cycle.

CMP_ELIGIBLE_SALARY_PRORATION_MONTH_END_AVERAGE

Calculates the eligible salary by averaging the salary on the last day of each month in the evaluation period of the workforce compensation cycle. The calculation uses the salary on the last day of the evaluation period for midmonth evaluation end dates.

CMP_ELIGIBLE_SALARY_PRORATION_DAILY_AVERAGE_NINETY_DAY_MIN

Calculates the eligible salary by averaging the daily salary. The formula accounts for the number of days that a salary is in effect during the evaluation period of the workforce compensation cycle. It returns 0 for people who worked fewer than 90 days.

CMP_ELIGIBLE_SALARY_PRORATION_DAILY_AVERAGE_USING_FTE

Calculates the eligible salary by averaging the daily salary adjusted for part-timers. The formula accounts for the number days that a salary is in effect and FTE during the evaluation period of the workforce compensation cycle.

CMP_ELIGIBLE_SALARY_PRORATION_DAILY_AVERAGE_FOR_JOBS

Calculates the eligible salary by averaging the salary for the number of days the person holds a specific job code on the assignment. The formula accounts for the number of days that a salary is in effect during the evaluation period of the workforce compensation cycle.