Overview

You want to update the TDSP rates for a specific TDSP or Market. The price point can be per kWh or a flat rate.

 

Solution

Please raise a support ticket with us (if not done already) specifying the Market/TDSP and the ERCOT TDSP rate or price point (flat or per KWH). We will inform you after updating the rate and you can verify it at your end.

<supportagent>

A Market provided by the client is to be considered as the TDSP/LDC.

 

Pre-requisite

Access to the Client database

 

Steps

If a decimal number (typically 6 places after decimal) is provided by the client for a TDSP with no units appended to it, then consider it to be the flat rate. For example, TNMP: 0.048763 denotes a flat rate for the TDSP TNMP.

The current TDSP rates for all the TDSPs can be seen from the database by running a similar query:

select ld.AvgRateCalc_EstimatedTDSPFlat,ld.AvgRateCalc_EstimatedTDSPKWH, 
ld.LDCId,ld.ServiceType,ld.CustomerType,l.LDCName,l.LDCShortName 
 from config.LDCConfiguration ld 
 join LDC l on l.LDCID = ld.LDCId 
where ld.LDCId in (1,2,3,4,5)

where (1,2,3,4,5) are the LDCIDs of the LDCs. The entire list of LDCs and their IDs can be fetched by querying the LDC table with select * from LDC and LDCShortName has the short names of the LDCs. Some of the known mappings are:

Short Name	LDCID
CPL	1
ONCOR	2
TNMP	4

To update Flat rates, execute the following query:
update config.LDCConfiguration set AvgRateCalc_EstimatedTDSPFlat = '<flat rate as string>'
where LDCId = <LDCID>

To update Per unit/kWh rate, execute the following query:
update config.LDCConfiguration set AvgRateCalc_EstimatedTDSPKWH = '<rate as string>'
where LDCId = <LDCID>

</supportagent>