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:
      Client
    • Company:
      TID
    • Item State:
      Stage QA - Stage Deployed
    • Sprint:
      WT Sprint 39 - Bugs

      Description

      Hello,

      Per the client: Last month when auditing the October prebill I noticed I had an issue with the age reductions for Voluntary EE Life, Voluntary EE ADD, and Voluntary Spouse Life. Shelly and I worked together last month and got everything back on track prior to releasing the invoice. When I went to audit the November invoice, I noticed I am still having trouble with the age reduction for the Voluntary EE ADD. The person I am having issues with is Paul Cooper, even though the VOL EE ADD plan matches the reduction to the VOL EE Life plan, the VOL EE ADD wants to age reduce Paul again, even though he has already been reduced once.

      Please take a look to see what I may have done wrong, so Paul’s VOL ADD will stop age reducing? Is it necessary to complete the Age Reduction tab for AD&D plans if the AD&D plan is contingent on the Life plan? Could this be why the plan is reducing the amount multiple times? Please advise.

      Thank you,
      Kira Hamilton
      Debbie Kulling

        Attachments

          Activity

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

          Hi Abhilash Warkari,

          Below are my findings on this issue.

          EE: Paul Cooper

          EE's First time enrollment in Voluntary EE ADD with $32,500 (65% reduction of 50000)

          The Coverage is again reduced while enrolling to the plan $21,125 (65% Reduction of 32500)

          Also the November invoice is showing records in the october adjustments.

          (Please refer the screen shot below)

          Request you to please look into this
          Thank you,
          ----------------------------------------------------------------
          CC: Mandar Kulkarni, Vijay Siddha, Umesh Kadam

          Show
          prasad.patil Prasad Patil (Inactive) added a comment - Hi Abhilash Warkari , Below are my findings on this issue. EE: Paul Cooper EE's First time enrollment in Voluntary EE ADD with $32,500 (65% reduction of 50000) The Coverage is again reduced while enrolling to the plan $21,125 (65% Reduction of 32500) Also the November invoice is showing records in the october adjustments. (Please refer the screen shot below) Request you to please look into this Thank you, ---------------------------------------------------------------- CC: Mandar Kulkarni , Vijay Siddha , Umesh Kadam
          Hide
          Kira.Hamilton Kira Hamilton (Inactive) added a comment -

          Hello,

          Any updates on this ticket that I can share with the client?

          Thank you,
          Kira Hamilton
          Debbie Kulling

          Show
          Kira.Hamilton Kira Hamilton (Inactive) added a comment - Hello, Any updates on this ticket that I can share with the client? Thank you, Kira Hamilton Debbie Kulling
          Hide
          abhilash.warkari Abhilash Warkari (Inactive) added a comment - - edited

          Hi Kira Hamilton

          Please find below 3Cs :

          Concern TID-Age Reduction Problems
          Cause As Display Reduced Amount On Enroll Now For Overage? flag on Reduction Schedule screen was set to YES,due to which employee was getting reduced coverage while enrolling in to both plans,but child plan's Original coverage was not maintained due to which Reduction Service was reducing its coverage again
          Correction We have fixed code for this

          Note: We have scanned all the employees and found one employee which was reported by you where child plans coverage was reduced twice.
          Do you want us to correct reported employees coverage which will be 32500 and recalculate its rates?

          Thanks Ans Regards
          Abhilash Warkari

          CC : Amruta Lohiya, Jyoti Mayne, Umesh Kadam,

          Show
          abhilash.warkari Abhilash Warkari (Inactive) added a comment - - edited Hi Kira Hamilton Please find below 3Cs : Concern TID-Age Reduction Problems Cause As Display Reduced Amount On Enroll Now For Overage? flag on Reduction Schedule screen was set to YES ,due to which employee was getting reduced coverage while enrolling in to both plans,but child plan's Original coverage was not maintained due to which Reduction Service was reducing its coverage again Correction We have fixed code for this Note : We have scanned all the employees and found one employee which was reported by you where child plans coverage was reduced twice. Do you want us to correct reported employees coverage which will be 32500 and recalculate its rates? Thanks Ans Regards Abhilash Warkari CC : Amruta Lohiya , Jyoti Mayne , Umesh Kadam ,
          Hide
          abhilash.warkari Abhilash Warkari (Inactive) added a comment -

          HI Prasanna Karlekar

          We have done data correction for the reported EE.
          Please verify on invoice and confirm.

          Thanks And Regards
          Abhilash Warkari

          CC : Amruta Lohiya, Jyoti Mayne, Umesh Kadam

          Show
          abhilash.warkari Abhilash Warkari (Inactive) added a comment - HI Prasanna Karlekar We have done data correction for the reported EE. Please verify on invoice and confirm. Thanks And Regards Abhilash Warkari CC : Amruta Lohiya , Jyoti Mayne , Umesh Kadam
          Hide
          Kira.Hamilton Kira Hamilton (Inactive) added a comment -

          Hello,

          Below are responses from the client regarding the above question: Do you want us to correct reported employees coverage which will be 32500 and recalculate its rates?

          "Yes, I would like development to make this correction for Paul Cooper. Could you please make sure this is done in the LIVE system as well as STAGE?

          I am slightly concerned that based on the below development believes this to be a child plan. Paul Cooper is an Active Employee and the coverage that is reducing twice is Voluntary Employee ADD. Could you please ensure the fix is applied to the correct plan?"

          Thank you,
          Kira Hamilton
          Debbie Kulling

          Show
          Kira.Hamilton Kira Hamilton (Inactive) added a comment - Hello, Below are responses from the client regarding the above question: Do you want us to correct reported employees coverage which will be 32500 and recalculate its rates? "Yes, I would like development to make this correction for Paul Cooper. Could you please make sure this is done in the LIVE system as well as STAGE? I am slightly concerned that based on the below development believes this to be a child plan. Paul Cooper is an Active Employee and the coverage that is reducing twice is Voluntary Employee ADD. Could you please ensure the fix is applied to the correct plan?" Thank you, Kira Hamilton Debbie Kulling
          Hide
          abhilash.warkari Abhilash Warkari (Inactive) added a comment -

          Hi Kira Hamilton

          Yes, we have fixed this issue considering Voluntary Employee ADD and have done correction for the same plan on production and we are working on stage correction.

          Thanks And Regards
          Abhilash Warkari

          CC : Amruta Lohiya, Jyoti Mayne, Umesh Kadam

          Show
          abhilash.warkari Abhilash Warkari (Inactive) added a comment - Hi Kira Hamilton Yes, we have fixed this issue considering Voluntary Employee ADD and have done correction for the same plan on production and we are working on stage correction. Thanks And Regards Abhilash Warkari CC : Amruta Lohiya , Jyoti Mayne , Umesh Kadam
          Hide
          Kira.Hamilton Kira Hamilton (Inactive) added a comment -

          Hello,

          Per the client:

          I have ran the December Invoice to see if Paul Cooper’s adjustment had been made. It is showing up correctly for the December billing ($1.37), but in the adjustment section, it is showing a credit of $1.37 for the months of September, October, and November. This is incorrect. We should be showing both a credit and a billing for those months. Could you please have development update the invoice so there is both a credit and billing of $1.37 for the months of September, October, and November.

          Thank you,
          Kira Hamilton
          Debbie Kulling

          Show
          Kira.Hamilton Kira Hamilton (Inactive) added a comment - Hello, Per the client: I have ran the December Invoice to see if Paul Cooper’s adjustment had been made. It is showing up correctly for the December billing ($1.37), but in the adjustment section, it is showing a credit of $1.37 for the months of September, October, and November. This is incorrect. We should be showing both a credit and a billing for those months. Could you please have development update the invoice so there is both a credit and billing of $1.37 for the months of September, October, and November. Thank you, Kira Hamilton Debbie Kulling
          Hide
          venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

          Hi Kira Hamilton,

          I have looked into the above concern and below is my observation :-

          Only credit was being displayed as Adjustment for months of September,October and November - This is wrong . No adjustment should have been displayed. For this one correction had been done last week for non health plans. Now the issue has been resolved. If the credit and billing amounts are exactly same then we do not show any adjustments. We have verified this by regenerating December 2017 invoice on HSPL copy. Please could you verify and let us know if you any queries on this.

          Prasanna Karlekar,Priya Dhamande

          Thanks,
          Venkatesh

          Show
          venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Kira Hamilton , I have looked into the above concern and below is my observation :- Only credit was being displayed as Adjustment for months of September,October and November - This is wrong . No adjustment should have been displayed. For this one correction had been done last week for non health plans. Now the issue has been resolved. If the credit and billing amounts are exactly same then we do not show any adjustments. We have verified this by regenerating December 2017 invoice on HSPL copy. Please could you verify and let us know if you any queries on this. Prasanna Karlekar , Priya Dhamande Thanks, Venkatesh
          Hide
          Kira.Hamilton Kira Hamilton (Inactive) added a comment -

          Hello,

          Per email received from Jennifer H. on 10/23/17:

          I have reviewed the December Invoice and all looks good. No credit or billing is showing in the adjustment section for Paul Cooper.

          Thank you for your help!
          Kira Hamilton
          Debbie Kulling

          Show
          Kira.Hamilton Kira Hamilton (Inactive) added a comment - Hello, Per email received from Jennifer H. on 10/23/17: I have reviewed the December Invoice and all looks good. No credit or billing is showing in the adjustment section for Paul Cooper. Thank you for your help! Kira Hamilton Debbie Kulling
          Hide
          priya.dhamande Priya Dhamande (Inactive) added a comment -

          Environment: LB
          Company: FDU for Hspl
          Login: Partner and Employee
          Plan: Employee Supplemental Life, EE AD&D, and Supplemental Spouse Life.

          Scenario 1: Without Pending
          1. Employee Reduction enrolled in Employee Supplemental Life and at age 65 gets 65% reduction
          2. Spouse meeting age 65% no reduction of Employee agian.

          Scenario 2: With Pending
          1. Employee Reduction enrolled in Employee Supplemental Life and at age 65 with approval pending > No reduction
          2. Spouse meeting age 65% no reduction of Employee as its in pending.

          Now, no double reduction is occurring. Scenarios worked as expected. so, moving jira on Stage.

          Hrishikesh Deshpande

          Show
          priya.dhamande Priya Dhamande (Inactive) added a comment - Environment: LB Company: FDU for Hspl Login: Partner and Employee Plan: Employee Supplemental Life, EE AD&D, and Supplemental Spouse Life. Scenario 1: Without Pending 1. Employee Reduction enrolled in Employee Supplemental Life and at age 65 gets 65% reduction 2. Spouse meeting age 65% no reduction of Employee agian. Scenario 2: With Pending 1. Employee Reduction enrolled in Employee Supplemental Life and at age 65 with approval pending > No reduction 2. Spouse meeting age 65% no reduction of Employee as its in pending. Now, no double reduction is occurring. Scenarios worked as expected. so, moving jira on Stage. Hrishikesh Deshpande
          Hide
          priya.dhamande Priya Dhamande (Inactive) added a comment -

          Environment: Stage
          Company: Asml for Hspl
          Login: Partner and Employee
          Plan: Employee Supplemental Life

          Testing in progress

          Show
          priya.dhamande Priya Dhamande (Inactive) added a comment - Environment: Stage Company: Asml for Hspl Login: Partner and Employee Plan: Employee Supplemental Life Testing in progress
          Hide
          priya.dhamande Priya Dhamande (Inactive) added a comment -

          Environment: Stage
          Company: Asml for Hspl
          Login: Partner and Employee
          Plan: Employee Supplemental Life

          1. Employee with age 65
          2. Employee with age 64 and moving to age 65 after age reduction service
          3. Employee age 65 and Spouse 65 later
          4. Employee already 65 nd spouse becoming 65

          Above scenario checked and worked as expected. So, moving jira on production.

          Show
          priya.dhamande Priya Dhamande (Inactive) added a comment - Environment: Stage Company: Asml for Hspl Login: Partner and Employee Plan: Employee Supplemental Life 1. Employee with age 65 2. Employee with age 64 and moving to age 65 after age reduction service 3. Employee age 65 and Spouse 65 later 4. Employee already 65 nd spouse becoming 65 Above scenario checked and worked as expected. So, moving jira on production.
          Hide
          dkulling Debbie Kulling added a comment -

          Can you tell me if we are changing the system to prevent this issue from happening in the system. Was there a new ticket created?

          Show
          dkulling Debbie Kulling added a comment - Can you tell me if we are changing the system to prevent this issue from happening in the system. Was there a new ticket created?
          Hide
          abhilash.warkari Abhilash Warkari (Inactive) added a comment -

          Hi Debbie Kulling

          We have done code fix for this under same JIRA, and it is deployed on Stage.
          No new ticket was created for code fix.

          Regards,
          Abhilash Warkari

          CC :Amruta Lohiya, Jyoti Mayne, Umesh Kadam

          Show
          abhilash.warkari Abhilash Warkari (Inactive) added a comment - Hi Debbie Kulling We have done code fix for this under same JIRA, and it is deployed on Stage. No new ticket was created for code fix. Regards, Abhilash Warkari CC : Amruta Lohiya , Jyoti Mayne , Umesh Kadam
          Hide
          rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

          Environment: Production
          Company: TID for Hspl
          Login: Partner and Employee

          Plan: Voluntary Employee life
          Voluntary Employee ADD
          Voluntary spouse Life

          1. Employee with age 65
          2. Employee with age 64 and moving to age 65 after age reduction service
          3. Employee age 65 and Spouse 65 later
          4. Employee already 65 nd spouse becoming 65

          Above scenario checked and worked as expected.

          Show
          rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Environment: Production Company: TID for Hspl Login: Partner and Employee Plan: Voluntary Employee life Voluntary Employee ADD Voluntary spouse Life 1. Employee with age 65 2. Employee with age 64 and moving to age 65 after age reduction service 3. Employee age 65 and Spouse 65 later 4. Employee already 65 nd spouse becoming 65 Above scenario checked and worked as expected.
          Hide
          rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

          Hi Kira Hamilton,

          This is deployed and verified in the production environment.
          Kindly, Update Jira accordingly.

          Thanks,
          Rashmita

          Show
          rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Hi Kira Hamilton , This is deployed and verified in the production environment. Kindly, Update Jira accordingly. Thanks, Rashmita
          Hide
          Kira.Hamilton Kira Hamilton (Inactive) added a comment -

          The Jennifer H emailed on 10/23 that "I agree with development, I didn’t think a credit should be there at all, but wasn’t sure what they were able to do to fix it. I have reviewed the December Invoice and all looks good. No credit or billing is showing in the adjustment section for Paul Cooper." So this ticket can be closed.

          Thank you,

          Kira Hamilton
          Debbie Kulling

          Show
          Kira.Hamilton Kira Hamilton (Inactive) added a comment - The Jennifer H emailed on 10/23 that "I agree with development, I didn’t think a credit should be there at all, but wasn’t sure what they were able to do to fix it. I have reviewed the December Invoice and all looks good. No credit or billing is showing in the adjustment section for Paul Cooper." So this ticket can be closed. Thank you, Kira Hamilton Debbie Kulling

            People

            Assignee:
            Kira.Hamilton Kira Hamilton (Inactive)
            Reporter:
            Kira.Hamilton Kira Hamilton (Inactive)
            Account Executive:
            Debbie Kulling
            Developer:
            Abhilash Warkari (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

              Dates

              Created:
              Updated:
              Dev Due Date:
              Pre-Prod Due Date:
              Production Due Date:
              Code Review Date:

                Time Tracking

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