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
            Hide
            Permalink
            neelam.yangal Neelam Yangal (Inactive) added a comment -

            Please find below scenarios to reproduce this issue:

            1) Plan A Election will be 1/1/2016 to NULL.
            2) Rates should have one active record and two inactive record
            1/1/2016 to 12/31/2015
            1/1/2016 to 12/31/2017.

            3) then re-enroll that plan again.
            It will set activate the dead record from the ratechanges_Log table hence duplicated cost appears to the Employee.

            Show
            neelam.yangal Neelam Yangal (Inactive) added a comment - Please find below scenarios to reproduce this issue: 1) Plan A Election will be 1/1/2016 to NULL. 2) Rates should have one active record and two inactive record 1/1/2016 to 12/31/2015 1/1/2016 to 12/31/2017. 3) then re-enroll that plan again. It will set activate the dead record from the ratechanges_Log table hence duplicated cost appears to the Employee.
            Hide
            Permalink
            rakeshr Rakesh Roy (Inactive) added a comment -

            Neelam Yangal What is Risk mitigation plan for this?

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - Neelam Yangal What is Risk mitigation plan for this?
            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi Rakesh,

            I tried to reproduce this issue on Stage but I am not able to do so. Also tried with two to three scenarios it is not being reproduced on stage and production.

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Rakesh, I tried to reproduce this issue on Stage but I am not able to do so. Also tried with two to three scenarios it is not being reproduced on stage and production. Thanks, Venkatesh
            Hide
            Permalink
            neelam.yangal Neelam Yangal (Inactive) added a comment -

            Affected trigger:

            1) OES_TR_Employee_Enrollment_Intermediate_ForRates_AFT_UPDT
            2) OES_TR_Employee_Enrollment_ForRates_AFT_UPDT

            Show
            neelam.yangal Neelam Yangal (Inactive) added a comment - Affected trigger: 1) OES_TR_Employee_Enrollment_Intermediate_ForRates_AFT_UPDT 2) OES_TR_Employee_Enrollment_ForRates_AFT_UPDT
            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            As discussion with Amruta and Neelam will be able to check this after they provide me the script through which this can be tested.

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - As discussion with Amruta and Neelam will be able to check this after they provide me the script through which this can be tested.
            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Please assign this ticket to me once you attach the script with this ticket through which I will be able to test this ticket

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Please assign this ticket to me once you attach the script with this ticket through which I will be able to test this ticket
            Hide
            Permalink
            rakeshr Rakesh Roy (Inactive) added a comment -

            Venkatesh Pujari Neelam Yangal Still pending?

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - Venkatesh Pujari Neelam Yangal Still pending?
            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: