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

Prime Healthcare > Saint Mary Regional Medical - Terminated employees missing on HR Simplified COBRA file

    Details

    • Type: Bug
    • Status: Closed
    • Priority: High
    • Resolution: Duplicate
    • Labels:
      None
    • Environment:
      Production
    • Categories:
      EDS
    • Company:
      Prime Healthcare
    • Reported by:
      EDI

      Description

      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
      Scheduled Date: Thursday 3:00pm pst
      Export date: 01/25/2018, 02/22/2018, and 03/01/2018
      Affected employees:
      Amber Senator - termed 01/23/2018 (transaction 01/19/2018 12:07:02 PM)
      Amy Siporen - termed 02/23/2018 (transaction 02/22/2018 12:29:40 PM)
      Carrier Contact:
      Cindy Gutierrez
      cindy.gutierrez@hrsimplified.com
      Client Contact:
      Miranda Holmes
      Human Resources Coordinator
      T:775.770.3989

      Hello Development Team,

      Saint Mary HR reported terminated employees who didn't pass over to HR Simplified. They already forwarded Amber Senator to the carrier and a packet is being mailed out. Nothing being sent out yet for Amy Siporen, because we can use her as an example for the bug. Both were terminated with status change reason Involuntary Termination. Can you check to see if there's any issues with the configuration on the backend, then re-trigger Amy Siporen to go on next file along with her dependents?

      There's also an issue I notice with the global template Prime Healthcare_NEW HR Simplified COBRA DEPENDENT_Group. The view history page is empty with message No record Found and also previous run dates are gone except 3/8/2018. Let me know if you need additional info.

      Thank you,

      Alex
      CC: Amber Love-Jones Amanda B. Garvey

        Attachments

        1. AmySiporen.jpg
          AmySiporen.jpg
          204 kB
        2. termed.jpg
          termed.jpg
          21 kB
        3. ViewHistory.png
          ViewHistory.png
          15 kB
        4. WT_13202_CobraContingentPlanCustmization_CompanyList.xls
          31 kB

          Issue Links

            Activity

            Hide
            rakeshr Rakesh Roy (Inactive) added a comment -

            Concern: Terminated employee did not go over COBRA file

            Cause: When active employee becomes terminated then system stores this transition of status change and export uses this stored information to send it on file.
            However in some cases, this information is not getting saved properly and such employees are missing out on cobra file.

            Workaround: While we are still analyzing issue and finding root cause, we have a workaround in which we are planning to deploy a 'database trigger' which will capture all terminations and issue will not occur on future files.
            For records which are already missed, export team has started working on getting a separate cobra file for missing records and will provide it to respective EDI analyst in this week.

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - Concern: Terminated employee did not go over COBRA file Cause: When active employee becomes terminated then system stores this transition of status change and export uses this stored information to send it on file. However in some cases, this information is not getting saved properly and such employees are missing out on cobra file. Workaround: While we are still analyzing issue and finding root cause, we have a workaround in which we are planning to deploy a 'database trigger' which will capture all terminations and issue will not occur on future files. For records which are already missed, export team has started working on getting a separate cobra file for missing records and will provide it to respective EDI analyst in this week.
            Hide
            satyap Satya added a comment -

            This issue duplicates to WB-236. Please refer updates in linked JIRA ticket.

            Regards,
            Satya Prakash

            Cc: Jennifer Reed Rakesh Roy Swapnil Pandhare Prashant Samal Vinayak Kulkarni

            Show
            satyap Satya added a comment - This issue duplicates to WB-236 . Please refer updates in linked JIRA ticket. Regards, Satya Prakash Cc: Jennifer Reed Rakesh Roy Swapnil Pandhare Prashant Samal Vinayak Kulkarni
            Hide
            niteen.surwase Niteen Surwase (Inactive) added a comment -

            Hi Rakesh Roy

            This fix has been deployed on Production. Please verify at your side.

            Thanks,

            Niteen S.

             

            CC: Swapnil Pandhare Satya Prashant Samal

            Show
            niteen.surwase Niteen Surwase (Inactive) added a comment - Hi Rakesh Roy This fix has been deployed on Production. Please verify at your side. Thanks, Niteen S.   CC: Swapnil Pandhare Satya Prashant Samal
            Hide
            Monika.Demla Monika Demla (Inactive) added a comment -

            WT_13202_CobraContingentPlanCustmization_CompanyList.xls

            Hi Jackie Sivigny

             Attached is the list of Groups that are affected. Please let me know if you need anything else.

            cc Satya

            Show
            Monika.Demla Monika Demla (Inactive) added a comment - WT_13202_CobraContingentPlanCustmization_CompanyList.xls Hi Jackie Sivigny  Attached is the list of Groups that are affected. Please let me know if you need anything else. cc Satya
            Hide
            jackie.sivigny Jackie Sivigny (Inactive) added a comment -

            thanks Monika Demla.  Were the impacted records corrected?

            Show
            jackie.sivigny Jackie Sivigny (Inactive) added a comment - thanks Monika Demla .  Were the impacted records corrected?

              People

              Assignee:
              rakesh.shahane Rakesh Shahane (Inactive)
              Reporter:
              alexn Alex Nguyen
              Votes:
              0 Vote for this issue
              Watchers:
              10 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

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