Overview

You want to change the rate code at the utility end (or LDC Rate Code) for an account to a specific value and send a rate change transaction to the utility. 

Solution

Please raise a support ticket with us mentioning the customer account number or UCID and the new LDC Rate Code value.  
We will make the changes and inform you.

<supportagent>

This solution is specific to the client, Spark Energy.

The requester must provide the account number and the new LDC rate code to have the LDC rate code changed. It is possible that the client raises a ticket mentioning "rate code" when they actually mean "LDC rate code". Here, rate code refers to Aurea rate code for the product, and LDC Rate Code refers to the rate code at the utility or LDC (local distribution company) side. From the length of the provided code, it can be determined if it is a rate code (typically longer in length, greater than 6 digits, example NICOR_G_Resi Fixed Evergreen T1) or an LDC rate code (typically smaller in length, 4-5 digit code, example BK820). Also, if there is a date change requested, it is likely to be a request for a rate code (and not an LDC rate code) update.

Pre-requisite

• Write access to the Client database
• Access to the client-specific CSR site

To proceed with making the change, follow these steps:

1. Get the customer ID by running the query below after replacing [accountNumber] with the account number provided by the requester.

   SELECT CustID FROM Customer WHERE CustNo='[accountNumber]'

2. Get the RateTransitionID for the current product of the customer. In the query below, replace [CustID] with the ID obtained in the previous step.

   SELECT TOP 1 RateTransitionID , * 
   FROM RateTransition 
   WHERE  custID = [CustID] 
   ORDER BY EndDate

3. Update the LDCRateCode in the ClientCustomer.RateTransition table. In the query below, replace [RateTransitionID] with the ID obtained in the previous step and [LDCRATECODE] with the provided rate code.

   UPDATE ClientCustomer.RateTransition 
   SET LDCRateCode = '[LDCRATECODE]' 
   WHERE RateTransitionID = [RateTransitionID]

4. Update the LDCRateCode in the Rate table. Run the query below after replacing [CustID] with the customer ID obtained in step 1 and [LDCRATECODE] with the provided rate code.

   UPDATE Rate 
   SET LDCRateCode = '[LDCRATECODE]' 
   WHERE RateID IN (SELECT RateID FROM Customer WHERE CustID = [CustID])

5. If the client has requested to trigger a rate change after the rate code has been correctly updated, then use these steps  Triggering a Change Transaction (814_C) via CSR

</supportagent>

Testing

Check that the LDC rate code has been updated correctly:

1. Log in to the CSR site.
2. Search for the account using the account number.
   
   
   
3. On the Customer Info tab, check the Rate Code field in the Billing Information section. 
   The updated LDC Rate Code value will be displayed in brackets (02801 in the sample below).