The Average Earnings Provision Reported Amount Screen allows users to define the rules for applying different reported amounts to different earnings periods.
- Reported Amount Name: space to select which Reported Amount is to be applied for the Average Earnings Provision.
- Override values with following: check this box and choose from the list of Formula Derived Items if you want to replace the amount values for each applicable Reported Amount with the calculation value from a Formula Derived Item. Choose between using all amounts, only actual amounts, or only projected amounts. Note that the Reported Amount must exist for any given period in order to be applied.
- Combination Type: choose from the following options to define how to apply each amount to each earnings period:
- Add to Amount: (default option) choose this option if each amount is to be added to each period amount.
- Subtract from Amount: choose this option if each amount is to be subtracted from each period amount.
- Add to Minimum: choose this option if each amount is to be added to each period's minimum amount (if applicable).
- Subtract from Minimum: choose this option if each amount is to be subtracted from each period's minimum amount (if applicable).
- Add latest on period start: select this option if the latest amount on each earnings period's start date is to be applied. This is generally only used for rates of pay plans that use the latest reported rate of pay for each earnings period.
- Override Period Amount: choose this option if a reported amount during a period (if it exists during a period) should override all other reported amounts.
- Add latest on period end: select this option if the latest amount on each earnings period's end date is to be applied.
- Allocation to Multiple Periods: item Description. Choose Prorate, Start Date, End Date, Start of Reporting Period.
- Prorate: (default option) choose this option if amounts are to be prorated if they 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: choose this option if amounts are to be fully allocated to different earnings periods based upon the start date of the amount.
- End Date: choose this option if amounts are to be fully allocated to different earnings periods based upon the end date of the amount.
- Start of Reporting Period: choose this option if amounts are to be applied based upon the reporting period start date.
- Date Received: choose this option if amounts are to be fully allocated to different earnings periods based upon the Date Received of the amount.
- Proration Allocation Method: (only applicable if Prorate is selected above) defines how reported amounts are to be 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 (amount effective date and the earlier of calculation date or 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 (365 or 366 if leap year).
- Nearest month (days): defines numerator and denominator based upon differences in days and then rounds each to the nearest 1/12.
- Worked day in month: for both the numerator and denominator, gives full credit for month if the participant worked a day in that month.
- Next-lowest month (days): defines numerator and denominator based upon differences in days and then rounds each to the next-lowest 1/12.
- Next-highest month (days): defines numerator and denominator based upon differences in days and then rounds each to the next-highest 1/12.
- Nearest month (months, days): defines numerator and denominator based upon date differences using months and days and then rounds up if more than 15 days were worked in a month.
- Nearest Week: defines numerator and denominator based upon differences in days and then rounds each to the nearest 1/52.
- Next-lowest Week: defines numerator and denominator based upon differences in days and then rounds each to the next-lowest 1/52.
- Working Days (months, day): allocates amounts for completed months and based upon the fraction of any partial months worked determined as the ratio of working days accrued divided by working days in that month.
- Next-lowest Month (month, days): defines numerator and denominator based upon date differences using months and days and then rounds each to the next-lowest 1/12.
- Working Days: defines numerator and denominator based upon differences in working days.
- Days (months, days in month): allocates amounts for completed months and based upon the fraction of any partial months worked determined as the ratio of days divided by days in that month.
- Multiply by: (rarely used) allows for Reported Amounts to be adjusted prior to being applied to earnings periods.
- Amount Range: area to specify minimum and maximums (if applicable) that are applicable before applying amounts to different periods. These should only be used when the minimum or maximum only applies to this reported amount (otherwise you should use the earnings limits within the provision so that these ranges apply to the summation of all amounts).
- Annualization Adjustment: allows partial amounts to be annualized prior to being applied to different periods. These should only be used when the annualization adjustment only applies to this reported amount (otherwise you should use the partial period rules within the provision so that annualization applied to all amounts).
- Show error if more than one reported amount in a period: check this box if multiple reported amounts within an earnings period should generate an error message.
- Ignore amount if unadjusted effective date is after termination date: check this box if amounts that are reported after a participant's termination date should be ignored.