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

          shailendra.honrao Shailendra Honrao (Inactive) logged work - 15/Jan/18 12:34 PM
          • Time Spent:
            8h
             

            issue understanding
            analysis data from back end
            reproduce issue by adding test employees and observed data
            analysed the root cause
            share analysis with umesh

          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 16/Jan/18 11:22 AM
          • Time Spent:
            0.5h
             

            Analysis

          shailendra.honrao Shailendra Honrao (Inactive) logged work - 16/Jan/18 12:50 PM
          • Time Spent:
            8h
             

            analysis
            share data and analysis with Jyoti
            conclude that import failed
            communicate with import team
            handover to import team to confirm 'is import failed on 10/17/17 ?'
            waiting for feedback from import team
            jaideep share failure error log
            check data for error log
            analysis data from back end
            share it with jyoti,jaideep

          jyoti.mayne Jyoti Mayne logged work - 16/Jan/18 12:55 PM
          • Time Spent:
            0.5h
             

            analysis and discussion

          vinanti.yadav Vinanti Yadav (Inactive) logged work - 17/Jan/18 05:06 PM
          • Time Spent:
            7.5h
             
            • Discussions. 30m
            • Writing script to find Affected Employee and their Enrollment. 1h
            • Data scanning is Completed for 10 Plans. 6h
            • JIRA updates.
          vinanti.yadav Vinanti Yadav (Inactive) logged work - 18/Jan/18 04:59 PM - edited
          • Time Spent:
            5h
             
            • Data scanning.
            • Data Correction and verification on HSPL.
            • Discussions.
          jyoti.mayne Jyoti Mayne logged work - 19/Jan/18 08:41 AM
          • Time Spent:
            5h
             

            analysis, data scanning and correction on HSPL, discussion with Suraj

          jyoti.mayne Jyoti Mayne logged work - 22/Jan/18 04:23 PM - edited
          • Time Spent:
            1.75h
             

            data correction and verification on main company

            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