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. EE AD&D mismatch.png
          94 kB
          Prasad Patil
        2. EE Life mismatch.png
          109 kB
          Prasad Patil
        3. EE AD&D match.png
          96 kB
          Prasad Patil
        4. EE Life Match.png
          140 kB
          Prasad Patil
        5. Cost and coverage.png
          53 kB
          Prasad Patil
        6. EmployeeList.xlsx
          10 kB
          Jyoti Mayne
        7. Employee AD&D.png
          107 kB
          Rohit Shete
        8. WT-12760_scenarios.xls
          20 kB
          Rashmita Dudhe

          Issue Links

            Activity

            Hide
            prasad.patil Prasad Patil (Inactive) added a comment -

            Hi Rohit Shete,

            Below are my observations on this issue.

            The Parent plan (Employee Life) and Child plan (Employee AD&D) are set to match the coverage.

            The Functionality is working fine when Coverage less than the 5x Salary (168,480) of the EE is selected for the Parent Plan.

            For Example:

            When we select 160,000 in Parent Plan 'Employee Life' and enroll. The Coverage of child plan 'Employee AD&D' will matched to the Parent Plan 'Employee Life'.

            (Please refer the screen shots below)

            However, when coverage more than 5x Salary (168,480) is selected for the Parent Plan the the coverage is mismatched. The coverage allocated is 168,480 (Maximum Coverage allowed to the plan).

            Also the coverage doesn't pends.

            (Please refer the screen shots below)

            Request you to please look into this.
            Thank you,
            -----------------------------------------------------------------------------
            CC: Mandar Kulkarni, Satya, Jyoti Mayne, Amruta Lohiya, Umesh Kadam

            Show
            prasad.patil Prasad Patil (Inactive) added a comment - Hi Rohit Shete , Below are my observations on this issue. The Parent plan ( Employee Life ) and Child plan ( Employee AD&D ) are set to match the coverage. The Functionality is working fine when Coverage less than the 5x Salary ( 168,480 ) of the EE is selected for the Parent Plan. For Example: When we select 160,000 in Parent Plan 'Employee Life' and enroll. The Coverage of child plan 'Employee AD&D' will matched to the Parent Plan 'Employee Life'. (Please refer the screen shots below) However, when coverage more than 5x Salary (168,480) is selected for the Parent Plan the the coverage is mismatched. The coverage allocated is 168,480 (Maximum Coverage allowed to the plan). Also the coverage doesn't pends. (Please refer the screen shots below) Request you to please look into this. Thank you, ----------------------------------------------------------------------------- CC: Mandar Kulkarni , Satya , Jyoti Mayne , Amruta Lohiya , Umesh Kadam
            Hide
            rohit.shete Rohit Shete (Inactive) added a comment -

            Hi Debbie Kulling,

            We are working on finding root cause and data correction.

            We will update you tomorrow EOD.

            Thanks And Regards,
            Rohit Shete.

            Cc: Amruta Lohiya, Jyoti Mayne, Prasad Patil

            Show
            rohit.shete Rohit Shete (Inactive) added a comment - Hi Debbie Kulling , We are working on finding root cause and data correction. We will update you tomorrow EOD. Thanks And Regards, Rohit Shete. Cc: Amruta Lohiya , Jyoti Mayne , Prasad Patil
            Hide
            rohit.shete Rohit Shete (Inactive) added a comment -

            Hi Debbie Kulling,

            We have done data correction on hspl copy and working on data verification for affected employee after verification we will correct data on main company and we will update you.

            Prasad Pise, Please verify changes on hspl for attached affected employee's [^EmployeeList.xls].
            Please confirm.

            Thanks and Regards,
            Rohit Shete.

            CC:Amruta Lohiya,Jyoti Mayne,Umesh Kadam

            Show
            rohit.shete Rohit Shete (Inactive) added a comment - Hi Debbie Kulling , We have done data correction on hspl copy and working on data verification for affected employee after verification we will correct data on main company and we will update you. Prasad Pise , Please verify changes on hspl for attached affected employee's [^EmployeeList.xls] . Please confirm. Thanks and Regards, Rohit Shete. CC: Amruta Lohiya , Jyoti Mayne , Umesh Kadam
            Hide
            sanjana.jadhav Sanjana Jadhav (Inactive) added a comment -

            Hi Rohit Shete

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

            Thanks,
            Sanjana Jadhav

            CC: Prasad Pise Hrishikesh Deshpande Rakesh Roy

            Show
            sanjana.jadhav Sanjana Jadhav (Inactive) added a comment - Hi Rohit Shete Verified data correction on "ATC For HSPL" company for affected employees. Please refer attached sheet for more details. [^EmployeeList-completed.xls] Working properly. Thanks, Sanjana Jadhav CC: Prasad Pise Hrishikesh Deshpande Rakesh Roy
            Hide
            rohit.shete Rohit Shete (Inactive) added a comment -

            Hi Debbie Kulling,

            Please find below 3C's:

            Concern: Child plan 'Employee AD&D' coverage is not matching when EE elect maximum coverage in parent plan

            Cause: On child plan 'Employee AD&D', 'Round Salary Values' flag is set to 'Round up to nearest $10,000' and maximum coverage is set to '5 lac or 5 times of annual compensation'. PFA screen shot.

            When EE elect maximum coverage in parent plan, at a time of allocating coverage to child plan system is not rounding salary. Due to this, given issue is coming.

            For example, EE Panagiotis Pantazis benefit salary is 46092.8. He elected 5X in parent plan.

            Parent plan coverage calculation: As per salary rounding rule, system first round salary to 50000 and then allocated $250000 coverage (50000*5) .
            As per current system working, child plan coverage calculation: System didn't round salary and allocated 46092.8*5 = 230464 coverage.

            Correction: We will add condition of salary rounding for child plan coverage calculation after development approval.

            Note: We have scanned all EEs and corrected data of attached EE.

            Thanks and Regards,
            Rohit Shete.

            Cc:Satya, Amruta Lohiya, Jyoti Mayne, Umesh Kadam

            Show
            rohit.shete Rohit Shete (Inactive) added a comment - Hi Debbie Kulling , Please find below 3C's: Concern: Child plan 'Employee AD&D' coverage is not matching when EE elect maximum coverage in parent plan Cause : On child plan 'Employee AD&D', 'Round Salary Values' flag is set to 'Round up to nearest $10,000' and maximum coverage is set to '5 lac or 5 times of annual compensation'. PFA screen shot. When EE elect maximum coverage in parent plan, at a time of allocating coverage to child plan system is not rounding salary. Due to this, given issue is coming. For example, EE Panagiotis Pantazis benefit salary is 46092.8. He elected 5X in parent plan. Parent plan coverage calculation: As per salary rounding rule, system first round salary to 50000 and then allocated $250000 coverage (50000*5) . As per current system working, child plan coverage calculation: System didn't round salary and allocated 46092.8*5 = 230464 coverage. Correction: We will add condition of salary rounding for child plan coverage calculation after development approval. Note: We have scanned all EEs and corrected data of attached EE. Thanks and Regards, Rohit Shete. Cc: Satya , Amruta Lohiya , Jyoti Mayne , Umesh Kadam
            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            scenario sheet attached in jira

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - scenario sheet attached in jira
            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            Verified all attached Scenarios on LB environment.
            working fine as expected

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Verified all attached Scenarios on LB environment. working fine as expected
            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            Verified all attached Scenarios on Stage environment.
            working fine as expected

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Verified all attached Scenarios on Stage environment. working fine as expected
            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - - edited

            Verified all attached Scenarios on the production environment.
            working fine as expected

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - - edited Verified all attached Scenarios on the production environment. working fine as expected
            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            Hi Debbie Kulling,

            This is deployed and verified on production.
            kindly, update jira accordingly.

            Thanks,
            Rashmita

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Hi Debbie Kulling , This is deployed and verified on production. kindly, update jira accordingly. Thanks, Rashmita
            Hide
            dkulling Debbie Kulling added a comment -

            Confirmed. Closing ticket

            Show
            dkulling Debbie Kulling added a comment - Confirmed. Closing ticket

              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