Affordable Care Act Reports

ACA Reports

            ACA Benefit Lookback List Ins Census Mail Export

           

            Purpose:

The report has additional information that insurance companies are requesting in order to give you a quote for how much insurance coverage would cost for these employees and has the employee’s address to assist with pre-filling initial enrollment forms and creating mailing labels.

This report allows you to see which employees have worked a weekly average of hours above a given amount and is designed to allow you to look back to see who qualified for the Affordable Care Act as a Full Time Employee (FTE).  The report looks to see if any of the employees qualify for the ACA Break In Service rules and if they do, then the report will not show them even if they meet the average hours requirement.  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).

NOTE:  only employees whose start date is before the start date range and who have worked the full length of the period you are running the report for and who have had no ACA defined breaks in service will show up in the report results.

            Parameters:

  1. Start Date: Starting weekend date of your desired date range based upon the Sunday after the weekend date of the timecard when the weekend date is not already a Sunday date.
  2. End Date: Ending weekend date of your desired date range based upon the Sunday after the weekend date of the timecard when the weekend date is not already a Sunday date.
  3. Branch: A drop down list of all branches in the user’s current hierarchy.  Is a multi-value parameter so they can select all branches, just one specific branch or any combination of different branches in the list.
  4. Show: A drop down determining what/how you want certain items to show up on the report.  Is a multi-value parameter so they can select all options, just one specific option or any combination of different options in the list.
    1. EIN Records Separated

EIN Records Combined (will combine all EIN’s into one to pull hours for employees who work in multiple EIN’s into one EIN according to the common ownership rules)

  1. Active Employees Only
  2. Inactive Employees Only
  3. Current Assigned Employees Only
  4. Current Un-Assigned Employees Only
  1. Average Hours >=: Allows you to set a limit to see which employees have a weekly average of hours over or equal to the entered amount.
 

ACA Benefit Lookback List Insurance Census

        

            Purpose:

This report allows you to see which employees have worked a weekly average of hours above a given amount and is designed to allow you to look back to see who qualified for the Affordable Care Act as a Full Time Employee (FTE).  The report looks to see if any of the employees qualify for the ACA Break In Service rules and if they do, then the report will not show them even if they meet the average hours requirement.  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).

The report also has additional information that insurance companies are requesting in order to give you a quote for how much insurance coverage would cost for these employees.

NOTE:  only employees whose start date is before the start date range and who have worked the full length of the period you are running the report for and who have had no ACA defined breaks in service will show up in the report results.

            Parameters:

  1. Start Date: Starting weekend date of your desired date range based upon the Sunday after the weekend date of the timecard when the weekend date is not already a Sunday date.
  2. End Date: Ending weekend date of your desired date range based upon the Sunday after the weekend date of the timecard when the weekend date is not already a Sunday date.
  3. Branch: A drop down list of all branches in the user’s current hierarchy.  Is a multi-value parameter so they can select all branches, just one specific branch or any combination of different branches in the list.
  4. Group By: A list of different fields to group the data into on the report.  Has the following options:
    1. (no grouping)
    2. Branch
  5. Show: A drop down determining what/how you want certain items to show up on the report.  Is a multi-value parameter so they can select all options, just one specific option or any combination of different options in the list.
    1. EIN Records Separated
    2. EIN Records Combined (will combine all EIN’s into one to pull hours for employees who work in multiple EIN’s into one EIN according to the common ownership rules)
    3. Active Employees Only
    4. Inactive Employees Only
    5. Current Assigned Employees Only
    6. Current Un-Assigned Employees Only
  6. Average Hours >=: Allows you to set a limit to see which employees have a weekly average of hours over or equal to the entered amount.
 

ACA Employee Adjustments

        

            Purpose:

