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
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) created issue -
          Prashant.samal Prashant Samal (Inactive) made changes -
          Field Original Value New Value
          Attachment Cobra List.xls [ 71385 ]
          rajendra.pawar Rajendra Pawar (Inactive) made changes -
          Issue Importance Must Have [ 11800 ]
          Priority Medium [ 3 ] High [ 2 ]
          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>
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
          Link This issue relates to WT-13027 [ WT-13027 ]
          Permalink
          Prashant.samal Prashant Samal (Inactive) logged work - 09/Jan/18 10:42 AM
          • Time Spent:
            6h
             

            Anlysis of COBRA Data and files

          rajendra.pawar Rajendra Pawar (Inactive) made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          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>
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Remaining Estimate 0h [ 0 ]
          Time Spent 2h [ 7200 ]
          Worklog Id 99804 [ 99804 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Time Spent 2h [ 7200 ] 4h [ 14400 ]
          Worklog Id 99805 [ 99805 ]
          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

          Prashant.samal Prashant Samal (Inactive) made changes -
          Time Spent 4h [ 14400 ] 10h [ 36000 ]
          Worklog Id 99826 [ 99826 ]
          Prashant.samal Prashant Samal (Inactive) made changes -
          Time Spent 10h [ 36000 ] 16h [ 57600 ]
          Worklog Id 99827 [ 99827 ]
          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>
          sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
          Time Spent 16h [ 57600 ] 23.5h [ 84600 ]
          Worklog Id 99915 [ 99915 ]
          sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
          Time Spent 23.5h [ 84600 ] 30.5h [ 109800 ]
          Worklog Id 99919 [ 99919 ]
          sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
          Time Spent 30.5h [ 109800 ] 31h [ 111600 ]
          Worklog Id 99919 [ 99919 ]
          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>
          rajendra.pawar Rajendra Pawar (Inactive) made changes -
          Time Spent 31h [ 111600 ] 39h [ 140400 ]
          Worklog Id 100081 [ 100081 ]
          rajendra.pawar Rajendra Pawar (Inactive) made changes -
          Time Spent 39h [ 140400 ] 47h [ 169200 ]
          Worklog Id 100083 [ 100083 ]
          rajendra.pawar Rajendra Pawar (Inactive) made changes -
          Time Spent 47h [ 169200 ] 55h [ 198000 ]
          Worklog Id 100085 [ 100085 ]
          rajendra.pawar Rajendra Pawar (Inactive) made changes -
          Time Spent 55h [ 198000 ] 63h [ 226800 ]
          Worklog Id 100086 [ 100086 ]
          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

          rakesh.shahane Rakesh Shahane (Inactive) made changes -
          Time Spent 63h [ 226800 ] 69h [ 248400 ]
          Worklog Id 100129 [ 100129 ]
          rakesh.shahane Rakesh Shahane (Inactive) made changes -
          Time Spent 69h [ 248400 ] 73h [ 262800 ]
          Worklog Id 100131 [ 100131 ]
          rakesh.shahane Rakesh Shahane (Inactive) made changes -
          Time Spent 73h [ 262800 ] 80.8h [ 290880 ]
          Worklog Id 100132 [ 100132 ]
          rakesh.shahane Rakesh Shahane (Inactive) made changes -
          Time Spent 80.8h [ 290880 ] 88h 59m [ 320399 ]
          Worklog Id 100133 [ 100133 ]
          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'

          sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
          Time Spent 88h 59m [ 320399 ] 93h 59m [ 338399 ]
          Worklog Id 100173 [ 100173 ]
          Permalink
          swapnil.eksambekar Swapnil Eksambekar (Inactive) logged work - 12/Jan/18 08:50 AM
          • Time Spent:
            2.5h
             
            <No comment>
          swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
          Time Spent 93h 59m [ 338399 ] 97h 59m [ 352799 ]
          Worklog Id 100196 [ 100196 ]
          swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
          Time Spent 97h 59m [ 352799 ] 101h 59m [ 367199 ]
          Worklog Id 100197 [ 100197 ]
          swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
          Time Spent 101h 59m [ 367199 ] 104h 29m [ 376199 ]
          Worklog Id 100198 [ 100198 ]
          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>
          rajendra.pawar Rajendra Pawar (Inactive) made changes -
          Time Spent 104h 29m [ 376199 ] 112h 29m [ 404999 ]
          Worklog Id 100258 [ 100258 ]
          Permalink
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) logged work - 12/Jan/18 12:49 PM
          • Time Spent:
            2h
             
            <No comment>
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Time Spent 112h 29m [ 404999 ] 114h 29m [ 412199 ]
          Worklog Id 100273 [ 100273 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Time Spent 114h 29m [ 412199 ] 115h 29m [ 415799 ]
          Worklog Id 99805 [ 99805 ]
          sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
          Time Spent 115h 29m [ 415799 ] 115h 59m [ 417599 ]
          Worklog Id 100286 [ 100286 ]
          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

          sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
          Time Spent 115h 59m [ 417599 ] 116h 44m [ 420299 ]
          Worklog Id 100389 [ 100389 ]
          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>
          rajendra.pawar Rajendra Pawar (Inactive) made changes -
          Time Spent 116h 44m [ 420299 ] 124h 44m [ 449099 ]
          Worklog Id 100423 [ 100423 ]
          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>
          Prashant.samal Prashant Samal (Inactive) made changes -
          Time Spent 124h 44m [ 449099 ] 131h 8m [ 472139 ]
          Worklog Id 100449 [ 100449 ]
          Prashant.samal Prashant Samal (Inactive) made changes -
          Time Spent 131h 8m [ 472139 ] 138h 20m [ 498059 ]
          Worklog Id 100450 [ 100450 ]
          Prashant.samal Prashant Samal (Inactive) made changes -
          Time Spent 138h 20m [ 498059 ] 144h 47m [ 521279 ]
          Worklog Id 100455 [ 100455 ]
          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

          yogita.bhadane Yogita Bhadane (Inactive) made changes -
          Time Spent 144h 47m [ 521279 ] 151h 47m [ 546479 ]
          Worklog Id 100488 [ 100488 ]
          yogita.bhadane Yogita Bhadane (Inactive) made changes -
          Time Spent 151h 47m [ 546479 ] 159h 47m [ 575279 ]
          Worklog Id 100490 [ 100490 ]
          kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
          Time Spent 159h 47m [ 575279 ] 162h 47m [ 586079 ]
          Worklog Id 100492 [ 100492 ]
          yogita.bhadane Yogita Bhadane (Inactive) made changes -
          Time Spent 162h 47m [ 586079 ] 170h 47m [ 614879 ]
          Worklog Id 100493 [ 100493 ]
          yogita.bhadane Yogita Bhadane (Inactive) made changes -
          Time Spent 170h 47m [ 614879 ] 178h 47m [ 643679 ]
          Worklog Id 100494 [ 100494 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Time Spent 178h 47m [ 643679 ] 180h 47m [ 650879 ]
          Worklog Id 100532 [ 100532 ]
          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

          Prashant.samal Prashant Samal (Inactive) made changes -
          Time Spent 180h 47m [ 650879 ] 187h 53m [ 676439 ]
          Worklog Id 100598 [ 100598 ]
          sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
          Time Spent 187h 53m [ 676439 ] 189h 53m [ 683639 ]
          Worklog Id 100602 [ 100602 ]
          Permalink
          sheetal.bodhale Sheetal Bodhale (Inactive) logged work - 17/Jan/18 01:31 AM
          • Time Spent:
            2h
             

            Script execution and verification
            Discussion with Swapnil

          rajendra.pawar Rajendra Pawar (Inactive) made changes -
          Time Spent 189h 53m [ 683639 ] 197h 53m [ 712439 ]
          Worklog Id 100666 [ 100666 ]
          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

          Prashant.samal Prashant Samal (Inactive) made changes -
          Time Spent 197h 53m [ 712439 ] 204h 47m [ 737279 ]
          Worklog Id 100766 [ 100766 ]
          Permalink
          rajendra.pawar Rajendra Pawar (Inactive) logged work - 17/Jan/18 12:43 PM
          • Time Spent:
            8h
             
            <No comment>
          Hide
          Permalink
          rajendra.pawar Rajendra Pawar (Inactive) added a comment -

          We have fetched all missed cobra records. as peer attached excel.

          Show
          rajendra.pawar Rajendra Pawar (Inactive) added a comment - We have fetched all missed cobra records. as peer attached excel.
          rajendra.pawar Rajendra Pawar (Inactive) made changes -
          Time Spent 204h 47m [ 737279 ] 212h 47m [ 766079 ]
          Worklog Id 100794 [ 100794 ]
          rajendra.pawar Rajendra Pawar (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status In Progress [ 3 ] Resolved [ 5 ]
          sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
          Time Spent 212h 47m [ 766079 ] 214h 47m [ 773279 ]
          Worklog Id 100843 [ 100843 ]
          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

          sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
          Time Spent 214h 47m [ 773279 ] 216h 17m [ 778679 ]
          Worklog Id 100957 [ 100957 ]
          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

          sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
          Time Spent 216h 17m [ 778679 ] 217h 17m [ 782279 ]
          Worklog Id 101195 [ 101195 ]
          sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
          Worklog Id 101195 [ 101195 ]
          Permalink
          sheetal.bodhale Sheetal Bodhale (Inactive) logged work - 20/Jan/18 02:09 AM - edited
          • Time Spent:
            1h
             

            Daily script execution
            Data verification

          Prajakta.belhe Prajakta Belhe (Inactive) made changes -
          Time Spent 217h 17m [ 782279 ] 224h 17m [ 807479 ]
          Worklog Id 101389 [ 101389 ]
          Prajakta.belhe Prajakta Belhe (Inactive) made changes -
          Time Spent 224h 17m [ 807479 ] 230h 17m [ 829079 ]
          Worklog Id 101390 [ 101390 ]
          Prajakta.belhe Prajakta Belhe (Inactive) made changes -
          Worklog Id 101390 [ 101390 ]
          Prajakta.belhe Prajakta Belhe (Inactive) made changes -
          Time Spent 230h 17m [ 829079 ] 234h 17m [ 843479 ]
          Worklog Id 101392 [ 101392 ]
          Prajakta.belhe Prajakta Belhe (Inactive) made changes -
          Remaining Estimate 0h [ 0 ] 7h [ 25200 ]
          Time Spent 234h 17m [ 843479 ] 227h 17m [ 818279 ]
          Worklog Id 101389 [ 101389 ]
          Worklog Time Spent 7h [ 25200 ]
          rakesh.shahane Rakesh Shahane (Inactive) made changes -
          Remaining Estimate 7h [ 25200 ] 0h [ 0 ]
          Time Spent 227h 17m [ 818279 ] 235h 17m [ 847079 ]
          Worklog Id 101530 [ 101530 ]
          rakesh.shahane Rakesh Shahane (Inactive) made changes -
          Time Spent 235h 17m [ 847079 ] 243h 17m [ 875879 ]
          Worklog Id 101531 [ 101531 ]
          rakesh.shahane Rakesh Shahane (Inactive) made changes -
          Time Spent 243h 17m [ 875879 ] 251h 17m [ 904679 ]
          Worklog Id 101532 [ 101532 ]
          rakesh.shahane Rakesh Shahane (Inactive) made changes -
          Time Spent 251h 17m [ 904679 ] 259h 17m [ 933479 ]
          Worklog Id 101533 [ 101533 ]
          Prajakta.belhe Prajakta Belhe (Inactive) made changes -
          Time Spent 259h 17m [ 933479 ] 266h 17m [ 958679 ]
          Worklog Id 102082 [ 102082 ]
          Prajakta.belhe Prajakta Belhe (Inactive) made changes -
          Time Spent 266h 17m [ 958679 ] 271h 17m [ 976679 ]
          Worklog Id 102424 [ 102424 ]
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
          Time Spent 271h 17m [ 976679 ] 274h 17m [ 987479 ]
          Worklog Id 102495 [ 102495 ]
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
          Time Spent 274h 17m [ 987479 ] 279h 17m [ 1005479 ]
          Worklog Id 102555 [ 102555 ]
          Transition Time In Source Status Execution Times
          Rajendra Pawar (Inactive) made transition -
          Open In Progress
          		1d 6h 31m 1
          Rajendra Pawar (Inactive) made transition -
          In Progress Resolved
          		7d 23h 51m 1

            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