Overview

You may want to change the name of the RateIndex type associated with a Product in case it is named differently than the product.

Solution

Create a support ticket mentioning the following details and support will complete the change

• Product code of the product
• The current name of the RateIndex type
• Preferred name of the RateIndex type

<supportagent>

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. Select the client-specific database.
5. Run the following queries to locate the RateIndexType
   

   select RateID, * from Product where ProductCode='<Product code specified by client>'
   select FixedCapRate, * from RateDetail where RateID=<RateID from above query>
   select * from RateIndexType where RateIndexTypeID=<FixedCapRate from above query>

6. Once the target RateIndexType row is found, update the name with the following query

   update RateIndexType set RateIndexType='<client specified name>' where RateIndexTypeID=<FixedCapRate from above query>

</supportagent>