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

RCF - Data Audit- Duplicate Rates patterns for clients.

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Cannot Reproduce
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Environment:
      Production
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - Enrollment
    • Reported by:
      Harbinger
    • Company:
      All Clients/Multiple Clients
    • Item State:
      Development - On Hold
    • Issue Importance:
      Must Have

      Attachments

        Issue Links

          Activity

          amruta.lohiya Amruta Lohiya logged work - 13/Jul/17 10:12 PM
          • Time Spent:
            2h
             
            <No comment>
          avnish.yadav Avnish Yadav (Inactive) created issue -
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Field Original Value New Value
          Assignee Vijay Siddha [ vijays ] Avnish Yadav [ avnish.yadav ]
          Hide
          avnish.yadav Avnish Yadav (Inactive) added a comment -

          Company Name:- GBAPS

          Configuration:-
          Benefit Type :- Medical
          Plan Name:- Voluntary Vision
          Plan Termination Date Rule:- End of Month
          Child Age :- Greater then 26 year

          Scenario:-

          Enroll Employee in "Voluntary Vision" plan with EE+SP+CH Tier.
          Effective Date:- 01/01/2017
          Termination Date:- NUll

          Raised QE Effective Date:- 07/13/2017 and Terminate or Remove Child from Tier.

          After child termination Enrollment in "Voluntary Vision" plan:-
          Tier:- EE+SP+CH
          Effective Date :- 01/01/2017
          Termination Date :- 31/07/2017

          Health Tier:- EE+SP
          Effective Date :- 01/08/2017
          Termination Date :- NUll

          Now Run Eligiblity Service, After this please check enrollment rates.

          Show
          avnish.yadav Avnish Yadav (Inactive) added a comment - Company Name :- GBAPS Configuration:- Benefit Type :- Medical Plan Name:- Voluntary Vision Plan Termination Date Rule:- End of Month Child Age :- Greater then 26 year Scenario :- Enroll Employee in " Voluntary Vision " plan with EE+SP+CH Tier. Effective Date:- 01/01/2017 Termination Date:- NUll Raised QE Effective Date:- 07/13/2017 and Terminate or Remove Child from Tier. After child termination Enrollment in "Voluntary Vision" plan:- Tier:- EE+SP+CH Effective Date :- 01/01/2017 Termination Date :- 31/07/2017 Health Tier:- EE+SP Effective Date :- 01/08/2017 Termination Date :- NUll Now Run Eligiblity Service, After this please check enrollment rates.
          Hide
          avnish.yadav Avnish Yadav (Inactive) added a comment -

          Company Name:- City of Durham

          Employee Name:- JO CLAYTON
          Plan Name:- B. Retiree Basic Plan

          Scenario:-
          1. Rasied Qualifying Event "Active to Retired Status" (Effective Date:- 09/01/2017)
          2. Enroll Employee in "B. Retiree Basic Plan" with Health Tier :- Employee + Domestic Partner + Domestic Partners Children (EEDPDP2+CH)

          Enrollment Effective Date:- 09/01/2017
          Enrollment Termination Date:- NUll

          Enrollment Rates Effective Date:- 09/01/2017
          Enrollment Rates Termination Date:- 06/30/2018

          3. After Enrollment Change the Child Status "Domestic Partner Child" to "Natural child"

          Enrollment Rates Effective Date:- 09/01/2017
          Enrollment Rates Termination Date:- 06/30/2018

          Enrollment Rates Effective Date:- 09/01/2017
          Enrollment Rates Termination Date:- 06/30/2018

          Show
          avnish.yadav Avnish Yadav (Inactive) added a comment - Company Name :- City of Durham Employee Name:- JO CLAYTON Plan Name:- B. Retiree Basic Plan Scenario:- 1. Rasied Qualifying Event "Active to Retired Status" (Effective Date:- 09/01/2017) 2. Enroll Employee in "B. Retiree Basic Plan" with Health Tier :- Employee + Domestic Partner + Domestic Partners Children (EEDPDP2+CH) Enrollment Effective Date:- 09/01/2017 Enrollment Termination Date:- NUll Enrollment Rates Effective Date:- 09/01/2017 Enrollment Rates Termination Date:- 06/30/2018 3. After Enrollment Change the Child Status "Domestic Partner Child" to "Natural child" Enrollment Rates Effective Date:- 09/01/2017 Enrollment Rates Termination Date:- 06/30/2018 Enrollment Rates Effective Date:- 09/01/2017 Enrollment Rates Termination Date:- 06/30/2018
          Hide
          avnish.yadav Avnish Yadav (Inactive) added a comment -

          Hi Prasad Pise,

          Can you please reproduce above mentioned scenarios on Production for "GBAPS" and "City of Durham" clients.

          Thanks,
          Avnish Y

          CC-- Rakesh Roy,Amruta Lohiya,Satya,Vijay Siddha

          Show
          avnish.yadav Avnish Yadav (Inactive) added a comment - Hi Prasad Pise , Can you please reproduce above mentioned scenarios on Production for "GBAPS" and "City of Durham" clients. Thanks, Avnish Y CC-- Rakesh Roy , Amruta Lohiya , Satya , Vijay Siddha
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Assignee Avnish Yadav [ avnish.yadav ] Prasad Pise [ prasadp ]
          prasadp Prasad Pise (Inactive) made changes -
          Assignee Prasad Pise [ prasadp ] Alankar Chavan [ alankar.chavan ]
          amruta.lohiya Amruta Lohiya made changes -
          Remaining Estimate 0h [ 0 ]
          Time Spent 2h [ 7200 ]
          Worklog Id 63355 [ 63355 ]
          avnish.yadav Avnish Yadav (Inactive) logged work - 19/Jul/17 07:26 AM
          • Time Spent:
            8h
             
            <No comment>
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Link This issue relates to WT-2034 [ WT-2034 ]
          Hide
          prasadp Prasad Pise (Inactive) added a comment -

          Hi Alankar Chavan

          Could you please share your updates on this?

          CC: Rakesh RoyAmruta LohiyaSatyaVijay Siddha

          Show
          prasadp Prasad Pise (Inactive) added a comment - Hi Alankar Chavan Could you please share your updates on this? CC: Rakesh Roy Amruta Lohiya Satya Vijay Siddha
          avnish.yadav Avnish Yadav (Inactive) logged work - 20/Jul/17 07:27 AM
          • Time Spent:
            8h
             
            <No comment>
          alankar.chavan Alankar Chavan (Inactive) made changes -
          Attachment Stage Worked Well.png [ 56193 ]
          Hide
          alankar.chavan Alankar Chavan (Inactive) added a comment -

          Hello,

          We tried reproducing this issue on Stage City of Durham for HSPL (mentioned in the second comment above) - System behaved in an expected way though

          • an employee was enrolled in a Medical plan with Tier EE + Domestic SP + Domestic CH from 03/01/2017 (cost for this tier in associated rate was 20 monthly)
          • effective from 09/01/2017, we changed Child's status as Natural Child from Child Form (cost in an associated rate for EE + Domestic SP + Natural CH is 30)

          As shown in the screenshot, there were two entries in the rate changes log table, one for 03/01/2017 to 08/31/2017 (20$) & another for 09/01/2017 to 12/31/2017 (30$)

          We should try this through Import end once to ensure that the system behaves in an expected manner through import too

          CC - Satya Rakesh Roy Prasad Pise Vijay Siddha Amruta Lohiya Avnish Yadav

          Show
          alankar.chavan Alankar Chavan (Inactive) added a comment - Hello, We tried reproducing this issue on Stage City of Durham for HSPL (mentioned in the second comment above) - System behaved in an expected way though an employee was enrolled in a Medical plan with Tier EE + Domestic SP + Domestic CH from 03/01/2017 (cost for this tier in associated rate was 20 monthly) effective from 09/01/2017, we changed Child's status as Natural Child from Child Form (cost in an associated rate for EE + Domestic SP + Natural CH is 30) As shown in the screenshot, there were two entries in the rate changes log table, one for 03/01/2017 to 08/31/2017 (20$) & another for 09/01/2017 to 12/31/2017 (30$) We should try this through Import end once to ensure that the system behaves in an expected manner through import too CC - Satya Rakesh Roy Prasad Pise Vijay Siddha Amruta Lohiya Avnish Yadav
          alankar.chavan Alankar Chavan (Inactive) made changes -
          Assignee Alankar Chavan [ alankar.chavan ] Prasad Pise [ prasadp ]
          alankar.chavan Alankar Chavan (Inactive) logged work - 20/Jul/17 12:47 PM
          • Time Spent:
            3h
             

            tried reproducing
            comments

          alankar.chavan Alankar Chavan (Inactive) made changes -
          Time Spent 2h [ 7200 ] 5h [ 18000 ]
          Worklog Id 65057 [ 65057 ]
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Summary Data Audit- Duplicate Rates patterns for clients. RCF - Data Audit- Duplicate Rates patterns for clients.
          prasadp Prasad Pise (Inactive) made changes -
          Assignee Prasad Pise [ prasadp ] Avnish Yadav [ avnish.yadav ]
          avnish.yadav Avnish Yadav (Inactive) logged work - 21/Jul/17 07:27 AM
          • Time Spent:
            8h
             
            <No comment>
          avnish.yadav Avnish Yadav (Inactive) logged work - 24/Jul/17 07:31 AM
          • Time Spent:
            8h
             
            <No comment>
          avnish.yadav Avnish Yadav (Inactive) logged work - 25/Jul/17 07:32 AM
          • Time Spent:
            8h
             
            <No comment>
          avnish.yadav Avnish Yadav (Inactive) logged work - 27/Jul/17 07:36 AM
          • Time Spent:
            8h
             
            <No comment>
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Time Spent 5h [ 18000 ] 13h [ 46800 ]
          Worklog Id 68107 [ 68107 ]
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Time Spent 13h [ 46800 ] 21h [ 75600 ]
          Worklog Id 68109 [ 68109 ]
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Time Spent 21h [ 75600 ] 29h [ 104400 ]
          Worklog Id 68110 [ 68110 ]
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Time Spent 29h [ 104400 ] 37h [ 133200 ]
          Worklog Id 68112 [ 68112 ]
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Time Spent 37h [ 133200 ] 45h [ 162000 ]
          Worklog Id 68113 [ 68113 ]
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Time Spent 45h [ 162000 ] 53h [ 190800 ]
          Worklog Id 68115 [ 68115 ]
          Prashant.samal Prashant Samal (Inactive) made changes -
          Time Spent 53h [ 190800 ] 54.5h [ 196200 ]
          Worklog Id 68366 [ 68366 ]
          Prashant.samal Prashant Samal (Inactive) logged work - 31/Jul/17 01:06 PM
          • Time Spent:
            1.5h
             

            Review of RCF Documents prepared by Kanchan

            Terminated Employees Election Active and

            Rates Beyond End Date

            Discussion of the scenarios and Review

          avnish.yadav Avnish Yadav (Inactive) made changes -
          Dev Due Date 10/Aug/2017
          Original Estimate 0h [ 0 ]
          avnish.yadav Avnish Yadav (Inactive) logged work - 08/Aug/17 04:54 PM
          • Time Spent:
            8h
             
            <No comment>
          avnish.yadav Avnish Yadav (Inactive) logged work - 09/Aug/17 04:54 PM
          • Time Spent:
            8h
             
            <No comment>
          avnish.yadav Avnish Yadav (Inactive) logged work - 10/Aug/17 04:55 PM
          • Time Spent:
            8h
             
            <No comment>
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Time Spent 54.5h [ 196200 ] 62.5h [ 225000 ]
          Worklog Id 74288 [ 74288 ]
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Time Spent 62.5h [ 225000 ] 70.5h [ 253800 ]
          Worklog Id 74290 [ 74290 ]
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Time Spent 70.5h [ 253800 ] 78.5h [ 282600 ]
          Worklog Id 74291 [ 74291 ]
          Hide
          avnish.yadav Avnish Yadav (Inactive) added a comment -

          Hi Prasad Pise,

          We have verified this issue import side but this issue is not from Import. Can you please verify this again.

          Thanks,
          Avnish Y

          Show
          avnish.yadav Avnish Yadav (Inactive) added a comment - Hi Prasad Pise , We have verified this issue import side but this issue is not from Import. Can you please verify this again. Thanks, Avnish Y
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Assignee Avnish Yadav [ avnish.yadav ] Prasad Pise [ prasadp ]
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Status In Progress [ 3 ] Dev Analysis [ 10016 ]
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Resolution Unresolved [ 10200 ]
          Status Dev Analysis [ 10016 ] Resolved [ 5 ]
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Resolution Unresolved [ 10200 ]
          Status Resolved [ 5 ] Reopened [ 4 ]
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Assignee Prasad Pise [ prasadp ] Avnish Yadav [ avnish.yadav ]
          Status Reopened [ 4 ] In Progress [ 3 ]
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Issue Type Support Activity [ 10301 ] Bug [ 1 ]
          Status In Progress [ 3 ] Open [ 1 ]
          Support Task Type Data Correction [ 11203 ]
          Workflow WT_Support [ 46899 ] WT_Defects [ 50606 ]
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Status Open [ 1 ] In Development [ 10007 ]
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Assignee Avnish Yadav [ avnish.yadav ] Prasad Pise [ prasadp ]
          Hide
          prasadp Prasad Pise (Inactive) added a comment -
          Show
          prasadp Prasad Pise (Inactive) added a comment - Hrishikesh Deshpande
          prasadp Prasad Pise (Inactive) made changes -
          Assignee Prasad Pise [ prasadp ] Rashmita Dudhe [ rashmita.dudhe ]
          Hide
          avnish.yadav Avnish Yadav (Inactive) added a comment -

          Hi Rashmita Dudhe,

          Could you please provide update on this.

          Thanks,
          Avnish Y

          CC-- Hrishikesh Deshpande,Prasad Pise,Rakesh Roy,Satya,Vijay Siddha

          Show
          avnish.yadav Avnish Yadav (Inactive) added a comment - Hi Rashmita Dudhe , Could you please provide update on this. Thanks, Avnish Y CC-- Hrishikesh Deshpande , Prasad Pise , Rakesh Roy , Satya , Vijay Siddha
          rashmita.dudhe Rashmita Dudhe (Inactive) logged work - 05/Oct/17 02:42 AM
          • Time Spent:
            2h
             

            Scenario verification

          rashmita.dudhe Rashmita Dudhe (Inactive) logged work - 05/Oct/17 06:02 AM - edited
          • Time Spent:
            1.5h
             
            <No comment>
          rashmita.dudhe Rashmita Dudhe (Inactive) logged work - 06/Oct/17 03:06 AM
          • Time Spent:
            1.5h
             

            try to repro issue

          Hide
          rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

          Hi Avnish Yadav,

          CC:Hrishikesh Deshpande,Rakesh Roy,Satya,Jyoti Mayne

          I have verified this issue but it is not getting reproduced tried below scenarios:

          Company Name:- City of Durham for hspl
          Employee Name:- JO CLAYTON
          Plan Name:- B. Retiree Basic Plan

          1]Add new employee and add there dependent
          2]Raised QE event Active to Retired Status with Effective date 09/01/2017 enrolled in B. Retiree Basic Plan with Employee + Domestic Partner + Domestic Partners Children

          cross verified through backend employee getting the correct rate

          Enrollment Effective Date:- 09/01/2017
          Enrollment Termination Date:- NUll

          Enrollment Rates Effective Date:- 09/01/2017
          Enrollment Rates Termination Date:- 06/30/2018

          3]Change child status as "Domestic Partner Child" to "Natural child"

          4]again check rate Enrollment Rates Effective Date:- 09/01/2017
          Enrollment Rates Termination Date:- 06/30/2018

          5]Change both of child staus as "Domestic Partner Child" to "Natural child"

          6]Change child staus through import as "Domestic Partner Child" to "Natural child"

          7]drop one child and check for new Election showing proper rate

          8]Verfied through Eligibility Service also

          above all scenarios, it showing proper rate.

          Thanks,
          Rashmita

          Show
          rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Hi Avnish Yadav , CC: Hrishikesh Deshpande , Rakesh Roy , Satya , Jyoti Mayne I have verified this issue but it is not getting reproduced tried below scenarios: Company Name:- City of Durham for hspl Employee Name:- JO CLAYTON Plan Name:- B. Retiree Basic Plan 1]Add new employee and add there dependent 2]Raised QE event Active to Retired Status with Effective date 09/01/2017 enrolled in B. Retiree Basic Plan with Employee + Domestic Partner + Domestic Partners Children cross verified through backend employee getting the correct rate Enrollment Effective Date:- 09/01/2017 Enrollment Termination Date:- NUll Enrollment Rates Effective Date:- 09/01/2017 Enrollment Rates Termination Date:- 06/30/2018 3]Change child status as "Domestic Partner Child" to "Natural child" 4]again check rate Enrollment Rates Effective Date:- 09/01/2017 Enrollment Rates Termination Date:- 06/30/2018 5]Change both of child staus as "Domestic Partner Child" to "Natural child" 6]Change child staus through import as "Domestic Partner Child" to "Natural child" 7]drop one child and check for new Election showing proper rate 8]Verfied through Eligibility Service also above all scenarios, it showing proper rate. Thanks, Rashmita
          rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
          Time Spent 78.5h [ 282600 ] 81.5h [ 293400 ]
          Worklog Id 83529 [ 83529 ]
          rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
          Assignee Rashmita Dudhe [ rashmita.dudhe ] Avnish Yadav [ avnish.yadav ]
          rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
          Time Spent 81.5h [ 293400 ] 83.5h [ 300600 ]
          Worklog Id 84646 [ 84646 ]
          rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
          Remaining Estimate 0h [ 0 ] 1.5h [ 5400 ]
          Time Spent 83.5h [ 300600 ] 82h [ 295200 ]
          Worklog Id 83529 [ 83529 ]
          rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
          Remaining Estimate 1.5h [ 5400 ] 0h [ 0 ]
          Time Spent 82h [ 295200 ] 83.5h [ 300600 ]
          Worklog Id 84651 [ 84651 ]
          jyoti.mayne Jyoti Mayne made changes -
          Labels Rate_Calculation
          satyap Satya made changes -
          Environment_New Production [ 18442 ]
          jyoti.mayne Jyoti Mayne made changes -
          Company All Clients/Multiple Clients [ 18434 ]
          Item State Parent values: Development(10200)Level 1 values: On Hold(10207)
          Hide
          avnish.yadav Avnish Yadav (Inactive) added a comment -

          Hi Rashmita Dudhe,

          We have also tried all possible scenario to reproduce this issue but we are unable to reproduce this.

          So we are closing this ticket. We will reopen this ticket once client face this issue again.

          Thanks,
          Avnish Y

          CC-- Amruta Lohiya

          Show
          avnish.yadav Avnish Yadav (Inactive) added a comment - Hi Rashmita Dudhe , We have also tried all possible scenario to reproduce this issue but we are unable to reproduce this. So we are closing this ticket. We will reopen this ticket once client face this issue again. Thanks, Avnish Y CC-- Amruta Lohiya
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Resolution Cannot Reproduce [ 5 ]
          Status In Development [ 10007 ] Rejected [ 10004 ]
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Status Rejected [ 10004 ] Closed [ 6 ]
          Transition Time In Source Status Execution Times
          Avnish Yadav (Inactive) made transition -
          Open In Progress
          18m 16s 1
          Avnish Yadav (Inactive) made transition -
          In Progress Dev Analysis
          46d 23h 58m 1
          Avnish Yadav (Inactive) made transition -
          Dev Analysis Resolved
          2m 37s 1
          Avnish Yadav (Inactive) made transition -
          Resolved Reopen
          6s 1
          Avnish Yadav (Inactive) made transition -
          Reopen In Progress
          3s 1
          Avnish Yadav (Inactive) made transition -
          In Progress Open
          2h 53m 1
          Avnish Yadav (Inactive) made transition -
          Open In Development
          7s 1
          Avnish Yadav (Inactive) made transition -
          In Development Rejected
          121d 41m 1
          Avnish Yadav (Inactive) made transition -
          Rejected Closed
          3s 1

            People

            Assignee:
            avnish.yadav Avnish Yadav (Inactive)
            Reporter:
            avnish.yadav Avnish Yadav (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 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 - 83.5h
                83.5h