Uploaded image for project: 'Workterra BenAdmin'
  1. Workterra BenAdmin
  2. WB-236

Saint Mary Regional Medical terms didn't transmit to HR Simplified COBRA

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: High
    • Resolution: Bug Fixed
    • Labels:
      None
    • Environment:
      Production
    • Categories:
      EDS
    • Company:
      Prime Healthcare
    • Reported by:
      EDI
    • Provider & Benefits:
      Vision VSP-Vision
    • Dev Estimates:
      8
    • QA Estimates:
      16
    • Sprint:
      WB - Sprint 46

      Description

      COBRA_P_EBSBenefits_Alecto_010920180223_230647628140.txt  Client: Prime Healthcare
      Facility: Saint Mary Regional Medical Center
      Group Template:
      Prime Healthcare_NEW HRSimplified_COBRA Coverage_Group
      Prime Healthcare_NEW HR Simplified COBRA Participant_Group
      Prime Healthcare_NEW HR Simplified COBRA DEPENDENT_Group
      Company Template affected:
      NEW HRSimplified_COBRA Coverage
      NEW HR Simplified COBRA Participant
      NEW HR Simplified COBRA DEPENDENT
      Export date: November and December 2017
      Export date example: 12/4/17, 12/19/2017
      Example affected: Christina Abina (terminated/per diem)

      Hello Vinayak Kulkarni,

      The carrier provided us a list of Saint Mary employees who's coverage were terminated but never went over on the HR Simplified COBRA files. There's many for the month of November and December. I didn't see Christina Abina on any of the files between 12/4/17 - 12/28/17. She had Medical, VSP vision, and Delta Dental terminated effective 12/31/17.

      Please see attachment with list of employees provided by the carrier. I took a quick look at the company templates and can see the facility, status, and plans are correctly selected. Not sure why many aren't coming over St Mary Employees.xlsx on the file.

      Thank you,

      Alex

      CC: Amit Thorve Amber Love-Jones

       

      Adding all COBRA files requested to be sent associated with this Bug. 

      Files are being attached to this ticket.

      In Jan 2018
      St Rose
      WNJ
      HMC
      Prime HealthCare
      PrimeHealthCare
      EHMC
      Hallmark Aviation Services
      KMC
      MHIN
      SRMC
      Karma
      El Camino
      Symphony
      PMC

       

      March 2018
      St Rose
      Prime Healthcare
      MHIN
      Karma
      City of Bellevue

        Attachments

        1. St Mary Employees.xlsx
          13 kB
          Alex Nguyen
        2. St Mary Employees_Updated-Final.xls
          31 kB
          Vinayak Kulkarni
        3. WB-236.xls
          18 kB
          Swapnil Eksambekar
        4. Re Cobra file for missed records on Nexion.msg
          65 kB
          Damion M Velasquez
        5. WARNING - ENCRYPTED ATTACHMENT NOT VIRUS SCANNED Missing cobra records files.msg
          72 kB
          Damion M Velasquez
        6. WARNING - ENCRYPTED ATTACHMENT NOT VIRUS SCANNED Cobra file for missed records on Nexion.msg
          64 kB
          Damion M Velasquez
        7. Re Export Feed List From 01 11 2018 8AM To 01 12 2018 8AM PST.msg
          224 kB
          Damion M Velasquez
        8. EBS_TERMS_COBRA010920180331.xls
          19 kB
          Cindy Wibbing
        9. EBS_TERMS_COBRA03272018_Karma
          14 kB
          Cindy Wibbing
        10. AlectoHealthcareParticipant-St Rose201801110333.txt
          1 kB
          Rochelle Thomas
        11. AlectoHealthcareDependent-St Rose201801110333.txt
          0.7 kB
          Rochelle Thomas
        12. AlectoHealthcareCoverage-St Rose201801110333.txt
          1.0 kB
          Rochelle Thomas
        13. COBRA_P_EBSBenefits_Alecto_010920180223_230647628140.txt
          8 kB
          Rochelle Thomas
        14. AlectoHealthcareParticipant-St Rose201803260323.txt
          0.3 kB
          Rochelle Thomas
        15. AlectoHealthcareDependent-St Rose201803260325.txt
          0.1 kB
          Rochelle Thomas
        16. AlectoHealthcareCoverage-St Rose201803260326.txt
          0.2 kB
          Rochelle Thomas
        17. COBRA_P_EBSBenefits_Alecto_011120181120.txt
          7 kB
          Rochelle Thomas
        18. COBRA_P_EBSBenefits_Alecto_010920180223_230647628140.txt
          8 kB
          Rochelle Thomas
        19. WB-236 Issue.doc
          490 kB
          Niteen Surwase
        20. exported.jpg
          290 kB
          Alex Nguyen

          Issue Links

            Activity

              People

              Assignee:
              alexn Alex Nguyen
              Reporter:
              alexn Alex Nguyen
              Developer:
              Niteen Surwase (Inactive)
              QA:
              Swapnil Eksambekar (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              18 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 0h
                  0h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 290.65h
                  290.65h