-
Type:
Support Activity
-
Status: Closed
-
Priority:
High
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: ACA
-
Labels:None
-
Support Task Type:ACA Data Audit
-
Reported by:Support
-
Company:CVHP
-
Module:BenAdmin
Hi Team,
CVHP would like to know how FT December employees were calculated. Can you send me that logic used to get to that number?
Thanks,
Kari
| Field | Original Value | New Value |
|---|---|---|
| Priority | Medium [ 3 ] | High [ 2 ] |
Hi Sonali Punse,
As per the bandwidth this is not possible in this week if it is urgent then please take the Dave's approval.
Hi Sachin Hingole,
Can you able to provide this logic with data.
Kari mejia There is no bandwidth to work on this now. If this is really required on high priority can you please take Dave's approval. Thanks!
| Assignee | Nandkumar [ satyap ] | Kari mejia [ karimejia@ebsbenefits.com ] |
Sachin Hingole (Inactive)
made changes -
| Assignee | Kari mejia [ karimejia@ebsbenefits.com ] | Sachin Hingole [ sachin.hingole ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
Sachin Hingole (Inactive)
made changes -
| Attachment | LookBackAndTimeSheet.png [ 18586 ] |
We have attached image for employee showing stable working hours.
Below are calculations for full time employee. If stable working hours for employee are equal to or greater than 30 then employee is full time.
1. Number of Days: Days in the range, refer image "LookBackAndTimeSheet.png"
2. Total Hours worked: Sum of All loaded worked hours
3. Number of weeks: Number of Days/7.0
From Start date 11/22/2015 to 12/05/2015 has 14 days and the total hours are 80, refer image 
Daily Average = 80/14 = 5.7143
The total Number of days in Dec =31
So Number of week in the month = 31/7 =4.428
Stable working Hours = (Daily Average * total Number of days)/ Number of week
= (5.7143*31)/ 4.428 = 40.0005
= 40.00
Sachin Hingole (Inactive)
added a comment - We have attached image for employee showing stable working hours.
Below are calculations for full time employee. If stable working hours for employee are equal to or greater than 30 then employee is full time.
1. Number of Days: Days in the range, refer image "LookBackAndTimeSheet.png"
2. Total Hours worked : Sum of All loaded worked hours
3. Number of weeks: Number of Days/7.0
From Start date 11/22/2015 to 12/05/2015 has 14 days and the total hours are 80, refer image
Daily Average = 80/14 = 5.7143
The total Number of days in Dec =31
So Number of week in the month = 31/7 =4.428
Stable working Hours = (Daily Average * total Number of days)/ Number of week
= (5.7143*31)/ 4.428 = 40.0005
= 40.00 Sachin Hingole (Inactive)
made changes -
| Assignee | Sachin Hingole [ sachin.hingole ] | Kari mejia [ karimejia@ebsbenefits.com ] |
| Resolution | Done [ 10000 ] | |
| Status | In Progress [ 3 ] | Resolved [ 5 ] |
| Status | Resolved [ 5 ] | Closed [ 6 ] |
| Transition | Time In Source Status | Execution Times |
|---|
Sachin Hingole (Inactive)
made transition
-
|
20h 43m | 1 |
Sachin Hingole (Inactive)
made transition
-
|
4m 59s | 1 |
|
20d 13h 25m | 1 |
Nandkumar Prabhakar Karlekar Can you please take this on priority, Client is expecting this by coming Friday. Thanks!