WORKTERRAProject Type: software

WORKTERRA

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

WT -> BCC Invoice Enhancement -> Incomplete Adjustment data shown in case of class change - eligible rates change scenarios

    Details

    • Type: Bug
    • Status: Closed
    • Priority: High
    • 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 - Life Plan
      Rate - Sub rate A for class A | sub rate B for class B

      • class A employee enrolled from 01/01/2016 (date time stamp in Dec 2016)
      • employee got sub rate A
      • fetched invoices for Jan Feb March April 2016 -> shown me billing details as per the sub rate A which is right
      • partner went on change class page and changed employee's class to B with Eff Date 03/01/2016 (find the rate changes log in attached screenshot)
      • Hence employee has sub rate A in Jan Feb 2016 | he has got sub rate B from March 2016
      • now fetched invoice for May 2016

      Expected Result & Actual Result

      1. billing details as per the sub rate B in May 2016 - worked well
      2. billing adjustment of (+ sub rate B cost) in March April 2016 - worked well
      3. billing adjustment of (- sub rate A cost) in March April 2016 - DID NOT SHOW

      CC - Deepali Tidke Rakesh Roy Venkatesh Pujari Hrishikesh Deshpande

        Attachments

        1. Invoice for May 2016.xlsx
          3 kB
          Alankar Chavan
        2. rate changes log.png
          18 kB
          Alankar Chavan

          Issue Links

          relates to

          Enhancement - An improvement or enhancement to an existing feature or task. WT-6331 BCC Invoice Management - Adjustments in future Invoice

          • Medium - Has the potential to affect progress.
          • Closed

            Activity

            Ascending order - Click to sort in descending order
            Hide
            Permalink
            alankar.chavan Alankar Chavan (Inactive) added a comment -

            please also check below scenario -

            1. employee was enrolled from 01/01/2016 in life plan (coverage 12000 and cost say 20)
            2. fetched Nov 2016 invoice - shown me billing for Nov 2016 and adjustment from Jan to Oct 2016 - expected
            3. raised a QE and changed coverage to 24000 (cost became say 40) - enrolled from 08/01/2016

            Expected and Actual in Dec 2016 Invoice -

            • billing details : cost 40 and coverage 24000 - worked well
            • adjustment from Aug to Nov 2016 : cost 40 and coverage 24000 - worked well
            • adjustment from Aug to Nov 2016 : cost -20 and coverage 12000 - DID NOT SHOW

            CC - Prasanna KarlekarVenkatesh Pujari Rakesh Roy

            Show
            alankar.chavan Alankar Chavan (Inactive) added a comment - please also check below scenario - employee was enrolled from 01/01/2016 in life plan (coverage 12000 and cost say 20) fetched Nov 2016 invoice - shown me billing for Nov 2016 and adjustment from Jan to Oct 2016 - expected raised a QE and changed coverage to 24000 (cost became say 40) - enrolled from 08/01/2016 Expected and Actual in Dec 2016 Invoice - billing details : cost 40 and coverage 24000 - worked well adjustment from Aug to Nov 2016 : cost 40 and coverage 24000 - worked well adjustment from Aug to Nov 2016 : cost -20 and coverage 12000 - DID NOT SHOW CC - Prasanna Karlekar Venkatesh Pujari Rakesh Roy
            Hide
            Permalink
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment -

            Below are 3C's :-
            Concern :- Incomplete Adjustment data shown in case of class change - eligible rates change scenarios
            Cause :- Joins in query were made based on healthtier. Non-health benefits do not have healthtier. So this was failing for non-health benefits
            Correction :- Removed healthtier join query and considered enrollment only.

            Show
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment - Below are 3C's :- Concern :- Incomplete Adjustment data shown in case of class change - eligible rates change scenarios Cause :- Joins in query were made based on healthtier. Non-health benefits do not have healthtier. So this was failing for non-health benefits Correction :- Removed healthtier join query and considered enrollment only.
            Hide
            Permalink
            alankar.chavan Alankar Chavan (Inactive) added a comment -

            Hello Jyoti Agrawal,

            This is working well for Non Health Plans.
            But it has broken the existing working functionality for Health Plans now.

            When I tried above scenarios with Health Plans - I am getting Zero cost for health plan in billing as well as in billing adjustment sections.

            CC - Deepali Tidke Rakesh Roy Hrishikesh Deshpande Prasanna Karlekar Venkatesh Pujari

            Show
            alankar.chavan Alankar Chavan (Inactive) added a comment - Hello Jyoti Agrawal , This is working well for Non Health Plans. But it has broken the existing working functionality for Health Plans now. When I tried above scenarios with Health Plans - I am getting Zero cost for health plan in billing as well as in billing adjustment sections. CC - Deepali Tidke Rakesh Roy Hrishikesh Deshpande Prasanna Karlekar Venkatesh Pujari
            Hide
            Permalink
            alankar.chavan Alankar Chavan (Inactive) added a comment -

            This is tested on WT Stage - 23rd Dec 2016

            Working Well for Health (Billed Rate and Self Insured Component) & Non Health Plans.
            Proper adjustments were shown in the mentioned scenarios

            CC - Deepali Tidke Hrishikesh DeshpandeVenkatesh PujariRakesh Roy

            Ready for Stage
            [please deploy this on Stage with it's parent item ie, WT-6331]

            Show
            alankar.chavan Alankar Chavan (Inactive) added a comment - This is tested on WT Stage - 23rd Dec 2016 Working Well for Health (Billed Rate and Self Insured Component) & Non Health Plans. Proper adjustments were shown in the mentioned scenarios CC - Deepali Tidke Hrishikesh Deshpande Venkatesh Pujari Rakesh Roy Ready for Stage [please deploy this on Stage with it's parent item ie, WT-6331]
            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            This is tested on Stage on AFI For Hspl company - 27th Dec 2016

            Working Well for Health (Billed Rate and Self Insured Component) & Non Health Plans.
            Proper adjustments were shown in the mentioned scenarios

            CC - Alankar Chavan,Prasanna Karlekar

            Ready for Production

            [please deploy this on Production with it's parent item i.e WT-6331]

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - This is tested on Stage on AFI For Hspl company - 27th Dec 2016 Working Well for Health (Billed Rate and Self Insured Component) & Non Health Plans. Proper adjustments were shown in the mentioned scenarios CC - Alankar Chavan , Prasanna Karlekar Ready for Production [please deploy this on Production with it's parent item i.e WT-6331]
            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            This is tested on Production on ASML For Hspl company

            Working Well for Health (Billed Rate and Self Insured Component) & Non Health Plans.

            Proper adjustments were shown in the mentioned scenarios

            Alankar Chavan,Prasanna Karlekar,Jyoti Agrawal

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - This is tested on Production on ASML For Hspl company Working Well for Health (Billed Rate and Self Insured Component) & Non Health Plans. Proper adjustments were shown in the mentioned scenarios Alankar Chavan , Prasanna Karlekar , Jyoti Agrawal

              People

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

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 5h Original Estimate - 5h
                  5h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 18h
                  18h