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

Data Analysis :Duplicate enrollment

    Details

    • Type: Support Activity
    • Status: Closed
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Support Task Type:
      Data Correction
    • Reported by:
      Harbinger
    • Module:
      BenAdmin - Enrollment
    • Issue Importance:
      Must Have

      Attachments

        Issue Links

          Activity

          nandkumar Nandkumar Prabhakar Karlekar (Inactive) created issue -
          Hide
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - - edited

          Please find the attached excel for duplicate enrollment on production OE completed companies
          37 companies scanned.

          @Samir,Satya,shyam sharma,Vijay Siddha

          Show
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - - edited Please find the attached excel for duplicate enrollment on production OE completed companies 37 companies scanned. @Samir, Satya , shyam sharma , Vijay Siddha
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
          Field Original Value New Value
          Assignee Vijay Siddha [ vijays ] Samir [ samir ]
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
          Attachment duplicate enrollment.zip [ 31914 ]
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
          Link This issue relates to WT-6178 [ WT-6178 ]
          abhijeet.khandagale Abhijeet Khandagale (Inactive) made changes -
          Attachment DuplicateElections_11_24_2016.zip [ 33432 ]
          Hide
          abhijeet.khandagale Abhijeet Khandagale (Inactive) added a comment -

          Please find latest data audit for duplicate enrollment in file DuplicateElections_11_24_2016.zip.

          Password will be shared in mail.

          CC: Samir Nandkumar Prabhakar Karlekar

          Show
          abhijeet.khandagale Abhijeet Khandagale (Inactive) added a comment - Please find latest data audit for duplicate enrollment in file DuplicateElections_11_24_2016.zip . Password will be shared in mail. CC: Samir Nandkumar Prabhakar Karlekar
          amruta.lohiya Amruta Lohiya made changes -
          Assignee Samir [ samir ] Umesh Kadam [ umesh.kadam ]
          amruta.lohiya Amruta Lohiya made changes -
          Assignee Umesh Kadam [ umesh.kadam ] Amruta Lohiya [ amruta.baheti ]
          Status Open [ 1 ] In Progress [ 3 ]
          amruta.lohiya Amruta Lohiya made changes -
          Assignee Amruta Lohiya [ amruta.baheti ] Umesh Kadam [ umesh.kadam ]
          umesh.kadam Umesh Kadam (Inactive) logged work - 29/Nov/16 04:00 AM
          • Time Spent:
            3.75h
             

            Analysis for patterns of occurrence of duplicate elections on 'Clarke', 'Employebridge', 'Wheaton Franciscan Healthcare' and 'City of Oceanside'

          umesh.kadam Umesh Kadam (Inactive) logged work - 29/Nov/16 08:30 AM
          • Time Spent:
            3h
             

            Analysis for patterns of occurrence of duplicate elections on 'Clarke', 'Employebridge', 'Wheaton Franciscan Healthcare' and 'City of Oceanside'

          umesh.kadam Umesh Kadam (Inactive) logged work - 29/Nov/16 12:00 PM
          • Time Spent:
            1h
             

            Started correction of duplicate enrollments for 'Clarke'

          umesh.kadam Umesh Kadam (Inactive) logged work - 30/Nov/16 04:00 AM
          • Time Spent:
            3.75h
             

            Complete correction of Duplicate elections of 'Clarke'
            Started correction of duplicate elections of 'Employbridge' and complete for 4 benefit types

          umesh.kadam Umesh Kadam (Inactive) logged work - 30/Nov/16 08:30 AM
          • Time Spent:
            2.25h
             

            Corrected Duplicate elections of 'Employbridge' for 4 benefit types

          umesh.kadam Umesh Kadam (Inactive) logged work - 30/Nov/16 11:00 AM
          • Time Spent:
            1h
             

            Corrected Duplicate elections of 'Employbridge' for 4 benefit types

          umesh.kadam Umesh Kadam (Inactive) logged work - 01/Dec/16 08:30 AM - edited
          • Time Spent:
            6.5h
             

            Corrected Duplicate elections for 'Wheaton Franciscan Healthcare'
            Corrected Duplicate elections for 'Employbridge' (Corrected remaining 30 records)

          umesh.kadam Umesh Kadam (Inactive) made changes -
          Remaining Estimate 0h [ 0 ]
          Time Spent 0.75h [ 2700 ]
          Worklog Id 11217 [ 11217 ]
          umesh.kadam Umesh Kadam (Inactive) made changes -
          Time Spent 0.75h [ 2700 ] 2.75h [ 9900 ]
          Worklog Id 11218 [ 11218 ]
          umesh.kadam Umesh Kadam (Inactive) made changes -
          Time Spent 2.75h [ 9900 ] 4h [ 14400 ]
          Worklog Id 11219 [ 11219 ]
          umesh.kadam Umesh Kadam (Inactive) made changes -
          Time Spent 4h [ 14400 ] 6.5h [ 23400 ]
          Worklog Id 11220 [ 11220 ]
          umesh.kadam Umesh Kadam (Inactive) made changes -
          Time Spent 6.5h [ 23400 ] 7.5h [ 27000 ]
          Worklog Id 11223 [ 11223 ]
          umesh.kadam Umesh Kadam (Inactive) made changes -
          Time Spent 7.5h [ 27000 ] 9.75h [ 35100 ]
          Worklog Id 11224 [ 11224 ]
          umesh.kadam Umesh Kadam (Inactive) made changes -
          Time Spent 9.75h [ 35100 ] 13.5h [ 48600 ]
          Worklog Id 11225 [ 11225 ]
          umesh.kadam Umesh Kadam (Inactive) made changes -
          Time Spent 13.5h [ 48600 ] 14.5h [ 52200 ]
          Worklog Id 11226 [ 11226 ]
          umesh.kadam Umesh Kadam (Inactive) made changes -
          Time Spent 14.5h [ 52200 ] 17.5h [ 63000 ]
          Worklog Id 11227 [ 11227 ]
          umesh.kadam Umesh Kadam (Inactive) made changes -
          Time Spent 17.5h [ 63000 ] 21.25h [ 76500 ]
          Worklog Id 11228 [ 11228 ]
          umesh.kadam Umesh Kadam (Inactive) made changes -
          Worklog Id 11219 [ 11219 ]
          umesh.kadam Umesh Kadam (Inactive) made changes -
          Worklog Id 11220 [ 11220 ]
          umesh.kadam Umesh Kadam (Inactive) made changes -
          Remaining Estimate 0h [ 0 ] 0.75h [ 2700 ]
          Time Spent 21.25h [ 76500 ] 20.5h [ 73800 ]
          Worklog Id 11217 [ 11217 ]
          Worklog Time Spent 0.75h [ 2700 ]
          umesh.kadam Umesh Kadam (Inactive) made changes -
          Remaining Estimate 0.75h [ 2700 ] 3.25h [ 11700 ]
          Time Spent 20.5h [ 73800 ] 18h [ 64800 ]
          Worklog Id 11220 [ 11220 ]
          Worklog Time Spent 2.5h [ 9000 ]
          umesh.kadam Umesh Kadam (Inactive) made changes -
          Remaining Estimate 3.25h [ 11700 ] 4.5h [ 16200 ]
          Time Spent 18h [ 64800 ] 16.75h [ 60300 ]
          Worklog Id 11219 [ 11219 ]
          Worklog Time Spent 1.25h [ 4500 ]
          umesh.kadam Umesh Kadam (Inactive) made changes -
          Remaining Estimate 4.5h [ 16200 ] 0h [ 0 ]
          Time Spent 16.75h [ 60300 ] 21.25h [ 76500 ]
          Worklog Id 11218 [ 11218 ]
          Hide
          umesh.kadam Umesh Kadam (Inactive) added a comment -

          Correction has been done for given companies. Closing this ticket.

          Show
          umesh.kadam Umesh Kadam (Inactive) added a comment - Correction has been done for given companies. Closing this ticket.
          umesh.kadam Umesh Kadam (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status In Progress [ 3 ] Resolved [ 5 ]
          umesh.kadam Umesh Kadam (Inactive) made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Transition Time In Source Status Execution Times
          Amruta Lohiya made transition -
          Open In Progress
          18d 11h 53m 1
          Umesh Kadam (Inactive) made transition -
          In Progress Resolved
          44d 11h 25m 1
          Umesh Kadam (Inactive) made transition -
          Resolved Closed
          2s 1

            People

            Assignee:
            umesh.kadam Umesh Kadam (Inactive)
            Reporter:
            nandkumar Nandkumar Prabhakar Karlekar (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

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