WORKTERRAProject Type: software

WORKTERRA

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

Export -> Event builder missing cobra data need to identify.

    Details

    • Type: Support Activity
    • Status: Resolved
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Support Task Type:
      Data Correction
    • Environment:
      Production
    • Reported by:
      Harbinger
    • Company:
      All Clients/Multiple Clients
    • Module:
      BenAdmin - Export
    • Issue Importance:
      Must Have
    • Severity:
      Simple

      Attachments

        Issue Links

        relates to

        Support Activity - Support Activity WT-13027 Fazoli's - COBRA File

        • Medium - Has the potential to affect progress.
        • Closed

          Activity

          Ascending order - Click to sort in descending order
          Permalink
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) logged work - 08/Jan/18 08:16 AM
          • Time Spent:
            3h
             
            <No comment>
          Permalink
          Prashant.samal Prashant Samal (Inactive) logged work - 08/Jan/18 10:42 AM
          • Time Spent:
            6h
             

            Analysis of COBRA Data on companies

          Permalink
          rajendra.pawar Rajendra Pawar (Inactive) logged work - 08/Jan/18 01:00 PM
          • Time Spent:
            8h
             
            <No comment>
          Permalink
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) logged work - 08/Jan/18 01:27 PM - edited
          • Time Spent:
            3h
             
            <No comment>
          Permalink
          rakesh.shahane Rakesh Shahane (Inactive) logged work - 08/Jan/18 03:48 PM
          • Time Spent:
            6h
             
            <No comment>
          Permalink
          Prashant.samal Prashant Samal (Inactive) logged work - 09/Jan/18 10:42 AM
          • Time Spent:
            6h
             

            Anlysis of COBRA Data and files

          Permalink
          rajendra.pawar Rajendra Pawar (Inactive) logged work - 09/Jan/18 01:00 PM
          • Time Spent:
            8h
             
            <No comment>
          Permalink
          Prajakta.belhe Prajakta Belhe (Inactive) logged work - 09/Jan/18 01:05 PM
          • Time Spent:
            7h
             
            <No comment>
          Permalink
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) logged work - 09/Jan/18 01:26 PM
          • Time Spent:
            2h
             
            <No comment>
          Permalink
          rakesh.shahane Rakesh Shahane (Inactive) logged work - 09/Jan/18 03:51 PM
          • Time Spent:
            4h
             
            <No comment>
          Permalink
          yogita.bhadane Yogita Bhadane (Inactive) logged work - 09/Jan/18 05:06 PM
          • Time Spent:
            7h
             

            Understanding issue and process to resolve it.
            Discussion with prashant and rajendra.
            Pulling ESBA sent files and merging.
            Preparing final file to send for missing employees and
            Testing of same.

          Permalink
          sheetal.bodhale Sheetal Bodhale (Inactive) logged work - 10/Jan/18 01:51 AM
          • Time Spent:
            7.5h
             

            Inserted data on all companies from cobra list

          Permalink
          swapnil.eksambekar Swapnil Eksambekar (Inactive) logged work - 10/Jan/18 08:50 AM
          • Time Spent:
            4h
             
            <No comment>
          Permalink
          Prashant.samal Prashant Samal (Inactive) logged work - 10/Jan/18 10:10 AM
          • Time Spent:
            6.4h
             

            EL Camino Hospital
            AH
            Hallmark Aviation

          Permalink
          rajendra.pawar Rajendra Pawar (Inactive) logged work - 10/Jan/18 01:00 PM
          • Time Spent:
            8h
             
            <No comment>
          Permalink
          rakesh.shahane Rakesh Shahane (Inactive) logged work - 10/Jan/18 03:51 PM
          • Time Spent:
            7.8h
             
            <No comment>
          Permalink
          Prajakta.belhe Prajakta Belhe (Inactive) logged work - 10/Jan/18 05:58 PM
          • Time Spent:
            5h
             
            <No comment>
          Permalink
          sheetal.bodhale Sheetal Bodhale (Inactive) logged work - 11/Jan/18 02:07 AM - edited
          • Time Spent:
            7.5h
             

            Daily script creation
            executed on main companies from cobra list
            Discussion with Rajendra and Ganesh

          Permalink
          swapnil.eksambekar Swapnil Eksambekar (Inactive) logged work - 11/Jan/18 08:50 AM
          • Time Spent:
            4h
             
            <No comment>
          Permalink
          Prashant.samal Prashant Samal (Inactive) logged work - 11/Jan/18 09:11 AM
          • Time Spent:
            7.2h
             

            EL Camino
            AH
            City of Belleveu

          Permalink
          rajendra.pawar Rajendra Pawar (Inactive) logged work - 11/Jan/18 01:00 PM
          • Time Spent:
            8h
             
            <No comment>
          Permalink
          Prajakta.belhe Prajakta Belhe (Inactive) logged work - 11/Jan/18 01:09 PM - edited
          • Time Spent:
            6h
             
            <No comment>
          Permalink
          rakesh.shahane Rakesh Shahane (Inactive) logged work - 11/Jan/18 03:51 PM
          • Time Spent:
            8h 11m
             
            <No comment>
          Permalink
          yogita.bhadane Yogita Bhadane (Inactive) logged work - 11/Jan/18 05:11 PM
          • Time Spent:
            8h
             

            Finding missing records,making of final file and testing to send for below companies:
            ESBA
            City of durham

          Permalink
          sheetal.bodhale Sheetal Bodhale (Inactive) logged work - 12/Jan/18 06:02 AM
          • Time Spent:
            5h
             

            Script Creation
            Executed script on all mentioned companies for date '01/11/2018'

          Permalink
          swapnil.eksambekar Swapnil Eksambekar (Inactive) logged work - 12/Jan/18 08:50 AM
          • Time Spent:
            2.5h
             
            <No comment>
          Permalink
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) logged work - 12/Jan/18 09:36 AM
          • Time Spent:
            5h
             
            <No comment>
          Permalink
          rakesh.shahane Rakesh Shahane (Inactive) logged work - 12/Jan/18 09:49 AM
          • Time Spent:
            8h
             
            <No comment>
          Permalink
          rajendra.pawar Rajendra Pawar (Inactive) logged work - 12/Jan/18 12:34 PM
          • Time Spent:
            8h
             
            <No comment>
          Permalink
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) logged work - 12/Jan/18 12:49 PM
          • Time Spent:
            2h
             
            <No comment>
          Permalink
          yogita.bhadane Yogita Bhadane (Inactive) logged work - 12/Jan/18 05:19 PM
          • Time Spent:
            8h
             

            Finding missing records,making of final file and testing to send for below companies:
            CHMC - Participant,Dependent and coverage file
            HMC - Participant,Dependent and coverage file

          Permalink
          sheetal.bodhale Sheetal Bodhale (Inactive) logged work - 13/Jan/18 01:19 AM
          • Time Spent:
            0.5h
             

            Script execution

          Permalink
          Prashant.samal Prashant Samal (Inactive) logged work - 15/Jan/18 09:14 AM
          • Time Spent:
            6.45h
             

            COBRA Point Company verification
            AH reverification
            Files resending
            EL Camino hospital files Divorce files

          Permalink
          rakesh.shahane Rakesh Shahane (Inactive) logged work - 15/Jan/18 09:49 AM
          • Time Spent:
            8h
             
            <No comment>
          Permalink
          rajendra.pawar Rajendra Pawar (Inactive) logged work - 15/Jan/18 12:46 PM
          • Time Spent:
            8h
             
            <No comment>
          Permalink
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) logged work - 15/Jan/18 01:00 PM
          • Time Spent:
            2h
             
            <No comment>
          Permalink
          Prajakta.belhe Prajakta Belhe (Inactive) logged work - 15/Jan/18 01:11 PM
          • Time Spent:
            4h
             
            <No comment>
          Permalink
          kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 15/Jan/18 05:19 PM
          • Time Spent:
            3h
             

            Discussing with Yogita about the process
            Company MHIN verifying the records provided

          Permalink
          yogita.bhadane Yogita Bhadane (Inactive) logged work - 15/Jan/18 05:22 PM
          • Time Spent:
            8h
             

            Finding missing records,making of final file and testing to send For
            KMC - Participant,Dependent and coverage file
            Hallmark terminated employee analysis.

          Permalink
          sheetal.bodhale Sheetal Bodhale (Inactive) logged work - 15/Jan/18 09:36 PM
          • Time Spent:
            0.75h
             

            Discussion with Rajendra and Ganesh
            Corrected data of 3 days from 13th to 15th Jan

          Permalink
          Prashant.samal Prashant Samal (Inactive) logged work - 16/Jan/18 09:20 AM
          • Time Spent:
            7.1h
             

            Prime Health Care

            Participant File

          Permalink
          rakesh.shahane Rakesh Shahane (Inactive) logged work - 16/Jan/18 09:50 AM
          • Time Spent:
            8h
             
            <No comment>
          Permalink
          rajendra.pawar Rajendra Pawar (Inactive) logged work - 16/Jan/18 01:00 PM
          • Time Spent:
            8h
             

            Prime Healthcare file creation

          Permalink
          sheetal.bodhale Sheetal Bodhale (Inactive) logged work - 17/Jan/18 01:31 AM
          • Time Spent:
            2h
             

            Script execution and verification
            Discussion with Swapnil

          Permalink
          rakesh.shahane Rakesh Shahane (Inactive) logged work - 17/Jan/18 09:50 AM
          • Time Spent:
            8h
             
            <No comment>
          Permalink
          Prashant.samal Prashant Samal (Inactive) logged work - 17/Jan/18 10:21 AM
          • Time Spent:
            6.9h
             

            Prime Healthcare Final Files
            Participant
            Dependent
            Coverage
            Missing COBRA record files

          Permalink
          rajendra.pawar Rajendra Pawar (Inactive) logged work - 17/Jan/18 12:43 PM
          • Time Spent:
            8h
             
            <No comment>
          Permalink
          sheetal.bodhale Sheetal Bodhale (Inactive) logged work - 18/Jan/18 02:35 AM
          • Time Spent:
            2h
             

            Executed daily script to insert missing entries
            prime database backup
            Fetched missing entries list

          Permalink
          sheetal.bodhale Sheetal Bodhale (Inactive) logged work - 19/Jan/18 01:13 AM
          • Time Spent:
            1.5h
             

            Daily script execution
            Fetch missing employee list
            Analysis

          Permalink
          sheetal.bodhale Sheetal Bodhale (Inactive) logged work - 20/Jan/18 02:09 AM - edited
          • Time Spent:
            1h
             

            Daily script execution
            Data verification

            People

            Assignee:
            rajendra.pawar Rajendra Pawar (Inactive)
            Reporter:
            Ganesh.sadawarte Ganesh Sadawarte (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 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 - 279h 17m
                279h 17m