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

            Deborah.Mascot@ebsbenefits.com Deborah Mascot (Inactive) created issue -
            jjsassy99 Jennifer Johnson (Inactive) made changes -
            Field Original Value New Value
            Assignee Jennifer Fernandes [ jjsassy99 ]
            jjsassy99 Jennifer Johnson (Inactive) made changes -
            Attachment screenshot-1.png [ 37365 ]
            jjsassy99 Jennifer Johnson (Inactive) made changes -
            Environment Production [ 10005 ]
            Issue Type Task [ 3 ] Support Activity [ 10301 ]
            Key CT-805 WT-7785
            Project WORKTERRA-CT [ 10800 ] WORKTERRA [ 10000 ]
            Status To Do [ 10000 ] Open [ 1 ]
            Support Task Type Data Correction [ 11203 ]
            Workflow CT: Task Management Workflow [ 30625 ] WT_Support [ 30637 ]
            jjsassy99 Jennifer Johnson (Inactive) made changes -
            Developer Amruta Lohiya [ amruta.baheti ]
            jjsassy99 Jennifer Johnson (Inactive) made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            jjsassy99 Jennifer Johnson (Inactive) made changes -
            Assignee Jennifer Fernandes [ jjsassy99 ] Amruta Lohiya [ amruta.baheti ]
            jyoti.mayne Jyoti Mayne made changes -
            Assignee Amruta Lohiya [ amruta.baheti ] Neelam Yangal [ neelam.yangal ]
            neelam.yangal Neelam Yangal (Inactive) made changes -
            Attachment AffectedEmployee_List.xls [ 37431 ]
            neelam.yangal Neelam Yangal (Inactive) made changes -
            Status In Progress [ 3 ] Waiting for Customer Input [ 10500 ]
            neelam.yangal Neelam Yangal (Inactive) made changes -
            Assignee Neelam Yangal [ neelam.yangal ] Jennifer Fernandes [ jjsassy99 ]
            neelam.yangal Neelam Yangal (Inactive) made changes -
            Remaining Estimate 1.5h [ 5400 ]
            Original Estimate 1.5h [ 5400 ]
            neelam.yangal Neelam Yangal (Inactive) made changes -
            Remaining Estimate 1.5h [ 5400 ] 0h [ 0 ]
            Time Spent 1.5h [ 5400 ]
            Worklog Id 19417 [ 19417 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Assignee Jennifer Fernandes [ jjsassy99 ] Jaideep Vinchurkar [ jaideep.vinchurkar ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Assignee Jaideep Vinchurkar [ jaideep.vinchurkar ] Sachin Hingole [ sachin.hingole ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Assignee Sachin Hingole [ sachin.hingole ] Priya Dhamande [ priya.dhamande ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Assignee Priya Dhamande [ priya.dhamande ] Jaideep Vinchurkar [ jaideep.vinchurkar ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Link This issue is caused by WT-7839 [ WT-7839 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Assignee Jaideep Vinchurkar [ jaideep.vinchurkar ] Jennifer Fernandes [ jjsassy99 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Time Spent 1.5h [ 5400 ] 2h [ 7200 ]
            Worklog Id 19600 [ 19600 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Time Spent 2h [ 7200 ] 6h [ 21600 ]
            Worklog Id 19635 [ 19635 ]
            neelam.yangal Neelam Yangal (Inactive) made changes -
            Time Spent 6h [ 21600 ] 6.5h [ 23400 ]
            Worklog Id 19693 [ 19693 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Link This issue relates to WT-7839 [ WT-7839 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Link This issue relates to WT-7839 [ WT-7839 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Time Spent 6.5h [ 23400 ] 7h [ 25200 ]
            Worklog Id 20694 [ 20694 ]
            satyap Satya made changes -
            Module Parent values: BenAdmin(10100) Parent values: BenAdmin(10100)Level 1 values: Enrollment(10107)
            Deborah.Mascot@ebsbenefits.com Deborah Mascot (Inactive) made changes -
            Assignee Jennifer Fernandes [ jjsassy99 ] Jyoti Mayne [ jyoti.mayne ]
            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 ] Deborah Mascot [ deborah.mascot@ebsbenefits.com ]
            jyoti.mayne Jyoti Mayne made changes -
            Time Spent 7h [ 25200 ] 8h [ 28800 ]
            Worklog Id 22133 [ 22133 ]
            jyoti.mayne Jyoti Mayne made changes -
            Time Spent 8h [ 28800 ] 9h [ 32400 ]
            Worklog Id 22133 [ 22133 ]
            jyoti.mayne Jyoti Mayne made changes -
            Assignee Deborah Mascot [ deborah.mascot@ebsbenefits.com ] Jyoti Mayne [ jyoti.mayne ]
            jyoti.mayne Jyoti Mayne made changes -
            Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
            jyoti.mayne Jyoti Mayne made changes -
            Assignee Jyoti Mayne [ jyoti.mayne ] Santosh Balid [ santosh.balid ]
            santosh.balid Santosh Balid (Inactive) made changes -
            Assignee Santosh Balid [ santosh.balid ] Deborah Mascot [ deborah.mascot@ebsbenefits.com ]
            santosh.balid Santosh Balid (Inactive) made changes -
            Status In Progress [ 3 ] Waiting for Customer Input [ 10500 ]
            santosh.balid Santosh Balid (Inactive) made changes -
            Time Spent 9h [ 32400 ] 10h [ 36000 ]
            Worklog Id 22628 [ 22628 ]
            santosh.balid Santosh Balid (Inactive) made changes -
            Worklog Id 22628 [ 22628 ]
            jyoti.mayne Jyoti Mayne made changes -
            Time Spent 10h [ 36000 ] 12h [ 43200 ]
            Worklog Id 23396 [ 23396 ]
            jyoti.mayne Jyoti Mayne made changes -
            Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
            jyoti.mayne Jyoti Mayne made changes -
            Status In Progress [ 3 ] Waiting for Customer Input [ 10500 ]
            jyoti.mayne Jyoti Mayne made changes -
            Time Spent 12h [ 43200 ] 16h [ 57600 ]
            Worklog Id 25661 [ 25661 ]
            Deborah.Mascot@ebsbenefits.com Deborah Mascot (Inactive) made changes -
            Assignee Deborah Mascot [ deborah.mascot@ebsbenefits.com ] Jyoti Mayne [ jyoti.mayne ]
            jyoti.mayne Jyoti Mayne made changes -
            Time Spent 16h [ 57600 ] 17h [ 61200 ]
            Worklog Id 25703 [ 25703 ]
            jyoti.mayne Jyoti Mayne made changes -
            Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
            jyoti.mayne Jyoti Mayne made changes -
            Attachment UND_Supp_Life_List.xls [ 40002 ]
            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 ] Deborah Mascot [ deborah.mascot@ebsbenefits.com ]
            jyoti.mayne Jyoti Mayne made changes -
            Time Spent 17h [ 61200 ] 21h [ 75600 ]
            Worklog Id 28266 [ 28266 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Resolution Done [ 10000 ]
            Status In Progress [ 3 ] Resolved [ 5 ]
            satyap Satya made changes -
            Environment_New Production [ 18442 ]

              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