This report allows you to see how much of the ACA insurance adjustments are being passed onto the employee and how much it is costing you as a company.  This report is designed to give you both a high level and a detailed view of your cost.  If you run the report with the “Expand All Detail?” set to Yes, you will get each individual adjustment amount that is on an employee’s check.   If you set that parameter to No, then you will just see the summary lines based upon what you set the Group By parameter to.   Therefore, if you just want to see company totals, set the Group By parameter to “Employer” and set the “Expand All Detail?” to No and you will see one line per Federal EIN you have setup in TempWorks.  You can also expand and collapse the details within each individual group, by clicking on the (+) located to the left of the group header.

            Parameters:

  1. Start Date: Starting date of your desired date range
  2. End Date: Ending date of your desired date range
  3. Date Filter: A drop down determining what field your date range filters on.
    1. Check Date of check
    2. Weekend Bill of check
  4. Branch: A drop down list of all branches in the user’s current hierarchy.  Is a multi-value parameter so they can select all branches, just one specific branch or any combination of different branches in the list.
  5. Group By: A list of different fields to group the data into on the report.  Has the following options:
    1. (no grouping)
    2. Adjustment
    3. Employer
    4. Branch on the check
    5. Check Date on the check
    6. Check Number on the check
    7. Employee Name on the check
  6. Employee Filter: Filters on the employee’s name
  7. Adjustment Type: A drop down list of all ACA adjustment types, both employee and employer paid adjustments.  Is a multi-value parameter so they can select all adjustment type, just one adjustment type or any combination of different adjustment types.
  8. Check ID: Filters for a specific check id.
  9. Expand All Detail?: A drop down determining if all of the detail records will be shown when the report is ran or if just the summary lines are shown.  Summary lines are determined by the selected Group By parameter.
 

ACA Employee Details

           

            Purpose:

Report was designed to allow you to find any sub set of employees based upon their ACA data listed in their Pay Setup area.  This report allows you to filter on any of the ACA dates and any of the different statues.   It also allows you to enter a range to filter for employees who have an average hours per week amount between the entered min and max amounts.  This will allow you to narrow down your search to people who are over, under, coming up to or not even close to the average hours per week limit mark that would deem them as a Full Time Employee according to ACA regulations.

One thing to note on this report is, for the date range, if you do not enter a date range (you leave the Null check boxes checked next to the start and end date) then the date range will not filter on anything in the report because we have no dates entered, even though the date filter drop down has a date field selected.  Reason for this, is to allow you to still see employees even if they do not have any of the ACA dates entered into the system yet.

            Parameters:

  1. Start Date: Starting date of your desired date range
  2. End Date: Ending date of your desired date range
  3. Date Filter: A drop down determining what field your date range filters on unless no dates are entered (meaning the Null check boxes are checked next to the start and end date parameters).
    1. Hire Date
    2. Date Offered
    3. Effective Insurance Date
    4. Date Declined
    5. Insurance Due Date
    6. Last Eval Date
    7. Admin Period Start Date
  4. Branch: A drop down list of all branches in the user’s current hierarchy.  Is a multi-value parameter so they can select all branches, just one specific branch or any combination of different branches in the list.
  5. Group By: A list of different fields to group the data into on the report.  Has the following options:
    1. (no grouping)
    2. Branch
    3. ACA Status
    4. Admin Status
    5. Insurance
    6. Declined Reason
    7. State Exchange State
    8. FTE Status
  6. ACA Status: A drop down list of all ACA statuses.  Is a multi-value parameter so you can select all ACA statuses, just one specific ACA Status or any combination of different ACA statuses in the list.
  7. Insurance Offering Response Status: A drop down list of all insurance offering response statuses.  Is a multi-value parameter so you can select all insurance offering response statuses, just one specific insurance offering response status or any combination of different insurance offering response statuses in the list
  8. Admin Status: A drop down list of all admin statuses.  Is a multi-value parameter so you can select all admin statuses, just one specific admin Status or any combination of different admin statuses in the list.
  9. Declined Reason: A drop down list of all declined reasons.  Is a multi-value parameter so you can select all declined reasons, just one specific declined reason or any combination of different declined reasons in the list.
  10. FTE Status: A drop down list of all FTE statuses.  Is a multi-value parameter so you can select all FTE statuses, just one specific FTE Status or any combination of different FTE statuses in the list.
  11. Employee Filter: A free text field that filters on the Employee name field.  Filters in “Last Name, First Name Middle Initial” format.  To filter for Joe Michael Smith you would enter “Smith, Joe Michael”.
  12. Customer Filter:
    1. A free text field that filters on the Customer - Department name.  Filters in “Customer Name – Department Name” format.  To filter for the accounting department of ABC company you would enter “ABC - Accounting”.
    2. Filters for the customer name on the employees current open assignment if no date range is selected.  If there is a date range, then it will filter for customer names of any open assignment that the employee was on between the date range.
  13. Average Hours Min: Employee must have an average hour per week amount greater than the entered minimum.
  14. Average Hours Max: Employee must have an average hour per week amount less than the entered maximum.
  15. Show: A drop down determining what/how you want certain items to show up on the report.  Is a multi-value parameter so they can select all options, just one specific option or any combination of different options in the list.
    1. All Employees
    2. Active Employees Only
    3. Inactive Employees Only
    4. Current Assigned Employees Only
    5. Current Un-Assigned Employees Only
 

