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

COSB - Consider previous paid coverage in cost calculation is not working

    Details

    • Type: Bug
    • Status: Closed
    • Priority: High
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Environment:
      Production
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - Enrollment
    • Reported by:
      Client
    • Company:
      All Clients/Multiple Clients
    • Item State:
      Production Complete - Closed
    • Sprint:
      WT Sprint 36 - Bugs, WT Sprint 37 - Bugs

      Description

      COSB HSA plan is set to elect by pay period and should consider previous paid coverage. I have set the flag "Consider previous paid coverage in cost calculation" to yes but it does not work.

      I spoke with Jyoti and she said that the Consider previous paid coverage in cost calculation flag was never programmed when the elect per pay period functionality was created.
      Kira Hamilton

        Attachments

        1. COSB_hsa_new.png
          COSB_hsa_new.png
          204 kB
        2. screenshot-1.png
          screenshot-1.png
          64 kB
        3. WT-10631_AffectedFiles.txt
          0.2 kB

          Issue Links

            Activity

            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            Verified this issue on Stage Environment considers below Scenarios:
            Add Age Wise Coverage?: Yes
            Max coverage for EE Tier: 3350
            Max coverage for EE +Sp+Ch Tier: 6750
            Employer coverage=900.12
            Elect per paycheck amount: Yes
            Show total annual election amount: Yes
            Is Process On Payroll Schedule Dates: Yes
            Is Prorate Employer Contribution: Yes
            Consider previous paid coverage in cost calculation: Yes
            Employee Payroll schedule Biweekly
            Scenario1:
            Enrolled in the HSA plan with effective date 01/01/2017
            Annual Election Amount is elect per paycheck value* total pay cycle
            EG: Elect per paycheck value 94.22 * 26(Paycycle)=2449.72
            Scenario 2
            Enrolled in the HSA plan with effective date 07/01/2017
            Annual Election Amount is elect per paycheck value* remaining pay cycle
            EG: Elect per paycheck value 94.22 * 13(Paycycle)=1224.86
            Scenario 3
            Enrolled in the HSA plan with effective date 01/01/2017
            Raised QE with effective date 7/1/2017 and Decreased Elect per paycheck value
            Annual Election Amount= Previous paid value +current elect per paycheck value remaining pay cycle
            EG: Elect per paycheck value 94.22 * 13(Paycycle)=1224.86
            Elect per paycheck value 40 * 13(Paycycle)=520
            Annual Election Amount= 1224.86+520=1744.86
            Scenario 4
            Enrolled in the HSA plan with effective date 01/01/2017
            Raised QE with effective date 7/1/2017 and Decreased Elect per paycheck value
            Annual Election Amount= Previous paid value +current elect per paycheck value remaining pay cycle
            EG: Elect per paycheck value 40 * 13(Paycycle)=520
            Elect per paycheck value 80 * 13(Paycycle)=1040
            Annual Election Amount= 1224.86+520=1560
            Scenario 5 increased tier scenario
            Enrolled in the medical plan with tier EE 01/01/2017
            Hsa plan with effective date 01/01/2017
            Raised QE with effective date 5/1/2017 and increase tier as EE+SP
            cross-verified for HSA plan with max elect per check value
            Annual Election Amount= Privious paid value +current elect per pay check value remaiining pay cycle
            eg. Elect per paycheck value 94.22 * 9(Paycycle)=848.03
            Elect per paycheck value 294.22 * 17(Paycycle)=5001.74
            Annual Election Amount= 848.03+5001.74 = 5849.72
            Scenario 6 increased tier scenario
            Enrolled in the medical plan with tier EE 01/01/2017
            Hsa plan with effective date 01/01/2017
            Raised QE with effective date 5/1/2017 and increase tier as EE+SP
            Raised QE with effective date 9/1/2017 and increase tier as EE+SP+CH
            Annual Election Amount= Privious paid value +current elect per pay check value remaining pay cycle
            eg.
            Elect per paycheck value 94.22 * 9(Paycycle)=847.98
            Elect per paycheck value 294.22 * 8(Paycycle)=2353.76
            Elect per paycheck value 294.23 * 9(Paycycle)=2648.07
            Annual Election Amount= 848.03+2353.76+2648.07 = 5849.81
            Scenario 7 Decrease tier Scenario
            Enrolled in the medical plan with tier EE+SP+CH 01/01/2017
            Hsa plan with effective date 01/01/2017
            Raised QE with effective date 5/1/2017 and increase tier as EE
            Annual Election Amount= Privious paid value +current elect per pay check value remaiining pay cycle
            eg. Elect per paycheck value 224.99 * 9(Paycycle)=1558.22
            Elect per paycheck value 91.66 * 17(Paycycle)=2024.91
            Annual Election Amount= 1558.22+2024.91 = 3583.13
            Scenario8: Verified for below points also
            Deduct a 1-time amount from my paycheck
            Deduct a 1-time amount from my profit sharing, commission or bonus check
            Scenario 9:
            Elect per paycheck amount: Yes and Show total annual election amount: No
            Cross verify on Enroll now screen, view enrollment summary, Confirmation Statment.
            All above Scenario it is working properly.

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Verified this issue on Stage Environment considers below Scenarios: Add Age Wise Coverage?: Yes Max coverage for EE Tier: 3350 Max coverage for EE +Sp+Ch Tier: 6750 Employer coverage=900.12 Elect per paycheck amount: Yes Show total annual election amount: Yes Is Process On Payroll Schedule Dates: Yes Is Prorate Employer Contribution: Yes Consider previous paid coverage in cost calculation: Yes Employee Payroll schedule Biweekly Scenario1: Enrolled in the HSA plan with effective date 01/01/2017 Annual Election Amount is elect per paycheck value* total pay cycle EG: Elect per paycheck value 94.22 * 26(Paycycle)=2449.72 Scenario 2 Enrolled in the HSA plan with effective date 07/01/2017 Annual Election Amount is elect per paycheck value* remaining pay cycle EG: Elect per paycheck value 94.22 * 13(Paycycle)=1224.86 Scenario 3 Enrolled in the HSA plan with effective date 01/01/2017 Raised QE with effective date 7/1/2017 and Decreased Elect per paycheck value Annual Election Amount= Previous paid value +current elect per paycheck value remaining pay cycle EG: Elect per paycheck value 94.22 * 13(Paycycle)=1224.86 Elect per paycheck value 40 * 13(Paycycle)=520 Annual Election Amount= 1224.86+520=1744.86 Scenario 4 Enrolled in the HSA plan with effective date 01/01/2017 Raised QE with effective date 7/1/2017 and Decreased Elect per paycheck value Annual Election Amount= Previous paid value +current elect per paycheck value remaining pay cycle EG: Elect per paycheck value 40 * 13(Paycycle)=520 Elect per paycheck value 80 * 13(Paycycle)=1040 Annual Election Amount= 1224.86+520=1560 Scenario 5 increased tier scenario Enrolled in the medical plan with tier EE 01/01/2017 Hsa plan with effective date 01/01/2017 Raised QE with effective date 5/1/2017 and increase tier as EE+SP cross-verified for HSA plan with max elect per check value Annual Election Amount= Privious paid value +current elect per pay check value remaiining pay cycle eg. Elect per paycheck value 94.22 * 9(Paycycle)=848.03 Elect per paycheck value 294.22 * 17(Paycycle)=5001.74 Annual Election Amount= 848.03+5001.74 = 5849.72 Scenario 6 increased tier scenario Enrolled in the medical plan with tier EE 01/01/2017 Hsa plan with effective date 01/01/2017 Raised QE with effective date 5/1/2017 and increase tier as EE+SP Raised QE with effective date 9/1/2017 and increase tier as EE+SP+CH Annual Election Amount= Privious paid value +current elect per pay check value remaining pay cycle eg. Elect per paycheck value 94.22 * 9(Paycycle)=847.98 Elect per paycheck value 294.22 * 8(Paycycle)=2353.76 Elect per paycheck value 294.23 * 9(Paycycle)=2648.07 Annual Election Amount= 848.03+2353.76+2648.07 = 5849.81 Scenario 7 Decrease tier Scenario Enrolled in the medical plan with tier EE+SP+CH 01/01/2017 Hsa plan with effective date 01/01/2017 Raised QE with effective date 5/1/2017 and increase tier as EE Annual Election Amount= Privious paid value +current elect per pay check value remaiining pay cycle eg. Elect per paycheck value 224.99 * 9(Paycycle)=1558.22 Elect per paycheck value 91.66 * 17(Paycycle)=2024.91 Annual Election Amount= 1558.22+2024.91 = 3583.13 Scenario8: Verified for below points also Deduct a 1-time amount from my paycheck Deduct a 1-time amount from my profit sharing, commission or bonus check Scenario 9: Elect per paycheck amount: Yes and Show total annual election amount: No Cross verify on Enroll now screen, view enrollment summary, Confirmation Statment. All above Scenario it is working properly.
            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            Testing in progress

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Testing in progress
            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            Verified this issue on Production Environment considers below Scenarios:
            Add Age Wise Coverage?: Yes
            Max coverage for EE Tier: 3350
            Max coverage for EE +Sp+Ch Tier: 6750
            Employer coverage=900.12
            Elect per paycheck amount: Yes
            Show total annual election amount: Yes
            Is Process On Payroll Schedule Dates: Yes
            Is Prorate Employer Contribution: Yes
            Consider previous paid coverage in cost calculation: Yes
            Employee Payroll schedule Biweekly
            Scenario1:
            Enrolled in the HSA plan with effective date 01/01/2017
            Annual Election Amount is elect per paycheck value* total pay cycle
            EG: Elect per paycheck value 94.22 * 26(Paycycle)=2449.72
            Scenario 2
            Enrolled in the HSA plan with effective date 07/01/2017
            Annual Election Amount is elect per paycheck value* remaining pay cycle
            EG: Elect per paycheck value 94.22 * 13(Paycycle)=1224.86
            Scenario 3
            Enrolled in the HSA plan with effective date 01/01/2017
            Raised QE with effective date 7/1/2017 and Decreased Elect per paycheck value
            Annual Election Amount= Previous paid value +current elect per paycheck value remaining pay cycle
            EG: Elect per paycheck value 94.22 * 13(Paycycle)=1224.86
            Elect per paycheck value 40 * 13(Paycycle)=520
            Annual Election Amount= 1224.86+520=1744.86
            Scenario 4
            Enrolled in the HSA plan with effective date 01/01/2017
            Raised QE with effective date 7/1/2017 and Decreased Elect per paycheck value
            Annual Election Amount= Previous paid value +current elect per paycheck value remaining pay cycle
            EG: Elect per paycheck value 40 * 13(Paycycle)=520
            Elect per paycheck value 80 * 13(Paycycle)=1040
            Annual Election Amount= 1224.86+520=1560
            Scenario 5 increased tier scenario
            Enrolled in the medical plan with tier EE 01/01/2017
            Hsa plan with effective date 01/01/2017
            Raised QE with effective date 5/1/2017 and increase tier as EE+SP
            cross-verified for HSA plan with max elect per check value
            Annual Election Amount= Privious paid value +current elect per pay check value remaiining pay cycle
            eg. Elect per paycheck value 94.22 * 9(Paycycle)=848.03
            Elect per paycheck value 294.22 * 17(Paycycle)=5001.74
            Annual Election Amount= 848.03+5001.74 = 5849.72
            Scenario 6 increased tier scenario
            Enrolled in the medical plan with tier EE 01/01/2017
            Hsa plan with effective date 01/01/2017
            Raised QE with effective date 5/1/2017 and increase tier as EE+SP
            Raised QE with effective date 9/1/2017 and increase tier as EE+SP+CH
            Annual Election Amount= Privious paid value +current elect per pay check value remaining pay cycle
            eg.
            Elect per paycheck value 94.22 * 9(Paycycle)=847.98
            Elect per paycheck value 294.22 * 8(Paycycle)=2353.76
            Elect per paycheck value 294.23 * 9(Paycycle)=2648.07
            Annual Election Amount= 848.03+2353.76+2648.07 = 5849.81
            Scenario 7 Decrease tier Scenario
            Enrolled in the medical plan with tier EE+SP+CH 01/01/2017
            Hsa plan with effective date 01/01/2017
            Raised QE with effective date 5/1/2017 and increase tier as EE
            Annual Election Amount= Privious paid value +current elect per pay check value remaiining pay cycle
            eg. Elect per paycheck value 224.99 * 9(Paycycle)=1558.22
            Elect per paycheck value 91.66 * 17(Paycycle)=2024.91
            Annual Election Amount= 1558.22+2024.91 = 3583.13
            Scenario8: Verified for below points also
            Deduct a 1-time amount from my paycheck
            Deduct a 1-time amount from my profit sharing, commission or bonus check
            Scenario 9:
            Elect per paycheck amount: Yes and Show total annual election amount: No
            Cross verify on Enroll now screen, view enrollment summary, Confirmation Statment.
            All above Scenario it is working properly.

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Verified this issue on Production Environment considers below Scenarios: Add Age Wise Coverage?: Yes Max coverage for EE Tier: 3350 Max coverage for EE +Sp+Ch Tier: 6750 Employer coverage=900.12 Elect per paycheck amount: Yes Show total annual election amount: Yes Is Process On Payroll Schedule Dates: Yes Is Prorate Employer Contribution: Yes Consider previous paid coverage in cost calculation: Yes Employee Payroll schedule Biweekly Scenario1: Enrolled in the HSA plan with effective date 01/01/2017 Annual Election Amount is elect per paycheck value* total pay cycle EG: Elect per paycheck value 94.22 * 26(Paycycle)=2449.72 Scenario 2 Enrolled in the HSA plan with effective date 07/01/2017 Annual Election Amount is elect per paycheck value* remaining pay cycle EG: Elect per paycheck value 94.22 * 13(Paycycle)=1224.86 Scenario 3 Enrolled in the HSA plan with effective date 01/01/2017 Raised QE with effective date 7/1/2017 and Decreased Elect per paycheck value Annual Election Amount= Previous paid value +current elect per paycheck value remaining pay cycle EG: Elect per paycheck value 94.22 * 13(Paycycle)=1224.86 Elect per paycheck value 40 * 13(Paycycle)=520 Annual Election Amount= 1224.86+520=1744.86 Scenario 4 Enrolled in the HSA plan with effective date 01/01/2017 Raised QE with effective date 7/1/2017 and Decreased Elect per paycheck value Annual Election Amount= Previous paid value +current elect per paycheck value remaining pay cycle EG: Elect per paycheck value 40 * 13(Paycycle)=520 Elect per paycheck value 80 * 13(Paycycle)=1040 Annual Election Amount= 1224.86+520=1560 Scenario 5 increased tier scenario Enrolled in the medical plan with tier EE 01/01/2017 Hsa plan with effective date 01/01/2017 Raised QE with effective date 5/1/2017 and increase tier as EE+SP cross-verified for HSA plan with max elect per check value Annual Election Amount= Privious paid value +current elect per pay check value remaiining pay cycle eg. Elect per paycheck value 94.22 * 9(Paycycle)=848.03 Elect per paycheck value 294.22 * 17(Paycycle)=5001.74 Annual Election Amount= 848.03+5001.74 = 5849.72 Scenario 6 increased tier scenario Enrolled in the medical plan with tier EE 01/01/2017 Hsa plan with effective date 01/01/2017 Raised QE with effective date 5/1/2017 and increase tier as EE+SP Raised QE with effective date 9/1/2017 and increase tier as EE+SP+CH Annual Election Amount= Privious paid value +current elect per pay check value remaining pay cycle eg. Elect per paycheck value 94.22 * 9(Paycycle)=847.98 Elect per paycheck value 294.22 * 8(Paycycle)=2353.76 Elect per paycheck value 294.23 * 9(Paycycle)=2648.07 Annual Election Amount= 848.03+2353.76+2648.07 = 5849.81 Scenario 7 Decrease tier Scenario Enrolled in the medical plan with tier EE+SP+CH 01/01/2017 Hsa plan with effective date 01/01/2017 Raised QE with effective date 5/1/2017 and increase tier as EE Annual Election Amount= Privious paid value +current elect per pay check value remaiining pay cycle eg. Elect per paycheck value 224.99 * 9(Paycycle)=1558.22 Elect per paycheck value 91.66 * 17(Paycycle)=2024.91 Annual Election Amount= 1558.22+2024.91 = 3583.13 Scenario8: Verified for below points also Deduct a 1-time amount from my paycheck Deduct a 1-time amount from my profit sharing, commission or bonus check Scenario 9: Elect per paycheck amount: Yes and Show total annual election amount: No Cross verify on Enroll now screen, view enrollment summary, Confirmation Statment. All above Scenario it is working properly.
            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            Hi Debbie Kulling,

            This is deployed and verified on Production.
            Kindly, Check and Update Jiira accordingly.

            Thanks,
            Rashmita

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Hi Debbie Kulling , This is deployed and verified on Production. Kindly, Check and Update Jiira accordingly. Thanks, Rashmita
            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            Hi Debbie Kulling,

            CC:Jyoti Mayne

            We have verified reported issues in given screenshots.

            #1

            If total annual election amount flag set to No
            Deduct a 1 time amount from my paycheck : Yes
            Deduct a 1 time amount from my profit sharing, commission or bonus check: yes

            It is allowing to elect over the max coverage. So, We have created Jira WT-11418 and assign it to development Team.

            #2

            If total annual election amount flag set to Yes
            Deduct a 1 time amount from my paycheck: Yes
            Deduct a 1 time amount from my profit sharing, commission or bonus check: yes

            it showing as per below screenshots

            We are not getting # 2 point so need to discuss this.
            Can we have Call on today to discuss #2 Point?

            Thanks,
            Rashmita

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Hi Debbie Kulling , CC: Jyoti Mayne We have verified reported issues in given screenshots. #1 If total annual election amount flag set to No Deduct a 1 time amount from my paycheck : Yes Deduct a 1 time amount from my profit sharing, commission or bonus check: yes It is allowing to elect over the max coverage. So, We have created Jira WT-11418 and assign it to development Team. #2 If total annual election amount flag set to Yes Deduct a 1 time amount from my paycheck: Yes Deduct a 1 time amount from my profit sharing, commission or bonus check: yes it showing as per below screenshots We are not getting # 2 point so need to discuss this. Can we have Call on today to discuss #2 Point? Thanks, Rashmita

              People

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

                Dates

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

                  Time Tracking

                  Estimated:
                  Original Estimate - 10h Original Estimate - 10h
                  10h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 42.25h
                  42.25h