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

            aditya.vishwakarma Aditya Vishwakarma (Inactive) logged work - 24/Sep/17 06:30 PM
            • Time Spent:
              8.3h
               
              <No comment>
            avnish.yadav Avnish Yadav (Inactive) logged work - 25/Sep/17 05:03 PM
            • Time Spent:
              2h
               
              <No comment>
            aditya.vishwakarma Aditya Vishwakarma (Inactive) logged work - 25/Sep/17 06:30 PM - edited
            • Time Spent:
              9h
               

              analysis, scenario discussion, coding ,client communcation

            santosh.balid Santosh Balid (Inactive) created issue -
            santosh.balid Santosh Balid (Inactive) made changes -
            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
            santosh.balid Santosh Balid (Inactive) made changes -
            Remaining Estimate 18h [ 64800 ] 21h [ 75600 ]
            Original Estimate 18h [ 64800 ] 21h [ 75600 ]
            santosh.balid Santosh Balid (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
            santosh.balid Santosh Balid (Inactive) made changes -
            Assignee Santosh Balid [ santosh.balid ] Aditya Vishwakarma [ aditya.vishwakarma ]
            santosh.balid Santosh Balid (Inactive) made changes -
            QA Kunal Kedari [ kunal.kedari ]
            santosh.balid Santosh Balid (Inactive) made changes -
            Attachment LBT_CostandCoverage.jpg [ 62618 ]
            Hide
            santosh.balid Santosh Balid (Inactive) added a comment -

            Show
            santosh.balid Santosh Balid (Inactive) added a comment -
            santosh.balid Santosh Balid (Inactive) made changes -
            Remaining Estimate 21h [ 75600 ] 18h [ 64800 ]
            Time Spent 3h [ 10800 ]
            Worklog Id 81207 [ 81207 ]
            santosh.balid Santosh Balid (Inactive) made changes -
            Link This issue relates to WT-9614 [ WT-9614 ]
            aditya.vishwakarma Aditya Vishwakarma (Inactive) made changes -
            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
            aditya.vishwakarma Aditya Vishwakarma (Inactive) logged work - 26/Sep/17 06:30 PM - edited
            • Time Spent:
              6h
               

              analysis and Coding

            aditya.vishwakarma Aditya Vishwakarma (Inactive) logged work - 26/Sep/17 06:30 PM - edited
            • Time Spent:
              1h
               

              code checkin on stage and production

            santosh.balid Santosh Balid (Inactive) logged work - 26/Sep/17 07:55 PM
            • Time Spent:
              3h
               
              <No comment>
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            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 ]
            aditya.vishwakarma Aditya Vishwakarma (Inactive) made changes -
            Remaining Estimate 18h [ 64800 ] 12h [ 43200 ]
            Time Spent 3h [ 10800 ] 9h [ 32400 ]
            Worklog Id 82122 [ 82122 ]
            aditya.vishwakarma Aditya Vishwakarma (Inactive) made changes -
            Worklog Id 82122 [ 82122 ]
            aditya.vishwakarma Aditya Vishwakarma (Inactive) made changes -
            Remaining Estimate 12h [ 43200 ] 11h [ 39600 ]
            Time Spent 9h [ 32400 ] 10h [ 36000 ]
            Worklog Id 82123 [ 82123 ]
            aditya.vishwakarma Aditya Vishwakarma (Inactive) made changes -
            Worklog Id 82123 [ 82123 ]
            aditya.vishwakarma Aditya Vishwakarma (Inactive) made changes -
            Remaining Estimate 11h [ 39600 ] 2h [ 7200 ]
            Time Spent 10h [ 36000 ] 19h [ 68400 ]
            Worklog Id 82125 [ 82125 ]
            aditya.vishwakarma Aditya Vishwakarma (Inactive) made changes -
            Worklog Id 82125 [ 82125 ]
            aditya.vishwakarma Aditya Vishwakarma (Inactive) made changes -
            Remaining Estimate 2h [ 7200 ] 0h [ 0 ]
            Time Spent 19h [ 68400 ] 27.3h [ 98280 ]
            Worklog Id 82126 [ 82126 ]
            aditya.vishwakarma Aditya Vishwakarma (Inactive) made changes -
            Time Spent 27.3h [ 98280 ] 31.3h [ 112680 ]
            Worklog Id 82128 [ 82128 ]
            aditya.vishwakarma Aditya Vishwakarma (Inactive) made changes -
            Remaining Estimate 0h [ 0 ] 4h [ 14400 ]
            Time Spent 31.3h [ 112680 ] 27.3h [ 98280 ]
            Worklog Id 82128 [ 82128 ]
            Worklog Time Spent 4h [ 14400 ]
            aditya.vishwakarma Aditya Vishwakarma (Inactive) made changes -
            Status New Request [ 10029 ] Pending for Approval [ 10002 ]
            aditya.vishwakarma Aditya Vishwakarma (Inactive) made changes -
            Status Pending for Approval [ 10002 ] Approved for Development [ 10003 ]
            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.
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Attachment LBTPlanCosts.jpg [ 62978 ]
            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:
            aditya.vishwakarma Aditya Vishwakarma (Inactive) made changes -
            Status Approved for Development [ 10003 ] In Development [ 10007 ]
            aditya.vishwakarma Aditya Vishwakarma (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            aditya.vishwakarma Aditya Vishwakarma (Inactive) made changes -
            Status Local Testing [ 10200 ] Pending for Stage Approval [ 10300 ]
            aditya.vishwakarma Aditya Vishwakarma (Inactive) made changes -
            Status Pending for Stage Approval [ 10300 ] Approved for Stage [ 10030 ]
            aditya.vishwakarma Aditya Vishwakarma (Inactive) made changes -
            Status Approved for Stage [ 10030 ] Stage Testing [ 10201 ]
            aditya.vishwakarma Aditya Vishwakarma (Inactive) made changes -
            Status Stage Testing [ 10201 ] Pending for Production Approval [ 10301 ]
            aditya.vishwakarma Aditya Vishwakarma (Inactive) made changes -
            Status Pending for Production Approval [ 10301 ] Approved for production [ 10034 ]
            aditya.vishwakarma Aditya Vishwakarma (Inactive) made changes -
            Status Approved for production [ 10034 ] Production Testing [ 10202 ]
            aditya.vishwakarma Aditya Vishwakarma (Inactive) made changes -
            Assignee Aditya Vishwakarma [ aditya.vishwakarma ] Kunal Kedari [ kunal.kedari ]
            kunal.kedari Kunal Kedari (Inactive) made changes -
            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)
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Resolution Done [ 10000 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            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
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Assignee Kunal Kedari [ kunal.kedari ] Debbie Kulling [ dkulling ]
            aditya.vishwakarma Aditya Vishwakarma (Inactive) logged work - 28/Sep/17 05:03 PM
            • Time Spent:
              2.5h
               

              Code deployment , testing and discussion

            avnish.yadav Avnish Yadav (Inactive) made changes -
            Remaining Estimate 4h [ 14400 ] 2h [ 7200 ]
            Time Spent 27.3h [ 98280 ] 29.3h [ 105480 ]
            Worklog Id 82409 [ 82409 ]
            aditya.vishwakarma Aditya Vishwakarma (Inactive) made changes -
            Remaining Estimate 2h [ 7200 ] 0h [ 0 ]
            Time Spent 29.3h [ 105480 ] 31.8h [ 114480 ]
            Worklog Id 82410 [ 82410 ]
            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
            Transition Time In Source Status Execution Times
            Aditya Vishwakarma (Inactive) made transition -
            New Request Pending for Approval
            2d 17h 23m 1
            Aditya Vishwakarma (Inactive) made transition -
            Pending for Approval Approved for Development
            3s 1
            Aditya Vishwakarma (Inactive) made transition -
            Approved for Development In Development
            18m 50s 1
            Aditya Vishwakarma (Inactive) made transition -
            In Development In LB Testing
            3s 1
            Aditya Vishwakarma (Inactive) made transition -
            In LB Testing Pending for Stage Approval
            3s 1
            Aditya Vishwakarma (Inactive) made transition -
            Pending for Stage Approval Approved for Stage
            2s 1
            Aditya Vishwakarma (Inactive) made transition -
            Approved for Stage Stage Testing
            2s 1
            Aditya Vishwakarma (Inactive) made transition -
            Stage Testing Pending for Production Approval
            4s 1
            Aditya Vishwakarma (Inactive) made transition -
            Pending for Production Approval Approved for production
            3s 1
            Aditya Vishwakarma (Inactive) made transition -
            Approved for production In Production Testing
            2s 1
            Kunal Kedari (Inactive) made transition -
            In Production Testing Production Complete
            2m 8s 1

              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