-
Type:
Change Request
-
Status: Production Complete
-
Priority:
Critical
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: BenAdmin
-
Labels:None
-
Module:BenAdmin - SSO
-
Reported by:Client
-
Item State:Production Complete - Closed
-
Sprint:WT Sprint 38 - Enhancement
-
Severity:Simple
I am putting the only part from attached xml , which is required here to understand the issue.
See below : The XML which we received has three <Application/> nodes , separately for every individual enrollment . This employee has enrolled for himself and two children’s separately in a single product(ProductID="13811").
As we all agreed that, Workterra should receive only Single plan enrollment details(Single <Application> node) for which employee gone from Workterra to Selerix. In Workterra we have configured single plan for “LBT” , which allows Spouse and Children enrollment along with employee enrollment. From Workterra we send employee , spouse and child demographic details to Selerix.
For Critical Illness and Accident plans, we are receiving the proper response. Even for LBT plan we were receiving proper response till date, but after this enrollment , our QA did detail level testing for this plan and they observed that “LBT” plan has lots of customizations on Selerix portal ,which can result multiple scenarios , mentioning few below:
1)Employee can enroll for himself, Spouse and Child differently.
2)Spouse can enroll for herself, Employee and Child differently.
<Applications>
<Application>
<Coverage ProductID="13811">
<Tier>Employee Only</Tier>
<DeductionFrequency>26</DeductionFrequency>
<EmployeeCost>9.6200</EmployeeCost>
<PreTaxEmployeeCost>0.0000</PreTaxEmployeeCost>
<PostTaxEmployeeCost>9.6200</PostTaxEmployeeCost>
<EmployerCost>0.0000</EmployerCost>
<BenefitAmount>25000.0000</BenefitAmount>
</Coverage>
</Application>
<Application>
<Coverage ProductID="13811">
<Tier>Children Only</Tier>
<DeductionFrequency>26</DeductionFrequency>
<EmployeeCost>6.0000</EmployeeCost>
<PreTaxEmployeeCost>0.0000</PreTaxEmployeeCost>
<PostTaxEmployeeCost>6.0000</PostTaxEmployeeCost>
<EmployerCost>0.0000</EmployerCost>
<BenefitAmount>25000.0000</BenefitAmount>
</Coverage>
</Application>
<Application>
<Coverage ProductID="13811">
<Tier>Children Only</Tier>
<DeductionFrequency>26</DeductionFrequency>
<EmployeeCost>6.0000</EmployeeCost>
<PreTaxEmployeeCost>0.0000</PreTaxEmployeeCost>
<PostTaxEmployeeCost>6.0000</PostTaxEmployeeCost>
<EmployerCost>0.0000</EmployerCost>
<BenefitAmount>25000.0000</BenefitAmount>
</Coverage>
</Application>
</Applications>
Solution :
We should change our code such way that , read all <Application> nodes against single product(ProductID="13811"), and combine the cost of each and show it against employee cost in Workterra, but show Coverage’s for every individual (EE, SP, CH) separately. As Workterra System allows Separate Coverage’s for all enrolled entities(EE,SP,CH) in Single plan , but doesn’t allow to enter individual cost in single plan.
- relates to
-
WT-9614 Nexion-Selerix Enrollment Service Integration for CHUBB through SSO
-
- Closed
-
-
- Time Spent:
- 9h
-
analysis, scenario discussion, coding ,client communcation
Field | Original Value | New Value |
---|---|---|
Attachment | RE Nexion - Keena James - LBT enrollment Scenarion - Need feedback on priority !.msg [ 62617 ] |
Remaining Estimate | 18h [ 64800 ] | 21h [ 75600 ] |
Original Estimate | 18h [ 64800 ] | 21h [ 75600 ] |
Item State | Parent values: Development(10200)Level 1 values: In Analysis(10204) |
Assignee | Santosh Balid [ santosh.balid ] | Aditya Vishwakarma [ aditya.vishwakarma ] |
QA | Kunal Kedari [ kunal.kedari ] |
Attachment | LBT_CostandCoverage.jpg [ 62618 ] |
Remaining Estimate | 21h [ 75600 ] | 18h [ 64800 ] |
Time Spent | 3h [ 10800 ] | |
Worklog Id | 81207 [ 81207 ] |
Summary | Show coverage Tierwise(EE,SP,CH) and sum up the cost of all against Employee Cost | Selerix -Show coverage Tier wise (EE,SP,CH) and sum up the cost of all against Employee Cost |
-
- Time Spent:
- 6h
-
analysis and Coding
-
- Time Spent:
- 1h
-
code checkin on stage and production
Component/s | BenAdmin [ 10000 ] | |
Dev Due Date | 28/Sep/2017 | |
Item State | Parent values: Development(10200)Level 1 values: In Analysis(10204) | Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) |
Module | Parent values: BenAdmin(10100) | Parent values: BenAdmin(10100)Level 1 values: SSO(11500) |
Sprint | WT Sprint 38 - Enhancement [ 88 ] |
Remaining Estimate | 18h [ 64800 ] | 12h [ 43200 ] |
Time Spent | 3h [ 10800 ] | 9h [ 32400 ] |
Worklog Id | 82122 [ 82122 ] |
Worklog Id | 82122 [ 82122 ] |
Remaining Estimate | 12h [ 43200 ] | 11h [ 39600 ] |
Time Spent | 9h [ 32400 ] | 10h [ 36000 ] |
Worklog Id | 82123 [ 82123 ] |
Worklog Id | 82123 [ 82123 ] |
Remaining Estimate | 11h [ 39600 ] | 2h [ 7200 ] |
Time Spent | 10h [ 36000 ] | 19h [ 68400 ] |
Worklog Id | 82125 [ 82125 ] |
Worklog Id | 82125 [ 82125 ] |
Remaining Estimate | 2h [ 7200 ] | 0h [ 0 ] |
Time Spent | 19h [ 68400 ] | 27.3h [ 98280 ] |
Worklog Id | 82126 [ 82126 ] |
Time Spent | 27.3h [ 98280 ] | 31.3h [ 112680 ] |
Worklog Id | 82128 [ 82128 ] |
Remaining Estimate | 0h [ 0 ] | 4h [ 14400 ] |
Time Spent | 31.3h [ 112680 ] | 27.3h [ 98280 ] |
Worklog Id | 82128 [ 82128 ] | |
Worklog Time Spent | 4h [ 14400 ] |
Status | New Request [ 10029 ] | Pending for Approval [ 10002 ] |
Status | Pending for Approval [ 10002 ] | Approved for Development [ 10003 ] |
Attachment | LBTPlanCosts.jpg [ 62978 ] |
Status | Approved for Development [ 10003 ] | In Development [ 10007 ] |
Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
Status | Local Testing [ 10200 ] | Pending for Stage Approval [ 10300 ] |
Status | Pending for Stage Approval [ 10300 ] | Approved for Stage [ 10030 ] |
Status | Approved for Stage [ 10030 ] | Stage Testing [ 10201 ] |
Status | Stage Testing [ 10201 ] | Pending for Production Approval [ 10301 ] |
Status | Pending for Production Approval [ 10301 ] | Approved for production [ 10034 ] |
Status | Approved for production [ 10034 ] | Production Testing [ 10202 ] |
Assignee | Aditya Vishwakarma [ aditya.vishwakarma ] | Kunal Kedari [ kunal.kedari ] |
Item State | Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) | Parent values: Production QA(10203)Level 1 values: In Testing(10218) |
Item State | Parent values: Production QA(10203)Level 1 values: In Testing(10218) | Parent values: Production Complete(10222)Level 1 values: Closed(10223) |
Resolution | Done [ 10000 ] | |
Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
Assignee | Kunal Kedari [ kunal.kedari ] | Debbie Kulling [ dkulling ] |
-
- Time Spent:
- 2.5h
-
Code deployment , testing and discussion
Remaining Estimate | 4h [ 14400 ] | 2h [ 7200 ] |
Time Spent | 27.3h [ 98280 ] | 29.3h [ 105480 ] |
Worklog Id | 82409 [ 82409 ] |
Remaining Estimate | 2h [ 7200 ] | 0h [ 0 ] |
Time Spent | 29.3h [ 105480 ] | 31.8h [ 114480 ] |
Worklog Id | 82410 [ 82410 ] |
Transition | Time In Source Status | Execution Times |
---|
|
2d 17h 23m | 1 |
|
3s | 1 |
|
18m 50s | 1 |
|
3s | 1 |
|
3s | 1 |
|
2s | 1 |
|
2s | 1 |
|
4s | 1 |
|
3s | 1 |
|
2s | 1 |
|
2m 8s | 1 |
Hello Aditya Vishwakarma,
We have committed 09/29 date to client, please start work on it tomorrow on high priority.
Putting below queries for your reference purpose, which are required to resolve the issue.
we need to deliver this by considering every plan, it should be a generic fix , no hard coding.
select * from Employee_DependentChild where EmployeeID =1883
--insert into Employee_Enrollment_Coverage_Intermediate (Employee_Enrollment_IntermediateID, MemberTypeID, MemberID,IsIntermediateTableID, AppliedCoverageAmount,ApprovedCoverageAmount,
--IsEOIPending,BuyUpAmount,IsCompanyUser, UserID,DateTimeStamp,ApprovedERCoverageAmount, SalaryIndex)
--values (1187,3,631,0,25000.0000000000,25000.0000000000,0,0.0000000000,0,5116,GETDATE(),0.0000000000,0)
select * from RateChanges_Log_Intermediate where employeeid=1883 and plandesignid in (47,48,49)
--update RateChanges_Log_Intermediate set EmployeePostTax ='59.8433333333' where id =1318
select CoverageString,* from Employee_Enrollment_Intermediate where EmployeeID =1883 and plandesignid in (47,48,49)
--update Employee_Enrollment_Intermediate set CoverageString ='1~1883~0~25000.0000~25000.0000~0~0~0|3~526~0~25000.0000~25000.0000~0~0~0|3~624~0~25000.0000~25000.0000~0~0~0|3~631~0~25000.0000~25000.0000~0~0~0' where id ='1187'
Please raise risk on time(tomorrow itself), if you think it is not achievable.
Regards,
Santosh
Cc: Samir, Satya, Jaideep Vinchurkar, Prasad Pise, Kunal Kedari