ACA Consecutive Assignment Worked

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 Consecutive Assignment Worked

Purpose: This report is a great way to audit your system to ensure all employees' ACA statuses are correct or if some part time employees may have reached full time status for the date range given. 

List out employees who have worked each week in the date range for the same customer and averaged over a given amount of hours each week. This is to help find employees who may have had their ACA status coded incorrectly.

Parameters

Parameter
 Description
Start DateThis is the starting date the report will use to report on hours worked and assignments included
  • Keep in mind this report runs off Weekend Bill Date. If you enter a date that is not Sunday it will pull information based on the Sunday following the date selected.
End DateThis is the end date the report will use to report on hours worked and assignments included. Start date + End date = date range for this report.
  • Keep in mind this report runs off Weekend Bill Date. If you enter a date that is not Sunday it will pull information based on the Sunday following the date selected.
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.
Group ByThis option allows you to pick how the report groups information. (The example shown above is grouping by Branch)
  • Branch: Will divide employee assignment and hour information by branch
  • ACA Status: Will divide employee assignment hour information by which ACA status they have set on their employee record (ex. Full-Time, Part-Time, etc.) 
ShowSelect which options you want to have included on this report:
  • EIN Records Separated or Combined: Will display the employee records either separated by EINC or combined regardless of EINC
  • Active or Inactive Employees: Select if you only want to see only active employees or inactive employees listed on the report
  • Employees Missing Hire Date Only: Select if you only want to see employees that meet the hour requirements but do not have an ACA hire date listed on their record
  • Current Assigned or Unassigned Employees: Select if you only want to see employees that are currently on assignment or not on assignments
ACA StatusSelect which employees you want to display on this report based on ACA Status coded on their employee record.
For example, if you did not want to see employees that are set to Variable, you could uncheck that option in the drop down.
For more information on setting ACA Statuses, check out Setting ACA Hire Dates for Employees
Average HoursEnter the minimum average number of hours each week that an employee must have worked to be included in this report 
  • Typically, this will be the same number of hours you use to determine your full time employees that are eligible for insurance
  • This field defaults to 30 hours


Related Articles