Uploaded image for project: 'WORKTERRA'
  1. WORKTERRA
  2. WT-11273

Selerix -Show coverage Tier wise (EE,SP,CH) and sum up the cost of all against Employee Cost

    Details

    • 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

      Description

      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.

        Attachments

          Issue Links

            Activity

            Hide
            santosh.balid Santosh Balid (Inactive) added a comment -

            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

            Show
            santosh.balid Santosh Balid (Inactive) added a comment - 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
            Hide
            santosh.balid Santosh Balid (Inactive) added a comment -

            Show
            santosh.balid Santosh Balid (Inactive) added a comment -
            Hide
            aditya.vishwakarma Aditya Vishwakarma (Inactive) added a comment -

            Hello
            We are done with this development.
            As per now we have covered the
            following tiers in case of multiple Node
            1) Individual Enrollment for Each member
            2) Combination of one or more member in single tag. provided included member in combination will not have separate individual Enrollment tag.

            Show
            aditya.vishwakarma Aditya Vishwakarma (Inactive) added a comment - Hello We are done with this development. As per now we have covered the following tiers in case of multiple Node 1) Individual Enrollment for Each member 2) Combination of one or more member in single tag. provided included member in combination will not have separate individual Enrollment tag.
            Hide
            kunal.kedari Kunal Kedari (Inactive) added a comment -

            Hi Aditya Vishwakarma,

            We have verified this change on Production.

            Verified following scenarios for LTB plan:
            1] Enroll with Employee node only
            2] Enroll with Employee/Spouse nodes
            3] Enroll with Employee/Spouse/Child One nodes
            4] Enroll with Employee/Spouse/Child One node/Child Two nodes
            5] Verify cost and coverages are displaying properly on Enroll Now, Enrollment Summary, Confirmation Statement page
            6] We have also verified waive functionality for LTB plan
            7] Enrolled in other plans (e.g. Critical Illness and Accident) and verified the costs are displaying properly.

            Cc: Prasad Pise, Jaideep Vinchurkar, Santosh Balid, Samir

            Cost is displaying as combine and coverages are displaying separately. Refer below screenshot for more details:

            Show
            kunal.kedari Kunal Kedari (Inactive) added a comment - Hi Aditya Vishwakarma , We have verified this change on Production. Verified following scenarios for LTB plan: 1] Enroll with Employee node only 2] Enroll with Employee/Spouse nodes 3] Enroll with Employee/Spouse/Child One nodes 4] Enroll with Employee/Spouse/Child One node/Child Two nodes 5] Verify cost and coverages are displaying properly on Enroll Now, Enrollment Summary, Confirmation Statement page 6] We have also verified waive functionality for LTB plan 7] Enrolled in other plans (e.g. Critical Illness and Accident) and verified the costs are displaying properly. Cc: Prasad Pise , Jaideep Vinchurkar , Santosh Balid , Samir Cost is displaying as combine and coverages are displaying separately. Refer below screenshot for more details:
            Hide
            kunal.kedari Kunal Kedari (Inactive) added a comment -

            Hi Debbie Kulling,

            We have deployed and verified this change on Production.

            Cc: Aditya Vishwakarma, Jaideep Vinchurkar, Santosh Balid, Samir, Prasad Pise

            Show
            kunal.kedari Kunal Kedari (Inactive) added a comment - Hi Debbie Kulling , We have deployed and verified this change on Production. Cc: Aditya Vishwakarma , Jaideep Vinchurkar , Santosh Balid , Samir , Prasad Pise
            Hide
            santosh.balid Santosh Balid (Inactive) added a comment -

            Hi Debbie Kulling,

            Could you please follow-up with Client and close this ticket if Client has no issue.

            Regards,
            Santosh

            Show
            santosh.balid Santosh Balid (Inactive) added a comment - Hi Debbie Kulling , Could you please follow-up with Client and close this ticket if Client has no issue. Regards, Santosh

              People

              Assignee:
              dkulling Debbie Kulling
              Reporter:
              santosh.balid Santosh Balid (Inactive)
              Account Executive:
              Debbie Kulling
              Developer:
              Aditya Vishwakarma (Inactive)
              QA:
              Kunal Kedari (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 21h Original Estimate - 21h
                  21h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 31.8h
                  31.8h