WORKTERRAProject Type: software

WORKTERRA

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

          relates to

          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
            7 older comments
            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - - edited

            Hi Rakesh,

            The tickets is in queue. So when they will take this ticket I will be able to test this after they give a solution.

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - - edited Hi Rakesh, The tickets is in queue. So when they will take this ticket I will be able to test this after they give a solution. Thanks, Venkatesh
            Hide
            Permalink
            rakeshr Rakesh Roy (Inactive) added a comment -

            Neelam Yangal
            What's the plan?

            Amruta Lohiya Vijay Siddha

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - Neelam Yangal What's the plan? Amruta Lohiya Vijay Siddha
            Hide
            Permalink
            rakeshr Rakesh Roy (Inactive) added a comment -

            Neelam Yangal Any update

            Vijay Siddha

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - Neelam Yangal Any update Vijay Siddha
            Hide
            Permalink
            neelam.yangal Neelam Yangal (Inactive) added a comment -

            Samir
            As per our discussion, need audit and correction team for this.

            Show
            neelam.yangal Neelam Yangal (Inactive) added a comment - Samir As per our discussion, need audit and correction team for this.
            Hide
            Permalink
            satyap Satya added a comment -

            Data audit has been done for OE 2017. Merillville not with Workterra. Hence closing this RCF ticket.

            Cc: Vijay Siddha Rakesh Roy

            Show
            satyap Satya added a comment - Data audit has been done for OE 2017. Merillville not with Workterra. Hence closing this RCF ticket. Cc: Vijay Siddha Rakesh Roy

              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: