WORKTERRAProject Type: software

WORKTERRA

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

BCC Invoice Management - Export Coverage corresponding to Rate for child life plans having family rate issue

    Details

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

      Description

      Steps:-
      1] Log into the system using partner credentials.
      2] Search and select For QA Caiso company.
      3] Click on Add/Change Plan Design from Customizer sub menu
      4] Edit Voluntary child life plan
      5] Click on the Cost and Coverage tab.
      6] Set the Rate Calculated for This Plan As Family rate for all Dependents or Family rate for all Dependent's - Flat.
      7] Enroll in this child life plan with effective date as 06/01/2017. Now generate an invoice for October 2017.
      8] Observe the records displayed on the invoice

      Actual Result:-
      No adjustments are displayed for the above enrollment which we have done, only billing details are displayed.

      Expected Result:-
      Adjustments should be displayed for this enrollment as it is the first invoice.

      Please let me know if you need any more information on this.

        Attachments

          Issue Links

          blocks

          Enhancement - An improvement or enhancement to an existing feature or task. WT-10129 BCC Invoice Management - Export Coverage corresponding to Rate for child life plans having family rate

          • Medium - Has the potential to affect progress.
          • Production Complete
          is cloned by

          Bug - A problem which impairs or prevents the functions of the product. NF-5139 CLONE - BCC Invoice Management - Export Coverage corresponding to Rate for child life plans having family rate issue

          • Medium - Has the potential to affect progress.
          • Production Complete

            Activity

            Ascending order - Click to sort in descending order
            venkatesh.pujari Venkatesh Pujari (Inactive) created issue -
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Field Original Value New Value
            Link This issue blocks WT-10129 [ WT-10129 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Summary BCC Invoice Management - Export Coverage corresponding to Rate for child life plans having family rate BCC Invoice Management - Export Coverage corresponding to Rate for child life plans having family rate issue
            Permalink
            harshada.borole Harshada Borole (Inactive) logged work - 01/Aug/17 05:34 PM
            • Time Spent:
              2h
               

              Analysis

            harshada.borole Harshada Borole (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 2h [ 7200 ]
            Worklog Id 68763 [ 68763 ]
            harshada.borole Harshada Borole (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            harshada.borole Harshada Borole (Inactive) made changes -
            Item State Parent values: Development(10200)
            Original Estimate 0h [ 0 ]
            Permalink
            harshada.borole Harshada Borole (Inactive) logged work - 02/Aug/17 05:38 PM
            • Time Spent:
              7h
               

              Analysis,Coding,Testing.

            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 02/Aug/17 09:30 PM
            • Time Spent:
              0.25h
               

              Scenario discussion: Adjustments not appearing in case NULL Subrate ID

            harshada.borole Harshada Borole (Inactive) made changes -
            Time Spent 2h [ 7200 ] 9h [ 32400 ]
            Worklog Id 69117 [ 69117 ]
            Permalink
            harshada.borole Harshada Borole (Inactive) logged work - 03/Aug/17 04:01 PM
            • Time Spent:
              2h
               

              Testing
              sent code for review

            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 04/Aug/17 12:30 AM
            • Time Spent:
              0.5h
               

              Verification of Invoice output for family rates
              Discussion on incorrect record appearing on invoice in one scenario

            harshada.borole Harshada Borole (Inactive) made changes -
            Time Spent 9h [ 32400 ] 11h [ 39600 ]
            Worklog Id 69308 [ 69308 ]
            Permalink
            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 04/Aug/17 01:08 PM
            • Time Spent:
              5h
               

              Discussion. issue go through, code fix, unit testing

            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Time Spent 11h [ 39600 ] 16h [ 57600 ]
            Worklog Id 69560 [ 69560 ]
            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 04/Aug/17 10:00 PM
            • Time Spent:
              1h
               

              Pari programming:
              Analysis and discussion for output not appearing as expected for Family Rates All Dependents scenario

            harshada.borole Harshada Borole (Inactive) made changes -
            Code Review Date 04/Aug/2017
            Code Reviewed By Jyoti Agarwal [ 16704 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Development(10200) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            Hide
            Permalink
            harshada.borole Harshada Borole (Inactive) added a comment - - edited

            Below are the 3C's:

            Concern:- Export Coverage corresponding to Rate for child life plans having family rate issue.
            Cause:- Adjustment for 'Family rate for all Dependents or Family rate for all Dependent's - Flat' was not handled properly for first invoice. RateID was missing in GroupBy clause of First Invoice query.
            Correction:- Added RateID in GroupBy clause of First Invoice Query.

            Affected files:
            OES_SP_GetRetroBillingDetails_InvoiceBenefitWise

            Affected Area's:
            Adjustment for 'Family rate for all Dependents or Family rate for all Dependent's - Flat' for first invoice.

            Tested Scenario's:
            Enrolled a child with 1/1/2017 effective date and generated first invoice for June 2017.
            We observed Retro Add from Jan-May 2017 and Billing for June 2017 month for 'Family rate for all Dependents or Family rate for all Dependent's - Flat'

            Show
            harshada.borole Harshada Borole (Inactive) added a comment - - edited Below are the 3C's: Concern :- Export Coverage corresponding to Rate for child life plans having family rate issue. Cause :- Adjustment for ' Family rate for all Dependents or Family rate for all Dependent's - Flat ' was not handled properly for first invoice. RateID was missing in GroupBy clause of First Invoice query. Correction :- Added RateID in GroupBy clause of First Invoice Query. Affected files: OES_SP_GetRetroBillingDetails_InvoiceBenefitWise Affected Area's: Adjustment for ' Family rate for all Dependents or Family rate for all Dependent's - Flat ' for first invoice. Tested Scenario's: Enrolled a child with 1/1/2017 effective date and generated first invoice for June 2017. We observed Retro Add from Jan-May 2017 and Billing for June 2017 month for ' Family rate for all Dependents or Family rate for all Dependent's - Flat '
            harshada.borole Harshada Borole (Inactive) made changes -
            Assignee Harshada Borole [ harshada.borole ] Venkatesh Pujari [ venkatesh.pujari ]
            Permalink
            harshada.borole Harshada Borole (Inactive) logged work - 07/Aug/17 03:51 PM
            • Time Spent:
              0.5h
               

              Code commit and ticket update

            harshada.borole Harshada Borole (Inactive) made changes -
            Time Spent 16h [ 57600 ] 16.5h [ 59400 ]
            Worklog Id 69816 [ 69816 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            This is tested. Working fine as expected

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - This is tested. Working fine as expected
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 16.5h [ 59400 ] 16.75h [ 60300 ]
            Worklog Id 72515 [ 72515 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 16.75h [ 60300 ] 17.25h [ 62100 ]
            Worklog Id 72523 [ 72523 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 17.25h [ 62100 ] 18.25h [ 65700 ]
            Worklog Id 72537 [ 72537 ]
            Hide
            Permalink
            Kira.Hamilton Kira Hamilton (Inactive) added a comment -

            Hello,

            Hello,

            Per email received from Susan at BCC on 10/17 this ticket can be closed.

            Thank you,
            Kira Hamilton
            Debbie Kulling

            Show
            Kira.Hamilton Kira Hamilton (Inactive) added a comment - Hello, Hello, Per email received from Susan at BCC on 10/17 this ticket can be closed. Thank you, Kira Hamilton Debbie Kulling
            satyap Satya made changes -
            Environment_New LB [ 18444 ]
            harshada.borole Harshada Borole (Inactive) made changes -
            Link This issue is cloned by NF-5139 [ NF-5139 ]
            Transition Time In Source Status Execution Times
            Harshada Borole (Inactive) made transition -
            Open In Development
            		1d 22h 23m 1
            Venkatesh Pujari (Inactive) made transition -
            In Development In LB Testing
            		5d 5h 1
            Venkatesh Pujari (Inactive) made transition -
            In LB Testing Stage Testing
            		6d 16h 57m 1
            Venkatesh Pujari (Inactive) made transition -
            Stage Testing In Production Testing
            		3d 6h 10m 1
            Venkatesh Pujari (Inactive) made transition -
            In Production Testing Production Complete
            		8s 1
            Venkatesh Pujari (Inactive) made transition -
            Production Complete Closed
            		47s 1

              People

              Assignee:
              venkatesh.pujari Venkatesh Pujari (Inactive)
              Reporter:
              venkatesh.pujari Venkatesh Pujari (Inactive)
              Developer:
              Harshada Borole (Inactive)
              QA:
              Venkatesh Pujari (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Code Review Date:

                  Time Tracking

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