WORKTERRAProject Type: software

WORKTERRA

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

Issue with coverages per family

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Environment:
      Production
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - Report
    • Reported by:
      Client
    • Item State:
      Production Complete - Closed
    • Sprint:
      WT Sprint 32-Bugs

      Description

      On the child life there is a problem with all clients with this type of coverage - If the coverage is per family - ie - you have 1 child and elect $10,000 in coverage the approved coverage amount on the bill should be $10,000, likewise if you have 3 children. But the report pulls $30,000. This amount is incorrect. In most cases, however the premium is correct, not in all but in most. if we could find a fix for this across the board that would be great.

        Attachments

          Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. WT-8628 Intrepid USA error on billing details reports

          • High - Serious problem that could block progress.
          • Production Complete

          Bug - A problem which impairs or prevents the functions of the product. WB-327 Issue with coverage in Billing Summary Report for plans having family rate customization

          • High - Serious problem that could block progress.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. WT-10739 Billing report - Throws Dataset error if Effective Date Fields exposed on Report

          • High - Serious problem that could block progress.
          • Closed

            Activity

            Ascending order - Click to sort in descending order
            Hide
            Permalink
            surender.kumar surender kumar (Inactive) added a comment -

            3C:

            Concern: Incorrect Approved Coverage Amount per Family.

            Cause: Use of Rate Calculated for This Plan As on Cost & Coverage page was not properly implemented in Report.

            Correction: Correction in Stored Procedure.

            Impacted Areas:

            • Billing Detail Report-
              • Normal Report
              • Column Wise Billing Detail Report
              • Demographic Billing Detail Report
            • Enrollment Report
              • Normal Report
              • Column Wise Enrollment Report
              • Demographic Enrollment Report
            • Benefit Wise Billing Details Report

            Files effected:
            /Database Objects/MasterCompanyDB/04_Stored Procedures/

            • dbo.OES_SP_Report_GetBenefitWiseBillingDetails.sql
            • dbo.OES_SP_GetEnrollmentDetailsForAllEmployee_Demographics.sql
            • dbo.OES_SP_GetEnrollmentDetailsForAllEmployee.StoredProcedure.sql
            • dbo.OES_SP_GetBillingDetailsMonthly_Demographics.sql
            • dbo.OES_SP_GetBillingDetailsMonthlyColumnWise.StoredProcedure.sql
            • dbo.OES_SP_GetBillingDetailsMonthly.StoredProcedure.sql

            Tested below scenarios:

            • Billing Detail Report-
              • Normal Report
              • Column Wise Billing Detail Report
              • Demographic Billing Detail Report
            • Enrollment Report
              • Normal Report
              • Column Wise Enrollment Report
              • Demographic Enrollment Report
            • Benefit Wise Billing Details Report
            Show
            surender.kumar surender kumar (Inactive) added a comment - 3C: Concern: Incorrect Approved Coverage Amount per Family. Cause: Use of Rate Calculated for This Plan As on Cost & Coverage page was not properly implemented in Report. Correction: Correction in Stored Procedure. Impacted Areas: Billing Detail Report- Normal Report Column Wise Billing Detail Report Demographic Billing Detail Report Enrollment Report Normal Report Column Wise Enrollment Report Demographic Enrollment Report Benefit Wise Billing Details Report Files effected: /Database Objects/MasterCompanyDB/04_Stored Procedures/ dbo.OES_SP_Report_GetBenefitWiseBillingDetails.sql dbo.OES_SP_GetEnrollmentDetailsForAllEmployee_Demographics.sql dbo.OES_SP_GetEnrollmentDetailsForAllEmployee.StoredProcedure.sql dbo.OES_SP_GetBillingDetailsMonthly_Demographics.sql dbo.OES_SP_GetBillingDetailsMonthlyColumnWise.StoredProcedure.sql dbo.OES_SP_GetBillingDetailsMonthly.StoredProcedure.sql Tested below scenarios: Billing Detail Report- Normal Report Column Wise Billing Detail Report Demographic Billing Detail Report Enrollment Report Normal Report Column Wise Enrollment Report Demographic Enrollment Report Benefit Wise Billing Details Report
            Hide
            Permalink
            meghana.joshi Meghana Joshi (Inactive) added a comment - - edited

            Verified above mentioned issue for below types of Rate Calculation for Plan [ LIFE benefit type ] :

            Rate Calculated for This Plan As -

            Individually Calculated Rate - Verified on Billing Details, Column Wise Billing Detail Report, Demographic Billing Detail Report , Enrollment report , Column Wise Enrollment Report , Demographic Enrollment Report and Benefit Wise Billing Details Report

            Family Rate For All Children -Verified on Billing Details, Column Wise Billing Detail Report, Demographic Billing Detail Report , Enrollment report , Column Wise Enrollment Report , Demographic Enrollment Report and Benefit Wise Billing Details Report

            Family Rate For All Dependent - Verified on Billing Details, Column Wise Billing Detail Report, Demographic Billing Detail Report , Enrollment report , Column Wise Enrollment Report , Demographic Enrollment Report and Benefit Wise Billing Details Report

            Family Rate For All Dependents-Flat -Verified on Billing Details, Column Wise Billing Detail Report, Demographic Billing Detail Report , Enrollment report , Column Wise Enrollment Report , Demographic Enrollment Report and Benefit Wise Billing Details Report

            Individually calculated rate by considering old age bands -Verified on Billing Details, Column Wise Billing Detail Report, Demographic Billing Detail Report , Enrollment report , Column Wise Enrollment Report , Demographic Enrollment Report and Benefit Wise Billing Details Report

            All are working Fine .

            Will update testing status ones WT-9409 is resolved

            CC - Sachin Hingole

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - - edited Verified above mentioned issue for below types of Rate Calculation for Plan [ LIFE benefit type ] : Rate Calculated for This Plan As - Individually Calculated Rate - Verified on Billing Details, Column Wise Billing Detail Report, Demographic Billing Detail Report , Enrollment report , Column Wise Enrollment Report , Demographic Enrollment Report and Benefit Wise Billing Details Report Family Rate For All Children -Verified on Billing Details, Column Wise Billing Detail Report, Demographic Billing Detail Report , Enrollment report , Column Wise Enrollment Report , Demographic Enrollment Report and Benefit Wise Billing Details Report Family Rate For All Dependent - Verified on Billing Details, Column Wise Billing Detail Report, Demographic Billing Detail Report , Enrollment report , Column Wise Enrollment Report , Demographic Enrollment Report and Benefit Wise Billing Details Report Family Rate For All Dependents-Flat -Verified on Billing Details, Column Wise Billing Detail Report, Demographic Billing Detail Report , Enrollment report , Column Wise Enrollment Report , Demographic Enrollment Report and Benefit Wise Billing Details Report Individually calculated rate by considering old age bands -Verified on Billing Details, Column Wise Billing Detail Report, Demographic Billing Detail Report , Enrollment report , Column Wise Enrollment Report , Demographic Enrollment Report and Benefit Wise Billing Details Report All are working Fine . Will update testing status ones WT-9409 is resolved CC - Sachin Hingole
            Hide
            Permalink
            prasanna Prasanna Karlekar (Inactive) added a comment -

            Following are the 3Cs:
            Concern:
            1. Spouse coverage amount not getting covered for customization Family Rates - All Children
            2. Employee coverage amount not getting considered for Family Rates.

            Cause:
            #1.
            System was considering maximum coverage amount of all dependents. Instead system should have calculated the coverage amount like maximum Coverage Amount for elected children + Coverage Amount elected for Spouse
            #2.
            In Family rates scenario coverage as per maximum coverage amount was appearing. Instead when employee is elected in Spouse / Child plan, coverage elected for employee, should get considered separately.

            Correction:
            Changes done in stored procedures to handle both scenarios

            Impacted areas:
            Billing / Billing Columnwise / Billing Demographic - All scenarios related to Life plans with Family Rate / without Family Rate customization
            Enrollment / Enrollment Column wise / Enrollment Demographic - All scenarios related to Life plans with Family Rate / without Family Rate customization

            Files affected:
            /trunk/WORKTERRAweb/Database Objects/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_GetBillingDetailsMonthly.StoredProcedure.sql
            /trunk/WORKTERRAweb/Database Objects/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_GetBillingDetailsMonthlyColumnWise.StoredProcedure.sql
            /trunk/WORKTERRAweb/Database Objects/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_GetBillingDetailsMonthly_Demographics.sql
            /trunk/WORKTERRAweb/Database Objects/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_GetEnrollmentDetailsForAllEmployee.StoredProcedure.sql
            /trunk/WORKTERRAweb/Database Objects/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_GetEnrollmentDetailsForAllEmployee_Demographics.sql

            Scenarios verified:
            Following Family Rate scenarios verified:
            Family Rates - All Children : Multiple Children enrolled
            Family rate for All Dependents : Spouse + Children enrolled
            Individually Calculated Rate: With Employee + Spouse + Child enrolled
            Verified scenarios added in excel Family Rates Scenarios.xlsx in WT-7614.

            Please note that we have not verified this change for Benefitwise Billing Report as this report is currently not in use.

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - Following are the 3Cs: Concern: 1. Spouse coverage amount not getting covered for customization Family Rates - All Children 2. Employee coverage amount not getting considered for Family Rates. Cause: #1. System was considering maximum coverage amount of all dependents. Instead system should have calculated the coverage amount like maximum Coverage Amount for elected children + Coverage Amount elected for Spouse #2. In Family rates scenario coverage as per maximum coverage amount was appearing. Instead when employee is elected in Spouse / Child plan, coverage elected for employee, should get considered separately. Correction: Changes done in stored procedures to handle both scenarios Impacted areas: Billing / Billing Columnwise / Billing Demographic - All scenarios related to Life plans with Family Rate / without Family Rate customization Enrollment / Enrollment Column wise / Enrollment Demographic - All scenarios related to Life plans with Family Rate / without Family Rate customization Files affected: /trunk/WORKTERRAweb/Database Objects/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_GetBillingDetailsMonthly.StoredProcedure.sql /trunk/WORKTERRAweb/Database Objects/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_GetBillingDetailsMonthlyColumnWise.StoredProcedure.sql /trunk/WORKTERRAweb/Database Objects/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_GetBillingDetailsMonthly_Demographics.sql /trunk/WORKTERRAweb/Database Objects/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_GetEnrollmentDetailsForAllEmployee.StoredProcedure.sql /trunk/WORKTERRAweb/Database Objects/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_GetEnrollmentDetailsForAllEmployee_Demographics.sql Scenarios verified: Following Family Rate scenarios verified: Family Rates - All Children : Multiple Children enrolled Family rate for All Dependents : Spouse + Children enrolled Individually Calculated Rate: With Employee + Spouse + Child enrolled Verified scenarios added in excel Family Rates Scenarios.xlsx in WT-7614 . Please note that we have not verified this change for Benefitwise Billing Report as this report is currently not in use.
            Hide
            Permalink
            meghana.joshi Meghana Joshi (Inactive) added a comment -

            Testing is not started yet due to other task WT-9746 , WT-129

            CC - Sachin Hingole

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - Testing is not started yet due to other task WT-9746 , WT-129 CC - Sachin Hingole
            Hide
            Permalink
            meghana.joshi Meghana Joshi (Inactive) added a comment - - edited

            Verified above mentioned issue for below types of Rate Calculation for Plan [ LIFE benefit type ] :

            Rate Calculated for This Plan As -
            Individually Calculated Rate
            Family Rate For All Children
            Family Rate For All Dependent
            Family Rate For All Dependents-Flat

            Found Two Issues : WT-10739 , WT-10859

            CC - Sachin Hingole Rakesh Roy

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - - edited Verified above mentioned issue for below types of Rate Calculation for Plan [ LIFE benefit type ] : Rate Calculated for This Plan As - Individually Calculated Rate Family Rate For All Children Family Rate For All Dependent Family Rate For All Dependents-Flat Found Two Issues : WT-10739 , WT-10859 CC - Sachin Hingole Rakesh Roy
            Hide
            Permalink
            prasanna Prasanna Karlekar (Inactive) added a comment -

            Hi [~meghana joshi],

            Have unlinked WT-10859 related to this JIRA.
            Appropriate comment updated in WT-10859.

            Thank you!

            cc: Sachin Hingole

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - Hi [~meghana joshi] , Have unlinked WT-10859 related to this JIRA. Appropriate comment updated in WT-10859 . Thank you! cc: Sachin Hingole
            Hide
            Permalink
            prasanna Prasanna Karlekar (Inactive) added a comment -

            Hi [~meghana joshi],

            This issue was re opened for WT-10739 which is deployed in LB environment.
            Hence, assigning this JIRA to you.

            cc: Sachin Hingole, Gaurav Sodani

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - Hi [~meghana joshi] , This issue was re opened for WT-10739 which is deployed in LB environment. Hence, assigning this JIRA to you. cc: Sachin Hingole , Gaurav Sodani
            Hide
            Permalink
            meghana.joshi Meghana Joshi (Inactive) added a comment -

            Verified on LB.

            Good to go on Stage

            CC - Sachin Hingole

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - Verified on LB. Good to go on Stage CC - Sachin Hingole
            Hide
            Permalink
            meghana.joshi Meghana Joshi (Inactive) added a comment -

            Verified above mentioned scenarios on Stage.

            Working Fine

            CC - Sachin Hingole

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - Verified above mentioned scenarios on Stage. Working Fine CC - Sachin Hingole
            Hide
            Permalink
            meghana.joshi Meghana Joshi (Inactive) added a comment -

            Verified above mentioned scenarios on Production.
            Working Fine

            CC - Sachin Hingole

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - Verified above mentioned scenarios on Production. Working Fine CC - Sachin Hingole

              People

              Assignee:
              meghana.joshi Meghana Joshi (Inactive)
              Reporter:
              aditya.vishwakarma Aditya Vishwakarma (Inactive)
              Developer:
              surender kumar (Inactive)
              QA:
              Meghana Joshi (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:
                Pre-Prod Due Date:
                Production Due Date:

                  Time Tracking

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