ACA Employee Details Communication Export

  

            Purpose:

This report is an exact replica of the ACA Employee Details report with the addition of the employees contact info (phone, email and address) and minus the Group By parameter.  Report is designed to be exported to Excel in order to allow for mass mailings or mass communication efforts to contact employees about ACA.

Report was designed to allow you to find any sub set of employees based upon their ACA data listed in their Pay Setup area.  This report allows you to filter on any of the ACA dates and any of the different statues.   It also allows you to enter a range to filter for employees who have an average hours per week amount between the entered min and max amounts.  This will allow you to narrow down your search to people who are over, under, coming up to or not even close to the average hours per week limit mark that would deem them as a Full Time Employee according to ACA regulations.

One thing to note on this report is, for the date range, if you do not enter a date range (you leave the Null check boxes checked next to the start and end date) then the date range will not filter on anything in the report because we have no dates entered, even though the date filter drop down has a date field selected.  Reason for this, is to allow you to still see employees even if they do not have any of the ACA dates entered into the system yet.

            Parameters:

  1. Start Date: Starting date of your desired date range
  2. End Date: Ending date of your desired date range
  3. Date Filter: A drop down determining what field your date range filters on unless no dates are entered (meaning the Null check boxes are checked next to the start and end date parameters).
    1.  Hire Date
    2. Date Offered
    3. Effective Insurance Date
    4. Date Declined
    5. Insurance Due Date
    6. Last Eval Date
    7. Admin Period Start Date
  4. Branch: A drop down list of all branches in the user’s current hierarchy.  Is a multi-value parameter so they can select all branches, just one specific branch or any combination of different branches in the list.
  5. ACA Status: A drop down list of all ACA statuses.  Is a multi-value parameter so you can select all ACA statuses, just one specific ACA Status or any combination of different ACA statuses in the list.
  6. Insurance Offering Response Status: A drop down list of all insurance offering response statuses.  Is a multi-value parameter so you can select all insurance offering response statuses, just one specific insurance offering response status or any combination of different insurance offering response statuses in the list
  7. Admin Status: A drop down list of all admin statuses.  Is a multi-value parameter so you can select all admin statuses, just one specific admin Status or any combination of different admin statuses in the list.
  8. Declined Reason: A drop down list of all declined reasons.  Is a multi-value parameter so you can select all declined reasons, just one specific declined reason or any combination of different declined reasons in the list.
  9. FTE Status: A drop down list of all FTE statuses.  Is a multi-value parameter so you can select all FTE statuses, just one specific FTE Status or any combination of different FTE statuses in the list.
  10. Show: A drop down determining what/how you want certain items to show up on the report.  Is a multi-value parameter so they can select all options, just one specific option or any combination of different options in the list.
    1. All Employees
    2. Active Employees Only
    3. Inactive Employees Only
    4. Current Assigned Employees Only
    5. Current Un-Assigned Employees Only
  11. Average Hours Min: Employee must have an average hour per week amount greater than the entered minimum.
  12. Average Hours Max: Employee must have an average hour per week amount less than the entered maximum. 
  13. Employee Filter: A free text field that filters on the Employee name field.  Filters in “Last Name, First Name Middle Initial” format.  To filter for Joe Michael Smith you would enter “Smith, Joe Michael”.
  14. Customer Filter:
    1. A free text field that filters on the Customer - Department name.  Filters in “Customer Name – Department Name” format.  To filter for the accounting department of ABC company you would enter “ABC - Accounting”.
    2. Filters for the customer name on the employees current open assignment if no date range is selected.  If there is a date range, then it will filter for customer names of any open assignment that the employee was on between the date range.

