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
            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)
            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.
            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 ]
            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?
            rakeshr Rakesh Roy (Inactive) made changes -
            Assignee Deepali Tidke [ deepalit ] Venkatesh Pujari [ venkatesh.pujari ]
            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
            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)
            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
            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)
            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
            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 ]
            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
            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)
            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.
            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 ]
            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
            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 ]
            Transition Time In Source Status Execution Times
            Neelam Yangal (Inactive) made transition -
            Open In Development
            		34d 21h 38m 1
            Amruta Lohiya made transition -
            In Development In LB Testing
            		8d 17h 46m 2
            Rakesh Roy (Inactive) made transition -
            In LB Testing Reopen in Local
            		67d 4h 31m 2
            Satya made transition -
            Reopen in Local In Development
            		12d 6h 58m 2
            Satya made transition -
            In Development Rejected
            		178d 2h 27m 1
            Satya made transition -
            Rejected Closed
            		3s 1

              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: