Overview

You want to update/adjust the From Date and/or To Date for a Product Code in Rate Index Range Maintenance.

Solution

Open a Support ticket specifying the Product Code, the current From Date and/or To Date shown in the CSR portal under Administration Menu > General > Rate Index Range Maintenance and the date to which the respective date/s should be modified.

In case there are multiple same From Dates and/or To Dates for the product, also provide a screenshot from the CSR portal specifying exactly which entry needs to be modified.

Support will get back to you once the update is complete.

<supportagent>

Access to the Jump server is required to perform the below update steps:

1. Login to the Jump server 10.185.40.141.
2. Open Microsoft SSMS and connect to aes.cons.com.
3. Select New Query in the top bar.
4. Find the RateIndexTypeId:
   

   use <client_specific_database>;
   select RateIndexTypeId from RateIndexType where RateIndexType='<Product Code>';

5. Find the RateIndexRangeId:

   use <client_specific_database>;
   select * from RateIndexRange where RateIndexTypeId=<Found from previous step>;

6. Find the record with the From Date and/or To Date that the customer has mentioned and update it. If required, skip the DateFrom or DateTo parameters in the below query as per the client's requirements:

   use <client_specific_database>;
   update RateIndexRange set DateFrom="YYYY-MM-DD 00:00:00.000", DateTo="YYYY-MM-DD 00:00:00.000" where RateIndexRangeId=<Found from previous step corresponding to what the client has requested the update for>

Inform the client that the requested date/s has/have been updated.

</supportagent>

Related Articles

Editing or Adding Dates of Indexed-Rate Plans