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

Can we suppress enrollment with zero coverage from pulling on the report?

    Details

    • Type: Enhancement
    • Status: Closed
    • Priority: Medium
    • Resolution: Cancelled
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Module:
      BenAdmin - Report
    • Reported by:
      Client
    • Company:
      Clarke
    • Item State:
      LB QA - On Hold
    • Sprint:
      WT Sprint 38 - Enhancement
    • Severity:
      Simple

      Description

      A report was run for Clarke. the 0-24 tier has 1 enrollment with zero coverage. I ran a report and there is only one person in that age band and her election is pending EOI so she has no Current coverage amount. Can we suppress these from pulling on the report?

        Attachments

          Issue Links

            Activity

            Hide
            aditya.vishwakarma Aditya Vishwakarma (Inactive) added a comment -

            Hello Debbie Kulling

            Currently we are displaying Approved enrollments only we doesn't check for EOI pending records on billing summary reports.
            If we suppress such records it will affect the volume of premiums and enrollment counts.

            Can you please share your views on this?

            Thanks

            cc:Prasanna Karlekar

            Show
            aditya.vishwakarma Aditya Vishwakarma (Inactive) added a comment - Hello Debbie Kulling Currently we are displaying Approved enrollments only we doesn't check for EOI pending records on billing summary reports. If we suppress such records it will affect the volume of premiums and enrollment counts. Can you please share your views on this? Thanks cc: Prasanna Karlekar
            Hide
            dkulling Debbie Kulling added a comment -

            If we are not pulling pending EOI records why does it show up in the enrollment count? The employee is pending with zero coverage but the report is still showing 1 person enrolled?

            Show
            dkulling Debbie Kulling added a comment - If we are not pulling pending EOI records why does it show up in the enrollment count? The employee is pending with zero coverage but the report is still showing 1 person enrolled?
            Hide
            dkulling Debbie Kulling added a comment -

            I need an update on this issue. Is it still be worked on.

            Show
            dkulling Debbie Kulling added a comment - I need an update on this issue. Is it still be worked on.
            Hide
            gaurav.sodani Gaurav Sodani (Inactive) added a comment -

            Hi Debbie Kulling,

            Apologies for the late response

            We are picking this issue up in Sprint 38 - Enhancement Sprint post Dave's approval. Will update the ETA by 9/25/17

            Regards
            Gaurav

            Aditya VishwakarmaPrasanna Karlekar

            Show
            gaurav.sodani Gaurav Sodani (Inactive) added a comment - Hi Debbie Kulling , Apologies for the late response We are picking this issue up in Sprint 38 - Enhancement Sprint post Dave's approval. Will update the ETA by 9/25/17 Regards Gaurav Aditya Vishwakarma Prasanna Karlekar
            Hide
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment -

            Description:
            With existing implementation there was no check available to pulling records on report even if enrollment having specific coverage (i.e. zero or non-zero) . Now we have added condition that only includes non-zero coverage enrollments on report.

            Affected Files: MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_Report_GetBillingSummary.StoredProcedure.sql

            Affected Areas: Billing summary report

            Tested Scenarios:
            1. Verified Life and Health benefit type records
            2. Verified records with zero coverage and non-zero coverage.

            CC: Prasanna Karlekar

            Show
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - Description : With existing implementation there was no check available to pulling records on report even if enrollment having specific coverage (i.e. zero or non-zero) . Now we have added condition that only includes non-zero coverage enrollments on report. Affected Files : MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_Report_GetBillingSummary.StoredProcedure.sql Affected Areas : Billing summary report Tested Scenarios : 1. Verified Life and Health benefit type records 2. Verified records with zero coverage and non-zero coverage. CC: Prasanna Karlekar
            Hide
            prasanna Prasanna Karlekar (Inactive) added a comment -

            Hi Sachin Hingole,

            We do not know, exact scenarios from where 0 coverage can come into system.
            It will be helpful, if we get test scenarios for this enhancement before we push it to LB.

            Thank you!

            cc: Gaurav Sodani, Rakesh Roy, [~parmeshwar.jumbade]

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - Hi Sachin Hingole , We do not know, exact scenarios from where 0 coverage can come into system. It will be helpful, if we get test scenarios for this enhancement before we push it to LB. Thank you! cc: Gaurav Sodani , Rakesh Roy , [~parmeshwar.jumbade]
            Hide
            sachin.hingole Sachin Hingole (Inactive) added a comment -

            Hi Venkatesh Pujari Rashmita Dudhe [~meghana joshi],

            Can you please help development for scenario mentioned in above comment.

            Thanks,
            Sachin

            Gaurav Sodani Rakesh Roy [~parmeshwar.jumbade]

            Show
            sachin.hingole Sachin Hingole (Inactive) added a comment - Hi Venkatesh Pujari Rashmita Dudhe [~meghana joshi] , Can you please help development for scenario mentioned in above comment. Thanks, Sachin Gaurav Sodani Rakesh Roy [~parmeshwar.jumbade]
            Hide
            prasanna Prasanna Karlekar (Inactive) added a comment -

            Hi Gaurav Sodani,

            Keeping this JIRA On Hold.
            We have verified scenario which the client has mentioned. We need test cases for this as we are not much aware from where 0 coverage can be set for an election.

            Changing Dev Due Date to 4-Oct-2017. Hope that we get the test cases by 3-Oct-2017.

            Thank you!

            cc: [~parmeshwar.jumbade], Sachin Hingole

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - Hi Gaurav Sodani , Keeping this JIRA On Hold. We have verified scenario which the client has mentioned. We need test cases for this as we are not much aware from where 0 coverage can be set for an election. Changing Dev Due Date to 4-Oct-2017. Hope that we get the test cases by 3-Oct-2017. Thank you! cc: [~parmeshwar.jumbade] , Sachin Hingole
            Hide
            meghana.joshi Meghana Joshi (Inactive) added a comment -
            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - PFA Test Cases WT- 9147 Test Cases.xls CC - Sachin Hingole
            Hide
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment -

            Hi [~meghana joshi],

            I have verified test-cases (marked in yellow color) provided by you for single benefit type and it is working as expected. Please find attached updated WT- 9147 Test Cases_updated.xls sheet (tested scenarios marked in yellow). All test-cases verified for SA login. Please do verify with all logins.

            CC: Prasanna Karlekar

            Show
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - Hi [~meghana joshi] , I have verified test-cases (marked in yellow color) provided by you for single benefit type and it is working as expected. Please find attached updated WT- 9147 Test Cases_updated.xls sheet (tested scenarios marked in yellow). All test-cases verified for SA login. Please do verify with all logins. CC: Prasanna Karlekar
            Hide
            meghana.joshi Meghana Joshi (Inactive) added a comment -

            Verified all attached scenarios .

            Working Fine

            CC - Sachin Hingole

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - Verified all attached scenarios . Working Fine CC - Sachin Hingole
            Hide
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment -

            Can not pushed this on stage environment because of WT-9409.

            CC: Prasanna Karlekar Sachin Hingole

            Show
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - Can not pushed this on stage environment because of WT-9409 . CC: Prasanna Karlekar Sachin Hingole
            Hide
            sachin.hingole Sachin Hingole (Inactive) added a comment -

            Can you please close these JIRA from WT & ST project.

            Show
            sachin.hingole Sachin Hingole (Inactive) added a comment - Can you please close these JIRA from WT & ST project.

              People

              Assignee:
              Unassigned
              Reporter:
              aditya.vishwakarma Aditya Vishwakarma (Inactive)
              Developer:
              Parmeshwar Jumbad (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

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

                  Time Tracking

                  Estimated:
                  Original Estimate - 30h Original Estimate - 30h
                  30h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 50.75h
                  50.75h