ACA Change Log

Purpose:

Is designed to give you access to the change tracking log info that is stored in the system.  Every time someone makes a change to any of our ACA areas, we store what field they changed, the old value and the new value they changed it to.   This will allow you to see the progression of changes made to an employee to be able to recreate why the system did what it did as well as use this report as an auditing tool if the need ever arises.  Report can be ran from the employee record directly and the employee id parameter will auto populate.

            Parameters:

1. Start Date:  Starting date of your desired date range

2. End Date:  Ending date of your desired date range

3. Employee Filter:  A free text field that filters on the Employee name field.  Filters in LastName,FirstName Middle Initial format.

4. Employee ID:  Filters on the Employee's ID field.

ACA Missing Check

Purpose:

Report was designed to assist you in finding employees who have an ACA insurance adjustment setup on their employee record, but was not paid in the date range.   This would then be the list of employees that you would need to check the following week to see if you can withhold more for their ACA insurance since they missed contributing the previous week.   It will allow you to set what adjustments are your ACA insurance adjustments or any other adjustment for that matter that you want to check on to see which employees missed a pay check.

We then show you some helpful information from their last paycheck that they were paid on prior to the start date of the date range you entered.

Parameters:

         

  1. Start Date: Starting weekend date of your desired date range based upon the Sunday after the weekend date of the timecard when the weekend date is not already a Sunday date.
  2. End Date: Ending weekend date of your desired date range based upon the Sunday after the weekend date of the timecard when the weekend date is not already a Sunday date.
  3. Branch: A drop down list of all branches in the user’s current hierarchy.  Is a multi-value parameter so they can select all branches, just one specific branch or any combination of different branches in the list.  Filters on the branch that the employee is listed in.
  4. Adjustment Type: A drop down list of all adjustment types, both employee and employer paid adjustments.  Is a multi-value parameter so they can select all adjustment type, just one adjustment type or any combination of different adjustment types.
  5. Group By: A list of different fields to group the data into on the report.  Has the following options:
    1. (no grouping)
    2. Branch
    3. Employee
    4. Adjustment
    5. Pay Frequency
  6. Show: A drop down determining what you want types of employees you want to show on the report.  If you want all employees to show leave all of the options checked.  This ss a multi-value parameter so they can select all options, just one specific option or any combination of different options in the list.
    1. Employees On Active Assignments In Date Range
    2. Employees Not On Active Assignments In Date Range
    3. Active Adjustments
    4. Inactive Adjustments
    5. Active Employees
    6. Inactive Employees
    7. Current Assigned Employees
    8. Current Un-Assigned Employees

Employee Filter: A free text field that filters on the Employee name field.  Filters in “Last Name, First Name Middle Initial” format.  To filter for Joe Michael Smith you would enter “Smith, Joe Michael”.

ACA Minimum Hours Ins Census Mail Export

           

            Purpose:

The report has additional information that insurance companies are requesting in order to give you a quote for how much insurance coverage would cost for these employees and has the employee’s address on here to assist with prefilling initial enrollment forms and creating mailing labels.

This report allows you to see employees that have worked over a given amount of hours for a given date range to determine which employees are considered Full Time Employees (FTE) for ACA.  The report looks to see if any of the employees qualify for the ACA Break In Service rules and if they do, then the report will not show them even if they meet the average hours requirement.  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).

            Parameters:

  1. Start Date: Starting weekend date of your desired date range based upon the Sunday after the weekend date of the timecard when the weekend date is not already a Sunday date.
  2. End Date: Ending weekend date of your desired date range based upon the Sunday after the weekend date of the timecard when the weekend date is not already a Sunday date.
  3. Branch: A drop down list of all branches in the user’s current hierarchy.  Is a multi-value parameter so they can select all branches, just one specific branch or any combination of different branches in the list.
  4. Show: A drop down determining what/how you want certain items to show up on the report.  Is a multi-value parameter so they can select all options, just one specific option or any combination of different options in the list.
    1. EIN Records Separated
    2. EIN Records Combined (will combine all EIN’s into one to pull hours for employees who work in multiple EIN’s into one EIN according to the common ownership rules)
    3. Active Employees Only
    4. Inactive Employees Only
    5. Current Assigned Employees Only
    6. Current Un-Assigned Employees Only
  5. Total Hours >=: Allows you to set a limit to see which employees have more or the same amount of total hours than the entered amount.

ACA Minimum Hours Insurance Census

        

            Purpose:

This report allows you to see employees that have worked over a given amount of hours for a given date range to determine which employees are considered Full Time Employees (FTE) for ACA.  The report looks to see if any of the employees qualify for the ACA Break In Service rules and if they do, then the report will not show them even if they meet the average hours requirement.  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).

The report also has additional information that insurance companies are requesting in order to give you a quote for how much insurance coverage would cost for these employees.

            Parameters:

  1. Start Date: Starting weekend date of your desired date range based upon the Sunday after the weekend date of the timecard when the weekend date is not already a Sunday date.
  2. End Date: Ending weekend date of your desired date range based upon the Sunday after the weekend date of the timecard when the weekend date is not already a Sunday date.
  3. Branch: A drop down list of all branches in the user’s current hierarchy.  Is a multi-value parameter so they can select all branches, just one specific branch or any combination of different branches in the list.
  4. Group By: A list of different fields to group the data into on the report.  Has the following options:
    1. (no grouping)
    2. Branch
  5. Show: A drop down determining what/how you want certain items to show up on the report.  Is a multi-value parameter so they can select all options, just one specific option or any combination of different options in the list.
    1. EIN Records Separated
    2. EIN Records Combined (will combine all EIN’s into one to pull hours for employees who work in multiple EIN’s into one EIN according to the common ownership rules)
    3. Active Employees Only
    4. Inactive Employees Only
    5. Current Assigned Employees Only
    6. Current Un-Assigned Employees Only
  6. Total Hours >=: Allows you to set a limit to see which employees have more or the same amount of total hours than the entered amount.

Affordable Care Act Benefit Lookback List

        

            Purpose:

This report allows you to see which employees have worked a weekly average of hours above a given amount and is designed to allow you to look back to see who qualified for the Affordable Care Act as a Full Time Employee (FTE).  The report looks to see if any of the employees qualify for the ACA Break In Service rules and if they do, then the report will not show them even if they meet the average hours requirement.  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).

NOTE:  Only employees whose start date is before the start date range and who have worked the full length of the period you are running the report for and who have had no ACA defined breaks in service will show up in the report results.

            Parameters:

  1. Start Date: Starting weekend date of your desired date range based upon the Sunday after the weekend date of the timecard when the weekend date is not already a Sunday date.
  2. End Date: Ending weekend date of your desired date range based upon the Sunday after the weekend date of the timecard when the weekend date is not already a Sunday date.
  3. Branch: A drop down list of all branches in the user’s current hierarchy.  Is a multi-value parameter so they can select all branches, just one specific branch or any combination of different branches in the list.
  4. Group By: A list of different fields to group the data into on the report.  Has the following options:
    1. (no grouping)
    2. Branch
    3. Customer
    4. Customer – Department
    5. Employee
  5. Show: A drop down determining what/how you want certain items to show up on the report.  Is a multi-value parameter so they can select all options, just one specific option or any combination of different options in the list.
    1. EIN Records Separated
    2. EIN Records Combined (will combine all EIN’s into one to pull hours for employees who work in multiple EIN’s into one EIN according to the common ownership rules)
    3. Customer Detail (will make the customer and department columns show up in the report)
    4. Active Employees Only
    5. Inactive Employees Only
    6. Current Assigned Employees Only
    7. Current Un-Assigned Employees Only
  6. Average Hours >=: Allows you to set a limit to see which employees have a weekly average of hours over or equal to the entered amount.
 

Affordable Care Act Compliance Determination

        

            Purpose:

