Overview

You may want to update the range limits on rate types that are part of the same product such that the intervals in the rates don't have gaps.

Information

Create a support ticket with the following information and support will update the ranges:

• Product Code(s) or Rate Package Code(s) for which you want the range limits updated
• Mention if you want the RangeLower or the RangeUpper updated.
• And the initial & final values of the range limits

<supportagent>

Follow the below steps to update the range limits

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. Find the RateID from the Product table for the mentioned ProductCodes or from the Rate table for the mentioned RateCodes with

   select RateID, * from Product where ProductCode='<client specified ProductCode>'
   OR
   select RateID, * from Rate where RateCode='<client specified RateCode>'

6. Find the applicable RateDetail rows with

   select RateDetID, * from RateDetail where RateID=<RateID as found above>

   Check the range values of the available RateDetail rows in the RangeUpper & RangeLower column and find the exact rows whose values for these columns are what the client specified and note down the RateDetIDs of the target rows.
7. Update the range limit values for the appropriate rate type rows as mentioned by the client with

   update RateDetail set RangeLower=<client specified value> where RateDetID=<as found above>
   OR
   update RateDetail set RangeUpper=<client specified value> where RateDetID=<as found above>

8. Contact the client if there is any ambiguity in identifying the rows.

</supportagent>