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

Deep South - Life Coverage Amount/Rounding/Reduction

    Details

    • Type: Support Activity
    • Status: Resolved
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Support Task Type:
      Configuration
    • Environment:
      Production
    • Reported by:
      White Label
    • Company:
      Deep South
    • Module:
      BenAdmin - Enrollment
    • Severity:
      Simple

      Description

      There were some incorrect plan rules set for all the life plans. Can you research and respond to the following:

      1. Please tell me the history of the changes made to the life plans
      2. Is it possible for you to run a query of the employees that have coverage amounts that do not match the plan rule
      3. Once the employees are identified can the coverage amount be corrected by development or do we have to correct them through the UI

        Attachments

        1. cost_and_coverage.png
          cost_and_coverage.png
          152 kB
        2. EE Vol Life.png
          EE Vol Life.png
          150 kB
        3. Vol EE AD&D.png
          Vol EE AD&D.png
          144 kB
        4. WT-13105_history_changes_&_comparission.xls
          11 kB

          Activity

          Hide
          jyoti.mayne Jyoti Mayne added a comment -

          Hi Debbie Kulling,

          Due to other priority issues, we couldn't work on this. We will update you on its progress.

          Show
          jyoti.mayne Jyoti Mayne added a comment - Hi Debbie Kulling , Due to other priority issues, we couldn't work on this. We will update you on its progress.
          Hide
          shailendra.honrao Shailendra Honrao (Inactive) added a comment -

          Hi Debbie Kulling,

          We are working on this and will update you.

          Thanks,
          Shailendra Honrao

          Cc: Jyoti Mayne

          Show
          shailendra.honrao Shailendra Honrao (Inactive) added a comment - Hi Debbie Kulling , We are working on this and will update you. Thanks, Shailendra Honrao Cc: Jyoti Mayne
          Hide
          shailendra.honrao Shailendra Honrao (Inactive) added a comment -

          Hi Debbie Kulling,

          We have checked for Employee Voluntary Life, Employee Voluntary Life And AD&D,Spouse Voluntary Life,Spouse Voluntary Life And AD&D plans.

          Please find below details of these plans:

          1. Please tell me the history of the changes made to the life plans?

          • We have found some changes in reduction, rounding rules of some plans.
          • We have mentioned those changes in attached file. WT-13105_history_changes_&_comparission.xls
          • We have also compare parent as well as child plan for reduction and rounding rules. No major changes are found
            while comparing.
          • You can also view the history of plan rules on view history tab inside Employer Administration menu.

          2. Is it possible for you to run a query of the employees that have coverage amounts that do not match the plan rule?

          • Yes absolutely possible.
          • We have written a query to find discrepancy of coverage amount in parent and child plan.

          Please go through that file and let me know if you have questions?

          Thanks,
          Shailendra Honrao

          Cc: Jyoti Mayne

          Show
          shailendra.honrao Shailendra Honrao (Inactive) added a comment - Hi Debbie Kulling , We have checked for Employee Voluntary Life, Employee Voluntary Life And AD&D,Spouse Voluntary Life,Spouse Voluntary Life And AD&D plans. Please find below details of these plans: 1. Please tell me the history of the changes made to the life plans? We have found some changes in reduction, rounding rules of some plans. We have mentioned those changes in attached file. WT-13105_history_changes_&_comparission.xls We have also compare parent as well as child plan for reduction and rounding rules. No major changes are found while comparing. You can also view the history of plan rules on view history tab inside Employer Administration menu. 2. Is it possible for you to run a query of the employees that have coverage amounts that do not match the plan rule? Yes absolutely possible. We have written a query to find discrepancy of coverage amount in parent and child plan. Please go through that file and let me know if you have questions? Thanks, Shailendra Honrao Cc: Jyoti Mayne
          Hide
          dkulling Debbie Kulling added a comment -

          I am sorry but I do not see the list of employees

          Show
          dkulling Debbie Kulling added a comment - I am sorry but I do not see the list of employees
          Hide
          dkulling Debbie Kulling added a comment -

          Can I please get the list of impacted employees

          Show
          dkulling Debbie Kulling added a comment - Can I please get the list of impacted employees
          Hide
          shailendra.honrao Shailendra Honrao (Inactive) added a comment -

          Hi Debbie Kulling,

          We have found only two affected employees who having coverage discrepancy.
          Those employees are: Ronald Light and Judy Stainsky

          There coverage details are as below
          Employee: Ronald Light

          Effective Date Termination Date Plan Name Applied Coverage Approved Coverage
          11/01/17 NULL Employee Voluntary Life 42250 42250
          11/01/17 NULL Employee Voluntary AD&D 33800 33800

          Employee: Judy Stainsky

          Effective Date Termination Date Plan Name Applied Coverage Approved Coverage
          11/01/17 NULL Employee Voluntary Life 65000 65000
          11/01/17 NULL Employee Voluntary AD&D 42250 42250

          Rounding rule of Employee Voluntary life and Employee voluntary AD&D plans are different.
          Please find attached screenshots

          Employee Voluntary Life Employee Voluntary AD&D

          Thanks,
          Shailendra Honrao

          Cc:Jyoti Mayne

          Show
          shailendra.honrao Shailendra Honrao (Inactive) added a comment - Hi Debbie Kulling , We have found only two affected employees who having coverage discrepancy. Those employees are: Ronald Light and Judy Stainsky There coverage details are as below Employee: Ronald Light Effective Date Termination Date Plan Name Applied Coverage Approved Coverage 11/01/17 NULL Employee Voluntary Life 42250 42250 11/01/17 NULL Employee Voluntary AD&D 33800 33800 Employee: Judy Stainsky Effective Date Termination Date Plan Name Applied Coverage Approved Coverage 11/01/17 NULL Employee Voluntary Life 65000 65000 11/01/17 NULL Employee Voluntary AD&D 42250 42250 Rounding rule of Employee Voluntary life and Employee voluntary AD&D plans are different. Please find attached screenshots Employee Voluntary Life Employee Voluntary AD&D Thanks, Shailendra Honrao Cc: Jyoti Mayne
          Hide
          Prashant.samal Prashant Samal (Inactive) added a comment -

          Hi Debbie Kulling,

          What is the next action on this ticket?

          This is pending from a week. Can you please provide updates? so we can take next action on this.

          __________________________________________________________________

          Satya Debbie Kulling Shailendra Honrao Jyoti Mayne Abhay Patil

          Show
          Prashant.samal Prashant Samal (Inactive) added a comment - Hi Debbie Kulling , What is the next action on this ticket? This is pending from a week. Can you please provide updates? so we can take next action on this. __________________________________________________________________ Satya Debbie Kulling Shailendra Honrao Jyoti Mayne Abhay Patil
          Hide
          abhay.patil Abhay Patil (Inactive) added a comment -

          Debbie Kulling - hope the dev response answers your questions.

          Show
          abhay.patil Abhay Patil (Inactive) added a comment - Debbie Kulling - hope the dev response answers your questions.

            People

            Assignee:
            dkulling Debbie Kulling
            Reporter:
            dkulling Debbie Kulling
            Account Executive:
            Debbie Kulling
            Votes:
            0 Vote for this issue
            Watchers:
            5 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 - 19.5h
                19.5h