Analysis
Discussion
Coding

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.

coding
Testing

Code review.

Discussion on addition of "EffectiveDateServiceInsertion" in both RateChanges_log table

Discussion.

Design team meeting

Go through of already done code changes
Test scenario preparation

Scenario creation on local

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

DDL and changes in effective date service procedure IsRatesIntermediate flag

Analysis

Analysis
Discussion
Coding
Testing

Discussion on Billing trigger fix related to effective date service

Testing

Testing

Code review and discussion on scenarios tested

Script Prepared
Testing

Review of script to update existing records

Testing on LB

Scenarios tested

Testing on LB

Billing trigger changes on Stage

Testing done on Stage

Testing of scenarios on Production

Testing on Production

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