WORKTERRAProject Type: software

WORKTERRA

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

Need to move dead enrollments through effective date service

    Details

    • Type: Change Request
    • Status: Closed
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Module:
      BenAdmin - Enrollment
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Must Have
    • Sprint:
      WT Sprint 29
    • Severity:
      Simple

      Description

        Attachments

        1. after service run 1.png
          after service run 1.png
          94 kB
        2. after service run 2.png
          after service run 2.png
          106 kB
        3. before service run.png
          before service run.png
          97 kB
        4. before service run.png
          before service run.png
          97 kB
        5. Checklist_for_WT_8417.doc
          26 kB
        6. WT_8417_Affected Files.txt
          0.3 kB
        7. WT_8417_Change_Request_Implementation.doc
          20 kB
        8. WT_8417_Data_Scanned.xls
          43 kB

          Issue Links

          relates to

          Change Request - Change Request WT-7604 Server Error while exporting Group Template Name CAISO_CEREDIAN

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

          Bug - A problem which impairs or prevents the functions of the product. WT-8172 Billing - Need to avoid double insertion in Billing when record is moved by effective date service

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

          Bug - A problem which impairs or prevents the functions of the product. WT-10291 METSO - Liberty Mutual Leave 3000 file

          • Critical - This problem will block progress.
          • Production Complete

          Support Activity - Support Activity WT-10315 LHP UHC Vision 834 5010

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

          Support Activity - Support Activity WT-10318 Groendyke - BCBSOK - Old terms in 7/20/2017 export file

          • Medium - Has the potential to affect progress.
          • Closed

            Activity

            Ascending order - Click to sort in descending order
            rajendra.pawar Rajendra Pawar (Inactive) created issue -
            rajendra.pawar Rajendra Pawar (Inactive) made changes -
            Field Original Value New Value
            Link This issue relates to WT-7604 [ WT-7604 ]
            satyap Satya made changes -
            Sprint Enhancements: March-June 2017 [ 48 ]
            jyoti.mayne Jyoti Mayne made changes -
            Developer Rohit Shete [ rohit.shete ]
            jyoti.mayne Jyoti Mayne made changes -
            Assignee Jyoti Mayne [ jyoti.mayne ] Rohit Shete [ rohit.shete ]
            Permalink
            rohit.shete Rohit Shete (Inactive) logged work - 04/May/17 11:15 AM - edited
            • Time Spent:
              1h
               

              Code Analysis And Task related Discussion with umesh

            Permalink
            umesh.kadam Umesh Kadam (Inactive) logged work - 04/May/17 04:30 PM
            • Time Spent:
              0.5h
               

              Issue discussion and Scenario Discussion with Rohit

            Permalink
            jyoti.mayne Jyoti Mayne logged work - 04/May/17 05:13 PM
            • Time Spent:
              0.25h
               

              scenario discussion with Umesh

            jyoti.mayne Jyoti Mayne made changes -
            Remaining Estimate 50h [ 180000 ]
            Original Estimate 50h [ 180000 ]
            jyoti.mayne Jyoti Mayne made changes -
            Remaining Estimate 50h [ 180000 ] 49.75h [ 179100 ]
            Time Spent 0.25h [ 900 ]
            Worklog Id 43286 [ 43286 ]
            umesh.kadam Umesh Kadam (Inactive) made changes -
            Remaining Estimate 49.75h [ 179100 ] 49.25h [ 177300 ]
            Time Spent 0.25h [ 900 ] 0.75h [ 2700 ]
            Worklog Id 43305 [ 43305 ]
            Permalink
            jyoti.mayne Jyoti Mayne logged work - 05/May/17 09:05 AM
            • Time Spent:
              0.25h
               

              scenario explanation to Umesh

            rohit.shete Rohit Shete (Inactive) made changes -
            Remaining Estimate 49.25h [ 177300 ] 48.25h [ 173700 ]
            Time Spent 0.75h [ 2700 ] 1.75h [ 6300 ]
            Worklog Id 43359 [ 43359 ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Worklog Id 43359 [ 43359 ]
            satyap Satya made changes -
            Sprint Enhancements: March-June 2017 [ 48 ] WT Sprint 29 [ 62 ]
            Permalink
            jyoti.mayne Jyoti Mayne logged work - 09/May/17 08:25 AM
            • Time Spent:
              0.5h
               

              scenario explanation to Shailendra and code debugging for adding dead condition in SP

            rohit.shete Rohit Shete (Inactive) made changes -
            Dev Due Date 12/May/2017
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
            rohit.shete Rohit Shete (Inactive) made changes -
            Assignee Rohit Shete [ rohit.shete ] Shailendra Honrao [ shailendra.honrao ]
            Permalink
            shailendra.honrao Shailendra Honrao (Inactive) logged work - 10/May/17 12:52 PM
            • Time Spent:
              7h
               
              <No comment>
            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Remaining Estimate 48.25h [ 173700 ] 41.25h [ 148500 ]
            Time Spent 1.75h [ 6300 ] 8.75h [ 31500 ]
            Worklog Id 44443 [ 44443 ]
            jyoti.mayne Jyoti Mayne made changes -
            Developer Rohit Shete [ rohit.shete ] Shailendra Honrao [ shailendra.honrao ]
            Permalink
            shailendra.honrao Shailendra Honrao (Inactive) logged work - 11/May/17 12:26 PM
            • Time Spent:
              8h
               
              <No comment>
            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Remaining Estimate 41.25h [ 148500 ] 33.25h [ 119700 ]
            Time Spent 8.75h [ 31500 ] 16.75h [ 60300 ]
            Worklog Id 44794 [ 44794 ]
            Permalink
            jyoti.mayne Jyoti Mayne logged work - 12/May/17 07:46 AM
            • Time Spent:
              0.5h
               

              code debugging with Shailendra and discussion

            Permalink
            shailendra.honrao Shailendra Honrao (Inactive) logged work - 12/May/17 12:57 PM
            • Time Spent:
              8h
               
              <No comment>
            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Remaining Estimate 33.25h [ 119700 ] 25.25h [ 90900 ]
            Time Spent 16.75h [ 60300 ] 24.75h [ 89100 ]
            Worklog Id 45248 [ 45248 ]
            jyoti.mayne Jyoti Mayne made changes -
            Remaining Estimate 25.25h [ 90900 ] 24.75h [ 89100 ]
            Time Spent 24.75h [ 89100 ] 25.25h [ 90900 ]
            Worklog Id 45348 [ 45348 ]
            jyoti.mayne Jyoti Mayne made changes -
            Remaining Estimate 24.75h [ 89100 ] 24.25h [ 87300 ]
            Time Spent 25.25h [ 90900 ] 25.75h [ 92700 ]
            Worklog Id 45373 [ 45373 ]
            jyoti.mayne Jyoti Mayne made changes -
            Remaining Estimate 24.25h [ 87300 ] 24h [ 86400 ]
            Time Spent 25.75h [ 92700 ] 26h [ 93600 ]
            Worklog Id 45402 [ 45402 ]
            Permalink
            shailendra.honrao Shailendra Honrao (Inactive) logged work - 15/May/17 07:03 AM
            • Time Spent:
              8h
               
              <No comment>
            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Status New Request [ 10029 ] Product Backlog [ 10100 ]
            Permalink
            umesh.kadam Umesh Kadam (Inactive) logged work - 15/May/17 04:30 PM
            • Time Spent:
              1h
               

              Discussion with Shailendra

            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Remaining Estimate 24h [ 86400 ] 16h [ 57600 ]
            Time Spent 26h [ 93600 ] 34h [ 122400 ]
            Worklog Id 45786 [ 45786 ]
            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Worklog Id 45786 [ 45786 ]
            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Remaining Estimate 16h [ 57600 ] 24h [ 86400 ]
            Time Spent 34h [ 122400 ] 26h [ 93600 ]
            Worklog Id 45786 [ 45786 ]
            Worklog Time Spent 8h [ 28800 ]
            umesh.kadam Umesh Kadam (Inactive) made changes -
            Status Product Backlog [ 10100 ] Pending for Approval [ 10002 ]
            umesh.kadam Umesh Kadam (Inactive) made changes -
            Status Pending for Approval [ 10002 ] Approved for Development [ 10003 ]
            umesh.kadam Umesh Kadam (Inactive) made changes -
            Status Approved for Development [ 10003 ] In Development [ 10007 ]
            umesh.kadam Umesh Kadam (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Remaining Estimate 24h [ 86400 ] 16h [ 57600 ]
            Time Spent 26h [ 93600 ] 34h [ 122400 ]
            Worklog Id 45791 [ 45791 ]
            Permalink
            shailendra.honrao Shailendra Honrao (Inactive) logged work - 16/May/17 01:47 PM
            • Time Spent:
              5h
               
              <No comment>
            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Remaining Estimate 16h [ 57600 ] 11h [ 39600 ]
            Time Spent 34h [ 122400 ] 39h [ 140400 ]
            Worklog Id 46142 [ 46142 ]
            Permalink
            umesh.kadam Umesh Kadam (Inactive) logged work - 16/May/17 04:30 PM
            • Time Spent:
              1h
               

              Scenario discussion with Shailendra

            Permalink
            shailendra.honrao Shailendra Honrao (Inactive) logged work - 17/May/17 12:46 PM
            • Time Spent:
              1h
               
              <No comment>
            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Remaining Estimate 11h [ 39600 ] 10h [ 36000 ]
            Time Spent 39h [ 140400 ] 40h [ 144000 ]
            Worklog Id 46437 [ 46437 ]
            Permalink
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 17/May/17 02:28 PM
            • Time Spent:
              0.5h
               
              <No comment>
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Remaining Estimate 10h [ 36000 ] 9.5h [ 34200 ]
            Time Spent 40h [ 144000 ] 40.5h [ 145800 ]
            Worklog Id 46492 [ 46492 ]
            Permalink
            umesh.kadam Umesh Kadam (Inactive) logged work - 17/May/17 04:30 PM
            • Time Spent:
              2h
               

              Discussion with team for legacy data and action items for it
              Scanning of data in active companies on production

            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 17/May/17 07:30 PM
            • Time Spent:
              0.5h
               

              Discussion on: move dead enrollments through effective date service

            umesh.kadam Umesh Kadam (Inactive) made changes -
            Remaining Estimate 9.5h [ 34200 ] 8.5h [ 30600 ]
            Time Spent 40.5h [ 145800 ] 41.5h [ 149400 ]
            Worklog Id 46502 [ 46502 ]
            umesh.kadam Umesh Kadam (Inactive) made changes -
            Remaining Estimate 8.5h [ 30600 ] 6.5h [ 23400 ]
            Time Spent 41.5h [ 149400 ] 43.5h [ 156600 ]
            Worklog Id 46503 [ 46503 ]
            umesh.kadam Umesh Kadam (Inactive) made changes -
            Remaining Estimate 6.5h [ 23400 ] 5.5h [ 19800 ]
            Time Spent 43.5h [ 156600 ] 44.5h [ 160200 ]
            Worklog Id 46504 [ 46504 ]
            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Code Review Date 17/May/2017
            Code Reviewed By Umesh Kadam [ 15302 ]
            Hide
            Permalink
            umesh.kadam Umesh Kadam (Inactive) added a comment -

            Hi,

            As discussed, following are the further action items of this change request.

            1. Scan existing data in production for dead and waived enrollments
            2. Remove dead and waived enrollments before and of year 2015 (2016 and onward records will be move by Effective Date service)
            3. Coding :
            • Make sure new IDs of dead enrollments are getting reflected for Rate Change Log and Billing details
            • As Nandkumar Prabhakar Karlekar mentioned, make sure Termination date of Enrollments and Rate change logs are moving properly (check for Billing details as well)

            Thanks and Regards,
            :: Umesh Kadam

            CC : Satya, Nandkumar Prabhakar Karlekar, Amruta Lohiya, Jaideep Vinchurkar, Prasanna Karlekar, Vinayak Kulkarni, Jyoti Mayne, Shailendra Honrao

            Show
            umesh.kadam Umesh Kadam (Inactive) added a comment - Hi, As discussed, following are the further action items of this change request. Scan existing data in production for dead and waived enrollments Remove dead and waived enrollments before and of year 2015 (2016 and onward records will be move by Effective Date service) Coding : Make sure new IDs of dead enrollments are getting reflected for Rate Change Log and Billing details As Nandkumar Prabhakar Karlekar mentioned, make sure Termination date of Enrollments and Rate change logs are moving properly (check for Billing details as well) Thanks and Regards, :: Umesh Kadam CC : Satya , Nandkumar Prabhakar Karlekar , Amruta Lohiya , Jaideep Vinchurkar , Prasanna Karlekar , Vinayak Kulkarni , Jyoti Mayne , Shailendra Honrao
            umesh.kadam Umesh Kadam (Inactive) made changes -
            Attachment WT_8417_Data_Scanned.xls [ 48735 ]
            Hide
            Permalink
            umesh.kadam Umesh Kadam (Inactive) added a comment -

            Please find attached WT_8417_Data_Scanned.xls for data scanning of dead enrollments on Production.

            Show
            umesh.kadam Umesh Kadam (Inactive) added a comment - Please find attached WT_8417_Data_Scanned.xls for data scanning of dead enrollments on Production.
            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Dev Due Date 12/May/2017
            jyoti.mayne Jyoti Mayne made changes -
            Dev Due Date 23/May/2017
            Permalink
            shailendra.honrao Shailendra Honrao (Inactive) logged work - 22/May/17 12:55 PM
            • Time Spent:
              0.5h
               
              <No comment>
            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Remaining Estimate 5.5h [ 19800 ] 5h [ 18000 ]
            Time Spent 44.5h [ 160200 ] 45h [ 162000 ]
            Worklog Id 47745 [ 47745 ]
            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)
            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Attachment WT_8417_Affected Files.txt [ 48822 ]
            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Attachment Checklist_for_WT_8417.doc [ 48823 ]
            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Assignee Shailendra Honrao [ shailendra.honrao ] Hrishikesh Deshpande [ hrishikesh.deshpande ]
            Hide
            Permalink
            shailendra.honrao Shailendra Honrao (Inactive) added a comment -

            cc:Alankar Chavan, Prasad Pise

            Show
            shailendra.honrao Shailendra Honrao (Inactive) added a comment - cc: Alankar Chavan , Prasad Pise
            prasadp Prasad Pise (Inactive) made changes -
            Assignee Hrishikesh Deshpande [ hrishikesh.deshpande ] Alankar Chavan [ alankar.chavan ]
            umesh.kadam Umesh Kadam (Inactive) made changes -
            Attachment WT_8417_Change_Request_Implementation.doc [ 49100 ]
            Hide
            Permalink
            umesh.kadam Umesh Kadam (Inactive) added a comment -

            Please find attached WT_8417_Change_Request_Implementation.doc analysis document for the change request.

            Show
            umesh.kadam Umesh Kadam (Inactive) added a comment - Please find attached WT_8417_Change_Request_Implementation.doc analysis document for the change request.
            umesh.kadam Umesh Kadam (Inactive) made changes -
            Remaining Estimate 5h [ 18000 ] 4.25h [ 15300 ]
            Time Spent 45h [ 162000 ] 45.75h [ 164700 ]
            Worklog Id 48307 [ 48307 ]
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Attachment before service run.png [ 49171 ]
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Attachment after service run 1.png [ 49173 ]
            Attachment after service run 2.png [ 49174 ]
            Attachment before service run.png [ 49175 ]
            Hide
            Permalink
            alankar.chavan Alankar Chavan (Inactive) added a comment -

            We tested this on WT Stage - LONG COMPANY
            (tested with LIFE as well as Health Plan)

            *Scenarios *

            • Enrolled an employee in plan with future effective date
            • Changed the Effective Date to the Current Date (so as Effective Date Service will pick this record to move in the Current Enrollments, Coverage & Rate Changes Log tables)
            • Also changed the Termination Date to the date which is lesser that the Effective Date above - to make these future elections as Dead Elections
            • Executed the Effective Date Service

            Expected and Actual Result : the Dead Election Entries from employee_enrollment_intermediate, Employee_Enrollment_Coverage_intermediate & RateChanges_Log_Intermediate moved to employee_enrollment, Employee_Enrollment_Coverage & RateChanges_Log

            CC - Shailendra Honrao Jyoti Mayne Umesh Kadam Prasad Pise Sachin Hingole Hrishikesh Deshpande Rakesh Roy

            This is ready for Stage

            Show
            alankar.chavan Alankar Chavan (Inactive) added a comment - We tested this on WT Stage - LONG COMPANY (tested with LIFE as well as Health Plan) *Scenarios * Enrolled an employee in plan with future effective date Changed the Effective Date to the Current Date (so as Effective Date Service will pick this record to move in the Current Enrollments, Coverage & Rate Changes Log tables) Also changed the Termination Date to the date which is lesser that the Effective Date above - to make these future elections as Dead Elections Executed the Effective Date Service Expected and Actual Result : the Dead Election Entries from employee_enrollment_intermediate, Employee_Enrollment_Coverage_intermediate & RateChanges_Log_Intermediate moved to employee_enrollment, Employee_Enrollment_Coverage & RateChanges_Log CC - Shailendra Honrao Jyoti Mayne Umesh Kadam Prasad Pise Sachin Hingole Hrishikesh Deshpande Rakesh Roy This is ready for Stage
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Status Local Testing [ 10200 ] Pending for Stage Approval [ 10300 ]
            Permalink
            alankar.chavan Alankar Chavan (Inactive) logged work - 24/May/17 01:35 PM
            • Time Spent:
              6h
               

              analysis
              discussion
              lb testing
              ready for stage

            alankar.chavan Alankar Chavan (Inactive) made changes -
            Remaining Estimate 4.25h [ 15300 ] 0h [ 0 ]
            Time Spent 45.75h [ 164700 ] 51.75h [ 186300 ]
            Worklog Id 48502 [ 48502 ]
            Permalink
            umesh.kadam Umesh Kadam (Inactive) logged work - 24/May/17 04:30 PM
            • Time Spent:
              0.75h
               

              Prepared analysis document

            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 51.75h [ 186300 ] 52.25h [ 188100 ]
            Worklog Id 49088 [ 49088 ]
            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 26/May/17 11:30 PM
            • Time Spent:
              1h
               

              Go through of code changes done and analysis of impact on Billing

            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 52.25h [ 188100 ] 53.25h [ 191700 ]
            Worklog Id 49621 [ 49621 ]
            Hide
            Permalink
            alankar.chavan Alankar Chavan (Inactive) added a comment -

            Can not test this on Stage right now - as the stage services are still running over companies.
            I will try testing this tomorrow (31st May 2017) morning before services start running

            CC - Prasad Pise Rakesh Roy

            Show
            alankar.chavan Alankar Chavan (Inactive) added a comment - Can not test this on Stage right now - as the stage services are still running over companies. I will try testing this tomorrow (31st May 2017) morning before services start running CC - Prasad Pise Rakesh Roy
            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 30/May/17 07:45 PM
            • Time Spent:
              0.25h
               

              Discussion on condition to pick the enrollmentID from main enrollment table while moving dead election getting moved from Intermediate to Main

            Hide
            Permalink
            alankar.chavan Alankar Chavan (Inactive) added a comment -

            This is tested on Stage - Working well

            Ready for Production

            CC - Prasad Pise Sachin Hingole Hrishikesh Deshpande Rakesh Roy

            Show
            alankar.chavan Alankar Chavan (Inactive) added a comment - This is tested on Stage - Working well Ready for Production CC - Prasad Pise Sachin Hingole Hrishikesh Deshpande Rakesh Roy
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Status Pending for Stage Approval [ 10300 ] Approved for Stage [ 10030 ]
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Status Approved for Stage [ 10030 ] Stage Testing [ 10201 ]
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 53.25h [ 191700 ] 53.5h [ 192600 ]
            Worklog Id 51124 [ 51124 ]
            Permalink
            alankar.chavan Alankar Chavan (Inactive) logged work - 31/May/17 01:25 PM
            • Time Spent:
              1.5h
               

              stage testing

            alankar.chavan Alankar Chavan (Inactive) made changes -
            Time Spent 53.5h [ 192600 ] 55h [ 198000 ]
            Worklog Id 51244 [ 51244 ]
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Production Due Date 13/Jun/2017
            Hide
            Permalink
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

            There are two dependent tickets for change, which must move along with this ticket.

            1] For export WT-7604, ready for stage.

            Prasanna Karlekar I believe there are some changes on your side as well, can you link that jira to this so that we can track all three tickets together.

            Show
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - There are two dependent tickets for change, which must move along with this ticket. 1] For export WT-7604 , ready for stage. Prasanna Karlekar I believe there are some changes on your side as well, can you link that jira to this so that we can track all three tickets together.
            prasanna Prasanna Karlekar (Inactive) made changes -
            Link This issue relates to WT-8172 [ WT-8172 ]
            Hide
            Permalink
            prasanna Prasanna Karlekar (Inactive) added a comment -

            Hi Vinayak Kulkarni / Umesh Kadam,

            For reports, have linked WT-8172. This will get deployed on LB today i.e. 15-Jun-2017.

            Thank you!

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - Hi Vinayak Kulkarni / Umesh Kadam , For reports, have linked WT-8172 . This will get deployed on LB today i.e. 15-Jun-2017. Thank you!
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Stage QA(10202)Level 1 values: On Hold(10215)
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: On Hold(10215) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
            umesh.kadam Umesh Kadam (Inactive) made changes -
            Time Spent 55h [ 198000 ] 59h [ 212400 ]
            Worklog Id 63963 [ 63963 ]
            Permalink
            jyoti.mayne Jyoti Mayne logged work - 17/Jul/17 03:41 PM
            • Time Spent:
              0.5h
               

              script review and discussion

            jyoti.mayne Jyoti Mayne made changes -
            Time Spent 59h [ 212400 ] 59.5h [ 214200 ]
            Worklog Id 64082 [ 64082 ]
            Permalink
            umesh.kadam Umesh Kadam (Inactive) logged work - 17/Jul/17 04:30 PM
            • Time Spent:
              4h
               

              Data correction for dead enrollments in _Intermediate tables having effective date before year 2016
              Data verification

            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
            Hide
            Permalink
            alankar.chavan Alankar Chavan (Inactive) added a comment -

            Mentioned scenarios tested on Production - Worked as per the expectations

            CC - Sachin Hingole Prasad Pise Hrishikesh Deshpande Rakesh Roy

            Show
            alankar.chavan Alankar Chavan (Inactive) added a comment - Mentioned scenarios tested on Production - Worked as per the expectations CC - Sachin Hingole Prasad Pise Hrishikesh Deshpande Rakesh Roy
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Status Stage Testing [ 10201 ] Pending for Production Approval [ 10301 ]
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Status Pending for Production Approval [ 10301 ] Approved for production [ 10034 ]
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Status Approved for production [ 10034 ] Production Testing [ 10202 ]
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]
            Permalink
            alankar.chavan Alankar Chavan (Inactive) logged work - 18/Jul/17 12:48 PM
            • Time Spent:
              2.5h
               

              prod testing

            alankar.chavan Alankar Chavan (Inactive) made changes -
            Time Spent 59.5h [ 214200 ] 62h [ 223200 ]
            Worklog Id 64300 [ 64300 ]
            Permalink
            umesh.kadam Umesh Kadam (Inactive) logged work - 18/Jul/17 04:30 PM
            • Time Spent:
              0.75h
               

              Service Module Deployment related discussion with Ashwin, Khandu, Gaurav, Vinayak, Prasanna and Shailendra
              Revert script shared with Ashwin

            umesh.kadam Umesh Kadam (Inactive) made changes -
            Time Spent 62h [ 223200 ] 62.75h [ 225900 ]
            Worklog Id 64461 [ 64461 ]
            Hide
            Permalink
            satyap Satya added a comment -

            This patch has been reverted from Production today, 07/27/2017.

            Regards,
            Satya Prakash

            Cc: Umesh Kadam Jyoti Mayne Vinayak Kulkarni Amruta Lohiya

            Show
            satyap Satya added a comment - This patch has been reverted from Production today, 07/27/2017. Regards, Satya Prakash Cc: Umesh Kadam Jyoti Mayne Vinayak Kulkarni Amruta Lohiya
            satyap Satya made changes -
            Link This issue relates to WT-10291 [ WT-10291 ]
            satyap Satya made changes -
            Link This issue relates to WT-10318 [ WT-10318 ]
            satyap Satya made changes -
            Link This issue relates to WT-10315 [ WT-10315 ]
            Permalink
            jyoti.mayne Jyoti Mayne logged work - 27/Jul/17 04:03 PM
            • Time Spent:
              4h
               

              data verification, correction script discussion, policy number scanning and discussion

            Permalink
            umesh.kadam Umesh Kadam (Inactive) logged work - 27/Jul/17 04:30 PM
            • Time Spent:
              9h
               

              Internal team discussion regarding service patch
              Impacted area testing
              Data correction verification with Team
              Tries to reproduce scenarios with different approaches and different scenarios discussed with team

            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 27/Jul/17 09:00 PM
            • Time Spent:
              5h
               

              Discussion on data corruption
              Data verification of Invoice for BCC companies
              Data audit to find the affected records

            Permalink
            amruta.lohiya Amruta Lohiya logged work - 27/Jul/17 09:02 PM
            • Time Spent:
              8h
               
              <No comment>
            Permalink
            jyoti.mayne Jyoti Mayne logged work - 28/Jul/17 04:14 PM
            • Time Spent:
              0.5h
               

              audit related discussion with Avnish and Amruta

            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 28/Jul/17 07:00 PM
            • Time Spent:
              3h
               

              Script to scan affected active elections for July 2017 month which may have gone on scheduled Enrollment / Billing Reports
              RCA Meeting for this JIRA (0.5)
              Learning & Mitigation Discussion (0.5)

            Permalink
            amruta.lohiya Amruta Lohiya logged work - 28/Jul/17 09:02 PM
            • Time Spent:
              2h
               
              <No comment>
            jyoti.mayne Jyoti Mayne made changes -
            Time Spent 62.75h [ 225900 ] 66.75h [ 240300 ]
            Worklog Id 67885 [ 67885 ]
            jyoti.mayne Jyoti Mayne made changes -
            Time Spent 66.75h [ 240300 ] 67.25h [ 242100 ]
            Worklog Id 67890 [ 67890 ]
            amruta.lohiya Amruta Lohiya made changes -
            Time Spent 67.25h [ 242100 ] 75.25h [ 270900 ]
            Worklog Id 67897 [ 67897 ]
            amruta.lohiya Amruta Lohiya made changes -
            Time Spent 75.25h [ 270900 ] 77.25h [ 278100 ]
            Worklog Id 67898 [ 67898 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 77.25h [ 278100 ] 82.25h [ 296100 ]
            Worklog Id 68188 [ 68188 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 82.25h [ 296100 ] 85.25h [ 306900 ]
            Worklog Id 68473 [ 68473 ]
            umesh.kadam Umesh Kadam (Inactive) made changes -
            Time Spent 85.25h [ 306900 ] 94.25h [ 339300 ]
            Worklog Id 68501 [ 68501 ]
            Transition Time In Source Status Execution Times
            Shailendra Honrao (Inactive) made transition -
            New Request Product Backlog
            		90d 20h 58m 1
            Umesh Kadam (Inactive) made transition -
            Product Backlog Pending for Approval
            		20h 40m 1
            Umesh Kadam (Inactive) made transition -
            Pending for Approval Approved for Development
            		5s 1
            Umesh Kadam (Inactive) made transition -
            Approved for Development In Development
            		3s 1
            Alankar Chavan (Inactive) made transition -
            In Development In LB Testing
            		8d 6h 47m 1
            Alankar Chavan (Inactive) made transition -
            In LB Testing Pending for Stage Approval
            		8s 1
            Alankar Chavan (Inactive) made transition -
            Pending for Stage Approval Approved for Stage
            		6d 18h 10m 1
            Alankar Chavan (Inactive) made transition -
            Approved for Stage Stage Testing
            		5s 1
            Alankar Chavan (Inactive) made transition -
            Stage Testing Pending for Production Approval
            		48d 4h 11m 1
            Alankar Chavan (Inactive) made transition -
            Pending for Production Approval Approved for production
            		9s 1
            Alankar Chavan (Inactive) made transition -
            Approved for production In Production Testing
            		7s 1
            Alankar Chavan (Inactive) made transition -
            In Production Testing Production Complete
            		10s 1
            Alankar Chavan (Inactive) made transition -
            Production Complete Closed
            		2s 1

              People

              Assignee:
              alankar.chavan Alankar Chavan (Inactive)
              Reporter:
              rajendra.pawar Rajendra Pawar (Inactive)
              Account Executive:
              Vinayak Kulkarni (Inactive)
              Developer:
              Shailendra Honrao (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:
                Production Due Date:
                Code Review Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 50h Original Estimate - 50h
                  50h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 94.25h
                  94.25h