ACA Employee Cycles

ACA Reporting

If you are using Enterprise or Beyond to track ACA information, we have a few report options for auditing, reviewing, or pulling out important information. Keep in mind that you can also create your own custom options utilizing a custom ACA Search. Check out Auditing Employee Records with ACA Searches for more information on search options available in your system. 

Looking for a list of all ACA Report options available? Check out Affordable Care Act Reports Manual

Looking for the full reports manual? Check out Full Reports Manual.

Locating ACA Reports

ACA reports are listed in their own category under all options > reports in Enterprise: 

*Note* Reports in Enterprise require you to have specific security permissions. You will need to have access to the Affordable Care Act reports category in order to see or run any ACA related reports. Check out Enterprise - Security Roles for more information or talk to your admin if you are not seeing the reports you are expecting to. 


ACA Employee Cycles

Purpose: If you are utilizing the Look Back method for ACA measurements, then you use this report to review important ACA related information including their ACA cycles and hours worked. This is a great way to identify which employees are in their Administration period and may need to be reviewed to see if they qualify for insurance. It's a quick way to find those employees that have reached a break in service and may be able to be removed from insurance. 

Displays all of the employees' ACA cycle data that the system has calculated, which is their Measurement, Admin, and Stability period start and end dates as well as the number of hours worked in the measurement period.

Parameters

 Parameter Description
Start DateThis is the starting date the report will use to determine which cycle information is displayed. 
  • By default, this option is set to Null which means all ACA cycle data from all years will be included
  • If you are going to set a start date, uncheck the null option and keep in mind the date range is affected by the date filter parameter
End DateThis is the end date the report will use to determine which cycle information is displayed. 
  • By default, this option is set to Null which means all ACA cycle data from all years will be included
  • If you are going to set a end date, uncheck the null option and keep in mind the date range is affected by the date filter parameter
BranchSelect which branches you want to include on this report 
  • Keep in mind that you will only see branches available at your current hierarchy level so we recommend running this report at System, Subsystem, or Entity level to ensure the report pulls all applicable information.
Date FilterIf you are entering a start or end date for this report, select how the start and/or end date will effect the data in this report.
  • For definitions of Measurement, Admin, Stability, and Break in Service statuses, see the breakdown of this report below. 
  • Hire date refers to the ACA hire date saved on the employee's record. Check out Setting ACA Hire Dates for Employees for more information. 
  • Start date means the start and end date range will include all employees whose Measurement/Admin/Stability period, etc. date starts within the date range vs. ends within the date range.
Cycle ACA StatusThis option refers to the ACA status for the employee during the ACA Cycle listed.
Because some ACA statuses may change after an initial measurement period, etc. you can choose to exclude certain ACA statuses from the report to focus on ACA cycles based on ACA status.
Current ACA StatusThis option refers to the current ACA status for the employee at the time you run the report. Because some ACA statuses may change over time, you can limit the report based on an employee's current status.
Insurance Offering Response StatusIf you are tracking the insurance offer status on the employee's record. Then you can limit this report by whether they accepted insurance or not using this drop down filter. Uncheck the options you do not wish to display.
Employee FilterIf you are looking to review one employee's ACA cycle history, you can use this optional filter to limit by employee's name. Remember to type last name, first name
Customer FilterIf you are looking to pull ACA cycle information based on the customer the employee was working for, you can limit by customer name. 
Average Hours MinThis parameter allows you to limit the report based on average hours the employee worked. 
  • Setting a minimum here would change the report to only display employees who worked on average at least X number of hours.
  • By default this is set to 0 to include all employees
Average Hours MaxThis parameter allows you to limit the report based on average hours the employee worked.
  • Setting a max here would change the report to only display employees who worked on average less than or equal to the max  hours entered.
ShowThe show filter options allow you to limit the employees shown on the report based on different criteria.
  • By default Show is set to All Employees so that all employees are displayed on the report. 
  • Employees Missing Cycles Only: will only show employees that should have ACA cycles but are missing data. 
  • Active vs. Inactive Employees Only: Active employees include any employee in an active status. Inactive employees are typically those that no longer work with you and their records have been archived or deactivated in your system. 
  • Employees Missing an ACA Hire Date Only: This is a great option when you are trying to audit your system for anyone who might be missing their ACA hire date that is entered on the employee's record at time of hire. 
  • Current Assigned or Unassigned Employees Only: Choose if you want to see only employees that have a current assignment or employees that are not currently working on an active assignment. 
Group ByThe group by option allows you to group the data in the report by different parameters. 
  • By default, the report will be set to "No Grouping" which will show all ACA cycles without grouping any information
  • Branch: will group ACA cycles by employee branch
  • ACA Status: will group ACA cycles by the employee's ACA Status
  • Customer: will group ACA cycles by the customer the employee worked for
  • Customer - Department: will group ACA cycles by primary customer and departments the employee worked for
Report Breakdown

The following sections review and define the columns of information on this report:

Employee & ACA Hire information 

  • Employee: Name of employee. Keep in mind that employees who have worked for you for a longer period of time may have multiple ACA cycles depending on your date range. 
  • Employee ID: the AIdent or Employee ID number to uniquely define their record
  • Hire Date: the ACA hire date listed on the employee's record for the ACA Cycle
  • Cycle Status: The ACA status of the employee when the cycle started
  • Current Status: The current ACA status of the employee
  • Insurance: If you have been entering the Insurance acceptance/decline options under ACA information on the employee's record, that will display here. 

For ACA Hire Date, Status, and Insurance information, check out Setting ACA Hire Dates for Employees for more information. 

Measurement Period 

  • The Measurement period refers to either the initial or standard measurement period for an employee which determines the employee's eligibility for insurance. 
  • Hrs: Total number of hours worked within the ACA cycle and report parameters
  • Weeks: Total number of weeks worked within the ACA cycle and report parameters
  • Avg Hrs Per: Average number of hours worked per week 
  • Start Date: The start date of the measurement period
  • End Date: The end date of the measurement period

Admin Period

  • The Admin period refers to the administrative period where employees should be evaluated to see if they meet the requirements to be offered insurance and be given time to accept or decline the insurance option if applicable. 
  • Start Date: The first day of the administrative period
  • End Date: The last day of the administrative period

Stability Period 

  • The Stability period is the period of time after the start of the insurance requirement that any eligible employee regardless of ongoing ACA status must have insurance available to them. Your stability period may not be less than your transitional period or measurement periods.
  • Start Date: The first day of the stability period
  • End Date: The last day of the stability period

Break In Service 

  • Break In Service rules are as follows: if the employee has not worked for a 13 week period or more, or the employee has not worked for 4 weeks or more, where that 4 week break is greater than the preceding work period (e.g. 3 week assignment followed by a 4 week break).
  • Start Date: The first day of the break in service
  • End Date: The last day of the break in service if applicable

Related Articles