-
Type:
Bug
-
Status: Closed
-
Priority:
Critical
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Labels:None
-
Environment:Production
-
Bug Severity:Medium
-
Module:Exchange
-
Reported by:Support
-
Item State:Production Complete - Closed
-
Issue Importance:Must Have
Payroll deductions for Five Guys on production Exchange are mapped using Employee cost, the deductions are not correct because defined contributions are not being considered.
The EE deduction should be the total premium that is in the system with the Defined Contribution for that plan / tier subtracted out.
these are the actual deductions for Anthony Burch
Burch Anthony Bi-Weekly Dental Dental Low Plan $10.32
Burch Anthony Bi-Weekly Medical/Rx PPO 1000 $250.43
Burch Anthony Bi-Weekly Vision Vision Plan $3.03
The cost minus credit mapping is not correct for the defined contribution amounts
CC- Jyoti Mayne,Satya
| Field | Original Value | New Value |
|---|---|---|
| Description |
Payroll deductions for Five Guys on production Exchange are mapped using Employee cost, the deductions are not correct because defined contributions are not being considered. The EE deduction should be the total premium that is in the system with the Defined Contribution for that plan / tier subtracted out. these are the actual deductions for Anthony Burch Burch Anthony Bi-Weekly Dental Dental Low Plan $10.32 Burch Anthony Bi-Weekly Medical/Rx PPO 1000 $250.43 Burch Anthony Bi-Weekly Vision Vision Plan $3.03 The cost minus credit mapping is not correct for the defined contribution amounts |
Payroll deductions for Five Guys on production Exchange are mapped using Employee cost, the deductions are not correct because defined contributions are not being considered. The EE deduction should be the total premium that is in the system with the Defined Contribution for that plan / tier subtracted out. these are the actual deductions for Anthony Burch Burch Anthony Bi-Weekly Dental Dental Low Plan $10.32 Burch Anthony Bi-Weekly Medical/Rx PPO 1000 $250.43 Burch Anthony Bi-Weekly Vision Vision Plan $3.03 The cost minus credit mapping is not correct for the defined contribution amounts CC- [~jyoti.mayne],[~satyap] |
| Remaining Estimate | 24h [ 86400 ] | |
| Original Estimate | 24h [ 86400 ] |
| Remaining Estimate | 24h [ 86400 ] | 22h [ 79200 ] |
| Time Spent | 2h [ 7200 ] | |
| Worklog Id | 17565 [ 17565 ] |
| Status | Open [ 1 ] | In Development [ 10007 ] |
| Code Review Date | 06/Jan/2017 | |
| Code Reviewed By | Amruta Lohiya [ 11906 ] | |
| Developer | Avnish Yadav [ avnish.yadav ] |
| Item State | Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) |
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
Khandu Kshirsagar (Inactive)
made changes -
| Item State | Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
| Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) |
Below scenario tested on LB.
1) There are 3 defined contribution, Each one for Medical, Dental and vision.
2) When employee Enrolled in Medical then employee get contribution of Medical. When employee Enrolled in Dental then employee get contribution of Dental and When employee Enrolled in Vision then employee get contribution of Vision.
Ready for Stage.
| Assignee | Avnish Yadav [ avnish.yadav ] | Hrishikesh Deshpande [ hrishikesh.deshpande ] |
Khandu Kshirsagar (Inactive)
made changes -
| Item State | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
| Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) |
Khandu Kshirsagar (Inactive)
made changes -
| Item State | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) |
| Item State | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) |
| Item State | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) | Parent values: Production Complete(10222)Level 1 values: Closed(10223) |
This issue is Fixed on Stage and on Production. We have tested it from our end.
We have also corrected Anthony Burch employee record.
| Status | Local Testing [ 10200 ] | Stage Testing [ 10201 ] |
| Status | Stage Testing [ 10201 ] | Production Testing [ 10202 ] |
| Assignee | Hrishikesh Deshpande [ hrishikesh.deshpande ] | Rochelle Thomas [ rochelle.thomas ] |
| Resolution | Fixed [ 1 ] | |
| Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
| Remaining Estimate | 22h [ 79200 ] | 17h [ 61200 ] |
| Time Spent | 2h [ 7200 ] | 7h [ 25200 ] |
| Worklog Id | 17968 [ 17968 ] |
some employees are not calculating correctly
some of the employees not calculating correctly have recent election changes
here are some examples:
Carrie Pruitt
Arielle Anderson
Julian Thomas
Victoria Doll
these employees have 'defined contributions' for medical, dental and vision
'enrollment employee cost minus credits' is mapped in the export
Hi Guys - Please make sure we get some movement on this tonight 
Thanks!
jenni
Hi Rochelle Thomas,
We have recalculated Employer Defined Contribution on main. Now Defined Contribution cost is proper in Exchange and in export file.
Regarding File issue :- Export team fixed this issue in code (store procedure).
Could please verify this at your end and let us know in case of any issue/concern.
Thanks,
Avnish Y
there are employees being found with no 'defined contributions' showing on the screen
'enrollment summary' - this means their deduction amounts for payroll are incorrect
examples:
Amadou Taal
Matthew Whelan
John Perez
can it be insured that all five guys employees that qualify have their 'defined contributions'
I'm including this with this ticket because the issues are not resolved. There is also wt-6785 and opened by dev wt-8008
| Assignee | Rochelle Thomas [ rochelle.thomas ] | Avnish Yadav [ avnish.yadav ] |
Hi Rochelle Thomas,
Please refer our comment in WT-8008 for more details.
Thanks,
Avnish Y
CC- Jyoti Mayne,Satya
| Assignee | Avnish Yadav [ avnish.yadav ] | Rochelle Thomas [ rochelle.thomas ] |
| Remaining Estimate | 17h [ 61200 ] | 9h [ 32400 ] |
| Time Spent | 7h [ 25200 ] | 15h [ 54000 ] |
| Worklog Id | 21902 [ 21902 ] |
| Remaining Estimate | 9h [ 32400 ] | 3h [ 10800 ] |
| Time Spent | 15h [ 54000 ] | 21h [ 75600 ] |
| Worklog Id | 21929 [ 21929 ] |
| Worklog Id | 21929 [ 21929 ] |
| Status | Production Complete [ 10028 ] | Closed [ 6 ] |
| Bug Severity | Medium [ 16702 ] | |
| Code Review Date | 06/Jan/2017 | 06/Jan/2017 |
| Environment_New | Production [ 18442 ] |
| Transition | Time In Source Status | Execution Times |
|---|
|
19h 53m | 1 |
|
2m 10s | 1 |
|
6h 10m | 1 |
|
3s | 1 |
|
10s | 1 |
|
63d 2h 11m | 1 |
Hi Hrishikesh Deshpande,
Please refer below 3'c of this issue:-
Concern:- Five Guys - payroll deduction file - employee cost not considering defined contribution amounts
Cause:- One condition is missing in 'OES_UDF_CreditPool_MappedBenefitTypePlanDesignExchange' UDF for Benefit Type mapping in Employer Defined Contribution.
Correction:- We have used enrollment OES_UDF_CreditPool_MappedBenefitTypePlanDesign UDF for Benefit Type mapping in Employer Defined Contribution because both implementation are same.
Please verify above code fix at your end and let us know in case of any issue/concern.
Thanks,
Avnish Y
CC- Jyoti Mayne,Rakesh Roy,Satya,Vijay Siddha,Samir