Average Earnings Reported Amount
The Average Earnings Provision Reported Amount screen defines the rules for applying Reported Amounts to earnings periods.
Source and combination
- Reported Amount Name: Selects the Reported Amount to apply for the Average Earnings Provision.
- Override values with Formula Derived Item: Replaces applicable Reported Amount values with the calculation value from a selected Formula Derived Item. You can apply the override to all amounts, only actual amounts, or only projected amounts.
The Reported Amount must exist for the period before the override is applied. - Combination Type: Defines how each Reported Amount is applied to each earnings period.
- Add to Amount: Adds each amount to the period amount. This is the default option.
- Subtract from Amount: Subtracts each amount from the period amount.
- Add to Minimum: Adds each amount to the period's minimum amount, if applicable.
- Subtract from Minimum: Subtracts each amount from the period's minimum amount, if applicable.
- Add latest on period start: Applies the latest amount on each earnings period's start date.
This is generally used for rate-of-pay plans that use the latest reported rate of pay for each earnings period. - Override Period Amount: Overrides all other Reported Amounts in a period when a value for this source exists during that period.
- Add latest on period end: Applies the latest amount on each earnings period's end date.
- Multiply by: Adjusts Reported Amounts before they are applied to earnings periods. This is rarely used.
- Amount Range: Specifies minimum and maximum values that apply before this Reported Amount is applied to different periods.
Use these ranges only when the minimum or maximum applies to this Reported Amount alone; otherwise use the earnings limits within the provision so the ranges apply to the sum of all amounts.
Allocation to earnings units
- Allocation to Multiple Periods: Determines how amounts are assigned when they can apply to more than one earnings period.
- Prorate: Prorates amounts that span multiple earnings periods.
When Reported Amounts are reported at the same rate and dates as the earnings periods, no proration is applied. - Start Date: Allocates the full amount to the earnings period containing the amount's start date.
- End Date: Allocates the full amount to the earnings period containing the amount's end date.
- Start of Reporting Period: Allocates the full amount using the reporting-period start date.
- Date Received: Allocates the full amount to the earnings period containing the Date Received.
- Prorate: Prorates amounts that span multiple earnings periods.
- Proration Allocation Method: Applies only when Prorate is selected. This defines how reported amounts are prorated when allocating to different earnings periods. With each method, proration fractions are developed by calculating numerators and denominators to determine fractions of a year. The numerator is the period between the period start date and the calculation date, and the denominator is the full period fraction: the amount effective date through the earlier of the calculation date or the amount end date.
- Allocate using days: Defines fractions for both the proration numerator and denominator as the difference in days divided by days in the year, using 365 days or 366 days in a leap year.
- Nearest month (days): Defines the numerator and denominator based on differences in days, then rounds each to the nearest 1/12.
- Worked day in month: Gives full credit for a month, for both the numerator and denominator, if the participant worked a day in that month.
- Next-lowest month (days): Defines the numerator and denominator based on differences in days, then rounds each to the next-lowest 1/12.
- Next-highest month (days): Defines the numerator and denominator based on differences in days, then rounds each to the next-highest 1/12.
- Nearest month (months, days): Defines the numerator and denominator based on date differences using months and days, then rounds up if more than 15 days were worked in a month.
- Nearest Week: Defines the numerator and denominator based on differences in days, then rounds each to the nearest 1/52.
- Next-lowest Week: Defines the numerator and denominator based on differences in days, then rounds each to the next-lowest 1/52.
- Working Days (months, day): Allocates amounts for completed months and for partial months using the ratio of working days accrued to working days in that month.
- Next-lowest Month (month, days): Defines the numerator and denominator based on date differences using months and days, then rounds each to the next-lowest 1/12.
- Working Days: Defines the numerator and denominator based on differences in working days.
- Days (months, days in month): Allocates amounts for completed months and for partial months using the ratio of days worked to days in that month.
- Annualization Adjustment: Allows partial amounts to be annualized before being applied to different periods.
Use this only when the annualization adjustment applies to this Reported Amount alone; otherwise use the partial-period rules within the provision so annualization applies to all amounts. - Show error if more than one reported amount in a period: Creates a validation error when multiple Reported Amounts occur within one earnings period.
- Ignore amount if unadjusted effective date is after termination date: Ignores amounts reported after a participant's termination date.
Related topics