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

            alexn Alex Nguyen created issue -
            Hide
            jenniferreed Jennifer Reed (Inactive) added a comment -

            Alex Nguyen Hey Alex, bug tickets needed to be created in the WB project not WD. WD is only used by development, and we want to make sure we don't lose your bug ticket. I will convert this for you to the WB project, but wanted to let you know which one to use for bugs moving forward.
            Satya

            Show
            jenniferreed Jennifer Reed (Inactive) added a comment - Alex Nguyen Hey Alex, bug tickets needed to be created in the WB project not WD. WD is only used by development, and we want to make sure we don't lose your bug ticket. I will convert this for you to the WB project, but wanted to let you know which one to use for bugs moving forward. Satya
            jenniferreed Jennifer Reed (Inactive) made changes -
            Field Original Value New Value
            Environment Production [ 18442 ]
            Key WD-64 WB-560
            Project Workterra Development [ 11503 ] Workterra BenAdmin [ 11501 ]
            Reported by EDI [ 18440 ]
            Status To Do [ 10000 ] Open [ 1 ]
            Workflow WD: Project Management Workflow [ 66222 ] 0803 Copy of WB: Bugs Project Management Workflow [ 66227 ]
            Hide
            alexn Alex Nguyen added a comment -

            Sorry Jennifer Reed. I will remember to create WB tickets next time, but thank you for informing me and taking care of it right away to avoid any delays with resolution.

            Alex

            Show
            alexn Alex Nguyen added a comment - Sorry Jennifer Reed . I will remember to create WB tickets next time, but thank you for informing me and taking care of it right away to avoid any delays with resolution. Alex
            alexn Alex Nguyen made changes -
            Assignee Jennifer Reed [ jenniferreed ] Nidhi Kaul [ nidhi.kaul ]
            alexn Alex Nguyen made changes -
            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 DEPENDENT_Group
            *Company Template affected: *
            NEW HRSimplified_COBRA Coverage
            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 !ViewHistory.png|thumbnail!
            CC: [~alov] [~agarvey]
            *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 !ViewHistory.png|thumbnail!
            CC: [~alov] [~agarvey]
            Hide
            Prashant.samal Prashant Samal (Inactive) added a comment -

            Vinayak Kulkarni Rakesh Shahane

            Please check this

            __________________
            Satya

            Show
            Prashant.samal Prashant Samal (Inactive) added a comment - Vinayak Kulkarni Rakesh Shahane Please check this __________________ Satya
            Prashant.samal Prashant Samal (Inactive) made changes -
            Assignee Nidhi Kaul [ nidhi.kaul ] Vinayak Kulkarni [ vinayak.kulkarni ]
            rakesh.shahane Rakesh Shahane (Inactive) logged work - 13/Mar/18 07:08 AM
            • Time Spent:
              4.5h
               
              <No comment>
            rakesh.shahane Rakesh Shahane (Inactive) made changes -
            Assignee Vinayak Kulkarni [ vinayak.kulkarni ] Rakesh Shahane [ rakesh.shahane ]
            satyap Satya made changes -
            Sprint WB - Sprint 45 [ 102 ]
            satyap Satya made changes -
            Rank Ranked higher
            rakesh.shahane Rakesh Shahane (Inactive) made changes -
            Attachment AmySiporen.jpg [ 74570 ]
            Hide
            rakesh.shahane Rakesh Shahane (Inactive) added a comment -

            Hi Alex Nguyen,

            #1
            For Employee Amber Senator, System did not capture the termination, We are working on this and will update you ASAP.

            For Employee Amy Siporen We have checked the view history and found that current status of Employee is active, So this will not export on COBRA file.
            Please find attached screen shot .

            #2
            Template Prime Healthcare_NEW HR Simplified COBRA DEPENDENT_Group has been deleted by mistake from @Van,
            So we have created it again and set the rundate from EDI Utility as 3/8/2018.
            Please refer WB-553 for more details.

            Please let us know if you required more details on this.

            CC-Vinayak Kulkarni, Swapnil Pandhare

            Show
            rakesh.shahane Rakesh Shahane (Inactive) added a comment - Hi Alex Nguyen , #1 For Employee Amber Senator , System did not capture the termination, We are working on this and will update you ASAP. For Employee Amy Siporen We have checked the view history and found that current status of Employee is active, So this will not export on COBRA file. Please find attached screen shot . #2 Template Prime Healthcare_NEW HR Simplified COBRA DEPENDENT_Group has been deleted by mistake from @Van, So we have created it again and set the rundate from EDI Utility as 3/8/2018. Please refer WB-553 for more details. Please let us know if you required more details on this. CC- Vinayak Kulkarni , Swapnil Pandhare
            Prashant.samal Prashant Samal (Inactive) made changes -
            Link This issue relates to WB-236 [ WB-236 ]
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) logged work - 13/Mar/18 02:51 PM
            • Time Spent:
              2h
               
              <No comment>
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 2h [ 7200 ]
            Worklog Id 108143 [ 108143 ]
            alexn Alex Nguyen made changes -
            Attachment termed.jpg [ 74572 ]
            Hide
            alexn Alex Nguyen added a comment -

            Thank you Rakesh Shahane for the update. My apology, please disregard Amy Siporen. The terminated employee with the issue is actually Angelique Manis who terminated on 02/23/2018 (transaction 02/22/2018 12:29:40 PM). Sorry I must have mistakenly copied Amy Siporen into the ticket somehow. So the two affected are Amber Senator and Angelique Manis terminated with reason Involuntary Termination. Keep in mind, you won't need to send a notice out to Amber Senator because it's already been done manually by the client. She won't need to be on the next file, but you can use her and Angelique as samples for the bug. Angelique will need a notice/packet.

            Alex

            Show
            alexn Alex Nguyen added a comment - Thank you Rakesh Shahane for the update. My apology, please disregard Amy Siporen. The terminated employee with the issue is actually Angelique Manis who terminated on 02/23/2018 (transaction 02/22/2018 12:29:40 PM). Sorry I must have mistakenly copied Amy Siporen into the ticket somehow. So the two affected are Amber Senator and Angelique Manis terminated with reason Involuntary Termination . Keep in mind, you won't need to send a notice out to Amber Senator because it's already been done manually by the client. She won't need to be on the next file, but you can use her and Angelique as samples for the bug. Angelique will need a notice/packet. Alex
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) logged work - 14/Mar/18 06:21 AM
            • Time Spent:
              4h
               
              <No comment>
            rakesh.shahane Rakesh Shahane (Inactive) logged work - 14/Mar/18 07:13 AM
            • Time Spent:
              5h
               
              <No comment>
            rajendra.pawar Rajendra Pawar (Inactive) made changes -
            Categories Parent values: Export(18505)Level 1 values: Scheduled Export(18509) Parent values: EDS(18481)
            Hide
            rakesh.shahane Rakesh Shahane (Inactive) added a comment -

            Hi Alex Nguyen,
            We have checked the details of employee and found the same discrepancy, That system did not capture the term. We suspect there are other terminated Employees are missing too, So We are scanning the data and will update you ASAP.

            CC-Vinayak Kulkarni

            Show
            rakesh.shahane Rakesh Shahane (Inactive) added a comment - Hi Alex Nguyen , We have checked the details of employee and found the same discrepancy, That system did not capture the term. We suspect there are other terminated Employees are missing too, So We are scanning the data and will update you ASAP. CC- Vinayak Kulkarni
            rajendra.pawar Rajendra Pawar (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            rakesh.shahane Rakesh Shahane (Inactive) made changes -
            Time Spent 2h [ 7200 ] 6.5h [ 23400 ]
            Worklog Id 108453 [ 108453 ]
            rakesh.shahane Rakesh Shahane (Inactive) made changes -
            Time Spent 6.5h [ 23400 ] 11.5h [ 41400 ]
            Worklog Id 108457 [ 108457 ]
            rajendra.pawar Rajendra Pawar (Inactive) logged work - 15/Mar/18 12:00 PM
            • Time Spent:
              4.5h
               

              Scan missed records for all company script creation

            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) logged work - 15/Mar/18 05:04 PM
            • Time Spent:
              3h
               
              <No comment>
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Time Spent 11.5h [ 41400 ] 14.5h [ 52200 ]
            Worklog Id 108628 [ 108628 ]
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) logged work - 16/Mar/18 06:26 AM
            • Time Spent:
              7h
               
              <No comment>
            rajendra.pawar Rajendra Pawar (Inactive) made changes -
            Time Spent 14.5h [ 52200 ] 19h [ 68400 ]
            Worklog Id 108789 [ 108789 ]
            rajendra.pawar Rajendra Pawar (Inactive) logged work - 16/Mar/18 11:45 AM
            • Time Spent:
              7h
               

              Scanned missed records and verified valid missed records

            rajendra.pawar Rajendra Pawar (Inactive) made changes -
            Time Spent 19h [ 68400 ] 26h [ 93600 ]
            Worklog Id 108791 [ 108791 ]
            Hide
            rajendra.pawar Rajendra Pawar (Inactive) added a comment -

            We are working on this and we will send missed cobra employee file in the next week.

            Vinayak Kulkarni Rajendra Pawar

            Show
            rajendra.pawar Rajendra Pawar (Inactive) added a comment - We are working on this and we will send missed cobra employee file in the next week. Vinayak Kulkarni Rajendra Pawar
            Hide
            jenniferreed Jennifer Reed (Inactive) added a comment -

            Satya We need to duplicate this with WB-236 and pickup WB-236 in Sprint 45, which should cover both tickets.

            Show
            jenniferreed Jennifer Reed (Inactive) added a comment - Satya We need to duplicate this with WB-236 and pickup WB-236 in Sprint 45, which should cover both tickets.
            swapnil.pandhare Swapnil Pandhare (Inactive) logged work - 19/Mar/18 02:37 AM
            • Time Spent:
              1h
               

              Discussion

            Prashant.samal Prashant Samal (Inactive) made changes -
            Link This issue relates to WB-236 [ WB-236 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Link This issue duplicates WB-236 [ WB-236 ]
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Link This issue is duplicated by WB-236 [ WB-236 ]
            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.
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) logged work - 19/Mar/18 01:13 PM
            • Time Spent:
              1h
               
              <No comment>
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Time Spent 26h [ 93600 ] 27h [ 97200 ]
            Worklog Id 108958 [ 108958 ]
            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
            satyap Satya made changes -
            Root Cause Duplicate Issue [ 18433 ]
            Original Estimate 0h [ 0 ]
            satyap Satya made changes -
            Resolution Duplicate [ 3 ]
            Status In Development [ 10007 ] Rejected [ 10004 ]
            satyap Satya made changes -
            Link This issue is duplicated by WB-236 [ WB-236 ]
            satyap Satya made changes -
            Status Rejected [ 10004 ] Closed [ 6 ]
            satyap Satya made changes -
            Sprint WB - Sprint 45 [ 102 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Workflow 0803 Copy of WB: Bugs Project Management Workflow [ 66227 ] 2203 WB: Bugs Project Management Workflow [ 67031 ]
            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
            rajendra.pawar Rajendra Pawar (Inactive) logged work - 26/Mar/18 04:30 PM
            • Time Spent:
              4h
               

              Karma file missed cobra records

            rajendra.pawar Rajendra Pawar (Inactive) made changes -
            Time Spent 27h [ 97200 ] 31h [ 111600 ]
            Worklog Id 110049 [ 110049 ]
            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Time Spent 31h [ 111600 ] 32h [ 115200 ]
            Worklog Id 110661 [ 110661 ]
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Time Spent 32h [ 115200 ] 36h [ 129600 ]
            Worklog Id 110783 [ 110783 ]
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Time Spent 36h [ 129600 ] 43h [ 154800 ]
            Worklog Id 110793 [ 110793 ]
            Monika.Demla Monika Demla (Inactive) made changes -
            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?
            Prashant.samal Prashant Samal (Inactive) made changes -
            Workflow 2203 WB: Bugs Project Management Workflow [ 67031 ] 0604 Issues Management Workflow [ 68396 ]
            Transition Time In Source Status Execution Times
            Jennifer Reed (Inactive) made transition -
            To Do Open
            8m 14s 1
            Rajendra Pawar (Inactive) made transition -
            Open In Development
            2d 10h 14m 1
            Satya made transition -
            In Development Rejected
            5d 7h 21m 1
            Satya made transition -
            Rejected Closed
            59s 1

              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