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