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

RCF - Rate issues for RDS 25--duplicate entries in DB

    Details

    • Type: Bug
    • Status: Closed
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Environment:
      Production
    • Module:
      BenAdmin - Enrollment
    • Reported by:
      Harbinger
    • Item State:
      LB QA - On Hold
    • Issue Importance:
      Must Have

      Description

      Can we please look at the mappings for RDS 25? It seems they are doubling or receiving more than one rate.
      2016 Secretary Category V Aetna CH POS II Low Option
      2016 Secretary Category V Dental - AETNA Dental
      2016 Secretary Category V Med HDHP Aetna CH POS II HDHP
      2016 Secretary Category V Vision – VSP

      Please find 3 C's of below issue,

      Concern: Rates doubling for RDS 25 Employees.

      Cause: We have checked plans which were mapped to rates given below. And we have checked all enrollments in those plans of RDS 25 employees, we found that there were duplicate rate entries against 15 enrollments in database which were causing this rate doubling problem.

      Correction: We have deleted those duplicate entries from back-end. And we are looking if there are any duplicate entries for other enrollments as well other than plans mapped with Rates given below.

        Attachments

          Issue Links

            Activity

            rakeshr Rakesh Roy (Inactive) created issue -
            satyap Satya made changes -
            Field Original Value New Value
            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 ]
            neelam.yangal Neelam Yangal (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            neelam.yangal Neelam Yangal (Inactive) made changes -
            Item State Parent values: Development(10200) Parent values: LB QA(10201)
            neelam.yangal Neelam Yangal (Inactive) made changes -
            Assignee Neelam Yangal [ neelam.yangal ] Rakesh Roy [ rakeshr ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Assignee Rakesh Roy [ rakeshr ] Deepali Tidke [ deepalit ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Assignee Deepali Tidke [ deepalit ] Venkatesh Pujari [ venkatesh.pujari ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Assignee Venkatesh Pujari [ venkatesh.pujari ] Deepali Tidke [ deepalit ]
            deepalit Deepali Tidke (Inactive) made changes -
            Assignee Deepali Tidke [ deepalit ] Venkatesh Pujari [ venkatesh.pujari ]
            neelam.yangal Neelam Yangal (Inactive) made changes -
            Link This issue relates to WT-2045 [ WT-2045 ]
            satyap Satya made changes -
            Item State Parent values: LB QA(10201) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            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: Development(10200)
            amruta.lohiya Amruta Lohiya made changes -
            Item State Parent values: Development(10200) 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 ]
            satyap Satya made changes -
            Resolution Done [ 10000 ]
            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:
              samir Samir
              Reporter:
              rakeshr Rakesh Roy (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: