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

ATC - Employee AD&D Coverage not matching when max is met

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Environment:
      Production
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - Enrollment
    • Reported by:
      White Label
    • Company:
      ATC
    • Item State:
      Production Complete - Closed
    • Sprint:
      WT- Sprint 43

      Description

      Please look at employee Charles Holland. He elected EE Life with a coverage amount of 200K during OE and the system gave him the two increments of GI 20k which is correct and pended the remaining amount.

      For some reason when the contingent AD&D amount enrolled it is enrolling him in the max of 5x salary and pending nothing. I cannot figure why the EE Life and EE AD&D are set up the same and should always match.

      I thought that maybe some customization was changed after the elections were made but that is not the case. I created Debbie Test and I was able to reproduce the issue.

      There are currently 65 employees in this situation. I need you to research the root cause and fix the impacted employees.

      Jackie Sivigny

        Attachments

        1. Cost and coverage.png
          Cost and coverage.png
          53 kB
        2. EE AD&D match.png
          EE AD&D match.png
          96 kB
        3. EE AD&D mismatch.png
          EE AD&D mismatch.png
          94 kB
        4. EE Life Match.png
          EE Life Match.png
          140 kB
        5. EE Life mismatch.png
          EE Life mismatch.png
          109 kB
        6. Employee AD&D.png
          Employee AD&D.png
          107 kB
        7. EmployeeList.xlsx
          10 kB
        8. WT-12760_scenarios.xls
          20 kB

          Issue Links

            Activity

            dkulling Debbie Kulling created issue -
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Field Original Value New Value
            Assignee Satya [ ID10004 ] Amruta Lohiya [ amruta.baheti ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Assignee Amruta Lohiya [ amruta.baheti ] Prasad Patil [ prasad.patil ]
            prasad.patil Prasad Patil (Inactive) made changes -
            Attachment EE AD&D mismatch.png [ 69968 ]
            prasad.patil Prasad Patil (Inactive) made changes -
            Attachment EE Life mismatch.png [ 69969 ]
            prasad.patil Prasad Patil (Inactive) made changes -
            Attachment EE AD&D match.png [ 69970 ]
            prasad.patil Prasad Patil (Inactive) made changes -
            Attachment EE Life Match.png [ 69971 ]
            prasad.patil Prasad Patil (Inactive) made changes -
            Attachment Cost and coverage.png [ 69972 ]
            prasad.patil Prasad Patil (Inactive) made changes -
            Assignee Prasad Patil [ prasad.patil ] Rohit Shete [ rohit.shete ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Developer Rohit Shete [ rohit.shete ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
            rohit.shete Rohit Shete (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Development(10200)Level 1 values: On Hold(10207)
            prasad.patil Prasad Patil (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 3h [ 10800 ]
            Worklog Id 95999 [ 95999 ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Environment Production [ 18442 ] Others [ 18445 ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Environment Others [ 18445 ] Production [ 18442 ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Time Spent 3h [ 10800 ] 7h [ 25200 ]
            Worklog Id 96157 [ 96157 ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Attachment EmployeeList.xls [ 70073 ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Assignee Rohit Shete [ rohit.shete ] Prasad Pise [ prasadp ]
            prasadp Prasad Pise (Inactive) made changes -
            Assignee Prasad Pise [ prasadp ] Sanjana Jadhav [ sanjana.jadhav ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Time Spent 7h [ 25200 ] 7.25h [ 26100 ]
            Worklog Id 96257 [ 96257 ]
            prasadp Prasad Pise (Inactive) made changes -
            Time Spent 7.25h [ 26100 ] 8.25h [ 29700 ]
            Worklog Id 96294 [ 96294 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Attachment EmployeeList (361e0649-60b9-42a3-99b5-32039052721e).xls [ 70152 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Time Spent 8.25h [ 29700 ] 11.25h [ 40500 ]
            Worklog Id 96335 [ 96335 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Comment [ Hi [~rohit.shete]

            Verified data correction on "ATC For HSPL" company for affected employees.
            Please refer attached sheet for more details.
             [^EmployeeList.xls]
            Working properly.

            Thanks,
            Sanjana Jadhav

            CC: [~prasadp] [~hrishikesh.deshpande] [~rakeshr] ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Attachment EmployeeList-completed.xls [ 70153 ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Attachment EmployeeList.xls [ 70073 ]
            jyoti.mayne Jyoti Mayne made changes -
            Attachment EmployeeList.xlsx [ 70162 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Attachment EmployeeList-completed.xls [ 70153 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Attachment EmployeeList (361e0649-60b9-42a3-99b5-32039052721e).xls [ 70152 ]
            jyoti.mayne Jyoti Mayne made changes -
            Root Cause Bug [ 18430 ]
            Original Estimate 0h [ 0 ]
            jyoti.mayne Jyoti Mayne made changes -
            Labels Enrollment_workflow
            rohit.shete Rohit Shete (Inactive) made changes -
            Attachment Employee AD&D.png [ 70173 ]
            prasadp Prasad Pise (Inactive) made changes -
            Assignee Sanjana Jadhav [ sanjana.jadhav ] Rohit Shete [ rohit.shete ]
            jyoti.mayne Jyoti Mayne made changes -
            Time Spent 11.25h [ 40500 ] 12h [ 43200 ]
            Worklog Id 96472 [ 96472 ]
            jyoti.mayne Jyoti Mayne made changes -
            Time Spent 12h [ 43200 ] 16h [ 57600 ]
            Worklog Id 96478 [ 96478 ]
            jyoti.mayne Jyoti Mayne made changes -
            Time Spent 16h [ 57600 ] 17h [ 61200 ]
            Worklog Id 96478 [ 96478 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Time Spent 17h [ 61200 ] 18.5h [ 66600 ]
            Worklog Id 96335 [ 96335 ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Time Spent 18.5h [ 66600 ] 20h [ 72000 ]
            Worklog Id 96971 [ 96971 ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Time Spent 20h [ 72000 ] 28h [ 100800 ]
            Worklog Id 96978 [ 96978 ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Time Spent 28h [ 100800 ] 34h [ 122400 ]
            Worklog Id 96983 [ 96983 ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Worklog Id 96983 [ 96983 ]
            satyap Satya made changes -
            Module Parent values: BenAdmin(10100) Parent values: BenAdmin(10100)Level 1 values: Enrollment(10107)
            rohit.shete Rohit Shete (Inactive) made changes -
            Dev Due Date 25/Jan/2018
            Dev Estimates 28
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            QA Rashmita Dudhe [ rashmita.dudhe ]
            QA Estimates 12
            rohit.shete Rohit Shete (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: On Hold(10207) Parent values: Development(10200)Level 1 values: In Analysis(10204)
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Sprint WT- Sprint 43 [ 98 ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Time Spent 34h [ 122400 ] 42h [ 151200 ]
            Worklog Id 101513 [ 101513 ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Development(10200)Level 1 values: In Progress(10206)
            jyoti.mayne Jyoti Mayne made changes -
            Time Spent 42h [ 151200 ] 42.25h [ 152100 ]
            Worklog Id 101750 [ 101750 ]
            jyoti.mayne Jyoti Mayne made changes -
            Time Spent 42.25h [ 152100 ] 42.5h [ 153000 ]
            Worklog Id 101750 [ 101750 ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: Development(10200)Level 1 values: Ready for Review(10208)
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Attachment WT-12760_scenarios.xls [ 72282 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Time Spent 42.5h [ 153000 ] 47.5h [ 171000 ]
            Worklog Id 101809 [ 101809 ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Time Spent 47.5h [ 171000 ] 53.5h [ 192600 ]
            Worklog Id 101823 [ 101823 ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Time Spent 53.5h [ 192600 ] 60.5h [ 217800 ]
            Worklog Id 101825 [ 101825 ]
            jyoti.mayne Jyoti Mayne made changes -
            Time Spent 60.5h [ 217800 ] 60.75h [ 218700 ]
            Worklog Id 101965 [ 101965 ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Time Spent 60.75h [ 218700 ] 66.75h [ 240300 ]
            Worklog Id 102156 [ 102156 ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Dev Due Date 25/Jan/2018 29/Jan/2018
            Dev Estimates 28 32
            rohit.shete Rohit Shete (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
            rohit.shete Rohit Shete (Inactive) made changes -
            Code Reviewed By Jyoti Mayne,Rohan Khandave [ 11910, 11903 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            rohit.shete Rohit Shete (Inactive) made changes -
            Code Review Date 29/Jan/2018
            rohit.shete Rohit Shete (Inactive) made changes -
            Assignee Rohit Shete [ rohit.shete ] Prasad Pise [ prasadp ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Assignee Prasad Pise [ prasadp ] Rohit Shete [ rohit.shete ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Assignee Rohit Shete [ rohit.shete ] Hrishikesh Deshpande [ hrishikesh.deshpande ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Assignee Hrishikesh Deshpande [ hrishikesh.deshpande ] Rashmita Dudhe [ rashmita.dudhe ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            jyoti.mayne Jyoti Mayne made changes -
            Time Spent 66.75h [ 240300 ] 69.75h [ 251100 ]
            Worklog Id 102459 [ 102459 ]
            jyoti.mayne Jyoti Mayne made changes -
            Worklog Id 102459 [ 102459 ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Time Spent 69.75h [ 251100 ] 75.75h [ 272700 ]
            Worklog Id 102503 [ 102503 ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Worklog Id 102503 [ 102503 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Attachment WT-12760_scenarios.xls [ 72282 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Attachment WT-12760_scenarios.xls [ 72544 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Time Spent 75.75h [ 272700 ] 81.75h [ 294300 ]
            Worklog Id 102679 [ 102679 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Time Spent 81.75h [ 294300 ] 83.75h [ 301500 ]
            Worklog Id 102983 [ 102983 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Time Spent 83.75h [ 301500 ] 87.75h [ 315900 ]
            Worklog Id 103248 [ 103248 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
            rohit.shete Rohit Shete (Inactive) made changes -
            Link This issue relates to NF-5876 [ NF-5876 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Time Spent 87.75h [ 315900 ] 89.75h [ 323100 ]
            Worklog Id 104603 [ 104603 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Time Spent 89.75h [ 323100 ] 91.75h [ 330300 ]
            Worklog Id 104604 [ 104604 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Resolution Done [ 10000 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Assignee Rashmita Dudhe [ rashmita.dudhe ] Debbie Kulling [ dkulling ]
            dkulling Debbie Kulling made changes -
            Resolution Done [ 10000 ]
            Status Production Complete [ 10028 ] Closed [ 6 ]

              People

              Assignee:
              dkulling Debbie Kulling
              Reporter:
              dkulling Debbie Kulling
              Account Executive:
              Debbie Kulling
              Developer:
              Rohit Shete (Inactive)
              QA:
              Rashmita Dudhe (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Dev Due Date:
                Code Review Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 0h
                  0h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 91.75h
                  91.75h