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

ok, I will be sending you complete folder at Wt_ACa@harbingergroup.com

Monika Demla

can you please provide the Complete set of files you imported. and send the password to Wt_ACa@harbingergroup.com

Hi Sachin Hingole

Please look into this.

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)?