Overview

You want to delete/remove a date and amount entry for a Product Code that is displayed on the Rate Index Range Maintenance page.

Solution

Open a Support ticket with the value of the Product Code as seen on the CSR site on the Rate Index Range Maintenance page and the exact details (From Date, To Date, Amount) of the entry that needs to be deleted.

<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 RateID:

use <Client specific Database>;
select RateID from Product where ProductCode='<Product Code provided by the client>';

    5. Find the FixedCapRate:

use <Client specific Database>;
select FixedCapRate from RateDetail where RateId=<Value from the results of the query in the previous step>;

    6. Find the RateIndexRange for the Product Code:

use <Client specific Database>;
select * from RateIndexRange where RateIndexTypeId=<Value from the results of the query in the previous step>;

    7. Delete the row that matches the client request:

use <Client specific Database>;
delete from RateIndexRange where RateIndexRangeID=<one of the values from the RateIndexRangeID column from the results of the query in the previous step>

</supportagent>