WORKTERRAProject Type: software

WORKTERRA

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

RCF - Duplicate entries in inserted in RateChanges_log table during rate recalculation using SA utility

    Details

    • Type: Bug
    • Status: Closed
    • Priority: High
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Environment:
      Production
    • Module:
      BenAdmin - Enrollment
    • Reported by:
      Harbinger
    • Item State:
      Development - In Analysis
    • Issue Importance:
      Must Have

      Description

      Eami Subject: UND - Supplemental Life in Production not Calculating Correctly

      The Supplemental Life is not calculating correctly in Production for UND.
      Please find the details about following issue -

      Concern: Cost not displayed properly for Supplemental Life enrollments

      Cause: We found that, there are duplicate entries in inserted in RateChanges_log table during rate recalculation using SA utility on 10/15/2015. Because of this incorrect cost displayed for this plan.

      Correction: We have removed unwanted(duplicate) entries related from RateChanges_log table, Now cost displayed properly for Supplemental Life elections.

        Attachments

          Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. WT-10148 RCF - Data Audit- Duplicate Rates patterns for clients.

          • Critical - This problem will block progress.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. WT-2045 RCF - • Employbridge-PROD- 2016 Dental PPO - High Option - 4KO Kohler Rate miscalculating--duplicate entry in Enrollment rate table

          • High - Serious problem that could block progress.
          • Closed

          Enhancement - An improvement or enhancement to an existing feature or task. WT-4762 DATA AUDIT : Main

          • Medium - Has the potential to affect progress.
          • Closed

            Activity

            Ascending order - Click to sort in descending order
            rakeshr Rakesh Roy (Inactive) created issue -
            rakeshr Rakesh Roy (Inactive) made changes -
            Field Original Value New Value
            Priority Medium [ 3 ] High [ 2 ]
            satyap Satya made changes -
            Assignee Satya [ ID10004 ] Amnesh Goel [ amnesh.goel ]
            Issue Importance Must Have [ 11800 ]
            amnesh.goel Amnesh Goel (Inactive) made changes -
            Assignee Amnesh Goel [ amnesh.goel ] Neelam Yangal [ neelam.yangal ]
            satyap Satya made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            satyap Satya made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            satyap Satya made changes -
            Assignee Neelam Yangal [ neelam.yangal ] Deepali Tidke [ deepalit ]
            satyap Satya made changes -
            Item State Parent values: Development(10200) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            neelam.yangal Neelam Yangal (Inactive) made changes -
            Link This issue relates to WT-2045 [ WT-2045 ]
            deepalit Deepali Tidke (Inactive) made changes -
            Assignee Deepali Tidke [ deepalit ] Venkatesh Pujari [ venkatesh.pujari ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: On Hold(10211)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Assignee Venkatesh Pujari [ venkatesh.pujari ] Neelam Yangal [ neelam.yangal ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: On Hold(10211) Parent values: Development(10200)Level 1 values: On Hold(10207)
            rakeshr Rakesh Roy (Inactive) made changes -
            Status Local Testing [ 10200 ] Reopen in Local [ 10018 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Status Reopen in Local [ 10018 ] In Development [ 10007 ]
            amruta.lohiya Amruta Lohiya made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            amruta.lohiya Amruta Lohiya made changes -
            Item State Parent values: Development(10200)Level 1 values: On Hold(10207) Parent values: LB QA(10201)
            amruta.lohiya Amruta Lohiya made changes -
            Assignee Neelam Yangal [ neelam.yangal ] Venkatesh Pujari [ venkatesh.pujari ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Assignee Venkatesh Pujari [ venkatesh.pujari ] Neelam Yangal [ neelam.yangal ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Item State Parent values: LB QA(10201) Parent values: LB QA(10201)Level 1 values: On Hold(10211)
            neelam.yangal Neelam Yangal (Inactive) made changes -
            Assignee Neelam Yangal [ neelam.yangal ] Samir [ samir ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Status Local Testing [ 10200 ] Reopen in Local [ 10018 ]
            satyap Satya made changes -
            Status Reopen in Local [ 10018 ] In Development [ 10007 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Link This issue relates to WT-4762 [ WT-4762 ]
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Severity Complex [ 13103 ]
            amruta.lohiya Amruta Lohiya made changes -
            Assignee Samir [ samir ] Avnish Yadav [ avnish.yadav ]
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Remaining Estimate 40h [ 144000 ]
            Original Estimate 40h [ 144000 ]
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Remaining Estimate 40h [ 144000 ] 36h [ 129600 ]
            Time Spent 4h [ 14400 ]
            Worklog Id 61218 [ 61218 ]
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Remaining Estimate 36h [ 129600 ] 28h [ 100800 ]
            Time Spent 4h [ 14400 ] 12h [ 43200 ]
            Worklog Id 62878 [ 62878 ]
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Remaining Estimate 28h [ 100800 ] 20h [ 72000 ]
            Time Spent 12h [ 43200 ] 20h [ 72000 ]
            Worklog Id 62880 [ 62880 ]
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Remaining Estimate 20h [ 72000 ] 12h [ 43200 ]
            Time Spent 20h [ 72000 ] 28h [ 100800 ]
            Worklog Id 62882 [ 62882 ]
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Remaining Estimate 12h [ 43200 ] 4h [ 14400 ]
            Time Spent 28h [ 100800 ] 36h [ 129600 ]
            Worklog Id 62884 [ 62884 ]
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Remaining Estimate 4h [ 14400 ] 0h [ 0 ]
            Time Spent 36h [ 129600 ] 44h [ 158400 ]
            Worklog Id 63184 [ 63184 ]
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Time Spent 44h [ 158400 ] 52h [ 187200 ]
            Worklog Id 63791 [ 63791 ]
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Time Spent 52h [ 187200 ] 60h [ 216000 ]
            Worklog Id 64123 [ 64123 ]
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Link This issue relates to WT-10148 [ WT-10148 ]
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: On Hold(10211) Parent values: Development(10200)Level 1 values: In Analysis(10204)
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Resolution Duplicate [ 3 ]
            Status In Development [ 10007 ] Rejected [ 10004 ]
            satyap Satya made changes -
            Status Rejected [ 10004 ] Closed [ 6 ]
            satyap Satya made changes -
            Environment_New Production [ 18442 ]

              People

              Assignee:
              avnish.yadav Avnish Yadav (Inactive)
              Reporter:
              rakeshr Rakesh Roy (Inactive)
              Account Executive:
              Satya
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 40h Original Estimate - 40h
                  40h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 60h
                  60h