Uploaded image for project: 'Workterra BenAdmin'
  1. Workterra BenAdmin
  2. WB-327

Issue with coverage in Billing Summary Report for plans having family rate customization

    Details

    • Type: Bug
    • Status: Closed
    • Priority: High
    • Resolution: Bug Fixed
    • Labels:
    • Environment:
      Production
    • Categories:
      Report - Billing
    • Company:
      All Clients/Multiple Clients
    • Reported by:
      Harbinger

      Description

      Issue with coverage in Billing Summary Report for plans having family rate customization

        Attachments

          Issue Links

            Activity

            surender.kumar surender kumar (Inactive) created issue -
            surender.kumar surender kumar (Inactive) made changes -
            Field Original Value New Value
            Assignee Vijay Siddha [ vijays ] surender kumar [ surender.kumar ]
            surender.kumar surender kumar (Inactive) made changes -
            Link This issue relates to WT-8642 [ WT-8642 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee surender kumar [ surender.kumar ] Harshada Borole [ harshada.borole ]
            Code Reviewed By Prasanna Karlekar [ 11907 ]
            Dev Due Date 13/Jun/2017
            admin01 admin made changes -
            Sprint WT Sprint 30 -Bugs [ 70 ]
            harshada.borole Harshada Borole (Inactive) logged work - 06/Jun/17 01:03 AM
            • Time Spent:
              1h
               

              Analysis

            prasanna Prasanna Karlekar (Inactive) made changes -
            Summary Issue with coverage in Billing Summary Report Issue with coverage in Billing Summary Report for plans having family rate customization
            harshada.borole Harshada Borole (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 1h [ 3600 ]
            Worklog Id 52637 [ 52637 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 06/Jun/17 02:18 PM
            • Time Spent:
              1h
               

              Discussion with harshada

            harshada.borole Harshada Borole (Inactive) logged work - 07/Jun/17 12:27 AM
            • Time Spent:
              6h
               

              Testing scenarios
              SP anaysis.

            harshada.borole Harshada Borole (Inactive) logged work - 08/Jun/17 12:27 AM - edited
            • Time Spent:
              8h
               

              Analysis of SP
              Discussion
              Coding

            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Dev Due Date 13/Jun/2017 14/Jun/2017
            harshada.borole Harshada Borole (Inactive) made changes -
            Time Spent 1h [ 3600 ] 7h [ 25200 ]
            Worklog Id 53352 [ 53352 ]
            harshada.borole Harshada Borole (Inactive) made changes -
            Time Spent 7h [ 25200 ] 15h [ 54000 ]
            Worklog Id 53355 [ 53355 ]
            harshada.borole Harshada Borole (Inactive) made changes -
            Worklog Id 53355 [ 53355 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Time Spent 15h [ 54000 ] 16h [ 57600 ]
            Worklog Id 53462 [ 53462 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 08/Jun/17 02:25 PM
            • Time Spent:
              3h
               

              Discussion, code go through, bug fix analysis

            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Time Spent 16h [ 57600 ] 19h [ 68400 ]
            Worklog Id 53469 [ 53469 ]
            harshada.borole Harshada Borole (Inactive) logged work - 08/Jun/17 10:23 PM
            • Time Spent:
              7h
               

              Analysis
              discussion
              coding

            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 ]
            harshada.borole Harshada Borole (Inactive) made changes -
            Time Spent 19h [ 68400 ] 26h [ 93600 ]
            Worklog Id 53642 [ 53642 ]
            harshada.borole Harshada Borole (Inactive) logged work - 09/Jun/17 12:48 PM
            • Time Spent:
              6h
               

              Discussion,Coding,Testing

            harshada.borole Harshada Borole (Inactive) made changes -
            Time Spent 26h [ 93600 ] 32h [ 115200 ]
            Worklog Id 53799 [ 53799 ]
            prasanna Prasanna Karlekar (Inactive) logged work - 09/Jun/17 11:00 PM
            • Time Spent:
              1h
               

              Discussion on family rates for Child Life plan

            prasanna Prasanna Karlekar (Inactive) logged work - 13/Jun/17 09:30 PM
            • Time Spent:
              1h
               

              Coverage scenario discussion

            harshada.borole Harshada Borole (Inactive) logged work - 14/Jun/17 12:54 AM
            • Time Spent:
              8h
               

              Discussion,Coding

            harshada.borole Harshada Borole (Inactive) logged work - 14/Jun/17 12:54 PM
            • Time Spent:
              8h
               

              Discussion,Coding,Documentation

            harshada.borole Harshada Borole (Inactive) made changes -
            Time Spent 32h [ 115200 ] 40h [ 144000 ]
            Worklog Id 55039 [ 55039 ]
            harshada.borole Harshada Borole (Inactive) made changes -
            Time Spent 40h [ 144000 ] 48h [ 172800 ]
            Worklog Id 55042 [ 55042 ]
            surender.kumar surender kumar (Inactive) logged work - 14/Jun/17 01:32 PM
            • Time Spent:
              4h
               

              Analysis
              Discussion
              coding

            surender.kumar surender kumar (Inactive) made changes -
            Time Spent 48h [ 172800 ] 52h [ 187200 ]
            Worklog Id 55087 [ 55087 ]
            prasanna Prasanna Karlekar (Inactive) logged work - 14/Jun/17 10:00 PM
            • Time Spent:
              2h
               

              Billing Summary Scenario discussion for family rates

            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 52h [ 187200 ] 54h [ 194400 ]
            Worklog Id 55320 [ 55320 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 54h [ 194400 ] 55h [ 198000 ]
            Worklog Id 55330 [ 55330 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Harshada Borole [ harshada.borole ] surender kumar [ surender.kumar ]
            Dev Due Date 14/Jun/2017 22/Jun/2017
            Developer surender kumar [ surender.kumar ]
            Hide
            prasanna Prasanna Karlekar (Inactive) added a comment -

            This will get complete in next sprint as we discovered new scenarios related to family rates.

            cc: Satya

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - This will get complete in next sprint as we discovered new scenarios related to family rates. cc: Satya
            surender.kumar surender kumar (Inactive) logged work - 16/Jun/17 12:53 PM
            • Time Spent:
              8h
               

              Analysis
              Discussion
              Coding
              Testing

            surender.kumar surender kumar (Inactive) made changes -
            Time Spent 55h [ 198000 ] 63h [ 226800 ]
            Worklog Id 55888 [ 55888 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Sprint WT Sprint 30 -Bugs [ 70 ] WT Sprint 31-Bugs [ 71 ]
            prasanna Prasanna Karlekar (Inactive) logged work - 20/Jun/17 12:00 AM
            • Time Spent:
              0.5h
               

              Scenario discussion on Billing summary report

            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 63h [ 226800 ] 64h [ 230400 ]
            Worklog Id 56626 [ 56626 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 64h [ 230400 ] 64.5h [ 232200 ]
            Worklog Id 57022 [ 57022 ]
            surender.kumar surender kumar (Inactive) logged work - 21/Jun/17 01:38 PM
            • Time Spent:
              8h
               

              Analysis
              Discussion
              Coding
              Testing

            surender.kumar surender kumar (Inactive) made changes -
            Time Spent 64.5h [ 232200 ] 72.5h [ 261000 ]
            Worklog Id 57248 [ 57248 ]
            surender.kumar surender kumar (Inactive) logged work - 22/Jun/17 01:08 PM
            • Time Spent:
              8h
               

              Analysis
              Discussion
              Coding

            surender.kumar surender kumar (Inactive) made changes -
            Dev Due Date 22/Jun/2017 28/Jun/2017
            surender.kumar surender kumar (Inactive) made changes -
            Time Spent 72.5h [ 261000 ] 80.5h [ 289800 ]
            Worklog Id 57534 [ 57534 ]
            prasanna Prasanna Karlekar (Inactive) logged work - 23/Jun/17 12:00 AM
            • Time Spent:
              0.5h
               

              Scenario discussion

            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 80.5h [ 289800 ] 81h [ 291600 ]
            Worklog Id 57772 [ 57772 ]
            surender.kumar surender kumar (Inactive) logged work - 23/Jun/17 12:57 PM
            • Time Spent:
              7h
               

              coding
              Discussion
              Testing

            surender.kumar surender kumar (Inactive) made changes -
            Time Spent 81h [ 291600 ] 88h [ 316800 ]
            Worklog Id 57982 [ 57982 ]
            prasanna Prasanna Karlekar (Inactive) logged work - 23/Jun/17 11:30 PM
            • Time Spent:
              0.25h
               

              Scenario discussion

            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 88h [ 316800 ] 88.25h [ 317700 ]
            Worklog Id 58166 [ 58166 ]
            prasanna Prasanna Karlekar (Inactive) logged work - 28/Jun/17 07:00 PM
            • Time Spent:
              0.25h
               

              Scenario discussion

            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 88.25h [ 317700 ] 88.5h [ 318600 ]
            Worklog Id 59102 [ 59102 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee surender kumar [ surender.kumar ] Prasanna Karlekar [ prasanna ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Item State Parent values: Development(10200) Parent values: Development(10200)Level 1 values: Ready for Review(10208)
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Sprint WT Sprint 31-Bugs [ 71 ] WT Sprint 32-Bugs [ 76 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Dev Due Date 28/Jun/2017 12/Jul/2017
            prasanna Prasanna Karlekar (Inactive) logged work - 29/Jul/17 02:00 AM
            • Time Spent:
              0.5h
               

              Code and functionality review

            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 88.5h [ 318600 ] 89h [ 320400 ]
            Worklog Id 68487 [ 68487 ]
            prasanna Prasanna Karlekar (Inactive) logged work - 02/Aug/17 07:30 PM
            • Time Spent:
              1.5h
               

              Issue resolution:
              Rate cost getting displayed as 0 instead of cost defined on Subrate Tab

            prasanna Prasanna Karlekar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208) 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)
            prasanna Prasanna Karlekar (Inactive) logged work - 10/Aug/17 12:30 AM
            • Time Spent:
              0.5h
               

              Code check in and 3C updates
              Issue found when no rate is mapped to a life plan.

            Hide
            prasanna Prasanna Karlekar (Inactive) added a comment -

            Concern:
            Family Rates scenario not working as expected on Billing Summary Report.

            Cause:
            Code implementation for family rates scenario was not working as expected.
            1. For Family rate - All Children customization and Require same coverage for child set to true, coverages were getting summed up. Instead, it should be considered only once.
            2. For other family rate customization too, individual coverages were getting summed up. Instead maximum coverage should be considered.

            Correction:
            We have done implementation changes and handled following scenarios:
            1. Family Rate For All Children with Require same coverage for child set true- Consider coverage only once
            2. Family Rate For All Children with Require same coverage for child set false- Consider maximum coverage elected for Children.
            3. Family Rate For All Dependent - Maximum coverage of Spouse and Child elected
            4. Family Rate For All Dependents-Flat - Maximum coverage of Spouse and Child elected
            5. Individually Calculated rates - All coverages as per election.

            Affected Files:
            dbo.OES_SP_Report_GetBillingSummary.StoredProcedure

            Impacted areas:
            Life Plan scenarios - With and without Family Rate customization.

            Known issues:
            1. Records displayed for Individually Calculated rates are as per coverage levels of Employee, Spouse and child. If Employee, Spouse and Child are enrolled 3 entries appear as per their coverages but premium displayed against them is calculated by considering all the elected coverages. This is discrepancy as we do not store memberwise coverage in the system. (We need to check if the cost split up can be saved.)
            2. If no rate is mapped, records are not appearing for Life Plan. This was working earlier.

            cc: Satya

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - Concern: Family Rates scenario not working as expected on Billing Summary Report. Cause: Code implementation for family rates scenario was not working as expected. 1. For Family rate - All Children customization and Require same coverage for child set to true, coverages were getting summed up. Instead, it should be considered only once. 2. For other family rate customization too, individual coverages were getting summed up. Instead maximum coverage should be considered. Correction: We have done implementation changes and handled following scenarios: 1. Family Rate For All Children with Require same coverage for child set true- Consider coverage only once 2. Family Rate For All Children with Require same coverage for child set false- Consider maximum coverage elected for Children. 3. Family Rate For All Dependent - Maximum coverage of Spouse and Child elected 4. Family Rate For All Dependents-Flat - Maximum coverage of Spouse and Child elected 5. Individually Calculated rates - All coverages as per election. Affected Files: dbo.OES_SP_Report_GetBillingSummary.StoredProcedure Impacted areas: Life Plan scenarios - With and without Family Rate customization. Known issues: 1. Records displayed for Individually Calculated rates are as per coverage levels of Employee, Spouse and child. If Employee, Spouse and Child are enrolled 3 entries appear as per their coverages but premium displayed against them is calculated by considering all the elected coverages. This is discrepancy as we do not store memberwise coverage in the system. (We need to check if the cost split up can be saved.) 2. If no rate is mapped, records are not appearing for Life Plan. This was working earlier. cc: Satya
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ] Sachin Hingole [ sachin.hingole ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            sachin.hingole Sachin Hingole (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)
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Assignee Sachin Hingole [ sachin.hingole ] Meghana Joshi [ meghana.kulkarni ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Production Due Date 29/Aug/2017
            Stage Due Date 24/Aug/17 [ 2017-08-24 ]
            Hide
            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
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Stage Due Date 24/Aug/17 [ 2017-08-24 ] 28/Aug/17 [ 2017-08-28 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 89h [ 320400 ] 90.5h [ 325800 ]
            Worklog Id 72519 [ 72519 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 90.5h [ 325800 ] 91h [ 327600 ]
            Worklog Id 72579 [ 72579 ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Dev Due Date 12/Jul/2017 12/Jul/2017
            Production Due Date 29/Aug/2017 31/Aug/2017
            Stage Due Date 28/Aug/17 [ 2017-08-28 ] 30/Aug/17 [ 2017-08-30 ]
            meghana.joshi Meghana Joshi (Inactive) logged work - 29/Aug/17 12:32 PM
            • Time Spent:
              3h
               

              LB Testing

            Hide
            meghana.joshi Meghana Joshi (Inactive) added a comment -

            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

            In all above rate calculation scenarios ,Coverage , Rate , Volume , Enrollment and Premium are displayed properly.

            ISSUE : But, Enrollment Count are not updated properly if two different employee enrolled in same plan with same coverage. [ Billing summary report : Cost by set to Age-band]

            CC - Sachin Hingole Rakesh Roy

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - 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 In all above rate calculation scenarios ,Coverage , Rate , Volume , Enrollment and Premium are displayed properly. ISSUE : But, Enrollment Count are not updated properly if two different employee enrolled in same plan with same coverage. [ Billing summary report : Cost by set to Age-band] CC - Sachin Hingole Rakesh Roy
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Time Spent 91h [ 327600 ] 94h [ 338400 ]
            Worklog Id 74823 [ 74823 ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Re-open(10212)
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Status Local Testing [ 10200 ] Reopen in Local [ 10018 ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Assignee Meghana Joshi [ meghana.kulkarni ] Prasanna Karlekar [ prasanna ]
            prasanna Prasanna Karlekar (Inactive) logged work - 30/Aug/17 12:00 AM
            • Time Spent:
              0.25h
               

              Scenario discussion with QA

            rakeshr Rakesh Roy (Inactive) made changes -
            Bug Severity Medium [ 16702 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 94h [ 338400 ] 94.25h [ 339300 ]
            Worklog Id 75657 [ 75657 ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Status Reopen in Local [ 10018 ] In Development [ 10007 ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Re-open(10212) Parent values: Development(10200)Level 1 values: In Analysis(10204)
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Sprint WT Sprint 32-Bugs [ 76 ] WT Sprint 32-Bugs, WT Sprint 37 - Bugs [ 76, 87 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Dev Due Date 12/Jul/2017 20/Sep/2017
            prasanna Prasanna Karlekar (Inactive) logged work - 19/Sep/17 12:00 AM
            • Time Spent:
              1.5h
               

              Discussion on Invoice test company missing from Stage environment
              Email communication
              Issue analysis

            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Dev Due Date 20/Sep/2017 29/Sep/2017
            Hide
            gaurav.sodani Gaurav Sodani (Inactive) added a comment -

            Hi Prasanna Karlekar

            Please make sure we complete this issue till 9/29/17. We can not have this extended further

            Regards
            Gaurav

            CC: Satya

            Show
            gaurav.sodani Gaurav Sodani (Inactive) added a comment - Hi Prasanna Karlekar Please make sure we complete this issue till 9/29/17. We can not have this extended further Regards Gaurav CC: Satya
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Sprint WT Sprint 32-Bugs, WT Sprint 37 - Bugs [ 76, 87 ] WT Sprint 32-Bugs [ 76 ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Dev Due Date 29/Sep/2017
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Sprint WT Sprint 32-Bugs [ 76 ] WT Sprint 32-Bugs, WT Sprint 38 - Bugs [ 76, 89 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Dev Due Date 04/Oct/2017
            Dev Estimates 28
            Production Due Date 31/Aug/2017
            Stage Due Date 30/Aug/17 [ 2017-08-30 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 94.25h [ 339300 ] 95.75h [ 344700 ]
            Worklog Id 81305 [ 81305 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Dev Due Date 04/Oct/2017 06/Oct/2017
            prasanna Prasanna Karlekar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Development(10200)Level 1 values: In Progress(10206)
            prasanna Prasanna Karlekar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: Development(10200)Level 1 values: Ready for Review(10208)
            prasanna Prasanna Karlekar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208) Parent values: Development(10200)Level 1 values: In Progress(10206)
            prasanna Prasanna Karlekar (Inactive) made changes -
            Dev Due Date 06/Oct/2017 10/Oct/2017
            prasanna Prasanna Karlekar (Inactive) made changes -
            Dev Due Date 10/Oct/2017 13/Oct/2017
            prasanna Prasanna Karlekar (Inactive) made changes -
            Dev Due Date 13/Oct/2017 16/Oct/2017
            prasanna Prasanna Karlekar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: Development(10200)Level 1 values: On Hold(10207)
            Hide
            prasanna Prasanna Karlekar (Inactive) added a comment -

            Keeping this JIRA On Hold.
            Not getting time to work on this due to Support tasks that needs to be worked up on.
            Will try to resume working on this if time permits.

            Thank you!

            cc: Gaurav Sodani

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - Keeping this JIRA On Hold. Not getting time to work on this due to Support tasks that needs to be worked up on. Will try to resume working on this if time permits. Thank you! cc: Gaurav Sodani
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Link This issue relates to WT-9147 [ WT-9147 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Link This issue relates to WT-9147 [ WT-9147 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Link This issue blocks WT-9147 [ WT-9147 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Labels Static_Reports
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 02/Nov/17 11:14 AM
            • Time Spent:
              3h
               

              Analysis
              Code changes
              Unit testing
              Internal discussion

            prasanna Prasanna Karlekar (Inactive) made changes -
            Priority Medium [ 3 ] High [ 2 ]
            Hide
            prasanna Prasanna Karlekar (Inactive) added a comment -

            Have changed the priority from Medium to High as these changes will be required for proper output of Family rate customization and also to keep the code consistency.

            cc: Gaurav Sodani, [~parmeshwar.jumbade]

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - Have changed the priority from Medium to High as these changes will be required for proper output of Family rate customization and also to keep the code consistency. cc: Gaurav Sodani , [~parmeshwar.jumbade]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ] Parmeshwar Jumbad [ parmeshwar.jumbade ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Company All Clients/Multiple Clients [ 18434 ]
            Item State Parent values: Development(10200)Level 1 values: On Hold(10207) Parent values: Development(10200)Level 1 values: In Progress(10206)
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Dev Due Date 16/Oct/2017 06/Nov/2017
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Assignee Parmeshwar Jumbad [ parmeshwar.jumbade ] Prasanna Karlekar [ prasanna ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: Development(10200)Level 1 values: Ready for Review(10208)
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 95.75h [ 344700 ] 98.75h [ 355500 ]
            Worklog Id 89004 [ 89004 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 03/Nov/17 11:15 AM
            • Time Spent:
              3.5h
               

              Unit testing and Review request

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 98.75h [ 355500 ] 102.25h [ 368100 ]
            Worklog Id 89005 [ 89005 ]
            satyap Satya made changes -
            Environment_New Production [ 18442 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Developer surender kumar [ surender.kumar ] Parmeshwar Jumbad [ parmeshwar.jumbade ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 06/Nov/17 11:18 AM
            • Time Spent:
              3.5h
               

              Code review changes and Unit testing

            prasanna Prasanna Karlekar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ] Parmeshwar Jumbad [ parmeshwar.jumbade ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 102.25h [ 368100 ] 103.25h [ 371700 ]
            Worklog Id 89337 [ 89337 ]
            prasanna Prasanna Karlekar (Inactive) logged work - 06/Nov/17 10:00 PM
            • Time Spent:
              1h
               

              Code review
              Functionlaity review on test company

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 103.25h [ 371700 ] 106.75h [ 384300 ]
            Worklog Id 89450 [ 89450 ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) Parent values: Development(10200)Level 1 values: On Hold(10207)
            satyap Satya made changes -
            Sprint WT Sprint 32-Bugs, WT Sprint 38 - Bugs [ 76, 89 ] WT - Sprint 44, WT Sprint 32-Bugs, WT Sprint 38 - Bugs [ 10, 76, 89 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Description Issue with coverage in Billing Summary Report for plans having family rate customization
            QA Venkatesh Pujari [ venkatesh.pujari ]
            QA Estimates 8
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Dev Due Date 06/Nov/2017 23/Feb/2018
            Dev Estimates 28 3
            jenniferreed Jennifer Reed (Inactive) made changes -
            Categories Parent values: Report(18507)Level 1 values: Billing(18515)
            Environment_Old Production [ 10005 ]
            Key WT-9409 WB-327
            Project WORKTERRA [ 10000 ] Workterra BenAdmin [ 11501 ]
            Workflow WT_Defects [ 40723 ] WB: Bugs Project Management Workflow [ 65164 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Workflow WB: Bugs Project Management Workflow [ 65164 ] 0803 Copy of WB: Bugs Project Management Workflow [ 65942 ]
            satyap Satya made changes -
            Sprint WT - Sprint 44, WT Sprint 32-Bugs, WT Sprint 38 - Bugs [ 10, 76, 89 ] WT - Sprint 44, WT Sprint 32-Bugs, WT Sprint 38 - Bugs, WB - Sprint 45 [ 10, 76, 89, 102 ]
            satyap Satya made changes -
            Rank Ranked lower
            satyap Satya made changes -
            Sprint WT - Sprint 44, WT Sprint 32-Bugs, WT Sprint 38 - Bugs, WB - Sprint 45 [ 10, 76, 89, 102 ] WT - Sprint 44, WT Sprint 32-Bugs, WT Sprint 38 - Bugs [ 10, 76, 89 ]
            Hide
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment -

            All above tested changes also merged in new UI so all changes need to test along with Enrollment count discrepancy.

            Below are the 3C's for Enrollment count discrepancy:

            Concern: Enrollment count were mismatched in Cost By Coverage and Cost by Age-Band for LIFE benefit type.
            Cause: Code was not exist to show sum of distinct enrollment count. So, it was always showing one count no matter how many number of enrollment available into specified Age band. This issue was present only in case of Cost by Age-Band for LIFE benefit type.
            Correction: Modified existing implementation in a way that will calculate correct Enrollment count (i.e. Equivalent count in both cases . Now it will show exact same count in case of Cost by Age band and Cost by Coverage.

            Affected Areas: Billing Summary Report
            Affected Files:
            /MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_Report_GetBillingSummary.StoredProcedure.sql

            Tested Scenarios:

            1. Verified Enrollment counts on Billing Summary reports For Life and Health benefit type.
            2. Compared Enrollment count in both cases (i.e. Cost by Coverage and Age band).

            CC: Amruta Lohiya Satya

            Show
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - All above tested changes also merged in new UI so all changes need to test along with Enrollment count discrepancy. Below are the 3C's for Enrollment count discrepancy: Concern : Enrollment count were mismatched in Cost By Coverage and Cost by Age-Band for LIFE benefit type. Cause : Code was not exist to show sum of distinct enrollment count. So, it was always showing one count no matter how many number of enrollment available into specified Age band. This issue was present only in case of Cost by Age-Band for LIFE benefit type. Correction : Modified existing implementation in a way that will calculate correct Enrollment count (i.e. Equivalent count in both cases . Now it will show exact same count in case of Cost by Age band and Cost by Coverage. Affected Areas : Billing Summary Report Affected Files : /MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_Report_GetBillingSummary.StoredProcedure.sql Tested Scenarios : 1. Verified Enrollment counts on Billing Summary reports For Life and Health benefit type. 2. Compared Enrollment count in both cases (i.e. Cost by Coverage and Age band). CC: Amruta Lohiya Satya
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Assignee Parmeshwar Jumbad [ parmeshwar.jumbade ] Sachin Hingole [ sachin.hingole ]
            prasadp Prasad Pise (Inactive) made changes -
            Assignee Sachin Hingole [ sachin.hingole ] Venkatesh Pujari [ venkatesh.pujari ]
            prasadp Prasad Pise (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi [~parmeshwar.jumbade],

            I have verified the below points on Codemap on For QA KinderCare company:-

            1. Family Rate For All Children with Require same coverage for child set true- Consider coverage only once
            2. Family Rate For All Children with Require same coverage for child set false- Consider maximum coverage elected for Children.
            3. Family Rate For All Dependent - Maximum coverage of Spouse and Child elected
            4. Family Rate For All Dependents-Flat - Maximum coverage of Spouse and Child elected
            5. Individually Calculated rates - All coverages as per election.

            System is not behaving as per expectation. For above points system is displaying wrong data on the Billing Summary Report.

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

            Sachin Hingole,Prasad Pise

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi [~parmeshwar.jumbade] , I have verified the below points on Codemap on For QA KinderCare company:- 1. Family Rate For All Children with Require same coverage for child set true- Consider coverage only once 2. Family Rate For All Children with Require same coverage for child set false- Consider maximum coverage elected for Children. 3. Family Rate For All Dependent - Maximum coverage of Spouse and Child elected 4. Family Rate For All Dependents-Flat - Maximum coverage of Spouse and Child elected 5. Individually Calculated rates - All coverages as per election. System is not behaving as per expectation. For above points system is displaying wrong data on the Billing Summary Report. Please let me know if you need any more information on this. Sachin Hingole , Prasad Pise Thanks, Venkatesh
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 19/Mar/18 10:25 AM
            • Time Spent:
              3h
               
              <No comment>
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi [~parmeshwar.jumbade],

            Please could you assign this ticket once the issue is fixed.

            Sachin Hingole

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi [~parmeshwar.jumbade] , Please could you assign this ticket once the issue is fixed. Sachin Hingole Thanks, Venkatesh
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Assignee Venkatesh Pujari [ venkatesh.pujari ] Parmeshwar Jumbad [ parmeshwar.jumbade ]
            Status Local Testing [ 10200 ] In Development [ 10007 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 106.75h [ 384300 ] 109.75h [ 395100 ]
            Worklog Id 108912 [ 108912 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 19/Mar/18 11:21 PM - edited
            • Time Spent:
              3h
               

              Discussion with QA for scenarios getting failed while testing

              internal discussion

            Prashant.samal Prashant Samal (Inactive) made changes -
            Workflow 0803 Copy of WB: Bugs Project Management Workflow [ 65942 ] 2203 WB: Bugs Project Management Workflow [ 67078 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 109.75h [ 395100 ] 112.75h [ 405900 ]
            Worklog Id 109710 [ 109710 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Worklog Id 109710 [ 109710 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 27/Mar/18 04:17 AM
            • Time Spent:
              1h
               

              Check files with old branch and deployed scripts

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 112.75h [ 405900 ] 113.75h [ 409500 ]
            Worklog Id 110216 [ 110216 ]
            satyap Satya made changes -
            Sprint WT - Sprint 44, WT Sprint 32-Bugs, WT Sprint 38 - Bugs [ 10, 76, 89 ] WT - Sprint 44, WT Sprint 32-Bugs, WT Sprint 38 - Bugs, WB - Sprint 46 [ 10, 76, 89, 104 ]
            satyap Satya made changes -
            Rank Ranked lower
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 30/Mar/18 02:02 AM
            • Time Spent:
              5h
               

              Test Case Writing and Analysis

            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 113.75h [ 409500 ] 118.75h [ 427500 ]
            Worklog Id 110919 [ 110919 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Dev Due Date 23/Feb/2018 10/Apr/2018
            Dev Estimates 3 8
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 05/Apr/18 07:36 AM
            • Time Spent:
              4.5h
               

              Check root cause of Re-opened points

              Internal discussion with Amruta & QA

            Prashant.samal Prashant Samal (Inactive) made changes -
            Workflow 2203 WB: Bugs Project Management Workflow [ 67078 ] 0604 Issues Management Workflow [ 68191 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 06/Apr/18 07:47 AM
            • Time Spent:
              1h
               

              Check-In related discussion with Amruta/Satya and Sachin

              Check trigger scenarios

            sachin.hingole Sachin Hingole (Inactive) made changes -
            Link This issue relates to WB-286 [ WB-286 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Dev Due Date 10/Apr/2018 13/Apr/2018
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 118.75h [ 427500 ] 123.25h [ 443700 ]
            Worklog Id 112086 [ 112086 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 123.25h [ 443700 ] 124.25h [ 447300 ]
            Worklog Id 112090 [ 112090 ]
            ashwin.wankhede Ashwin Wankhede (Inactive) made changes -
            Assignee Parmeshwar Jumbad [ parmeshwar.jumbade ] Hrishikesh Deshpande [ hrishikesh.deshpande ]
            Status In Development [ 10007 ] LB Deployed [ 11600 ]
            Hide
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment -

            Hi Venkatesh Pujari/Hrishikesh Deshpande

            For now we have handled few scenarios which are mentioned in WB-275. Please check those scenarios and as mentioned in WB-275, remaining scenarios we can consider in WB-852.

            Please let me know if require some additional details.

            CC: Prashant Samal Amruta Lohiya Satya

            Show
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - Hi Venkatesh Pujari / Hrishikesh Deshpande For now we have handled few scenarios which are mentioned in WB-275. Please check those scenarios and as mentioned in WB-275, remaining scenarios we can consider in WB-852. Please let me know if require some additional details. CC: Prashant Samal   Amruta Lohiya Satya
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Assignee Hrishikesh Deshpande [ hrishikesh.deshpande ] Venkatesh Pujari [ venkatesh.pujari ]
            Status LB Deployed [ 11600 ] In LB Testing [ 10200 ]
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi [~parmeshwar.jumbade],

            Verified this issue on Lb on For QA FDU Azure company. All the scenarios worked fine as per expectation. I have tested Individual Calculated rates and*Family rates for all children* (Only Child Enrollment Allow Flag - Yes) and Individual Calculated rates for Employee Only and Spouse Only plans. System displaying correct coverage and premium on Billing Summary Report. This is good to be deployed on Preprod.

            Sachin Hingole

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi [~parmeshwar.jumbade] , Verified this issue on Lb on For QA FDU Azure company. All the scenarios worked fine as per expectation. I have tested  Individual Calculated rates and*Family rates for all children* ( Only Child Enrollment Allow Flag - Yes ) and  Individual Calculated rates for Employee Only and Spouse Only plans. System displaying correct coverage and premium on Billing Summary Report. This is good to be deployed on Preprod. Sachin Hingole Thanks, Venkatesh
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status In LB Testing [ 10200 ] Ready for Pre-Prod [ 11615 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 124.25h [ 447300 ] 125.25h [ 450900 ]
            Worklog Id 112379 [ 112379 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 16/Apr/18 10:08 AM
            • Time Spent:
              1h
               
              <No comment>
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Status Ready for Pre-Prod [ 11615 ] Pre-Prod Deployed [ 11601 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Pre-Prod Deployed [ 11601 ] IN Pre-prod Testing [ 11500 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 20/Apr/18 12:46 AM
            • Time Spent:
              1h
               
              <No comment>
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi [~parmeshwar.jumbade],

            Verified this issue on AFI For Hspl company. All the scenarios worked fine as per expectation. I have tested Individual Calculated rates*and*Family rates for all children (Only Child Enrollment Allow Flag - Yes) and Individual Calculated rates for Employee Only and Spouse Only plans. System displaying correct coverage and premium on Billing Summary Report. This is good to be deployed on Prod.

            Sachin Hingole

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi [~parmeshwar.jumbade] , Verified this issue on AFI For Hspl company. All the scenarios worked fine as per expectation. I have tested  Individual Calculated rates*and*Family rates for all children ( Only Child Enrollment Allow Flag - Yes ) and  Individual Calculated rates for Employee Only and Spouse Only plans. System displaying correct coverage and premium on Billing Summary Report. This is good to be deployed on Prod. Sachin Hingole Thanks, Venkatesh
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status IN Pre-prod Testing [ 11500 ] Ready for Production [ 10024 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 125.25h [ 450900 ] 126.25h [ 454500 ]
            Worklog Id 113029 [ 113029 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Status Ready for Production [ 10024 ] Production Deployed [ 10025 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Production Deployed [ 10025 ] In Production Testing [ 10202 ]
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi [~parmeshwar.jumbade],

            Verified this issue on Production on AFI For Hspl company. All the scenarios worked fine as per expectation. I have tested Individual Calculated rates and Family rates for all children(Only Child Enrollment Allow Flag - Yes) and Individual Calculated rates for Employee Only and Spouse Only plans. System displaying correct coverage and premium on Billing Summary Report.

            Sachin Hingole

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi [~parmeshwar.jumbade] , Verified this issue on Production on AFI For Hspl company. All the scenarios worked fine as per expectation. I have tested  Individual Calculated rates and Family rates for all children ( Only Child Enrollment Allow Flag - Yes ) and  Individual Calculated rates for Employee Only and Spouse Only plans. System displaying correct coverage and premium on Billing Summary Report. Sachin Hingole Thanks, Venkatesh
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Resolution Bug Fixed [ 10402 ]
            Status In Production Testing [ 10202 ] In Production Review [ 11501 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status In Production Review [ 11501 ] Closed [ 6 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Link This issue relates to WB-762 [ WB-762 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Link This issue relates to WB-502 [ WB-502 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Root Cause Coding Error [ 19002 ]
            Transition Time In Source Status Execution Times
            Harshada Borole (Inactive) made transition -
            Open In Development
            34d 18h 51m 1
            Meghana Joshi (Inactive) made transition -
            In LB Testing Reopen in Local
            13d 6h 2m 1
            Gaurav Sodani (Inactive) made transition -
            Reopen in Local In Development
            2d 18h 9m 1
            Prasad Pise (Inactive) made transition -
            In Development In LB Testing
            264d 7h 58m 2
            Venkatesh Pujari (Inactive) made transition -
            In LB Testing In Development
            2d 21h 20m 1
            Ashwin Wankhede (Inactive) made transition -
            In Development LB Deployed
            23d 14h 1m 1
            Hrishikesh Deshpande (Inactive) made transition -
            LB Deployed In LB Testing
            20h 51m 1
            Venkatesh Pujari (Inactive) made transition -
            In LB Testing Ready for Pre-Prod
            3d 49m 1
            Khandu Kshirsagar (Inactive) made transition -
            Ready for Pre-Prod Pre-Prod Deployed
            2d 2h 36m 1
            Venkatesh Pujari (Inactive) made transition -
            Pre-Prod Deployed IN Pre-prod Testing
            1d 23h 52m 1
            Venkatesh Pujari (Inactive) made transition -
            IN Pre-prod Testing Ready for Production
            8m 44s 1
            Khandu Kshirsagar (Inactive) made transition -
            Ready for Production Production Deployed
            2d 21h 43m 1
            Venkatesh Pujari (Inactive) made transition -
            Production Deployed In Production Testing
            3h 33m 1
            Venkatesh Pujari (Inactive) made transition -
            In Production Testing In Production Review
            1h 9m 1
            Venkatesh Pujari (Inactive) made transition -
            In Production Review Closed
            4s 1

              People

              Assignee:
              venkatesh.pujari Venkatesh Pujari (Inactive)
              Reporter:
              surender.kumar surender kumar (Inactive)
              Developer:
              Parmeshwar Jumbad (Inactive)
              QA:
              Venkatesh Pujari (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:

                  Time Tracking

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