WORKTERRAProject Type: software

WORKTERRA

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

Duplicate election was caused by Eligibility Service.

    Details

    • Type: Bug
    • Status: Production Complete
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Environment:
      Production
    • Bug Type:
      Functional
    • Bug Severity:
      Critical
    • Module:
      BenAdmin - Enrollment
    • Reported by:
      Data Audit
    • Item State:
      Production Complete
    • Sprint:
      WT Sprint 35 - Bugs

      Description

      Duplicate election was caused by Eligibility Service. This service inserted 14 election records for below employee with election Termination Null.
      Company Name:- Merrillville
      Employee:- Beverly Street
      Plan Name:- 2016 Supplemental AD&D Employee

      CC-- Amruta Lohiya,Satya,Vijay Siddha

        Attachments

          Activity

          Ascending order - Click to sort in descending order
          avnish.yadav Avnish Yadav (Inactive) created issue -
          jyoti.mayne Jyoti Mayne made changes -
          Field Original Value New Value
          Assignee Jyoti Mayne [ jyoti.mayne ] Shailendra Honrao [ shailendra.honrao ]
          jyoti.mayne Jyoti Mayne made changes -
          Sprint WT Sprint 35 - Bugs [ 81 ]
          jyoti.mayne Jyoti Mayne made changes -
          Dev Due Date 22/Aug/2017
          jyoti.mayne Jyoti Mayne made changes -
          Dev Due Date 22/Aug/2017 24/Aug/2017
          shailendra.honrao Shailendra Honrao (Inactive) made changes -
          Status Open [ 1 ] In Development [ 10007 ]
          shailendra.honrao Shailendra Honrao (Inactive) made changes -
          Developer Shailendra Honrao [ shailendra.honrao ]
          Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Description Duplicate election was caused by Eligibility Service. This service inserted 14 election records for below employee with election Termination Null.

          Employee:- Beverly Street
          Plan Name:- 2016 Supplemental AD&D Employee

          CC-- [~amruta.lohiya],[~satyap],[~vijays]
          		 Duplicate election was caused by Eligibility Service. This service inserted 14 election records for below employee with election Termination Null.
          Company Name:- Merrillville
          Employee:- Beverly Street
          Plan Name:- 2016 Supplemental AD&D Employee

          CC-- [~amruta.lohiya],[~satyap],[~vijays]
          shailendra.honrao Shailendra Honrao (Inactive) made changes -
          Assignee Shailendra Honrao [ shailendra.honrao ] Abhilash Warkari [ abhilash.warkari ]
          abhilash.warkari Abhilash Warkari (Inactive) made changes -
          Developer Shailendra Honrao [ shailendra.honrao ] Abhilash Warkari [ abhilash.warkari ]
          Permalink
          shailendra.honrao Shailendra Honrao (Inactive) logged work - 23/Aug/17 01:08 PM
          • Time Spent:
            3h
             

            data analysis,database backup and script execution

          shailendra.honrao Shailendra Honrao (Inactive) made changes -
          Remaining Estimate 0h [ 0 ]
          Time Spent 3h [ 10800 ]
          Worklog Id 73858 [ 73858 ]
          Permalink
          abhilash.warkari Abhilash Warkari (Inactive) logged work - 23/Aug/17 04:30 PM
          • Time Spent:
            3h
             

            Tried Scenarios and data analysis.
            tried to reproduce the issue.

          abhilash.warkari Abhilash Warkari (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          abhilash.warkari Abhilash Warkari (Inactive) made changes -
          Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
          abhilash.warkari Abhilash Warkari (Inactive) made changes -
          Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
          abhilash.warkari Abhilash Warkari (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Production Complete(10222)
          abhilash.warkari Abhilash Warkari (Inactive) made changes -
          Attachment Cost And Coverage customization.png [ 59719 ]
          Hide
          Permalink
          abhilash.warkari Abhilash Warkari (Inactive) added a comment - - edited

          Hi,

          This issue is fixed under JIRA WT-8047 and patch deployed on production 3/1/17 IST.

          Customization on cost and coverage screen in plan 2016 Supplemental AD&D Employee is as below :

          because of this, when service is running it is also changing the GI amount as per setting.

          Concern Duplicate election was caused by Eligibility Service.
          Cause '2016 Supplemental AD&D Employee' plan is having age banded GI Customization for 0-59 and 60-69. Employee 'Beverly Street' elected plan with 1/1/16 effective date, his age was 59 at that time(Date of birth is 1956-05-14). When his birthday came in 2017 year, he became 60 year's old. Midnight service was running everyday and allocating new coverage as per 60-69 GI which is wrong.
          Correction Jyoti Mayne has already fix this issue under the JIRA WT-8047

          Avnish Yadav please correct the data for the employee.

          Thanks and Regards
          Abhilash Warkari

          CC: Jyoti Mayne, Umesh Kadam, Avnish Yadav, Gaurav Sodani

          Show
          abhilash.warkari Abhilash Warkari (Inactive) added a comment - - edited Hi, This issue is fixed under JIRA WT-8047 and patch deployed on production 3/1/17 IST. Customization on cost and coverage screen in plan 2016 Supplemental AD&D Employee is as below : because of this, when service is running it is also changing the GI amount as per setting. Concern Duplicate election was caused by Eligibility Service. Cause '2016 Supplemental AD&D Employee' plan is having age banded GI Customization for 0-59 and 60-69. Employee 'Beverly Street' elected plan with 1/1/16 effective date, his age was 59 at that time(Date of birth is 1956-05-14). When his birthday came in 2017 year, he became 60 year's old. Midnight service was running everyday and allocating new coverage as per 60-69 GI which is wrong. Correction Jyoti Mayne has already fix this issue under the JIRA WT-8047 Avnish Yadav please correct the data for the employee. Thanks and Regards Abhilash Warkari CC: Jyoti Mayne , Umesh Kadam , Avnish Yadav , Gaurav Sodani
          abhilash.warkari Abhilash Warkari (Inactive) made changes -
          Assignee Abhilash Warkari [ abhilash.warkari ] Avnish Yadav [ avnish.yadav ]
          Permalink
          abhilash.warkari Abhilash Warkari (Inactive) logged work - 24/Aug/17 04:30 PM
          • Time Spent:
            3h
             

            Tried to reproduce the issue .
            Data Analysis.

          abhilash.warkari Abhilash Warkari (Inactive) made changes -
          Time Spent 3h [ 10800 ] 6h [ 21600 ]
          Worklog Id 75303 [ 75303 ]
          abhilash.warkari Abhilash Warkari (Inactive) made changes -
          Time Spent 6h [ 21600 ] 9h [ 32400 ]
          Worklog Id 75306 [ 75306 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status Production Testing [ 10202 ] Production Complete [ 10028 ]
          Hide
          Permalink
          rakeshr Rakesh Roy (Inactive) added a comment -

          Avnish Yadav Is data correction pending?

          Gaurav Sodani

          Show
          rakeshr Rakesh Roy (Inactive) added a comment - Avnish Yadav Is data correction pending? Gaurav Sodani
          gaurav.sodani Gaurav Sodani (Inactive) made changes -
          Issue Category Harbinger [ 10700 ] Data Audit [ 18400 ]
          satyap Satya made changes -
          Environment_New Production [ 18442 ]
          Transition Time In Source Status Execution Times
          Shailendra Honrao (Inactive) made transition -
          Open In Development
          		13d 23h 34m 1
          Abhilash Warkari (Inactive) made transition -
          In Development In LB Testing
          		1d 58m 1
          Abhilash Warkari (Inactive) made transition -
          In LB Testing Stage Testing
          		19s 1
          Abhilash Warkari (Inactive) made transition -
          Stage Testing In Production Testing
          		3s 1
          Rakesh Roy (Inactive) made transition -
          In Production Testing Production Complete
          		18d 8h 4m 1

            People

            Assignee:
            avnish.yadav Avnish Yadav (Inactive)
            Reporter:
            avnish.yadav Avnish Yadav (Inactive)
            Developer:
            Abhilash Warkari (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Dev Due Date:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 9h
                9h