This report allows you to see employees who have worked a weekly average of hours above a given amount and is designed to allow you to see if you are required to comply with the Affordable Care Act (ACA).  If you click on the (+)’s, the detail will expand to show you the employees who qualify under each category.  Total Part Time Employees FTE is calculated by taking the sum of the weekly average amount for your PTE, who have worked an average of less than the entered hour limit amount, and dividing that sum/total by the entered hour limit amount.  In the screen shot above the entered hour limit amount is 10.

Companies who have more than 100 FTE are subject to ACA.

            Parameters:

  1. Start Date: Starting weekend date of your desired date range based upon the Sunday after the weekend date of the timecard when the weekend date is not already a Sunday date.
  2. End Date: Ending weekend date of your desired date range based upon the Sunday after the weekend date of the timecard when the weekend date is not already a Sunday date.
  3. Branch: A drop down list of all branches in the user’s current hierarchy.  Is a multi-value parameter so they can select all branches, just one specific branch or any combination of different branches in the list.
  4. Show: A drop down determining what/how you want certain items to show up on the report.  Is a multi-value parameter so they can select all options, just one specific option or any combination of different options in the list.
    1. EIN Records Separated
    2. EIN Records Combined (will combine all EIN’s into one to pull hours for employees who work in multiple EIN’s into one EIN according to the common ownership rules)
  5. Average Hours >=: Allows you to set a limit to see which employees have a weekly average of hours over or equal to the entered amount.
 

Affordable Care Act Financial Exposure

        

            Purpose:

This report allows you to see which employees have worked a weekly average of hours above a given amount and is designed to allow you see which how much each Affordable Care Act (ACA) option would cost your company.  The report looks to see if any of the employees qualify for the ACA Break In Service rules and if they do, then the report will not show them even if they meet the average hours requirement.  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). 

You have the option to Pay the tax penalties or Play and offer your employees health insurance.  Report calculates the average weekly gross amount that an employee earns to determine how much they would contribute to their insurance premiums if you were to decide to offer insurance coverage (Play) to them.  Therefore, this report is just an estimation on what your yearly cost would be, based upon the averages for your employees for the given date range you entered.

Report also has the ability to be grouped by customer so that you can see an estimation for how much of the cost each one of you customers would be responsible for.

            Parameters:

  1. Start Date: Starting weekend date of your desired date range based upon the Sunday after the weekend date of the timecard when the weekend date is not already a Sunday date.
  2. End Date: Ending weekend date of your desired date range based upon the Sunday after the weekend date of the timecard when the weekend date is not already a Sunday date.
  3. Branch: A drop down list of all branches in the user’s current hierarchy.  Is a multi-value parameter so they can select all branches, just one specific branch or any combination of different branches in the list.
  4. Monthly Ins Cost Per Employee $: Enter in the total monthly insurance premiums per employee that is being paid for insurance coverage regardless of who pays the amounts (Employee or Employer).
  5. Group By: A list of different fields to group the data into on the report.  Has the following options:
    1. (no grouping)
    2. Branch
    3. Customer
    4. Customer – Department
    5. Employee
  6. Show: A drop down determining what/how you want certain items to show up on the report.  Is a multi-value parameter so they can select all options, just one specific option or any combination of different options in the list.
    1. EIN Records Separated
    2. EIN Records Combined (will combine all EIN’s into one to pull hours for employees who work in multiple EIN’s into one EIN according to the common ownership rules)
    3. Customer Detail (will make the customer and department columns show up in the report)
    4. Active Employees Only
    5. Inactive Employees Only
    6. Current Assigned Employees Only
    7. Current Un-Assigned Employees Only
  7. Average Hours >=: Allows you to set a limit to see which employees have a weekly average of hours over or equal to the entered amount.
 

Affordable Care Act Minimum Hours

        

            Purpose:

