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

WT -> BCC Invoice Enhancement -> Adjustments shown was summation of all costs (not wrong but not uniform with the decided behaviour)

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Environment:
      QA
    • Module:
      BenAdmin - Report
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed

      Description

      Plan - Vision [existing enrollment from Sept to Dec 2016]
      Rate 1 - Non Self Insured (billed rate = $20)
      Rate 2 - Non Self Insured (billed rate = $7)

      Hence system invoices showed total cost $27 - expected

      Now make second rate ineligible for an employee and recalculate the same

      fetched invoice for Sept Oct Nov 2016 -> billing details shown as $20 - Expected

      Now again make second rate eligible for employee and recalculate the same

      fetched Dec 2016 Invoice

      Expected & Actual Results -

      Dec 2016 billing Detail of $27 - worked well
      Adjustment for Sept Oct Nov 2016 should have come as $ +20 and $ + $07 - it came as $27

      This is not wrong
      But we are showing two entries everywhere in adjustments - not summing u the costs.
      Please decide one approach and make it uniform everywhere

      CC - Deepali Tidke Rakesh Roy Prasanna Karlekar Venkatesh Pujari

        Attachments

          Issue Links

            Activity

            Hide
            alankar.chavan Alankar Chavan (Inactive) added a comment - - edited

            Somewhere I also think - showing the adjustment amounts buy summing up them will be more appropriate. But as in other cases we are not summing up the adjustment amounts - logging this discrepancy in above ticket
            Ie, say if it is $20 and $ 30 - we can show it as $50
            if it is $ - 20 and $ 30 - we can show it as $10

            we can have a call with client and decide the approach

            Show
            alankar.chavan Alankar Chavan (Inactive) added a comment - - edited Somewhere I also think - showing the adjustment amounts buy summing up them will be more appropriate. But as in other cases we are not summing up the adjustment amounts - logging this discrepancy in above ticket Ie, say if it is $20 and $ 30 - we can show it as $50 if it is $ - 20 and $ 30 - we can show it as $10 we can have a call with client and decide the approach
            Hide
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment -

            3c's:-
            Concern :- Incorrect adjustments in case of multiple rates mapped to a plan
            Cause :- Adjustments for multiple rates were not handled properly
            Correction :- Handled Adjustments for multiple rate mapped to a plan. Implemented to show adjustments at subrate level

            Affected areas :- Adjustment of all benefit types
            Affected files :- OES_SP_GetRetroBillingDetails_InvoiceBenefitWise

            Tested following scenarios :-
            1) Health benefits
            a) With two billed rates

            • Retro enrollment and future enrollment
            • Eligibility change of rates
            • Cost change of one rate
            • Cost swap of both rate
            • Addition of new rate
            • Tier change
            • Change in cost of one subrate

            b) With two Self insured rates - tested all of above scenarios
            c) With one billed rate and other self insured rate - tested all of above scenarios

            2) Non health benefits
            a) Life benefits - tested all of above with coverage change

            b) Transit benefits - tested with cost change

            Note :-
            1) As per new implementation the adjustements will appear at subrate level
            2) This item needs regression testing of adjustment for all benefit types

            Show
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment - 3c's:- Concern :- Incorrect adjustments in case of multiple rates mapped to a plan Cause :- Adjustments for multiple rates were not handled properly Correction :- Handled Adjustments for multiple rate mapped to a plan. Implemented to show adjustments at subrate level Affected areas :- Adjustment of all benefit types Affected files :- OES_SP_GetRetroBillingDetails_InvoiceBenefitWise Tested following scenarios :- 1) Health benefits a) With two billed rates Retro enrollment and future enrollment Eligibility change of rates Cost change of one rate Cost swap of both rate Addition of new rate Tier change Change in cost of one subrate b) With two Self insured rates - tested all of above scenarios c) With one billed rate and other self insured rate - tested all of above scenarios 2) Non health benefits a) Life benefits - tested all of above with coverage change b) Transit benefits - tested with cost change Note :- 1) As per new implementation the adjustements will appear at subrate level 2) This item needs regression testing of adjustment for all benefit types
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi Jyoti Agrawal,

            After the fix on LB. I have verified the following scenarios on ASML company on LB:-

            1] Health Benefits :- a] With a single billed rate
            b] With two billed rates
            This is verified for Retro and Future enrollments both
            c] Also changed the eligibility of rates,cost change of one rate,swapping the cost one rate to other rate,added one new rate,tier change and also changed cost of only one subrate.
            d] Verified the above scenarios for Self Insured components also.
            e] Verified the above scenarios for one self insured component and one billed rate
            f] Verified the above scenarios for Add Term Policies.
            g] Now Non Health benefits plans are in testing will update once done

            Sachin Hingole,Prasanna Karlekar

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Jyoti Agrawal , After the fix on LB. I have verified the following scenarios on ASML company on LB:- 1] Health Benefits :- a] With a single billed rate b] With two billed rates This is verified for Retro and Future enrollments both c] Also changed the eligibility of rates,cost change of one rate,swapping the cost one rate to other rate,added one new rate,tier change and also changed cost of only one subrate. d] Verified the above scenarios for Self Insured components also. e] Verified the above scenarios for one self insured component and one billed rate f] Verified the above scenarios for Add Term Policies. g] Now Non Health benefits plans are in testing will update once done Sachin Hingole , Prasanna Karlekar Thanks, Venkatesh
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            HI Jyoti Agrawal,

            Tested the Non health benefit plans scenarios like coverage change,transit cost change and also without cost change.

            Ready for Stage.

            Sachin Hingole,Prasanna Karlekar

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - HI Jyoti Agrawal , Tested the Non health benefit plans scenarios like coverage change,transit cost change and also without cost change. Ready for Stage. Sachin Hingole , Prasanna Karlekar Thanks, Venkatesh
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi Jyoti Agrawal,

            After the fix on Stage. I have verified the following scenarios on on AFI For Hspl company:-
            1] Health Benefits :- a] With a single billed rate
            b] With two billed rates
            This is verified for Retro and Future enrollments both
            c] Also changed the eligibility of rates,cost change of one rate,swapping the cost one rate to other rate,added one new rate,tier change and also changed cost of only one subrate.
            d] Verified the above scenarios for Self Insured components also.
            e] Verified the above scenarios for one self insured component and one billed rate
            f] Verified the above scenarios for Add Term Policies.
            g]Tested the Non health benefit plans scenarios like coverage change,transit cost change and also without cost change.

            Ready for Production

            Prasanna Karlekar,Sachin Hingole

            Only one concern is that if we are blocking 2016 adjustments then why are they displayed on the Invoice of 2017 year.

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Jyoti Agrawal , After the fix on Stage. I have verified the following scenarios on on AFI For Hspl company:- 1] Health Benefits :- a] With a single billed rate b] With two billed rates This is verified for Retro and Future enrollments both c] Also changed the eligibility of rates,cost change of one rate,swapping the cost one rate to other rate,added one new rate,tier change and also changed cost of only one subrate. d] Verified the above scenarios for Self Insured components also. e] Verified the above scenarios for one self insured component and one billed rate f] Verified the above scenarios for Add Term Policies. g]Tested the Non health benefit plans scenarios like coverage change,transit cost change and also without cost change. Ready for Production Prasanna Karlekar , Sachin Hingole Only one concern is that if we are blocking 2016 adjustments then why are they displayed on the Invoice of 2017 year. Thanks, Venkatesh
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi Jyoti Agrawal,

            After the fix on Production. I have verified the following scenarios on AFI For Hspl company on Production:-
            1] Health Benefits :- a] With a single billed rate
            b] With two billed rates
            This is verified for Retro and Future enrollments both
            c] Also changed the eligibility of rates,cost change of one rate,swapping the cost one rate to other rate,added one new rate,tier change and also changed cost of only one subrate.
            d] Verified the above scenarios for Self Insured components also.
            e] Verified the above scenarios for one self insured component and one billed rate
            f] Verified the above scenarios for Add Term Policies.

            Now Non Health benefits plans are in testing will update once done

            Sachin Hingole

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Jyoti Agrawal , After the fix on Production. I have verified the following scenarios on AFI For Hspl company on Production:- 1] Health Benefits :- a] With a single billed rate b] With two billed rates This is verified for Retro and Future enrollments both c] Also changed the eligibility of rates,cost change of one rate,swapping the cost one rate to other rate,added one new rate,tier change and also changed cost of only one subrate. d] Verified the above scenarios for Self Insured components also. e] Verified the above scenarios for one self insured component and one billed rate f] Verified the above scenarios for Add Term Policies. Now Non Health benefits plans are in testing will update once done Sachin Hingole Thanks, Venkatesh
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            HI Jyoti Agrawal,

            Tested the Non health benefit plans scenarios like coverage change,transit cost change and also without cost change.

            Sachin Hingole,Prasanna Karlekar

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - HI Jyoti Agrawal , Tested the Non health benefit plans scenarios like coverage change,transit cost change and also without cost change. Sachin Hingole , Prasanna Karlekar Thanks, Venkatesh

              People

              Assignee:
              venkatesh.pujari Venkatesh Pujari (Inactive)
              Reporter:
              alankar.chavan Alankar Chavan (Inactive)
              Developer:
              Jyoti Agrawal (Inactive)
              QA:
              Venkatesh Pujari (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

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

                  Time Tracking

                  Estimated:
                  Original Estimate - 3h Original Estimate - 3h
                  3h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 150.5h
                  150.5h