WORKTERRAProject Type: software

WORKTERRA

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

Billing - Need to avoid double insertion in Billing when record is moved by effective date service

    Details

    • Type: Bug
    • Status: Closed
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Environment:
      Production
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - Report
    • Reported by:
      Harbinger
    • Item State:
      Stage QA - Stage Deployed
    • Sprint:
      WT Sprint 30 -Bugs

      Description

      Due to Invoice Management we are tracking future rate changes in Billing Table.
      After the election is moved from Intermediate to main table, currently the Enrollment and RateChanges_LogID are not getting updated.

        Attachments

          Issue Links

          causes

          Analysis - Analysis WT-12048 Billing Details Issue

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

          Change Request - Change Request WT-8417 Need to move dead enrollments through effective date service

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

            Activity

            Ascending order - Click to sort in descending order
            Permalink
            surender.kumar surender kumar (Inactive) logged work - 01/Feb/17 12:59 PM
            • Time Spent:
              7h
               

              Analysis
              Discussion
              Coding

            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 01/Feb/17 09:45 PM
            • Time Spent:
              2h
               

              Discussion on addition of column in RateChanges_Log table to identify if the record got inserted by effective date service or not.
              Discussion on code changes required in effective date service.

            Permalink
            surender.kumar surender kumar (Inactive) logged work - 02/Feb/17 01:49 PM
            • Time Spent:
              3.5h
               

              coding
              Testing

            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 10/Feb/17 01:00 AM
            • Time Spent:
              0.5h
               

              Code review.

            Permalink
            saurabh.sablaka Saurabh Sablaka (Inactive) logged work - 10/Feb/17 11:25 AM
            • Time Spent:
              0.5h
               

              Discussion on addition of "EffectiveDateServiceInsertion" in both RateChanges_log table

            Permalink
            surender.kumar surender kumar (Inactive) logged work - 10/Feb/17 12:58 PM
            • Time Spent:
              1.5h
               

              Discussion.

            Permalink
            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 10/Feb/17 01:54 PM
            • Time Spent:
              0.5h
               

              Design team meeting

            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 11/Feb/17 07:30 AM
            • Time Spent:
              1.5h
               

              Design Team meeting on addition of flag
              Discussion on - flag needs to be added in Ratechanges_log table.

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

              Go through of already done code changes
              Test scenario preparation

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

              Scenario creation on local

            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 06/Jun/17 12:30 AM
            • Time Spent:
              0.5h
               

              Effective date procedure go through and analysis on introducing flag for Rates Intermediate

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

              DDL and changes in effective date service procedure IsRatesIntermediate flag

            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 09/Jun/17 07:00 PM
            • Time Spent:
              1.5h
               

              Analysis

            Permalink
            surender.kumar surender kumar (Inactive) logged work - 12/Jun/17 01:42 PM
            • Time Spent:
              8h
               

              Analysis
              Discussion
              Coding
              Testing

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

              Discussion on Billing trigger fix related to effective date service

            Permalink
            surender.kumar surender kumar (Inactive) logged work - 13/Jun/17 01:53 PM
            • Time Spent:
              4h
               

              Testing

            Permalink
            surender.kumar surender kumar (Inactive) logged work - 14/Jun/17 01:33 PM
            • Time Spent:
              3h
               

              Testing

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

              Code review and discussion on scenarios tested

            Permalink
            surender.kumar surender kumar (Inactive) logged work - 15/Jun/17 01:24 PM
            • Time Spent:
              2h
               

              Script Prepared
              Testing

            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 15/Jun/17 10:00 PM
            • Time Spent:
              0.25h
               

              Review of script to update existing records

            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 20/Jun/17 07:57 AM
            • Time Spent:
              4h
               

              Testing on LB

            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 20/Jun/17 12:47 PM
            • Time Spent:
              4h
               

              Scenarios tested

            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 21/Jun/17 05:55 PM
            • Time Spent:
              2h
               

              Testing on LB

            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 11/Jul/17 09:28 AM
            • Time Spent:
              2h
               

              Billing trigger changes on Stage

            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 12/Jul/17 09:52 AM
            • Time Spent:
              4h
               

              Testing done on Stage

            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 18/Jul/17 12:47 PM
            • Time Spent:
              1.5h
               

              Testing of scenarios on Production

            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 18/Jul/17 06:56 PM
            • Time Spent:
              1h
               

              Testing on Production

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

              Code check in
              Disucssion related to Patch Deployment and revert
              coding - Correction script to correct records which have RateChanges_LogID but their IsRatesIntermediate flag is NULL

              People

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

                Dates

                Due:
                Created:
                Updated:
                Resolved:
                Dev Due Date:

                  Time Tracking

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