Overview

You want assistance with the update of the rate and/or blend ratio/percentage of a Rate Package.

Solution

Open a Support request with the below information:

1. The Rate Package Name
2. What needs to be updated for that Rate Package - Rate and/or Blend percentage
3. The updated value/s for the information (rate and/or blend percentage) that needs to be updated

Support will inform you once the updates have been made.

<supportagent>

You should have access to the Jump server for performing the below 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 Rate Package's RateID:

   use <Client specific Database>;
   select RateID from rate 
   where ratecode = '<Rate Code/Rate Package Name provided by the client>'

    If the client has provided the Product Code, you can find the RateID as follows:

   use <Client specific Database>;
   
   select RateID,* from Product  
   where ProductCode like '%<Product Code provided>%'

5. Get the current rate details:

   use <Client specific Database>;
   select RateDetID, RateAmt, RateAmt2 
   from ratedetail 
   where RateId = <Found from the results of the previous query>

    If the client has requested the rate amount to be updated and has provided the current value, locate the RateID for the record with the provided current value.
6. Update the Rate and/or Blend percentage as per the client's requirements:
   • Update only Rate:
     

     use <Client specific Database>;
     update ratedetail 
     set rateamt = '<rate provided by client>' 
     where ratedetid = <Found from the results of the query in step 5>

   • Update only Blend %:
     

     use <Client specific Database>;
     update ratedetail 
     set rateamt2 = '<blend % provided by client>' 
     where ratedetid = <Found from the results of the query in step 5>

   • Update both - Rate and the Blend %:
     

     use <Client specific Database>;
     update ratedetail 
     set rateamt = '<rate provided by client>', 
     rateamt2 = '<blend % provided by client>' 
     where ratedetid = <Found from the results of the query in step 4>

Testing

You can run the same query as in step 5 to confirm that the update has gone through as expected.

Inform the client that the update has been completed.

</supportagent>