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

UND (University of Notre Dame) - Supplemental Life

    Details

    • Type: Support Activity
    • Status: Resolved
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Support Task Type:
      Data Correction
    • Environment:
      Production
    • Reported by:
      Client
    • Company:
      University of Notre Dame
    • Module:
      BenAdmin - Enrollment

      Description

      URGENT EMPLOYER ISSUE

      Tagging Damion M Velasquez
      During OE set up, we also set up a SSO with Securian and made sure the EOI rules were set correctly and transferring correctly. Several tests were done and several corrections made, but now the files are showing incorrectly as well as some incorrect data to Securian.

      This is causing extreme hardship for the client. Possible Ticket to Reference: WT-6196

      Below are some examples found by the client:

      Tijana Milenkovic (NDID: 901669678) was approved for 3x her salary for supplemental life insurance as of 2/1/2016. This was entered correctly in Banner and also WorkTerra in 2016. During open enrollment Tijana elected to keep her coverage at 3x for 2017. However, the upload from WorkTerra changed her election to 1x her salary as of 2/6/2016. Can you please explain the reason for the reduction and also the arbitrary date change? I would like to try to determine if there are others that experienced this type of situation. If you know of a way to audit this problem that would be helpful.

      Thomas O'Sullivan (NDID: 901968258) elected 3x his salary for supplemental life insurance as of 7/1/2016 when he was newly hired. During open enrollment he elected to increase his coverage to 4x for 2017. This increase does not require an EOI through Securian since he only increased by 1x his salary and the total amount of coverage does not exceed $750,000. However, his information was sent to Securian by WorkTerra indicating that an EOI was required. There are several other individuals that experienced this same exact scenario as well.

      Salary multiples are not rounding correctly for all individuals. This was an issue last year too. For example, Boldizsar Janko (NDID: 900513331) shows up in Securian with 10.01x his salary. We only allow whole number multiples.

      Keith Hostetler (NDID: 901917614) appears to have elected 4x his salary during open enrollment. He did not previously have coverage, so this would require an EOI with Securian. Based on the open enrollment upload Keith was given 3x his salary as of 1/1/17. He should not have received any coverage since he has not been approved through Securian. There are others in a similar situation as well. Is WorkTerra set up to automatically approve 3x coverage for anyone that is electing coverage for the first time during open enrollment?

      Lawrence Dwyer (NDID: 900313791) had 10x his salary in 2016, but he was sent to Securian stating that he needed to complete an EOI in order to receive 10x his salary again in 2017. This was not a change, so it does not require an EOI.

      I need corrections and audit done asap.

        Attachments

        1. AffectedEmployee_List.xls
          13 kB
          Neelam Yangal
        2. screenshot-1.png
          12 kB
          Jennifer Johnson
        3. UND_Supp_Life_List.xls
          11 kB
          Jyoti Mayne

          Issue Links

            Activity

            Hide
            Deborah.Mascot@ebsbenefits.com Deborah Mascot (Inactive) added a comment -

            Note that the enrollment was not to be done by Securian. The EOI processing was all that was sent through the SSO connection with Securian. Only those elections requiring EOI were to be sent through that connection.

            Show
            Deborah.Mascot@ebsbenefits.com Deborah Mascot (Inactive) added a comment - Note that the enrollment was not to be done by Securian. The EOI processing was all that was sent through the SSO connection with Securian. Only those elections requiring EOI were to be sent through that connection.
            Hide
            jyoti.mayne Jyoti Mayne added a comment -

            Hello Deborah Mascot,

            Shall we proceed with data correction for the employee ''Tijana Milenkovic'' as explained in above comments in tabular format.

            We will also do scanning and check whether employees coverage are as per current salary and do correction if required.

            Show
            jyoti.mayne Jyoti Mayne added a comment - Hello Deborah Mascot , Shall we proceed with data correction for the employee ''Tijana Milenkovic'' as explained in above comments in tabular format. We will also do scanning and check whether employees coverage are as per current salary and do correction if required.
            Hide
            Deborah.Mascot@ebsbenefits.com Deborah Mascot (Inactive) added a comment -

            Yes, you should make the change for Tijana Milenkovic.

            Show
            Deborah.Mascot@ebsbenefits.com Deborah Mascot (Inactive) added a comment - Yes, you should make the change for Tijana Milenkovic.
            Hide
            jyoti.mayne Jyoti Mayne added a comment -

            Hello Deborah Mascot,

            We have scanned all employees and found attached UND_Supp_Life_List.xls employees whose coverage were not as per 2017 salary for Supp Life plans. We have corrected their coverages.

            Please confirm and let us know if you face any issue.

            Cc: Satya, Jaideep Vinchurkar, Vishal Bajad, Vijay Siddha

            Show
            jyoti.mayne Jyoti Mayne added a comment - Hello Deborah Mascot , We have scanned all employees and found attached UND_Supp_Life_List.xls employees whose coverage were not as per 2017 salary for Supp Life plans. We have corrected their coverages. Please confirm and let us know if you face any issue. Cc: Satya , Jaideep Vinchurkar , Vishal Bajad , Vijay Siddha
            Hide
            rakeshr Rakesh Roy (Inactive) added a comment -

            Deborah Mascot Please update for next action if required.

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - Deborah Mascot Please update for next action if required.

              People

              Assignee:
              Deborah.Mascot@ebsbenefits.com Deborah Mascot (Inactive)
              Reporter:
              Deborah.Mascot@ebsbenefits.com Deborah Mascot (Inactive)
              Developer:
              Amruta Lohiya
              Votes:
              0 Vote for this issue
              Watchers:
              12 Start watching this issue

                Dates

                Due:
                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 1.5h Original Estimate - 1.5h
                  1.5h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 21h
                  21h