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

            santosh.balid Santosh Balid (Inactive) created issue -
            santosh.balid Santosh Balid (Inactive) made changes -
            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 ]
            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
            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 ]
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Attachment LBTPlanCosts.jpg [ 62978 ]
            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 ]
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Assignee Kunal Kedari [ kunal.kedari ] Debbie Kulling [ dkulling ]
            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 ]

              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