...

The AFFORD Report will assist in determining if an employee will exceed 30 hours per week or 130 hours per month and therefore, be classified as full-time under the Affordable Care Act (ACA).  The report will be available in .pdf format.

Image RemovedImage Added

The report file created is called Retire Hours For Affordable Care Act Report.pdf

...

• Include Employees with no retire hours on CSV file?  If this box is checked, it will include 0 retire hours and only put those on the CSV file but have to have a pay inclusive of the input parameters to be included.

• Exclude based on termination date?  If this box is checked and an employee's termination date is prior to the ending date entered, the employee will not be included on the report.  This will allow the district to optionally exclude terminated employees from being reported since they would not be eligible for coverage per ACA rules.
  •  = Exclude employees whose termination date is prior to the ending date
  •  = Include ALL employees (even if terminated) if they meet all other specifications
    
    
• Exclude employees with insurance?  If this box is checked and an employee currently has an active health insurance deduction set up, the employee will not be included on the report.  It will use the Payroll Item Configuration Menu "Employer Health Coverage"  with a value of "true" to determine which payroll item types to consider as health insurance.  A payroll item will be considered active if the start date of the payroll item is before the ending date entered and the stop date on the poll item is after the ending date entered.  A payroll item is also considered active when no starting or ending date is present on the payroll item.  
  
  •  = Exclude employees who have Employer Sponsored Insurance
  •  = Include ALL employees (with or without Employer Sponsored Insurance)
    
    
• Calculate based on number of weeks or months?  This drop-down box allows for Weeks (based on 30 hours per week) or Months (based on 130 hours per month)
  
  • Weekly = All calculations will be based on a per WEEK calculation
    • This option is required when 26 pays (bi-weekly) is used for payroll processing
  • Monthly = All calculations will be based on a per MONTH calculation
    • This option should only be used when 24 pays (semi-monthly) is used for payroll processing because a semi-monthly payroll would include the first day of the month and last day of the month respectively.  The monthly option will NOT provide accurate amounts when ran for a district with 26 pays since a single pay period may stretch across multiple months.
      
      
• Calendar for calculating breaks: This drop-down box provides a list of all calendar types available.
  • Per the ACA, any break of 4 or more weeks cannot be included in the counts used to determine if an employee has averaged 30 or more hours per week (or 130 hours per month) in a given measurement period.  
  • If you enter a calendar type, it will use it to determine if there is a break stretching more than 27 days and will exclude these days from the calculated average.  Any combination of 28 consecutive days with a blank, C (calamity), or H (holiday) on the calendar will be excluded in the calculations.
  • In theory, you could create and use one or more calendars to be used specifically for this report.
    
    
• Select Pay Groups: Highlight to select those pay groups that you wish to report on from the Available box and move it over  to the Selected box.  You can choose none or any number of pay groups to report on.  To remove from the selected box use  to move it back to the available box.
  
  
• Select Employees: Highlight to select those employees that you wish to report on from the Available box and move it over to the Selected box.  You can choose none or any number of employees to report on. To remove from the selected box use  to move it back to the available box. 

...

The hours per WEEK calculation is: Total Hrs / (Total days / 7). Can verify the hours by looking on pay report under SERS/STRS hours also.
The Total Hrs is the total retirement hours from Payroll Payments  + the adjustment retirement hours taken from Adjustments for SERS/STRS hours.
The Total days are determined by taking the beginning date used for AFFORD or the calendar start date from Positions (it uses the date from whichever position is most recent).  It then subtracts the ending date used for AFFORD or the employees termination date (if checked to use the termination date as a criteria) and uses whichever is LEAST recent).  If there are any breaks of 28 or more consecutive days from the BREAK calendar, those days are also subtracted from the total days.  It divides the total days by 7 (it includes weekend days and there are 7 days in a week).

The hours per MONTH calculation is:  Total Hrs / (Total days / number of months between beginning and ending date).
The Total Hrs is the total retirement hours from Payroll Payments  + the adjustment retirement hours taken from Adjustments for SERS/STRS hours.
The Total days are determined by taking the beginning date used for AFFORD or the calendar start date from Positions (it uses the date from whichever position is most recent).  It then subtracts the ending date used for AFFORD or the employees termination date (if checked to use the termination date as a criteria) and uses whichever is LEAST recent).  If there are any breaks of 28 or more consecutive days from the BREAK calendar, those days are also subtracted from the total days.  It divides the total days by the number of months between the beginning and ending date.

Afford CSV

...