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

          alexn Alex Nguyen created issue -
          alexn Alex Nguyen made changes -
          Field Original Value New Value
          Summary CHMC - Supplemental Lie coverages terminated after salary update CHMC - Sun Life Supplemental Life coverages terminated after salary update
          umesh.kadam Umesh Kadam (Inactive) made changes -
          Assignee Satya [ ID10004 ] Umesh Kadam [ umesh.kadam ]
          Status Open [ 1 ] In Progress [ 3 ]
          umesh.kadam Umesh Kadam (Inactive) made changes -
          Assignee Umesh Kadam [ umesh.kadam ] Shailendra Honrao [ shailendra.honrao ]
          shailendra.honrao Shailendra Honrao (Inactive) made changes -
          Remaining Estimate 0h [ 0 ]
          Time Spent 8h [ 28800 ]
          Worklog Id 100420 [ 100420 ]
          shailendra.honrao Shailendra Honrao (Inactive) made changes -
          Assignee Shailendra Honrao [ shailendra.honrao ] Jaideep Vinchurkar [ jaideep.vinchurkar ]
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
          Time Spent 8h [ 28800 ] 8.5h [ 30600 ]
          Worklog Id 100566 [ 100566 ]
          shailendra.honrao Shailendra Honrao (Inactive) made changes -
          Time Spent 8.5h [ 30600 ] 16.5h [ 59400 ]
          Worklog Id 100589 [ 100589 ]
          jyoti.mayne Jyoti Mayne made changes -
          Assignee Jaideep Vinchurkar [ jaideep.vinchurkar ] Vinanti Yadav [ vinanti.yadav ]
          vinanti.yadav Vinanti Yadav (Inactive) made changes -
          Time Spent 16.5h [ 59400 ] 22.5h [ 81000 ]
          Worklog Id 101056 [ 101056 ]
          vinanti.yadav Vinanti Yadav (Inactive) made changes -
          Remaining Estimate 0h [ 0 ] 2h [ 7200 ]
          Time Spent 22.5h [ 81000 ] 20.5h [ 73800 ]
          Worklog Id 101056 [ 101056 ]
          vinanti.yadav Vinanti Yadav (Inactive) made changes -
          Remaining Estimate 2h [ 7200 ] 1h [ 3600 ]
          Time Spent 20.5h [ 73800 ] 21.5h [ 77400 ]
          Worklog Id 101056 [ 101056 ]
          vinanti.yadav Vinanti Yadav (Inactive) made changes -
          Remaining Estimate 1h [ 3600 ] 0h [ 0 ]
          Time Spent 21.5h [ 77400 ] 29h [ 104400 ]
          Worklog Id 101057 [ 101057 ]
          jyoti.mayne Jyoti Mayne made changes -
          Assignee Vinanti Yadav [ vinanti.yadav ] Jyoti Mayne [ jyoti.mayne ]
          jyoti.mayne Jyoti Mayne made changes -
          Attachment CHMC Affected EE List.xlsx [ 72062 ]
          jyoti.mayne Jyoti Mayne made changes -
          Status In Progress [ 3 ] Waiting for Customer Input [ 10500 ]
          jyoti.mayne Jyoti Mayne made changes -
          Assignee Jyoti Mayne [ jyoti.mayne ] Alex Nguyen [ alexn ]
          jyoti.mayne Jyoti Mayne made changes -
          Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
          jyoti.mayne Jyoti Mayne made changes -
          Assignee Alex Nguyen [ alexn ] Jyoti Mayne [ jyoti.mayne ]
          jyoti.mayne Jyoti Mayne made changes -
          Assignee Jyoti Mayne [ jyoti.mayne ] Suraj Sokasane [ suraj.sokasane ]
          suraj.sokasane Suraj Sokasane (Inactive) made changes -
          Assignee Suraj Sokasane [ suraj.sokasane ] Alex Nguyen [ alexn ]
          Resolution Done [ 10000 ]
          Status In Progress [ 3 ] Resolved [ 5 ]
          jyoti.mayne Jyoti Mayne made changes -
          Time Spent 29h [ 104400 ] 29.5h [ 106200 ]
          Worklog Id 101645 [ 101645 ]
          jyoti.mayne Jyoti Mayne made changes -
          Time Spent 29.5h [ 106200 ] 31h [ 111600 ]
          Worklog Id 101713 [ 101713 ]
          jyoti.mayne Jyoti Mayne made changes -
          Time Spent 31h [ 111600 ] 31.25h [ 112500 ]
          Worklog Id 101713 [ 101713 ]
          jyoti.mayne Jyoti Mayne made changes -
          Time Spent 31.25h [ 112500 ] 36.25h [ 130500 ]
          Worklog Id 101764 [ 101764 ]
          alov Amber Love-Jones (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status Resolved [ 5 ] Reopen [ 4 ]
          alov Amber Love-Jones (Inactive) made changes -
          Assignee Alex Nguyen [ alexn ] Jyoti Mayne [ jyoti.mayne ]
          alov Amber Love-Jones (Inactive) made changes -
          Resolution Unresolved [ 10200 ]
          Status Reopen [ 4 ] Closed [ 6 ]

            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