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

            Activity

            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

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

              Issue discussion and Scenario Discussion with Rohit

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

              scenario discussion with Umesh

            jyoti.mayne Jyoti Mayne logged work - 05/May/17 09:05 AM
            • Time Spent:
              0.25h
               

              scenario explanation to Umesh

            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

            shailendra.honrao Shailendra Honrao (Inactive) logged work - 10/May/17 12:52 PM
            • Time Spent:
              7h
               
              <No comment>
            shailendra.honrao Shailendra Honrao (Inactive) logged work - 11/May/17 12:26 PM
            • Time Spent:
              8h
               
              <No comment>
            jyoti.mayne Jyoti Mayne logged work - 12/May/17 07:46 AM
            • Time Spent:
              0.5h
               

              code debugging with Shailendra and discussion

            shailendra.honrao Shailendra Honrao (Inactive) logged work - 12/May/17 12:57 PM
            • Time Spent:
              8h
               
              <No comment>
            shailendra.honrao Shailendra Honrao (Inactive) logged work - 15/May/17 07:03 AM
            • Time Spent:
              8h
               
              <No comment>
            umesh.kadam Umesh Kadam (Inactive) logged work - 15/May/17 04:30 PM
            • Time Spent:
              1h
               

              Discussion with Shailendra

            shailendra.honrao Shailendra Honrao (Inactive) logged work - 16/May/17 01:47 PM
            • Time Spent:
              5h
               
              <No comment>
            umesh.kadam Umesh Kadam (Inactive) logged work - 16/May/17 04:30 PM
            • Time Spent:
              1h
               

              Scenario discussion with Shailendra

            shailendra.honrao Shailendra Honrao (Inactive) logged work - 17/May/17 12:46 PM
            • Time Spent:
              1h
               
              <No comment>
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 17/May/17 02:28 PM
            • Time Spent:
              0.5h
               
              <No comment>
            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

            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

            shailendra.honrao Shailendra Honrao (Inactive) logged work - 22/May/17 12:55 PM
            • Time Spent:
              0.5h
               
              <No comment>
            alankar.chavan Alankar Chavan (Inactive) logged work - 24/May/17 01:35 PM
            • Time Spent:
              6h
               

              analysis
              discussion
              lb testing
              ready for stage

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

              Prepared analysis document

            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

            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

            alankar.chavan Alankar Chavan (Inactive) logged work - 31/May/17 01:25 PM
            • Time Spent:
              1.5h
               

              stage testing

            jyoti.mayne Jyoti Mayne logged work - 17/Jul/17 03:41 PM
            • Time Spent:
              0.5h
               

              script review and discussion

            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

            alankar.chavan Alankar Chavan (Inactive) logged work - 18/Jul/17 12:48 PM
            • Time Spent:
              2.5h
               

              prod testing

            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

            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

            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

            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

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

              audit related discussion with Avnish and Amruta

            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)

            amruta.lohiya Amruta Lohiya logged work - 28/Jul/17 09:02 PM
            • Time Spent:
              2h
               
              <No comment>

              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