This report allows you to see employees that have worked over a given amount of hours for a given date range.  The report looks to see if any of the employees qualify for the ACA Break In Service rules and if they do, then the report will not show them even if they meet the average hours requirement.  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).

            Parameters:

  1. Start Date: Starting weekend date of your desired date range based upon the Sunday after the weekend date of the timecard when the weekend date is not already a Sunday date.
  2. End Date: Ending weekend date of your desired date range based upon the Sunday after the weekend date of the timecard when the weekend date is not already a Sunday date.
  3. Branch: A drop down list of all branches in the user’s current hierarchy.  Is a multi-value parameter so they can select all branches, just one specific branch or any combination of different branches in the list.
  4. Group By: A list of different fields to group the data into on the report.  Has the following options:
    1. (no grouping)
    2. Branch
    3. Customer
    4. Customer – Department
    5. Employee
  5. Show: A drop down determining what/how you want certain items to show up on the report.  Is a multi-value parameter so they can select all options, just one specific option or any combination of different options in the list.
    1. EIN Records Separated
    2. EIN Records Combined (will combine all EIN’s into one to pull hours for employees who work in multiple EIN’s into one EIN according to the common ownership rules)
    3. Customer Detail (will make the customer and department columns show up in the report)
    4. Active Employees Only
    5. Inactive Employees Only
    6. Current Assigned Employees Only
    7. Current Un-Assigned Employees Only
  6. Total Hours >=: Allows you to set a limit to see which employees have more or the same amount of total hours than the entered amount.

ACA Employee Cycles

                Purpose:

This report allows you to see at a glance each employee’s ACA cycle data that the system has calculated.  It is designed to allow you to find employees that have just completed their Measurement period and are now in their Admin period and need to have their record reviewed to determine their ACA Status (Full Time/Part Time/Variable/Seasonal) for their next Stability period.  On top of that, this report allows you to find employees that have had a break in service and now can be removed from your insurance coverage.

The Measurement period hours and results can be cross referenced against one of the Lookback or Minimum Hours reports if you run the Lookback reports for the same start and end date of the measurement period for a given cycle record.

                Parameters:

1.Start Date: Starting date of your desired date range

2.End Date: Ending date of your desired date range

3.Date Filter: A drop down determining what field your date range filters on unless no dates are entered (no dates entered, meaning the Null check boxes are checked next to the start and end date parameters).

a. Measurement Period Start Date

b. Measurement Period End Date

c. Admin Period Start Date

d. Admin Period End Date

e. Stability Period Start Date

f. Stability Period End Date

g. Break in Service Start Date

h. Break in Service End Date

i. Hire Date

4.Branch: A drop down list of all branches in the user’s current hierarchy.  Is a multi-value parameter so they can select all branches, just one specific branch or any combination of different branches in the list.

5.ACA Status: A drop down list of all ACA statuses.  Is a multi-value parameter so you can select all ACA statuses, just one specific ACA Status or any combination of different ACA statuses in the list.

a.Filters on the ACA Status set on the employee’s cycle when they were in their Admin period for that given cycle.  It does not filter on the employee’s current ACA Status that they have set currently on their employee record.  Use the ACA Employee Details report to filter on that one.

6.Insurance Offering Response Status: A drop down list of all insurance offering response statuses.  Is a multi-value parameter so you can select all insurance offering response statuses, just one specific insurance offering response status or any combination of different insurance offering response statuses in the list

7.Employee Filter: a  free text field that filters on Employee’s name. 

8.Customer Filter:

a.A free text field that filters on the Customer - Department name.  Filters in “Customer Name – Department Name” format.  To filter for the accounting department of ABC company you would enter “ABC - Accounting”.

b.Filters for the customer name on the employees current open assignment if no date range is selected.  If there is a date range, then it will filter for customer names of any open assignment that the employee was on between the date range.

9.Average Hours Min: Employee must have an average hour per week amount greater than the entered minimum.

10.Average Hours Max: Employee must have an average hour per week amount less than the entered maximum.

11.Show: A drop down determining what/how you want certain items to show up on the report.  Is a multi-value parameter so they can select all options, just one specific option or any combination of different options in the list.

a. All Employees

b. Employees Missing Cycles Only

c. Active Employees Only

d. Inactive Employees Only

e. Employees Missing an ACA Hire Date Only

f. Current Assigned Employees Only

g. Current Un-Assigned Employees Only

12.Group By: A list of different fields to group the data into on the report.  Has the following options:

a. (no grouping)

b. Branch

c. ACA Status

d. Customer

e. Customer - Department

Related Articles

  • None