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

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

    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

      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. AlectoHealthcareCoverage-St Rose201801110333.txt
          1.0 kB
        2. AlectoHealthcareCoverage-St Rose201803260326.txt
          0.2 kB
        3. AlectoHealthcareDependent-St Rose201801110333.txt
          0.7 kB
        4. AlectoHealthcareDependent-St Rose201803260325.txt
          0.1 kB
        5. AlectoHealthcareParticipant-St Rose201801110333.txt
          1 kB
        6. AlectoHealthcareParticipant-St Rose201803260323.txt
          0.3 kB
        7. COBRA_P_EBSBenefits_Alecto_010920180223_230647628140.txt
          8 kB
        8. COBRA_P_EBSBenefits_Alecto_010920180223_230647628140.txt
          8 kB
        9. COBRA_P_EBSBenefits_Alecto_011120181120.txt
          7 kB
        10. EBS_TERMS_COBRA010920180331.xls
          19 kB
        11. EBS_TERMS_COBRA03272018_Karma
          14 kB
        12. exported.jpg
          exported.jpg
          290 kB
        13. January 2018_Prime Healthcare.zip
          11 kB
        14. March 2018_Prime Healthcare.zip
          4 kB
        15. PrimeHealthCareCobra.zip
          8 kB
        16. Re Cobra file for missed records on Nexion.msg
          65 kB
        17. Re Export Feed List From 01 11 2018 8AM To 01 12 2018 8AM PST.msg
          224 kB
        18. St Mary Employees_Updated-Final.xls
          31 kB
        19. St Mary Employees.xlsx
          13 kB
        20. WARNING - ENCRYPTED ATTACHMENT NOT VIRUS SCANNED Cobra file for missed records on Nexion.msg
          64 kB
        21. WARNING - ENCRYPTED ATTACHMENT NOT VIRUS SCANNED Missing cobra records files.msg
          72 kB
        22. WB-236.xls
          18 kB
        23. WB-236 Issue.doc
          490 kB

          Issue Links

            Activity

            Transition Time In Source Status Execution Times
            Vinayak Kulkarni (Inactive) made transition -
            Open In Progress
            17m 18s 1
            Vinayak Kulkarni (Inactive) made transition -
            In Progress Open
            52d 14h 11m 1
            Rajendra Pawar (Inactive) made transition -
            Open In Development
            26d 18h 23m 1
            Niteen Surwase (Inactive) made transition -
            In Development In Analysis
            20d 19h 6m 1
            Niteen Surwase (Inactive) made transition -
            In Analysis In Development
            17d 2h 54m 1
            Niteen Surwase (Inactive) made transition -
            In Production Review REOPENED IN PRODUCTION REVIEW
            12d 21h 10m 1
            Niteen Surwase (Inactive) made transition -
            REOPENED IN PRODUCTION REVIEW In Development
            9s 1
            Niteen Surwase (Inactive) made transition -
            In Development LB Deployed
            23h 39m 2
            Niteen Surwase (Inactive) made transition -
            LB Deployed In LB Testing
            14s 2
            Niteen Surwase (Inactive) made transition -
            In LB Testing Ready for Pre-Prod
            11s 2
            Niteen Surwase (Inactive) made transition -
            Ready for Pre-Prod Pre-Prod Deployed
            9s 2
            Niteen Surwase (Inactive) made transition -
            Pre-Prod Deployed IN Pre-prod Testing
            8s 2
            Niteen Surwase (Inactive) made transition -
            IN Pre-prod Testing Ready for Production
            10s 2
            Niteen Surwase (Inactive) made transition -
            Ready for Production Production Deployed
            13s 2
            Swapnil Eksambekar (Inactive) made transition -
            Production Deployed In Production Testing
            1d 1h 55m 2
            Swapnil Eksambekar (Inactive) made transition -
            In Production Testing In Production Review
            23d 21h 58m 2
            Alex Nguyen made transition -
            In Production Review Closed
            2d 11h 7m 1

              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