-
Type:
Support Activity
-
Status: Resolved
-
Priority:
Critical
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: ACA
-
Labels:None
-
Support Task Type:ACA Data Audit
-
Environment:Production
-
Reported by:Client
-
Company:Mesquite Gaming
-
Module:ACA - Reports
-
Issue Importance:Must Have
Open enrollment starts 12/5, therefore the importance for the Client is critical.
Client is asking the following questions included is the attached reports.
Attached are the two reports we spoke about in our conference call. I’m trying to figure out if either of these reports tell me which extra board or part employee is eligible for health benefits next year.
1. On the first attachment it shows some employees with average monthly hours of 173.82 or 347.66. What does this report mean?
2. The attachment report reflects FTE hours. Is this the report I use to determine eligibility for part time/extra board employees?
3. Does either report show me the average hours worked per month for the calendar year 2016?
4. Are the average hours calculated on the basis of a 12 month period, even if the employee worked less than a 12-month period (e.g. new hire who worked 5 months in 2016)?
Sorry for all the questions, but I need to determine eligibility for this group before Open Enrollment so I can contact the employees.
Monika Demla Can you please verify the notes from Nandkumar above regarding the ACA hours load?
The email I received was sent over to Jen L. she’ll know what they are asking.
Best Regards,
Cathy Harrington | WORKTERRA Project Manager
WORKTERRA
PO Box 11657, Pleasanton, CA 94588
PH: 925-218-3527 | FAX: 925-460-3920 | cathleen.harrington@workterra.com
Internal: Ext 527
[cid:image007.png@01D24B0F.3AC494C0][Description: Description: Description: Description: Description: Workterra 300dpi_logo (2)]DISCLAIMER
This e-mail message (including attachments, if any) is intended for the use of the individual or entity to which it is addressed and may contain information that is privileged, proprietary, confidential and exempt from disclosure. If you are not the intended recipient, you are notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender and erase this e-mail message immediately.
From: Kristi Smith (JIRA) jira@workterra.atlassian.net
Sent: Wednesday, November 30, 2016 1:32 PM
To: Cathleen Harrington <cathleen.harrington@ebsbenefits.com>
Subject: [JIRA] (WT-6731) ACA WT FTE Rpt Questions
[cid:image003.png@01D24B0F.3AB181F0]
Kristi Smith<https://workterra.atlassian.net/secure/ViewProfile.jspa?name=kristi.smith> commented on [Support Activity] WT-6731<https://workterra.atlassian.net/browse/WT-6731>
Re: ACA WT FTE Rpt Questions<https://workterra.atlassian.net/browse/WT-6731>
Monika Demla<https://workterra.atlassian.net/secure/ViewProfile.jspa?name=Monika.Demla> Can you please verify the notes from Nandkumar above regarding the ACA hours load?
[Add Comment]<https://workterra.atlassian.net/browse/WT-6731#add-comment>
Add Comment<https://workterra.atlassian.net/browse/WT-6731#add-comment>
This message was sent by Atlassian JIRA (v1000.586.0#100022-sha1:8faca49)
[Atlassian logo]
Nandkumar Prabhakar Karlekar Monika has updated all of the ACA hours. Do you want me to send you a zip of those files? The Client wants to know which of their PT employees are eligible for OE this year. OE opens 12/5/16.
Hi Kristi Smith and Cathleen Harrington
I have scanned this company and only 336 employees only , Please load the complete timesheet so system will provide you this report.
Note: There is no sufficient time sheet data loaded into the system so system is unable to provide the specified report.
THe client sends only hours for part time and extra board class to determine if they are eligible for benefits. Is that the 336 people you are referring to? They believe there are only about 5 people that may be eligible in 2017.
Hi Kristi Smith
We have processed all the data loaded into the system. There is no any employees present whose weekly average is greater then 24 hours.
So we have not found a single employee whose is eligible for 2017 stability period for benefits.
Thanks
Nandkumar
Template Used to Load files is:
Files received has only worked hours.
Nandkumar Prabhakar Karlekar Thank you for the information. What does the client need to send so the reporting is correct? Were they wrong information or is it correct and the reporting is reflecting that way. I don't know how to answer their questions below.
On the first attachment it shows some employees with average monthly hours of 173.82 or 347.66. What does this report mean?
2. The attachment report reflects FTE hours. Is this the report I use to determine eligibility for part time/extra board employees?
3. Does either report show me the average hours worked per month for the calendar year 2016?
4. Are the average hours calculated on the basis of a 12 month period, even if the employee worked less than a 12-month period (e.g. new hire who worked 5 months in 2016)?
Please look into this.
can you please provide the Complete set of files you imported. and send the password to Wt_ACa@harbingergroup.com
ok, I will be sending you complete folder at Wt_ACa@harbingergroup.com
Hi Monika Demla, Cathleen Harrington
We have loaded all provided time sheet on HSPL copy of Mesquite gaming company.
Total employee in company are 1981 but time sheet is provided only for 306 employees.
So as per time sheet none of the employees are eligible for 2017 stability period for benefits.
Below are the answers for your queries.
For point 1 and 2 below is the answer :
Some Employees shown with average monthly hours as 173.82 or 347.66 are those employees who do not have timesheet or are new hire employee who are in thier inital measurement period. As per their employee type and Number of worked hours set on Demographics,173.82 or 347.66 values are calculated.
EE's whose worked hours per week is not set but employee type is set to full time or not set ,then such EE's average monthly hours is set as 173.82.
EE's whose worked hours per week is not set but employee type is set to part time ,then such EE's average monthly hours is set as 86.91.
EE's whose worked hours per week is set then such EE's average monthly hours is calculated as (WorkedHrsPerWeek/7.0)*30.42
So EE's whose worked hours per week is set to 80 ,their average monthly hours is 347.66.
For point 3 and 4 below is the answer
Average hours is calculated as per interval set on measurement and stability period.
eg: if employee time sheet is present for the whole year and if measurement and stability interval is set as 3 months,then Average hours is calculated in the interval of 3 of the months. i.e 1/1/2016 -3/31/2016 ,4/1/2016-6/30/2016,7/1/2016-9/30/2016,10/1/2016-12/31/2016
In case of New Hire employee,we consider employee type and Number of worked hours set on Demographic for their initial measurement period.
Thanks,
Sachin Hingole
shyam sharma Nandkumar Prabhakar Karlekar Rakesh Roy Ramya Tantry Smita Pawar
Sachin Hingole (Inactive)
added a comment - Hi Monika Demla , Cathleen Harrington
We have loaded all provided time sheet on HSPL copy of Mesquite gaming company.
Total employee in company are 1981 but time sheet is provided only for 306 employees.
So as per time sheet none of the employees are eligible for 2017 stability period for benefits.
Below are the answers for your queries.
For point 1 and 2 below is the answer :
Some Employees shown with average monthly hours as 173.82 or 347.66 are those employees who do not have timesheet or are new hire employee who are in thier inital measurement period. As per their employee type and Number of worked hours set on Demographics,173.82 or 347.66 values are calculated.
EE's whose worked hours per week is not set but employee type is set to full time or not set ,then such EE's average monthly hours is set as 173.82.
EE's whose worked hours per week is not set but employee type is set to part time ,then such EE's average monthly hours is set as 86.91.
EE's whose worked hours per week is set then such EE's average monthly hours is calculated as (WorkedHrsPerWeek/7.0)*30.42
So EE's whose worked hours per week is set to 80 ,their average monthly hours is 347.66.
For point 3 and 4 below is the answer
Average hours is calculated as per interval set on measurement and stability period.
eg: if employee time sheet is present for the whole year and if measurement and stability interval is set as 3 months,then Average hours is calculated in the interval of 3 of the months. i.e 1/1/2016 -3/31/2016 ,4/1/2016-6/30/2016,7/1/2016-9/30/2016,10/1/2016-12/31/2016
In case of New Hire employee,we consider employee type and Number of worked hours set on Demographic for their initial measurement period.
Thanks,
Sachin Hingole
shyam sharma Nandkumar Prabhakar Karlekar Rakesh Roy Ramya Tantry Smita Pawar 
Hi Cathleen Harrington
As per analysis, Time and attendance data is not loaded in the system properly, can you please provide the complete 2016 time import files so we will import and let you know the average working hours for weekly and monthly for complete year 2016.
Note : Only 322 employees time sheet data is loaded in to the system so system is referring data from employee demographic page.