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
            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 '
            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
            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

              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