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

CHMC - Sun Life Supplemental Life coverages terminated after salary update

    Details

    • Type: Support Activity
    • Status: Closed
    • Priority: Critical
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Support Task Type:
      Configuration
    • Environment:
      Production
    • Reported by:
      EDI
    • Company:
      CHMC
    • Module:
      BenAdmin - Enrollment
    • Issue Importance:
      Must Have
    • Severity:
      Simple
    • Provider & Benefits:
      Sun Life Financial-LTD, Sun Life Financial-Optional Life - Child, Sun Life Financial-Optional Life - Employee, Sun Life Financial-Optional Life - Spouse, (3)
      Sun Life Financial-STD, Sun Life Financial-Voluntary LTD, Sun Life Financial-Voluntary STD
    • Reported by Customer:
      Kelly Kyle at CHMC

      Description

      client: Prime Healthcare
      *facility: CHMC
      import template: Salary_Change_Ongoing
      import date: 10/17/17
      example affected: Helen Manzano and Janis Ozaki

      Hi Development Team,

      We did a salary update/load back in 10/17/17 around open enrollment and after the salary loaded into WT, some employees supplemental life coverages were terminated afterwards. The employees listed above were reported with the terminated coverages. There may be more out there with the same issue. So far this is the only facility from Prime Healthcare with the issue. You can find the original salary file used during the load from following location:

      Y:\1.CLIENT\Prime Healthcare\0. OPEN ENROLLMENT\OE 2018\14. SALARY UPDATES\CHMC.txt

      The employees coverages were supposed to roll over to 2018. Normally a salary increase or update should have increased the amounts instead of terminating the coverages. The CE already checked the plan/rule settings and couldn't find anything that is triggering the termination. Can you check in the back end to see if there's something causing the issue? I have attached screenshots of the payroll and enrollment history for review.

      Client needs resolution soon if possible before the next payroll file. Let me know if you need additional info from me.

      Thank you,

      Alex

      Amber Love-Jones Amit Thorve Vinayak Kulkarni

        Attachments

        1. CHMC Affected EE List.xlsx
          32 kB
        2. payroll update.jpg
          payroll update.jpg
          69 kB
        3. payroll update2.jpg
          payroll update2.jpg
          77 kB
        4. term coverages.jpg
          term coverages.jpg
          38 kB
        5. term coverages2.jpg
          term coverages2.jpg
          25 kB
        6. term coverages3.jpg
          term coverages3.jpg
          53 kB

          Activity

          Hide
          suraj.sokasane Suraj Sokasane (Inactive) added a comment -

          Hi Alex Nguyen,

          Answering to your question "how can we avoid this from happening again in the future?"
          This is called as "Back-end Routine failure" after Import. We monitor this under WT-13017 on daily basis. Additionally, we get an email whenever back-end routine fails. So we do the corrections if required and re-execute the routines.

          Show
          suraj.sokasane Suraj Sokasane (Inactive) added a comment - Hi Alex Nguyen , Answering to your question " how can we avoid this from happening again in the future? " This is called as "Back-end Routine failure" after Import. We monitor this under WT-13017 on daily basis. Additionally, we get an email whenever back-end routine fails. So we do the corrections if required and re-execute the routines.
          Hide
          alexn Alex Nguyen added a comment -

          Thank you Suraj Sokasane for taking care of the issue. I will make note it.

          Alex

          Show
          alexn Alex Nguyen added a comment - Thank you Suraj Sokasane for taking care of the issue. I will make note it. Alex
          Hide
          alov Amber Love-Jones (Inactive) added a comment -

          Thank you all for helping to resolve this.

          Amber

          Show
          alov Amber Love-Jones (Inactive) added a comment - Thank you all for helping to resolve this. Amber
          Hide
          alov Amber Love-Jones (Inactive) added a comment - - edited

          Hello,

          Please look at confirmation statement for ee Helen Manzano. There are no Employee costs showing for the Optional Life Plan. Was this something that should have been updated in WorkTerra along with the updates Dev made for the other 290 entries? Please see screenshot attached.

          Please advise a.s.a.p.

          Thank you.

          Amber

          Show
          alov Amber Love-Jones (Inactive) added a comment - - edited Hello, Please look at confirmation statement for ee Helen Manzano. There are no Employee costs showing for the Optional Life Plan. Was this something that should have been updated in WorkTerra along with the updates Dev made for the other 290 entries? Please see screenshot attached. Please advise a.s.a.p. Thank you. Amber
          Hide
          alov Amber Love-Jones (Inactive) added a comment -

          Hello,

          Just discovered that the employee actually waived the Voluntary Life benefit; this is separate from the STD and LTD benefits that she was to remain enrolled in that were taken care of previously on this ticket.

          My apologies.

          Amber

          Show
          alov Amber Love-Jones (Inactive) added a comment - Hello, Just discovered that the employee actually waived the Voluntary Life benefit; this is separate from the STD and LTD benefits that she was to remain enrolled in that were taken care of previously on this ticket. My apologies. Amber

            People

            Assignee:
            jyoti.mayne Jyoti Mayne
            Reporter:
            alexn Alex Nguyen
            Votes:
            0 Vote for this issue
            Watchers:
            6 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 - 36.25h
                36.25h