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

CHMC - Former employee missing from HR Simplified COBRA file

    Details

    • Type: Support Activity
    • Status: Closed
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Support Task Type:
      Data Correction
    • Environment:
      Production
    • Reported by:
      EDI
    • Company:
      CHMC
    • Module:
      BenAdmin - Export
    • Issue Importance:
      Must Have
    • Severity:
      Simple
    • Reported by Customer:
      CHMC

      Description

      Client: CHMC
      Group Template: Prime Healthcare_NEW HRSimplified_COBRA Coverage_Group
      Company Template affected: NEW HRSimplified_COBRA Coverage
      Export date: 12/4/17

      Hello Development Team,

      There is a former employee, Kristi Ayala (terminated status), is not passing on the HR Simplified COBRA coverage file. She had medical before but at some point there was a medical waive placed on her account. Our account exec, Amber Love, has already removed this waive but it only fixed part of the issue. The member is now coming on the participant file, but still missing from the coverage file. Is there a way you can retrigger to have her come on the file or will this needs to be handle manually with the carrier?

      Thank you,

      Alex

      CC: Amber Love-Jones Amanda B. Garvey

        Attachments

          Activity

          Hide
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment -

          Hi Alex Nguyen,

          We have not found 12/4/2017 export of Dependent, Participant and Coverage group template. The Prime Healthcare_NEW HR Simplified COBRA DEPENDENT_Group last exported on 11/30/2017 and above employees dependents were not roll out on this export file. Please find below snap of view exported.

          But still if you want to re-trigger Kristi Ayala on coverage template for Dental and Vision plan, will do please confirm?

          CC-Vinayak Kulkarni

          Thanks,
          Ganesh

          Show
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - Hi Alex Nguyen , We have not found 12/4/2017 export of Dependent, Participant and Coverage group template. The Prime Healthcare_NEW HR Simplified COBRA DEPENDENT_Group last exported on 11/30/2017 and above employees dependents were not roll out on this export file. Please find below snap of view exported. But still if you want to re-trigger Kristi Ayala on coverage template for Dental and Vision plan, will do please confirm? CC- Vinayak Kulkarni Thanks, Ganesh
          Hide
          alexn Alex Nguyen added a comment -

          Sorry for the confusion Ganesh Sadawarte. I just realized that there's three Group Templates for HR Simplified COBRA, but gave you the wrong one. Can you have a look at Group Template Prime Healthcare_NEW HRSimplified_COBRA Coverage_Group and either export date 11/30/17 or 12/4/17? I ran another export to check, but Kristi Ayala is still missing on the COBRA coverage file. She only needs the medical election, because the Dental and Vision is already received. Can you retrigger the medical for her HR Simplified COBRA?

          Thank you,

          Alex

          Show
          alexn Alex Nguyen added a comment - Sorry for the confusion Ganesh Sadawarte . I just realized that there's three Group Templates for HR Simplified COBRA, but gave you the wrong one. Can you have a look at Group Template Prime Healthcare_NEW HRSimplified_COBRA Coverage_Group and either export date 11/30/17 or 12/4/17? I ran another export to check, but Kristi Ayala is still missing on the COBRA coverage file. She only needs the medical election, because the Dental and Vision is already received. Can you retrigger the medical for her HR Simplified COBRA? Thank you, Alex
          Hide
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment -

          Hi Vinayak Kulkarni,

          Please check this

          Thanks,
          Ganesh

          Show
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - Hi Vinayak Kulkarni , Please check this Thanks, Ganesh
          Hide
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

          Hi Alex Nguyen

          We have made necessary changes at back-end to re-trigger this record on next export.
          You don't have to delete any run-date from template. Thanks.

          Show
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Hi Alex Nguyen We have made necessary changes at back-end to re-trigger this record on next export. You don't have to delete any run-date from template. Thanks.
          Hide
          alexn Alex Nguyen added a comment -

          Thank you Vinayak Kulkarni for looking into this. I will monitor next COBRA coverage file to make sure before closing the ticket.

          Alex

          Show
          alexn Alex Nguyen added a comment - Thank you Vinayak Kulkarni for looking into this. I will monitor next COBRA coverage file to make sure before closing the ticket. Alex
          Hide
          alexn Alex Nguyen added a comment -

          Hi Vinayak Kulkarni,

          I looked at the recent HR Simplified COBRA participant and coverage files, but I don't see former employee, Kristi Ayala, on any of the 12/7/17 and 12/14/17 files. Seems like the coverage file stopped sending after 11/30/17, and this is concerning because the participant files have been exporting on 12/7/17 and 12/14/17. I verified the coverage template shows that it's live and didn't see any file failure from workterradex.

          Can you check to see if anything needs to be done to the coverage file? It seems to stop exporting and also why the employee is not on any of the recent participant files.

          Thank you,

          Alex

          Show
          alexn Alex Nguyen added a comment - Hi Vinayak Kulkarni , I looked at the recent HR Simplified COBRA participant and coverage files, but I don't see former employee, Kristi Ayala, on any of the 12/7/17 and 12/14/17 files. Seems like the coverage file stopped sending after 11/30/17, and this is concerning because the participant files have been exporting on 12/7/17 and 12/14/17. I verified the coverage template shows that it's live and didn't see any file failure from workterradex. Can you check to see if anything needs to be done to the coverage file? It seems to stop exporting and also why the employee is not on any of the recent participant files. Thank you, Alex
          Hide
          alexn Alex Nguyen added a comment -

          Kristi Ayala still missing from the COBRA files.

          Show
          alexn Alex Nguyen added a comment - Kristi Ayala still missing from the COBRA files.
          Hide
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

          Hi Alex Nguyen

          We have 2 issues here,

          #1 Kristi Ayala still missing from the COBRA files

          There was some issue while correcting her record from back-end last time, Now we have corrected it properly. Please check.

          #2 Cobra Coverage file stopped exporting

          Group template's Prime Healthcare_NEW HRSimplified_COBRA Coverage_Group
          schedule start date is change to "2018-12-07 15:00:00.000" on 12/04 by you. Please start date to year 2017.

          Note: Please export all these 3 group file at once to get them aligned, send them to vendor informing coverage file did not run on 12/07 and 12/14 whereas participant and dependent file ran on those dates.
          Coverage records for those participant file ( 12/7 and 12/14) will export on next run.

          let us know if you have any questions on this. Thanks.

          Show
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Hi Alex Nguyen We have 2 issues here, #1 Kristi Ayala still missing from the COBRA files There was some issue while correcting her record from back-end last time, Now we have corrected it properly. Please check. #2 Cobra Coverage file stopped exporting Group template's Prime Healthcare_NEW HRSimplified_COBRA Coverage_Group schedule start date is change to "2018-12-07 15:00:00.000" on 12/04 by you. Please start date to year 2017. Note: Please export all these 3 group file at once to get them aligned, send them to vendor informing coverage file did not run on 12/07 and 12/14 whereas participant and dependent file ran on those dates. Coverage records for those participant file ( 12/7 and 12/14) will export on next run. let us know if you have any questions on this. Thanks.
          Hide
          alexn Alex Nguyen added a comment -

          Appreciate the fix, Vinayak Kulkarni. Sorry I must have changed the delivery date out to following week 12/7/17 to give time for fixing the record and any changes to the template, but somehow 2018 date was selected by mistake. Reason I do this date change under delivery tab is, because many global template would auto export the file once we make any small changes and saving it. It happened to me with other global templates I worked with in the past. I should have looked at this date closely, before letting it run on its own.

          I have exported all 3 cobra files (dependent, participant, and coverage) today and notified the carrier. I do see Kristi Ayala now on the participant and coverage files

          Thank you,

          Alex

          Show
          alexn Alex Nguyen added a comment - Appreciate the fix, Vinayak Kulkarni . Sorry I must have changed the delivery date out to following week 12/7/17 to give time for fixing the record and any changes to the template, but somehow 2018 date was selected by mistake. Reason I do this date change under delivery tab is, because many global template would auto export the file once we make any small changes and saving it. It happened to me with other global templates I worked with in the past. I should have looked at this date closely, before letting it run on its own. I have exported all 3 cobra files (dependent, participant, and coverage) today and notified the carrier. I do see Kristi Ayala now on the participant and coverage files Thank you, Alex

            People

            Assignee:
            alexn Alex Nguyen
            Reporter:
            alexn Alex Nguyen
            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 - 7h
                7h