WORKTERRAProject Type: software

WORKTERRA

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

University Health - Issue in rates calculation

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Environment:
      Production
    • Bug Type:
      Functional
    • Bug Severity:
      Critical
    • Module:
      BenAdmin - Enrollment
    • Reported by:
      Harbinger
    • Company:
      University Health
    • Item State:
      Production Complete - Closed
    • Sprint:
      WT Sprint 39 - Bugs, WT Sprint 40 - Bugs

      Attachments

        Activity

        Ascending order - Click to sort in descending order
        Permalink
        jyoti.mayne Jyoti Mayne logged work - 17/Oct/17 09:51 AM
        • Time Spent:
          0.5h
           

          root cause checking

        Permalink
        jyoti.mayne Jyoti Mayne logged work - 17/Oct/17 10:00 AM
        • Time Spent:
          1h
           

          reproducing issue, code fix and reply to amruta

        Permalink
        jyoti.mayne Jyoti Mayne logged work - 18/Oct/17 10:25 AM - edited
        • Time Spent:
          0.75h
           

          testing on production and code fix

        amruta.lohiya Amruta Lohiya created issue -
        amruta.lohiya Amruta Lohiya made changes -
        Field Original Value New Value
        Assignee Satya [ ID10004 ] Umesh Kadam [ umesh.kadam ]
        umesh.kadam Umesh Kadam (Inactive) made changes -
        Dev Due Date 19/Oct/2017
        Developer Umesh Kadam [ umesh.kadam ]
        Sprint WT Sprint 39 - Bugs [ 90 ]
        umesh.kadam Umesh Kadam (Inactive) made changes -
        Status Open [ 1 ] In Development [ 10007 ]
        khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
        Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
        umesh.kadam Umesh Kadam (Inactive) made changes -
        Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Development(10200)Level 1 values: In Progress(10206)
        Permalink
        umesh.kadam Umesh Kadam (Inactive) logged work - 19/Oct/17 04:30 PM
        • Time Spent:
          5h
           

          Analysis
          Discussion with Amruta
          Unit Testing
          Stage deployment and smoke testing
          Production deployment and smoke testing

        umesh.kadam Umesh Kadam (Inactive) made changes -
        Remaining Estimate 0h [ 0 ]
        Time Spent 5h [ 18000 ]
        Worklog Id 86433 [ 86433 ]
        jyoti.mayne Jyoti Mayne made changes -
        Assignee Umesh Kadam [ umesh.kadam ] Jyoti Mayne [ jyoti.mayne ]
        jyoti.mayne Jyoti Mayne made changes -
        Developer Umesh Kadam [ umesh.kadam ] Jyoti Mayne [ jyoti.mayne ]
        jyoti.mayne Jyoti Mayne made changes -
        Code Review Date 19/Oct/2017
        Root Cause Scenario/Requirement Missed [ 18432 ]
        Sprint WT Sprint 39 - Bugs [ 90 ] WT Sprint 39 - Bugs, WT Sprint 40 - Bugs [ 90, 94 ]
        Original Estimate 0h [ 0 ]
        jyoti.mayne Jyoti Mayne made changes -
        Dev Due Date 19/Oct/2017 26/Oct/2017
        jyoti.mayne Jyoti Mayne made changes -
        Code Reviewed By Amruta Lohiya [ 11906 ]
        jyoti.mayne Jyoti Mayne made changes -
        Time Spent 5h [ 18000 ] 5.5h [ 19800 ]
        Worklog Id 86647 [ 86647 ]
        jyoti.mayne Jyoti Mayne made changes -
        Time Spent 5.5h [ 19800 ] 6.5h [ 23400 ]
        Worklog Id 86655 [ 86655 ]
        jyoti.mayne Jyoti Mayne made changes -
        Time Spent 6.5h [ 23400 ] 7.5h [ 27000 ]
        Worklog Id 86673 [ 86673 ]
        jyoti.mayne Jyoti Mayne made changes -
        Remaining Estimate 0h [ 0 ] 0.25h [ 900 ]
        Time Spent 7.5h [ 27000 ] 7.25h [ 26100 ]
        Worklog Id 86673 [ 86673 ]
        khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
        Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
        Permalink
        jyoti.mayne Jyoti Mayne logged work - 26/Oct/17 11:57 AM
        • Time Spent:
          0.5h
           

          LB code check-in and JIRA Update

        Hide
        Permalink
        jyoti.mayne Jyoti Mayne added a comment - - edited

        Hi Hrishikesh Deshpande, Prasad Pise

        Concern: EE 'MILLIE KING' is not getting rate for plan 'Spouse AD&D'

        Cause: If EE is having dead record in rates table, then rate is not getting calculated with SA Utility

        Correction: We have fixed code for this.

        Impact Testing:
        1. calculate rate having more than one dead record
        2. rates table are properly terminated like 1/1/17 to 12/31/17 and then recal rate for 2018 year
        3. No rate is present and recal 2018 rate

        • create 2018 new rate and try out all three scenarios
        • extend 2017 old rate termination date to 12/31/2018 and try out all three scenarios
          Cc: Amruta Lohiya
        Show
        jyoti.mayne Jyoti Mayne added a comment - - edited Hi Hrishikesh Deshpande , Prasad Pise Concern: EE 'MILLIE KING' is not getting rate for plan 'Spouse AD&D' Cause: If EE is having dead record in rates table, then rate is not getting calculated with SA Utility Correction: We have fixed code for this. Impact Testing: 1. calculate rate having more than one dead record 2. rates table are properly terminated like 1/1/17 to 12/31/17 and then recal rate for 2018 year 3. No rate is present and recal 2018 rate create 2018 new rate and try out all three scenarios extend 2017 old rate termination date to 12/31/2018 and try out all three scenarios Cc: Amruta Lohiya
        jyoti.mayne Jyoti Mayne made changes -
        Assignee Jyoti Mayne [ jyoti.mayne ] Hrishikesh Deshpande [ hrishikesh.deshpande ]
        Jennifer.Reed Jennifer Reed (Inactive) made changes -
        Reported by Support (Workterra) [ 10350 ] Harbinger [ 10700 ]
        jyoti.mayne Jyoti Mayne made changes -
        Remaining Estimate 0.25h [ 900 ] 0h [ 0 ]
        Time Spent 7.25h [ 26100 ] 7.75h [ 27900 ]
        Worklog Id 87158 [ 87158 ]
        hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
        Assignee Hrishikesh Deshpande [ hrishikesh.deshpande ] Rashmita Dudhe [ rashmita.dudhe ]
        rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
        Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
        rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
        Status In Development [ 10007 ] Local Testing [ 10200 ]
        Permalink
        rashmita.dudhe Rashmita Dudhe (Inactive) logged work - 31/Oct/17 11:31 AM
        • Time Spent:
          4h
           

          LB testing Scenario to cal rate it will take too much time for more than 4000 employee

        Hide
        Permalink
        rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

        Verified on Lb environment consider scenarios:
        1]Recal rate through Sa utility for dead rate entry in the table.
        2]Recal Rate through Sa utility for extend and recalculation more than 4000 thousand employees
        (rate effective date 01/01/2017 termination date 12/31/2018)

        3]Recal rate through Sa utility for a new rate and new plan with effective date 01/01/2018 term date 12/31/2018
        4]Cross verified on ui confirmation Statment, View enrollment summary.
        5]verified by adding a new employee and using existing
        working fine as expected

        Show
        rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Verified on Lb environment consider scenarios: 1]Recal rate through Sa utility for dead rate entry in the table. 2]Recal Rate through Sa utility for extend and recalculation more than 4000 thousand employees (rate effective date 01/01/2017 termination date 12/31/2018) 3]Recal rate through Sa utility for a new rate and new plan with effective date 01/01/2018 term date 12/31/2018 4]Cross verified on ui confirmation Statment, View enrollment summary. 5]verified by adding a new employee and using existing working fine as expected
        rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
        Time Spent 7.75h [ 27900 ] 11.75h [ 42300 ]
        Worklog Id 88170 [ 88170 ]
        jyoti.mayne Jyoti Mayne made changes -
        Labels Rate_Calculation
        hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
        Attachment Alignement.png [ 66308 ]
        hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
        Attachment Alignement.png [ 66308 ]
        rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
        Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
        khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
        Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
        Permalink
        rashmita.dudhe Rashmita Dudhe (Inactive) logged work - 02/Nov/17 11:16 AM
        • Time Spent:
          4h
           

          Stage testing

        Hide
        Permalink
        rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

        Verified on Stage environment consider scenarios:
        1]Recal rate through Sa utility for dead rate entry in the table.
        2]Recal Rate through Sa utility for extend and recalculation more than 4000 thousand employees
        (rate effective date 01/01/2017 termination date 12/31/2018)
        3]Recal rate through Sa utility for a new rate and new plan with effective date 01/01/2018 term date 12/31/2018
        4]Cross verified on ui confirmation Statment, View enrollment summary.
        5]verified by adding a new employee and using existing
        working fine as expected

        Show
        rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Verified on Stage environment consider scenarios: 1]Recal rate through Sa utility for dead rate entry in the table. 2]Recal Rate through Sa utility for extend and recalculation more than 4000 thousand employees (rate effective date 01/01/2017 termination date 12/31/2018) 3]Recal rate through Sa utility for a new rate and new plan with effective date 01/01/2018 term date 12/31/2018 4]Cross verified on ui confirmation Statment, View enrollment summary. 5]verified by adding a new employee and using existing working fine as expected
        rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
        Time Spent 11.75h [ 42300 ] 15.75h [ 56700 ]
        Worklog Id 88771 [ 88771 ]
        rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
        Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
        rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
        Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
        Permalink
        jyoti.mayne Jyoti Mayne logged work - 02/Nov/17 03:41 PM
        • Time Spent:
          0.25h
           

          Stage code check-in

        satyap Satya made changes -
        Environment_New Production [ 18442 ]
        khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
        Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
        Permalink
        snehal.shabade Snehal Shabade (Inactive) logged work - 04/Nov/17 12:14 PM
        • Time Spent:
          0.25h
           

          Production Check-in

        snehal.shabade Snehal Shabade (Inactive) made changes -
        Time Spent 15.75h [ 56700 ] 16h [ 57600 ]
        Worklog Id 89091 [ 89091 ]
        rakeshr Rakesh Roy (Inactive) made changes -
        Attachment sanity_pass.png [ 66863 ]
        rakeshr Rakesh Roy (Inactive) made changes -
        Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
        Permalink
        prasadp Prasad Pise (Inactive) logged work - 04/Nov/17 04:01 PM
        • Time Spent:
          1h
           

          Understanding and Produciton Testing
          Discussion with Jaideep, rashmita

        prasadp Prasad Pise (Inactive) made changes -
        Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
        prasadp Prasad Pise (Inactive) made changes -
        Time Spent 16h [ 57600 ] 17h [ 61200 ]
        Worklog Id 89116 [ 89116 ]
        rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
        Resolution Fixed [ 1 ]
        Status Production Testing [ 10202 ] Production Complete [ 10028 ]
        rashmita.dudhe Rashmita Dudhe (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)
        rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
        Status Production Complete [ 10028 ] Closed [ 6 ]
        jyoti.mayne Jyoti Mayne made changes -
        Time Spent 17h [ 61200 ] 17.25h [ 62100 ]
        Worklog Id 90025 [ 90025 ]
        Transition Time In Source Status Execution Times
        Umesh Kadam (Inactive) made transition -
        Open In Development
        		13h 52m 1
        Rashmita Dudhe (Inactive) made transition -
        In Development In LB Testing
        		11d 23h 7m 1
        Rashmita Dudhe (Inactive) made transition -
        In LB Testing Stage Testing
        		2d 5h 19m 1
        Rakesh Roy (Inactive) made transition -
        Stage Testing In Production Testing
        		2d 2h 40m 1
        Rashmita Dudhe (Inactive) made transition -
        In Production Testing Production Complete
        		2d 15h 25m 1
        Rashmita Dudhe (Inactive) made transition -
        Production Complete Closed
        		17s 1

          People

          Assignee:
          rashmita.dudhe Rashmita Dudhe (Inactive)
          Reporter:
          amruta.lohiya Amruta Lohiya
          Developer:
          Jyoti Mayne
          Votes:
          0 Vote for this issue
          Watchers:
          3 Start watching this issue

            Dates

            Created:
            Updated:
            Resolved:
            Dev Due Date:
            Code Review Date:

              Time Tracking

              Estimated:
              Original Estimate - 0h
              0h
              Remaining:
              Remaining Estimate - 0h
              0h
              Logged:
              Time Spent - 17.25h
              17.25h