Tariffs are rate plans for electricity. They describe who the plan applies to (service and applicability), what the charges are, and other information about this electricity service:

  • We have residential tariffs and general tariffs (commercial & industrial), and specialty (agriculture, transport, lighting).
  • You can specify whether you want the tariff fully populated, or whether you just want a sub section of the data (to avoid charges and to speed up your queries).

Data Definitions

The complete tariff data is actually a hierarchy of a number of objects. We call the “header” object the Tariff (to confuse things!), which contains zero or more TariffRate objects. Think of a tariff rate like the line item on your bill. Then each tariff rate has 1 or more TariffRateBand. Some charges (rates) can be banded to contain several levels based on demand or consumption (or other) thresholds. Our rich structure is designed to support the complexity found in the large array of tariff plans that are in the market.

TariffId versus MasterTariffId

Tariff data changes periodically. E-1 Residential in PG&E territory, for example, usually changes a few times per year. For each revision we created a new tariff with a unique tariffId. Logically, however, each of these new tariffs is actually just a different version of a single “master” tariff. This family of tariffs is tied together with the masterTariffId property. Again using E-1 as an example, each version of the tariff will have a different tariffId, but they all have the same masterTariffId522.

Taxes

The Genability database only has rates that appear in utility tariff books. That means that it does not have state, local, and other tax rates. That doesn’t mean that you can’t include them in a calculation, though. We have a quick how-to on exactly how to do that.

Tariff

The Tariff object has the following data structure.

Name Type Fields Description
tariffId Long M Unique Genability ID (primary key) for this tariff
masterTariffId Long M Unique Genability ID that persists across all revisions of this tariff
tariffCode String M Short code that the LSE uses as an alternate name for the tariff
tariffName String M Name of the tariff as used by the LSE
tariffBookName String E Name of the tariff as it appears in the tariff document
lseId Long M ID of load serving entity this tariff belongs to
lseName String M Name of the load serving entity
lseCode String E Abbreviated name of the load serving entity
serviceType String M Type of service for the tariff. Current values include ELECTRICITY (grid power), SOLAR_PV (for a Solar PPA, Lease or similar) and GAS (Natural Gas)
priorTariffId Long   Unique Genability ID that identifies the prior revision of the tariffId above
distributionLseId Long   In states like Texas where the load serving entity that sells the power is different than the load serving entity that distributes the power, this will contain the ID of the distribution LSE. Otherwise, it will be null.
tariffType String   Possible values are:
DEFAULT - tariff that is automatically given to this service class
ALTERNATE - opt in alternate tariff for this service class
OPTIONAL_EXTRA - opt in extra, such as green power or a smart thermostat program
RIDER - charge that can apply to multiple tariffs. Often a regulatory mandated charge
customerClass String   Possible values are:
RESIDENTIAL - homes, apartments etc.
GENERAL - commercial, industrial and other business and organization service types (often have additional applicability criteria)
SPECIAL_USE - examples are government, agriculture, street lighting, transportation
PROPOSED - Utility rates that have been proposed by utilities and approved by utility commissions, but are not yet effective (requires product subscription)
customerCount Integer   Number of customers that are on this master tariff
customerLikelihood Decimal   The likelihood that a customer is on this tariff of all the tariffs in the search results. Only populated when getting more than one tariff.
customerCountSource String E Where we got the customer count numbers from. Typically FERC (form 1 filings) or Genability (our own estimates).
territoryId String   ID of the territory that this tariff applies to. This is typically the service area for the LSE in this regulatory region (i.e. a state in the USA)
effectiveDate DateTime   Date on which the tariff was or will be effective
endDate DateTime   Date on which this tariff is no longer effective. Can be null which means end date is not known or tariff is open ended
closedDate Date E Date on which a tariff became closed to new customers, but still available for customers who were on it at the time. Can be null which means that the tariff is not closed. All versions of a particular tariff (i.e. those that share a particular masterTariffId) will have the same closedDate value. See example
effectiveOnRule String E Property of the tariff determining when the tariff takes effect. Possible values: TARIFF_EFFECTIVE_DATE, BILLING_PERIOD_START
timeZone String   If populated (usually is), its the timezone that this tariffs dates and times refer to
billingPeriod String   How frequently bills are generated.
currency String   ISO Currency code that the rates for this tariff refer to (e.g. USD for USA Dollar)
chargeTypes String   A comma separated list of all the different ChargeType rates on this tariff (see field on TariffRate below).
chargePeriod String   The most fine grained period for which charges are calculated.
minMonthlyConsumption Decimal E When applicable, the minimum monthly consumption allowed in order to be eligible for this tariff.
maxMonthlyConsumption Decimal E When applicable, the maximum monthly consumption allowed in order to be eligible for this tariff.
minMonthlyDemand Decimal E When applicable, the minimum monthly demand allowed in order to be eligible for this tariff.
maxMonthlyDemand Decimal E When applicable, the maximum monthly demand allowed in order to be eligible for this tariff.
hasTimeOfUseRates Boolean   Indicates whether this tariff contains one or more Time of Use Rate.
hasTieredRates Boolean   Indicates whether this tariff contains one or more Tiered Rate.
hasContractedRates Boolean   Indicates whether this tariff contains one or more Rate that can be contracted (sometimes called by-passable or associated with a price to compare).
hasTariffApplicability Boolean E Indicates that this tariff has additional eligibility criteria, as specified in the TariffProperty collection (below).
hasRateApplicability Boolean   Indicates that one or more rates on this tariff are only applicable to customer with a particular circumstance. When true, this will be specified in the TariffProperty collection, and also on the TariffRate or rates in question.
hasNetMetering Boolean E Indicates whether this tariff contains one or more net metered rates.
privacy String E Privacy status of the tariff. Possible values are PUBLIC, UNLISTED or PRIVATE.
isActive Boolean   DEPRECATED. Signifies that this tariff id is the currently active tariff (now) within all tariffs sharing this master tariff id. Instead, use the effective and end dates to test whether a tariff is active or not. If you’re searching for tariffs, use effectiveOn instead.
properties List of TariffProperty   The properties on this tariff. See below for the TariffProperty structure.
rates List of TariffRate   The rates for this tariff. See below for TariffRate structure
documents List of TariffDocument   The documents for this tariff. See below for TariffDocument structure

Tariff Rate

The TariffRate object has the following data structure.

Name Type Fields Description
tariffRateId Long M Unique Genability ID (primary key) for each tariff rate
tariffId Long M Associates the rate with a tariff (foreign key)
riderTariffId Long E Tariff ID of the rider attached to this tariff version. null otherwise
riderId Long M Master Tariff ID of the rider linked to this tariff rate.
tariffSequenceNumber Integer M Sequence of this rate in the tariff, for display purposes only (e.g. this is the order on the bill)
tariffBookSequenceNumber Integer E Sequence of this rate in the tariff source document, if it differs from tariffSequenceNumber
rateGroupName String M Name of the group this rate belongs to
tariffBookRateGroupName String E Name of the group this rate belongs to in the tariff source document, if it differs from rateGroupName
rateName String M Name of this rate. Can be null (in which case use the group name)
tariffBookRateName String E Name of this rate in the tariff source document, if it differs from rateName
fromDateTime DateTime   If populated, this indicates the rates effective date is not the same as that of its tariff
toDateTime DateTime   If populated, this indicates the rates end date is not the same as that of its tariff
territory Territory   Only populated when this rate applies to a different region than the whole tariff (e.g. California Baseline Regions). This how-to has more.
season Season   The season this rate applies to. Only used for seasonal rates (null otherwise)
timeOfUse TimeOfUse   The time period this rate applies to. Only used for TOU rates (null otherwise)
chargeType String   Possible values:
FIXED_PRICE - a fixed charge for the period
CONSUMPTION_BASED - based on quantity used (e.g. kW/h)
DEMAND_BASED - based on the peak demand (e.g. kW)
QUANTITY - a rate per number of items (e.g. $5 per street light)
FORMULA - a rate that has a specific or custom formula
MINIMUM - a minimum amount that the LSE will charge you, overriding lower pre-tax charges
MAXIMUM - a maximum amount that the LSE will charge you, overriding higher pre-tax charges
TAX - a percentage tax rate which is applied to the sum of all of the other charges on a bill
chargeClass String   A comma separated string that indicates what class(es) of charges this rate is for. Values include:
SUPPLY - Energy related charges.
TRANSMISSION - Transmission level delivery charges.
DISTRIBUTION - Distribution level (last mile) delivery charges of moving electricity into your home or business.
TAX - Tax surcharges which appear in the utility tariff document.
CONTRACTED - Charges which get replaced or overridden when you pass the retail (contracted) energy supply rate in the calculation.
USER_ADJUSTED - Additional or custom rates you can add to a public or private tariff. An example would be a local tax rate which Genability does not model but you would want included.
AFTER_TAX - Charges which apply post utility and other taxes. A good example would be the California Climate credit which is applied to the bill after the taxes are applied to the bill subtotal.
OTHER - Charges which cannot be classified in any of the above buckets. This is very rare. NON_BYPASSABLE - Charges which cannot be offset by credits (usually Net Metering)
chargePeriod String   Indicates what period this charge is calculated for. This is usually the same as the billing period (and is usually monthly) but can be other intervals. Possible values are:
MONTHLY - each calendar month
DAILY - calculated for each day
QUARTERLY - every 3 months
ANNUALLY - every year
transactionType String E Indicates whether this rate is BUY (charge when importing from the grid, no credit when exporting), SELL (credit when exporting to the grid, no charge when importing), or NET (charge when importing, credit when exporting) with imports and exports resolved according the the chargePeriod. BUY_IMPORT (charge only when importing) and SELL_EXPORT (credit only when exporting) indicate that imports and exports are resolved in real-time (instantaneous netting).
quantityKey String   When not null, the property that defines the type of quantity this rate applies to. (e.g. billingMeter : property which defines the number of billing meters the rate will apply to)
applicabilityKey String   When not null, the property that defines the eligibility criteria for this rate. (e.g. connectionType : property which defines how the service is connected to the grid)
variableLimitKey String   When populated this defines the variable which determines the upper limit(s) of this rate. (e.g. demandMultiplierTierswithkWhTiers2416: property which uses the demand value to drive the consumption limits)
variableRateKey String   When not null, this is the name of the property that defines the variable rate. In this case the rate field is null, or can (rarely) be used as an input to the determination of the variable rate. (e.g massachusettsResidentialRetailPrevailingRates : property which provides the regional prevailing residential supply rate for Massachusetts )
variableFactorKey String   When not null, this is the name of the property that defines the variable factor to apply to this rate. (e.g billingPeriodProrationFactor: property which defines a prorated number of billing days)
rateBands List of TariffRateBand   See the data definition below

Tariff Rate Band

The TariffRateBand object has the following data structure.

Name Type Fields Description
tariffRateBandId Long   Unique Genability ID (primary key) for each Band
tariffRateId Long   ID of the rate this band belongs to (foreign key)
rateSequenceNumber Integer   This bands position in the bands for its rate
hasConsumptionLimit Boolean   true indicates that this has banded consumption
consumptionUpperLimit Decimal   When hasConsumptionLimit is true, this indicates the upper consumption limit of this band. null means no upper limit
hasDemandLimit Boolean   true indicates that this has banded demand
demandUpperLimit Decimal   When hasDemandLimit is true, this indicates the upper demand limit of this band. null means no upper limit
hasPropertyLimit Boolean   true indicates that this has a limit based on a property
propertyUpperLimit Decimal   When hasPropertyLimit is true, this indicates the upper limit of this band. null means no upper limit
prevUpperLimit Integer   The upper limit of the previous rate band for this rate
applicabilityValue String   When not null, this indicates the value of applicability property that qualifies for this rate.
calculationFactor Decimal   A factor to be applied to the cost of the rate.
rateAmount Decimal   Charge amount for this band
rateUnit String   Possible values:
COST_PER_UNIT - rate amount multiplied by the number of units
PERCENTAGE - percentage of a value (e.g. percentage of overall bill)
isCredit Boolean   When true this band is a credit amount (reduces the bill)

Tariff Document

The TariffDocument object has the following data structure.

Name Type Fields Description
tariffId Long   The tariff ID associated with this document
documentId Long   Unique ID of the document associated with this tariff
documentSectionId Long   Unique ID of the section of the documentSection associated with this tariff
document Document   The Document object associated with this tariff

Document

The Document object has the following data structure.

Name Type Fields Description
documentId Long   Unique ID of this document
documentTitle String   Title of this document
archiveUrl String   URL for Genability’s archive of this document
sourceUrl String   URL for original source document (if applicable)
sourceContentType String   Type of source document, possible values are (???)
lseId Long   ID of the LSE associated with this document
lseName String   Name of the LSE associated with this document
territoryId Long   ID of the territory associated with this document
territoryName String   Name of the territory associated with this document
sequenceNumber Integer   The position of this document in all documents for the LSE
parentDocumentId Long   The documentId of the parent document of this document, if this document is part of a collection
sections List of DocumentSection   Document sections, typically corresponding to specific tariffs
priorDocumentId Long   documentId of the document for the previous version of this tariff

Document Section

The DocumentSection object has the following data structure.

Name Type Fields Description
documentSectionId Long   Unique ID of this document section
documentId Long   Unique ID of the document associated with this section
sectionHeading String   Title of the document section
sectionType String   Possible values are SERVICE, TARIFF, CLIMATE_ZONE, or UTILITY_CLIMATE_ZONE
startPage Integer   The page number of the document this section starts on
customerClass String   The type of customer this document section concerns. Possible values are GENERAL, RESIDENTIAL, SPECIAL_USE or PROPOSED
revised Boolean   Whether this document has been revised from the original
priorDocumentSectionId Long   Unique ID of the document section for the previous version of this tariff

Tariff Property

Tariff properties represent metadata about a tariff. They might tell you things like, “What values are required to do a calculation with this tariff?” or “What do I have to do in order to be eligible for this tariff?” They’re broken down into a number of types, the most important of which are listed below.

Applicabilities

Tariff properties of type APPLICABILITY tell you whether or not a customer is eligible to receive service under a particular tariff. For example, a tariff that is only for electric vehicles might have the hasElectricVehicle applicability property.

Rate Criteria

Tariff properties of type RATE_CRITERIA represent things that you need to know in order to properly calculate the tariff. This includes obvious things like consumption and demand, but also things like dailyMedicalAllowance or isSmartRateCustomer.

For things other than consumption and demand, we usually set a reasonable default value so you don’t have to answer questions about every single property before doing a calculation. If you want to set these values yourself, though, you can do that by running through the list of properties returned when you set populateProperties to true when getting a tariff.

Data Structure

The TariffProperty object has the following data structure.

Name Type Fields Description
keyName String M Unique name for this property
period String   If applicable the type of time of use. Possible values are SUPER_OFF_PEAK, OFF_PEAK, PARTIAL_PEAK, ON_PEAK, SUPER_ON_PEAK or CRITICAL_PEAK.
displayName String M The display name of this property
keyspace String M Top level categorization of the property hierarchy
family String M Second level categorization of the property hierarchy, below keyspace
description String M A longer description of the tariff property. Good for further explanation as part of a customer “questionnaire”
dataType String M The data type of this property. Possible values are string, choice, boolean, date, decimal, integer, formula, demand
propertyTypes String M The category of property. Possible values are APPLICABILITY, RATE_CRITERIA, BENEFIT, DATA_REPUTATION, SERVICE_TERMS
operator String   The mathematical operator associated with this property’s value, where applicable.
propertyValue String   If applicable the specific value of this property.
minValue String   If applicable the minimum value of this property.
maxValue String   If applicable the maximum value of this property.
choices Array of Choices   The possible choices for this array
formulaDetail String   If this property is a FORMULA type, the formula details will be in this field.
isDefault Boolean   Whether the value of this Property is the default value.

Here’s an example in JSON of a fully populated tariff, containing tariff rates and tariff rate bands:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
{
	"tariffId":512,
	"masterTariffId":512,
	"priorTariffId":null,
	"lseId":2756,
	"lseName":"Georgia Power Co",
	"distributionLseId":null,
	"tariffCode":"R-17",
	"tariffName":"Residential Service",
	"tariffType":"DEFAULT",
	"customerClass":"RESIDENTIAL",
	"territoryId":3114,
	"effectiveDate":"2011-03-01T00:00:00.000-0800",
	"endDate":null,
	"isActive":true,
	"hasNetMetering":true,
	"minMonthlyConsumption":null,
	"maxMonthlyConsumption":null,
	"minMonthlyDemand":null,
	"maxMonthlyDemand":null,
	"billingPeriod":"MONTHLY",
	"properties":null,
	"timeZone":"US/Eastern",
	"currency":"USD",
	"rates":[
    {
       "tariffRateId":2734,
       "tariffId":512,
       "riderId":null,
       "tariffSequenceNumber":0,
       "rateGroupName":"Basic Service Charge",
       "rateName":"Basic Service Charge",
       "territory":null,
       "season":null,
       "timeOfUse":null,
       "chargeType":"FIXED_PRICE",
       "chargePeriod":"MONTHLY",
       "quantityKey":null,
       "applicabilityKey":null,
       "variableLimitKey":null,
       "rateBands":[
          {
             "tariffRateBandId":3258,
             "tariffRateId":2734,
             "rateSequenceNumber":1,
             "hasConsumptionLimit":false,
             "consumptionUpperLimit":null,
             "hasDemandLimit":false,
             "demandUpperLimit":null,
             "hasPropertyLimit":false,
             "propertyUpperLimit":null,
             "applicabilityValue":null,
             "calculationFactor":null,
             "rateAmount":.090000,
             "rateUnit":"COST_PER_UNIT",
             "isCredit":false
          }
       ]
    },
    {
       "tariffRateId":2735,
       "tariffId":512,
       "riderId":null,
       "tariffSequenceNumber":1,
       "rateGroupName":"Energy Charges",
       "rateName":"Winter Energy Charges",
       "territory":null,
       "season":{
          "seasonId":314,
          "lseId":2756,
          "seasonGroupId":3,
          "seasonName":"Winter",
          "seasonFromMonth":10,
          "seasonFromDay":1,
          "seasonToMonth":5,
          "seasonToDay":31
       },
       "timeOfUse":null,
       "chargeType":"CONSUMPTION_BASED",
       "chargePeriod":"MONTHLY",
       "quantityKey":null,
       "applicabilityKey":null,
       "variableLimitKey":null,
       "rateBands":[
          {
             "tariffRateBandId":3259,
             "tariffRateId":2735,
             "rateSequenceNumber":1,
             "hasConsumptionLimit":true,
             "consumptionUpperLimit":650.0,
             "hasDemandLimit":false,
             "demandUpperLimit":null,
             "hasPropertyLimit":false,
             "propertyUpperLimit":null,
             "applicabilityValue":null,
             "calculationFactor":null,
             "rateAmount":.050633,
             "rateUnit":"COST_PER_UNIT",
             "isCredit":false
          },
          {
             "tariffRateBandId":3260,
             "tariffRateId":2735,
             "rateSequenceNumber":2,
             "hasConsumptionLimit":true,
             "consumptionUpperLimit":1000.0,
             "hasDemandLimit":false,
             "demandUpperLimit":null,
             "hasPropertyLimit":false,
             "propertyUpperLimit":null,
             "applicabilityValue":null,
             "calculationFactor":null,
             "rateAmount":.043443,
             "rateUnit":"COST_PER_UNIT",
             "isCredit":false
          },
          {
             "tariffRateBandId":3261,
             "tariffRateId":2735,
             "rateSequenceNumber":3,
             "hasConsumptionLimit":true,
             "consumptionUpperLimit":null,
             "hasDemandLimit":false,
             "demandUpperLimit":null,
             "hasPropertyLimit":false,
             "propertyUpperLimit":null,
             "applicabilityValue":null,
             "calculationFactor":null,
             "rateAmount":.042647,
             "rateUnit":"COST_PER_UNIT",
             "isCredit":false
          }
       ]
    },
 ]
}

Get a List of Tariffs

This allows you to search for a set of tariffs and get them back as a list of tariff objects in the standard response format.

Resource URI

GET /rest/public/tariffs

Request Parameters

Along with the standard pagination parameters, searching and sorting parameters, and the required security parameters, the following parameters are available as part of the request:

Name Type Description
lseId Long Filter tariffs for a specific LSE (Optional)
masterTariffId Long If specified, all versions of a tariff belonging to the master tariff Id are returned. (Optional)
effectiveOn DateTime Only tariffs that are effective on this date (Optional)
openOn Date Only tariffs that were open (i.e. were not closed to new customers) on this date (Optional) See example
isActive Boolean Only the current, active tariff version for the LSE or master tariff Id. (Optional)
fromDateTime DateTime Only include tariffs that are effective on or after this date (Optional)
toDateTime DateTime Only include tariffs that are effective on or before this date (Optional)
customerClasses String Comma separated string that indicates the customer classes to include. Choices are: RESIDENTIAL, GENERAL, SPECIAL_USE (Optional)
chargeTypes String Comma separated string that indicates the charge types to include. Choices are: FIXED_PRICE, CONSUMPTION_BASED, DEMAND_BASED, QUANTITY, MINIMUM, TAX, NET_EXCESS_GENERATION (Optional)
tariffTypes String Comma separated string that indicates the tariff types to include. Choices are: DEFAULT, ALTERNATIVE, OPTIONAL_EXTRA, RIDER (Optional)
serviceTypes String Comma separated string that indicates the service types to include. Choices are: ELECTRICITY, SOLAR_PV, ‘GAS’ (Optional, default is all serviceTypes)
privacyFlags String Comma separated string that indicates the privacy flags types to include. Only applicable if you publish private tariffs. Choices are: PUBLIC, UNLISTED, PRIVATE (Optional)
zipCode String (Optional but Recommended) Use this to return just the Tariffs that are for this given location. Most Tariffs apply for a regional, not national, geography. When populating this field you should also populate country too.
postCode String Alias for zipCode. You can use either.
country ISO Country Code Use this when passing in a zipCode or postCode, and set it to the ISO Country Code of your zipCode since some countries use the same format (Optional)
addressString String An alternative to using zipCode and country. Use this if you do not have the address parsed out in your app, but instead have a long string. For the best results this string will contain a zipcode or post code, plus a country. If you do have the address split out it is better to use postCode and country (Optional)
riderId Long When set to the masterTariffId of a Rider, this will return all of the tariffs that the rider is used on (Optional)
populateProperties Boolean Populates the properties for the returned tariffs (Optional; defaults to false)
populateRates Boolean Populates the rate details for the returned tariffs (Optional; defaults to false)
populateDocuments Boolean Populates the document links for the returned tariffs (Optional; defaults to false)
accountId String DEPRECATED. Use account tariffs instead. The unique ID of the Account for which you want to find tariffs. Values passed in will override those from the account. For example, passing in zipCode=48322 will override whatever zipCode may be set on the Account. (Optional)
consumption Decimal Return tariffs which are eligible for this consumption amount (Optional)
demand Decimal Return tariffs which are eligible for this demand amount (Optional)
hasNetMetering Boolean Return tariffs which have or do not have any net metered tariff rates (Optional)
hasTimeOfUseRates Boolean Return tariffs which have or do not have any time-of-use rates (Optional)
hasTieredRates Boolean Return tariffs which have or do not have any tiered rates (Optional)
hasContractedRates Boolean Return tariffs which have or do not have any contracted rates (Optional)
bundleRates Boolean When true (false by default) the rates are summarized (bundled). Note that this only works for tariffs with a customerClass of RESIDENTIAL. (Optional)
applicableRatesOnly Boolean When true (false by default) rate applicability criteria will be applied to the rates. You’ll only get back rates that match the requests rate applicability values, or the default rate applicability value as set on the tariff. (Optional)
filterRiderRates Boolean Used in concert with populateRates = true, when filterRiderRates = true (false by default) rider rates will not be returned. However pointers to the riders will be returned. This is used primarily when using and existing tariff’s structure when creating private tariffs

Example 1 - Retrieving Residential Tariffs for a Zip Code

In this example we query for all residential tariffs in the 94115 zip code. We also request to populate the properties. In the response, the territoryId property is returned with a default value, which is the territoryId that matches the requested ZIP code. This is helpful when working with tariffs with rates that vary by geographic location.

GET /rest/public/tariffs?zipCode=94115&populateProperties=true&customerClasses=RESIDENTIAL
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
{
   "status":"success",
   "count":40,
   "type":"Tariff",
   "results":[
      {
         "tariffId":518,
         "masterTariffId":518,
         "priorTariffId":518,
         "lseId":734,
         "lseName":"Pacific Gas & Electric Co",
         "distributionLseId":null,
         "tariffCode":"E-7",
         "tariffName":"Residential Time-Of-Use Service E-7 (Basic)",
         "tariffType":"ALTERNATIVE",
         "customerClass":"RESIDENTIAL",
         "territoryId":807,
         "effectiveDate":"2011-03-01",
         "endDate":"2011-06-19",
         "timeZone":"US/Pacific",
         "isActive":false,
         "hasNetMetering":true,
         "minMonthlyConsumption":null,
         "maxMonthlyConsumption":null,
         "minMonthlyDemand":null,
         "maxMonthlyDemand":null,
         "billingPeriod":"MONTHLY",
         "currency":"USD",
         "properties":[
            {
               "keyName":"territoryId",
               "displayName":"TerritoryId",
               "family":"billing",
               "keyspace":"electricity",
               "description":"Territory id where tariff is operational",
               "dataType":"CHOICE",
               "choices":[
                  {
                     "value":"3542",
                     "displayValue":"Baseline Region Y"
                  },
                  {
                     "value":"3543",
                     "displayValue":"Baseline Region Z"
                  },
                  {
                     "value":"3540",
                     "displayValue":"Baseline Region W"
                  },
                  {
                     "value":"3541",
                     "displayValue":"Baseline Region X"
                  },
                  {
                     "value":"3538",
                     "displayValue":"Baseline Region T"
                  },
                  {
                     "value":"3539",
                     "displayValue":"Baseline Region V"
                  },
                  {
                     "value":"3536",
                     "displayValue":"Baseline Region R"
                  },
                  {
                     "value":"3537",
                     "displayValue":"Baseline Region S"
                  },
                  {
                     "value":"3535",
                     "displayValue":"Baseline Region Q"
                  },
                  {
                     "value":"3534",
                     "displayValue":"Baseline Region P"
                  }
               ],
               "propertyTypes":"RATE_CRITERIA",
               "operator":null,
               "propertyValue":"3538",
               "isDefault":true
            },
            {
               "keyName":"consumption",
               "displayName":"Consumption (kWh)",
               "family":"load",
               "keyspace":"electricity",
               "description":"Quantity in kWh of load that is used for a period of time",
               "dataType":"DECIMAL",
               "choices":[

               ],
               "propertyTypes":"RATE_CRITERIA",
               "operator":null,
               "isDefault":false
            }
         ]
      },

	  /* edited for length */

Example 2 - Excluding Closed Tariffs from Tariff Selection

Utilities may close a tariff to new customers and allow customers that are currently on the tariff to be grandfathered. Therefore, closed tariffs should typically be included in the pre-solar tariff list but does not need to be included in the post-solar tariff list unless the customer is currently on a closed tariff.

To exclude closed tariffs from the tariff list, add the openOn parameter to your Get Tariffs call:

GET /rest/public/tariffs?zipCode=93550&customerClasses=RESIDENTIAL&tariffTypes=DEFAULT,ALTERNATIVE&effectiveOn=2017-01-01&openOn=2017-01-01

Example 3 - Retrieving Tariffs that have a given rider

This example shows how to pass in the masterTariffId of a particular rider in order to see where that rider is used (what tariffs it is attached to).

GET /rest/public/tariffs/?riderId=3163711
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
{
    "status": "success",
    "count": 26,
    "type": "Tariff",
    "results": [
        {
            "tariffId": 386,
            "masterTariffId": 386,
            "tariffCode": "ET-1",
            "tariffName": "Residential - Time of Use, Time Advantage, 9pm - 9 am",
            "lseId": 2885,
            "lseName": "Arizona Public Service Co",
            "priorTariffId": 386,
            "tariffType": "ALTERNATIVE",
            "customerClass": "RESIDENTIAL",
            "customerCount": 292035,
            "customerLikelihood": 15.49,
            "territoryId": 3255,
            "effectiveDate": "2010-01-01",
            "endDate": "2012-07-01",
            "timeZone": "US/Arizona",
            "billingPeriod": "MONTHLY",
            "currency": "USD",
            "chargeTypes": "FIXED_PRICE,CONSUMPTION_BASED,QUANTITY,MINIMUM",
            "chargePeriod": "DAILY",
            "hasTimeOfUseRates": true,
            "hasTieredRates": true,
            "hasContractedRates": false,
            "hasRateApplicability": true,
            "isActive": false
        },
        {
            "tariffId": 3154455,
            "masterTariffId": 386,
            "tariffCode": "ET-1",
            "tariffName": "Residential - Time of Use, Time Advantage, 9pm - 9 am",
            "lseId": 2885,
            "lseName": "Arizona Public Service Co",
            "priorTariffId": 3154455,
            "tariffType": "ALTERNATIVE",
            "customerClass": "RESIDENTIAL",
            "customerCount": 292035,
            "customerLikelihood": 15.49,
            "territoryId": 3255,
            "effectiveDate": "2012-07-01",
            "endDate": "2013-03-01",
            "timeZone": "US/Arizona",
            "billingPeriod": "MONTHLY",
            "currency": "USD",
            "chargeTypes": "FIXED_PRICE,CONSUMPTION_BASED,QUANTITY,MINIMUM",
            "chargePeriod": "DAILY",
            "hasTimeOfUseRates": true,
            "hasTieredRates": true,
            "hasContractedRates": false,
            "hasRateApplicability": true,
            "isActive": false
        },
        {
            "tariffId": 3162814,
            "masterTariffId": 386,
            "tariffCode": "ET-1",
            "tariffName": "Residential - Time of Use, Time Advantage, 9pm - 9 am",
            "lseId": 2885,
            "lseName": "Arizona Public Service Co",
            "priorTariffId": 3162814,
            "tariffType": "ALTERNATIVE",
            "customerClass": "RESIDENTIAL",
            "customerCount": 292035,
            "customerLikelihood": 15.49,
            "territoryId": 3255,
            "effectiveDate": "2013-03-01",
            "endDate": "2017-08-19",
            "timeZone": "US/Arizona",
            "billingPeriod": "MONTHLY",
            "currency": "USD",
            "chargeTypes": "FIXED_PRICE,CONSUMPTION_BASED,QUANTITY,MINIMUM",
            "chargePeriod": "DAILY",
            "hasTimeOfUseRates": true,
            "hasTieredRates": true,
            "hasContractedRates": false,
            "hasRateApplicability": true,
            "isActive": false
        },
        {
            "tariffId": 3291746,
            "masterTariffId": 386,
            "tariffCode": "ET-1",
            "tariffName": "Residential - Time of Use, Time Advantage, 9pm - 9 am",
            "lseId": 2885,
            "lseName": "Arizona Public Service Co",
            "priorTariffId": 3154455,
            "tariffType": "ALTERNATIVE",
            "customerClass": "RESIDENTIAL",
            "customerCount": 292035,
            "customerLikelihood": 15.49,
            "territoryId": 3255,
            "effectiveDate": "2017-08-19",
            "endDate": null,
            "timeZone": "US/Arizona",
            "billingPeriod": "MONTHLY",
            "currency": "USD",
            "chargeTypes": "FIXED_PRICE,CONSUMPTION_BASED,QUANTITY,MINIMUM",
            "chargePeriod": "DAILY",
            "hasTimeOfUseRates": true,
            "hasTieredRates": true,
            "hasContractedRates": false,
            "hasRateApplicability": true,
            "isActive": true
        },
        {
            "tariffId": 391,
            "masterTariffId": 391,
            "tariffCode": "ET-2",
            "tariffName": "Residential - Time of Use, Time Advantage, 7PM-Noon",
            "lseId": 2885,
            "lseName": "Arizona Public Service Co",
            "priorTariffId": 391,
            "tariffType": "ALTERNATIVE",
            "customerClass": "RESIDENTIAL",
            "customerCount": 122463,
            "customerLikelihood": 6.49,
            "territoryId": 3255,
            "effectiveDate": "2010-01-01",
            "endDate": "2012-07-01",
            "timeZone": "US/Arizona",
            "billingPeriod": "MONTHLY",
            "currency": "USD",
            "chargeTypes": "FIXED_PRICE,CONSUMPTION_BASED,QUANTITY,MINIMUM",
            "chargePeriod": "DAILY",
            "hasTimeOfUseRates": true,
            "hasTieredRates": true,
            "hasContractedRates": false,
            "hasRateApplicability": true,
            "isActive": false
        },
        {
            "tariffId": 83896,
            "masterTariffId": 391,
            "tariffCode": "ET-2",
            "tariffName": "Residential - Time of Use, Time Advantage, 7PM-Noon ",
            "lseId": 2885,
            "lseName": "Arizona Public Service Co",
            "priorTariffId": 83896,
            "tariffType": "ALTERNATIVE",
            "customerClass": "RESIDENTIAL",
            "customerCount": 122463,
            "customerLikelihood": 6.49,
            "territoryId": 3255,
            "effectiveDate": "2012-07-01",
            "endDate": "2013-03-01",
            "timeZone": "US/Arizona",
            "billingPeriod": "MONTHLY",
            "currency": "USD",
            "chargeTypes": "FIXED_PRICE,CONSUMPTION_BASED,QUANTITY,MINIMUM",
            "chargePeriod": "DAILY",
            "hasTimeOfUseRates": true,
            "hasTieredRates": true,
            "hasContractedRates": false,
            "hasRateApplicability": true,
            "isActive": false
        },
        {
            "tariffId": 3154452,
            "masterTariffId": 391,
            "tariffCode": "ET-2",
            "tariffName": "Residential - Time of Use, Time Advantage, 7PM-Noon",
            "lseId": 2885,
            "lseName": "Arizona Public Service Co",
            "priorTariffId": 3154452,
            "tariffType": "ALTERNATIVE",
            "customerClass": "RESIDENTIAL",
            "customerCount": 122463,
            "customerLikelihood": 6.49,
            "territoryId": 3255,
            "effectiveDate": "2013-03-01",
            "endDate": "2017-08-19",
            "timeZone": "US/Arizona",
            "billingPeriod": "MONTHLY",
            "currency": "USD",
            "chargeTypes": "FIXED_PRICE,CONSUMPTION_BASED,QUANTITY,MINIMUM",
            "chargePeriod": "DAILY",
            "hasTimeOfUseRates": true,
            "hasTieredRates": true,
            "hasContractedRates": false,
            "hasRateApplicability": true,
            "isActive": false
        },
        {
            "tariffId": 3291747,
            "masterTariffId": 391,
            "tariffCode": "ET-2",
            "tariffName": "Residential - Time of Use, Time Advantage, 7PM-Noon",
            "lseId": 2885,
            "lseName": "Arizona Public Service Co",
            "priorTariffId": 3154452,
            "tariffType": "ALTERNATIVE",
            "customerClass": "RESIDENTIAL",
            "customerCount": 122463,
            "customerLikelihood": 6.49,
            "territoryId": 3255,
            "effectiveDate": "2017-08-19",
            "endDate": null,
            "timeZone": "US/Arizona",
            "billingPeriod": "MONTHLY",
            "currency": "USD",
            "chargeTypes": "FIXED_PRICE,CONSUMPTION_BASED,QUANTITY,MINIMUM",
            "chargePeriod": "DAILY",
            "hasTimeOfUseRates": true,
            "hasTieredRates": true,
            "hasContractedRates": false,
            "hasRateApplicability": true,
            "isActive": true
        },
        {
            "tariffId": 80886,
            "masterTariffId": 80886,
            "tariffCode": "ECT-1R",
            "tariffName": "Residential - Time of Use, Combined Advantage, Demand, 9pm - 9 am (Closed)",
            "lseId": 2885,
            "lseName": "Arizona Public Service Co",
            "priorTariffId": 80886,
            "tariffType": "ALTERNATIVE",
            "customerClass": "RESIDENTIAL",
            "customerCount": 47173,
            "customerLikelihood": 2.5,
            "territoryId": 3255,
            "effectiveDate": "2010-01-01",
            "endDate": "2012-07-01",
            "timeZone": "US/Arizona",
            "billingPeriod": "MONTHLY",
            "currency": "USD",
            "chargeTypes": "FIXED_PRICE,CONSUMPTION_BASED,DEMAND_BASED,QUANTITY,MINIMUM",
            "chargePeriod": "DAILY",
            "hasTimeOfUseRates": true,
            "hasTieredRates": true,
            "hasContractedRates": false,
            "hasRateApplicability": true,
            "isActive": false
        },
        {
            "tariffId": 3154454,
            "masterTariffId": 80886,
            "tariffCode": "ECT-1R",
            "tariffName": "Residential - Time of Use, Combined Advantage, Demand, 9pm - 9 am (Closed)",
            "lseId": 2885,
            "lseName": "Arizona Public Service Co",
            "priorTariffId": 3154454,
            "tariffType": "ALTERNATIVE",
            "customerClass": "RESIDENTIAL",
            "customerCount": 47173,
            "customerLikelihood": 2.5,
            "territoryId": 3255,
            "effectiveDate": "2012-07-01",
            "endDate": "2013-03-01",
            "timeZone": "US/Arizona",
            "billingPeriod": "MONTHLY",
            "currency": "USD",
            "chargeTypes": "FIXED_PRICE,CONSUMPTION_BASED,DEMAND_BASED,QUANTITY,MINIMUM",
            "chargePeriod": "DAILY",
            "hasTimeOfUseRates": true,
            "hasTieredRates": true,
            "hasContractedRates": false,
            "hasRateApplicability": true,
            "isActive": false
        },
        {
            "tariffId": 3162813,
            "masterTariffId": 80886,
            "tariffCode": "ECT-1R",
            "tariffName": "Residential - Time of Use, Combined Advantage, Demand, 9pm - 9 am (Closed)",
            "lseId": 2885,
            "lseName": "Arizona Public Service Co",
            "priorTariffId": 3162813,
            "tariffType": "ALTERNATIVE",
            "customerClass": "RESIDENTIAL",
            "customerCount": 47173,
            "customerLikelihood": 2.5,
            "territoryId": 3255,
            "effectiveDate": "2013-03-01",
            "endDate": "2017-08-19",
            "timeZone": "US/Arizona",
            "billingPeriod": "MONTHLY",
            "currency": "USD",
            "chargeTypes": "FIXED_PRICE,CONSUMPTION_BASED,DEMAND_BASED,QUANTITY,MINIMUM",
            "chargePeriod": "DAILY",
            "hasTimeOfUseRates": true,
            "hasTieredRates": true,
            "hasContractedRates": false,
            "hasRateApplicability": true,
            "isActive": false
        },
        {
            "tariffId": 3162813,
            "masterTariffId": 80886,
            "tariffCode": "ECT-1R",
            "tariffName": "Residential - Time of Use, Combined Advantage, Demand, 9pm - 9 am (Closed)",
            "lseId": 2885,
            "lseName": "Arizona Public Service Co",
            "priorTariffId": 3162813,
            "tariffType": "ALTERNATIVE",
            "customerClass": "RESIDENTIAL",
            "customerCount": 47173,
            "customerLikelihood": 2.5,
            "territoryId": 3255,
            "effectiveDate": "2013-03-01",
            "endDate": "2017-08-19",
            "timeZone": "US/Arizona",
            "billingPeriod": "MONTHLY",
            "currency": "USD",
            "chargeTypes": "FIXED_PRICE,CONSUMPTION_BASED,DEMAND_BASED,QUANTITY,MINIMUM",
            "chargePeriod": "DAILY",
            "hasTimeOfUseRates": true,
            "hasTieredRates": true,
            "hasContractedRates": false,
            "hasRateApplicability": true,
            "isActive": false
        },
        {
            "tariffId": 84750,
            "masterTariffId": 408,
            "tariffCode": "ECT-2",
            "tariffName": "Residential - Time of Use, Combined Advantage, Demand,  7PM-Noon ",
            "lseId": 2885,
            "lseName": "Arizona Public Service Co",
            "priorTariffId": 84750,
            "tariffType": "ALTERNATIVE",
            "customerClass": "RESIDENTIAL",
            "customerCount": 37882,
            "customerLikelihood": 2.01,
            "territoryId": 3255,
            "effectiveDate": "2012-07-01",
            "endDate": "2013-03-01",
            "timeZone": "US/Arizona",
            "billingPeriod": "MONTHLY",
            "currency": "USD",
            "chargeTypes": "FIXED_PRICE,CONSUMPTION_BASED,DEMAND_BASED,QUANTITY,MINIMUM",
            "chargePeriod": "DAILY",
            "hasTimeOfUseRates": true,
            "hasTieredRates": true,
            "hasContractedRates": false,
            "hasRateApplicability": true,
            "isActive": false
        },
        {
            "tariffId": 80883,
            "masterTariffId": 80883,
            "tariffCode": "ECT-1R",
            "tariffName": "Residential - Low-Income, Time of Use, Combined Advantage, Demand",
            "lseId": 2885,
            "lseName": "Arizona Public Service Co",
            "tariffType": "ALTERNATIVE",
            "customerClass": "RESIDENTIAL",
            "customerCount": 998,
            "customerLikelihood": 0.05,
            "territoryId": 3255,
            "effectiveDate": "2010-01-01",
            "endDate": null,
            "timeZone": "US/Arizona",
            "billingPeriod": "MONTHLY",
            "currency": "USD",
            "chargeTypes": "FIXED_PRICE,CONSUMPTION_BASED,DEMAND_BASED,QUANTITY,MINIMUM",
            "chargePeriod": "DAILY",
            "hasTimeOfUseRates": true,
            "hasTieredRates": true,
            "hasContractedRates": false,
            "hasRateApplicability": true,
            "isActive": true
        },
        {
            "tariffId": 409,
            "masterTariffId": 409,
            "tariffCode": "ET-SP",
            "tariffName": "Residential - Time of Use, Time Advantage, Super Peak, 7PM-Noon",
            "lseId": 2885,
            "lseName": "Arizona Public Service Co",
            "priorTariffId": 409,
            "tariffType": "ALTERNATIVE",
            "customerClass": "RESIDENTIAL",
            "customerCount": 108,
            "customerLikelihood": 0.01,
            "territoryId": 3255,
            "effectiveDate": "2010-01-01",
            "endDate": "2012-07-01",
            "timeZone": "US/Arizona",
            "billingPeriod": "MONTHLY",
            "currency": "USD",
            "chargeTypes": "FIXED_PRICE,CONSUMPTION_BASED,QUANTITY,MINIMUM",
            "chargePeriod": "DAILY",
            "hasTimeOfUseRates": true,
            "hasTieredRates": true,
            "hasContractedRates": false,
            "hasRateApplicability": true,
            "isActive": false
        },
        {
            "tariffId": 3154453,
            "masterTariffId": 409,
            "tariffCode": "ET-SP",
            "tariffName": "Residential - Time of Use, Time Advantage, Super Peak, 7PM-Noon",
            "lseId": 2885,
            "lseName": "Arizona Public Service Co",
            "priorTariffId": 3154453,
            "tariffType": "ALTERNATIVE",
            "customerClass": "RESIDENTIAL",
            "customerCount": 108,
            "customerLikelihood": 0.01,
            "territoryId": 3255,
            "effectiveDate": "2012-07-01",
            "endDate": "2013-03-01",
            "timeZone": "US/Arizona",
            "billingPeriod": "MONTHLY",
            "currency": "USD",
            "chargeTypes": "FIXED_PRICE,CONSUMPTION_BASED,QUANTITY,MINIMUM",
            "chargePeriod": "DAILY",
            "hasTimeOfUseRates": true,
            "hasTieredRates": true,
            "hasContractedRates": false,
            "hasRateApplicability": true,
            "isActive": false
        },
        {
            "tariffId": 3162817,
            "masterTariffId": 409,
            "tariffCode": "ET-SP",
            "tariffName": "Residential - Time of Use, Time Advantage, Super Peak, 7PM-Noon",
            "lseId": 2885,
            "lseName": "Arizona Public Service Co",
            "priorTariffId": 3154453,
            "tariffType": "ALTERNATIVE",
            "customerClass": "RESIDENTIAL",
            "customerCount": 108,
            "customerLikelihood": 0.01,
            "territoryId": 3255,
            "effectiveDate": "2013-03-01",
            "endDate": null,
            "timeZone": "US/Arizona",
            "billingPeriod": "MONTHLY",
            "currency": "USD",
            "chargeTypes": "FIXED_PRICE,CONSUMPTION_BASED,QUANTITY,MINIMUM",
            "chargePeriod": "DAILY",
            "hasTimeOfUseRates": true,
            "hasTieredRates": true,
            "hasContractedRates": false,
            "hasRateApplicability": true,
            "isActive": true
        },
        {
            "tariffId": 405,
            "masterTariffId": 405,
            "tariffCode": "E-12",
            "tariffName": "Residential - Low Income ",
            "lseId": 2885,
            "lseName": "Arizona Public Service Co",
            "priorTariffId": 405,
            "tariffType": "ALTERNATIVE",
            "customerClass": "RESIDENTIAL",
            "customerCount": 1,
            "customerLikelihood": 0,
            "territoryId": 3255,
            "effectiveDate": "2010-01-01",
            "endDate": "2012-07-01",
            "timeZone": "US/Arizona",
            "billingPeriod": "MONTHLY",
            "currency": "USD",
            "chargeTypes": "FIXED_PRICE,CONSUMPTION_BASED,QUANTITY,MINIMUM",
            "chargePeriod": "DAILY",
            "hasTimeOfUseRates": false,
            "hasTieredRates": true,
            "hasContractedRates": false,
            "hasRateApplicability": true,
            "isActive": false
        },
        {
            "tariffId": 407,
            "masterTariffId": 407,
            "tariffCode": "ECT-2",
            "tariffName": "Residential - Low Income, Time of Use, Combined Advantage, Demand, 7PM-Noon ",
            "lseId": 2885,
            "lseName": "Arizona Public Service Co",
            "priorTariffId": 407,
            "tariffType": "ALTERNATIVE",
            "customerClass": "RESIDENTIAL",
            "customerCount": 1,
            "customerLikelihood": 0,
            "territoryId": 3255,
            "effectiveDate": "2010-01-01",
            "endDate": "2012-07-01",
            "timeZone": "US/Arizona",
            "billingPeriod": "MONTHLY",
            "currency": "USD",
            "chargeTypes": "FIXED_PRICE,CONSUMPTION_BASED,DEMAND_BASED,QUANTITY,MINIMUM",
            "chargePeriod": "DAILY",
            "hasTimeOfUseRates": true,
            "hasTieredRates": true,
            "hasContractedRates": false,
            "hasRateApplicability": true,
            "isActive": false
        },
        {
            "tariffId": 83900,
            "masterTariffId": 405,
            "tariffCode": "E-12",
            "tariffName": "Residential - Low Income",
            "lseId": 2885,
            "lseName": "Arizona Public Service Co",
            "priorTariffId": 83900,
            "tariffType": "ALTERNATIVE",
            "customerClass": "RESIDENTIAL",
            "customerCount": 1,
            "customerLikelihood": 0,
            "territoryId": 3255,
            "effectiveDate": "2012-07-01",
            "endDate": "2013-03-01",
            "timeZone": "US/Arizona",
            "billingPeriod": "MONTHLY",
            "currency": "USD",
            "chargeTypes": "FIXED_PRICE,CONSUMPTION_BASED,QUANTITY,MINIMUM",
            "chargePeriod": "DAILY",
            "hasTimeOfUseRates": false,
            "hasTieredRates": true,
            "hasContractedRates": false,
            "hasRateApplicability": true,
            "isActive": false
        },
        {
            "tariffId": 83901,
            "masterTariffId": 407,
            "tariffCode": "ECT-2",
            "tariffName": "Residential - Low Income, Time of Use, Combined Advantage, Demand, 7PM-Noon",
            "lseId": 2885,
            "lseName": "Arizona Public Service Co",
            "priorTariffId": 83901,
            "tariffType": "ALTERNATIVE",
            "customerClass": "RESIDENTIAL",
            "customerCount": 1,
            "customerLikelihood": 0,
            "territoryId": 3255,
            "effectiveDate": "2012-07-01",
            "endDate": "2013-03-01",
            "timeZone": "US/Arizona",
            "billingPeriod": "MONTHLY",
            "currency": "USD",
            "chargeTypes": "FIXED_PRICE,CONSUMPTION_BASED,DEMAND_BASED,QUANTITY,MINIMUM",
            "chargePeriod": "DAILY",
            "hasTimeOfUseRates": true,
            "hasTieredRates": true,
            "hasContractedRates": false,
            "hasRateApplicability": true,
            "isActive": false
        },
        {
            "tariffId": 3154456,
            "masterTariffId": 389,
            "tariffCode": "E-12",
            "tariffName": "Residential",
            "lseId": 2885,
            "lseName": "Arizona Public Service Co",
            "priorTariffId": 3154456,
            "tariffType": "DEFAULT",
            "customerClass": "RESIDENTIAL",
            "customerCount": 1,
            "customerLikelihood": 0,
            "territoryId": 3255,
            "effectiveDate": "2013-03-01",
            "endDate": "2017-08-19",
            "timeZone": "US/Arizona",
            "billingPeriod": "MONTHLY",
            "currency": "USD",
            "chargeTypes": "FIXED_PRICE,CONSUMPTION_BASED,QUANTITY,MINIMUM",
            "chargePeriod": "DAILY",
            "hasTimeOfUseRates": false,
            "hasTieredRates": true,
            "hasContractedRates": false,
            "hasRateApplicability": true,
            "isActive": false
        },
        {
            "tariffId": 3162816,
            "masterTariffId": 405,
            "tariffCode": "E-12",
            "tariffName": "Residential - Low Income ",
            "lseId": 2885,
            "lseName": "Arizona Public Service Co",
            "priorTariffId": 3162816,
            "tariffType": "ALTERNATIVE",
            "customerClass": "RESIDENTIAL",
            "customerCount": 1,
            "customerLikelihood": 0,
            "territoryId": 3255,
            "effectiveDate": "2013-03-01",
            "endDate": "2017-08-19",
            "timeZone": "US/Arizona",
            "billingPeriod": "MONTHLY",
            "currency": "USD",
            "chargeTypes": "FIXED_PRICE,CONSUMPTION_BASED,QUANTITY,MINIMUM",
            "chargePeriod": "DAILY",
            "hasTimeOfUseRates": false,
            "hasTieredRates": true,
            "hasContractedRates": false,
            "hasRateApplicability": true,
            "isActive": false
        },
        {
            "tariffId": 3162818,
            "masterTariffId": 407,
            "tariffCode": "ECT-2",
            "tariffName": "Residential - Low Income, Time of Use, Combined Advantage, Demand, 7PM-Noon",
            "lseId": 2885,
            "lseName": "Arizona Public Service Co",
            "priorTariffId": 3162818,
            "tariffType": "ALTERNATIVE",
            "customerClass": "RESIDENTIAL",
            "customerCount": 1,
            "customerLikelihood": 0,
            "territoryId": 3255,
            "effectiveDate": "2013-03-01",
            "endDate": "2017-08-19",
            "timeZone": "US/Arizona",
            "billingPeriod": "MONTHLY",
            "currency": "USD",
            "chargeTypes": "FIXED_PRICE,CONSUMPTION_BASED,DEMAND_BASED,QUANTITY,MINIMUM",
            "chargePeriod": "DAILY",
            "hasTimeOfUseRates": true,
            "hasTieredRates": true,
            "hasContractedRates": false,
            "hasRateApplicability": true,
            "isActive": false
        },
        {
            "tariffId": 3291759,
            "masterTariffId": 405,
            "tariffCode": "E-12",
            "tariffName": "Residential - Low Income",
            "lseId": 2885,
            "lseName": "Arizona Public Service Co",
            "priorTariffId": 3162816,
            "tariffType": "ALTERNATIVE",
            "customerClass": "RESIDENTIAL",
            "customerCount": 1,
            "customerLikelihood": 0,
            "territoryId": 3255,
            "effectiveDate": "2017-08-19",
            "endDate": null,
            "timeZone": "US/Arizona",
            "billingPeriod": "MONTHLY",
            "currency": "USD",
            "chargeTypes": "FIXED_PRICE,CONSUMPTION_BASED,QUANTITY,MINIMUM",
            "chargePeriod": "DAILY",
            "hasTimeOfUseRates": false,
            "hasTieredRates": true,
            "hasContractedRates": false,
            "hasRateApplicability": true,
            "isActive": true
        }
    ],
    "pageCount": 25,
    "pageStart": 0
}

Get One Tariff

This is how you retrieve a particular tariff.

Resource URI

GET /rest/public/tariffs/{masterTariffId}

Request Parameters

Along with the required security parameters, the following parameters are available as part of the request:

Name Type Description
populateProperties Boolean Optional. Populates the properties for the Tariff
populateRates Boolean Optional. Populates the rate details, seasons, and TOU definitions for this Tariff
populateDocuments Boolean Optional. Populates the list of tariff book documents for the Tariff
effectiveOn DateTime Optional. Will only return the version of this tariff that is effective as of this date if populated.
territoryId Long Optional. Will only include this territory’s rates and rates that apply to all territories if passed in. Note that rate filtering only occurs when applicableRatesOnly is set to true
bundleRates Boolean When true (false by default) the rates are summarized (bundled). Note that this only works for tariffs with a customerClass of RESIDENTIAL. (Optional)
applicableRatesOnly Boolean When true (false by default) rate applicability criteria will be applied to the rates. You’ll only get back rates that match the requests rate applicability values, or the default rate applicability value as set on the tariff. (Optional)
lookupVariableRates Boolean When true (false by default) any variable price tariff rates will be looked up and returned on the response. Can work in conjunction with a passed in date range. If used with effectiveOn, the date range returned will be the effectiveOn through one month later. (Optional).

Example 1 - Retrieve Tariff with Tariff Properties

GET /rest/public/tariffs/809?populateProperties=true
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
{
    "status": "success",
    "count": 1,
    "type": "Tariff",
    "results": [
        {
            "tariffId": 3298025,
            "masterTariffId": 809,
            "tariffCode": "EL1",
            "tariffName": "Residential and Religious",
            "lseId": 2252,
            "lseName": "Consolidated Edison Co-NY Inc",
            "priorTariffId": 3282853,
            "tariffType": "DEFAULT",
            "customerClass": "RESIDENTIAL",
            "customerCount": 2790056,
            "customerLikelihood": null,
            "territoryId": 2533,
            "effectiveDate": "2018-01-01",
            "endDate": null,
            "timeZone": "US/Eastern",
            "billingPeriod": "MONTHLY",
            "currency": "USD",
            "chargeTypes": "FIXED_PRICE,CONSUMPTION_BASED,MINIMUM",
            "chargePeriod": "MONTHLY",
            "hasTimeOfUseRates": false,
            "hasTieredRates": true,
            "hasContractedRates": true,
            "hasRateApplicability": true,
            "isActive": true,
            "properties": [
                {
                    "keyName": "consumption",
                    "quantityKey": null,
                    "displayName": "Consumption (kWh)",
                    "family": "load",
                    "keyspace": "electricity",
                    "description": "Quantity in kWh of load that is used for a period of time",
                    "dataType": "DECIMAL",
                    "propertyTypes": "RATE_CRITERIA",
                    "operator": "",
                    "isDefault": false
                },
                {
                    "keyName": "lowIncomeCustomer",
                    "quantityKey": null,
                    "displayName": "Is Low Income Customer",
                    "family": "customerStatus",
                    "keyspace": "customer",
                    "description": "Customer who are enrolled in the Company's low-income program. To qualify for the low-income program, a Customer must be enrolled in the Direct Vendor or Utility Guarantee Program and/or receiving benefits under Supplemental Security Income, Temporary Assistance to Needy Persons/Families, Safety Net Assistance, or Food Stamps, or have received a Home Energy Assistance Program grant in the preceding 12 months.",
                    "dataType": "BOOLEAN",
                    "propertyTypes": "RATE_CRITERIA",
                    "operator": "=",
                    "propertyValue": "false",
                    "isDefault": true
                },
                {
                    "keyName": "territoryId",
                    "quantityKey": null,
                    "displayName": "Territory",
                    "family": "billing",
                    "keyspace": "electricity",
                    "description": "Territory where tariff is operational",
                    "dataType": "CHOICE",
                    "propertyTypes": "RATE_CRITERIA",
                    "operator": "",
                    "choices": [
                        {
                            "displayValue": "Zone H",
                            "value": "3632",
                            "dataValue": "3632",
                            "likelihood": null
                        },
                        {
                            "displayValue": "Zone I",
                            "value": "3633",
                            "dataValue": "3633",
                            "likelihood": null
                        },
                        {
                            "displayValue": "Zone J",
                            "value": "3634",
                            "dataValue": "3634",
                            "likelihood": null
                        }
                    ],
                    "isDefault": false
                },
                {
                    "keyName": "chargeClass",
                    "quantityKey": null,
                    "displayName": "Charge Class Type",
                    "family": "service",
                    "keyspace": "electricity",
                    "description": "The tariff has rates with the following charge class.",
                    "dataType": "CHOICE",
                    "propertyTypes": "SERVICE_TERMS",
                    "operator": "=",
                    "propertyValue": "TRANSMISSION, SUPPLY, CONTRACTED, DISTRIBUTION",
                    "choices": [
                        {
                            "displayValue": "Transmission",
                            "value": "1",
                            "dataValue": "1",
                            "likelihood": null
                        },
                        {
                            "displayValue": "Distribution",
                            "value": "2",
                            "dataValue": "2",
                            "likelihood": null
                        },
                        {
                            "displayValue": "Supply",
                            "value": "4",
                            "dataValue": "4",
                            "likelihood": null
                        },
                        {
                            "displayValue": "Tax",
                            "value": "8",
                            "dataValue": "8",
                            "likelihood": null
                        },
                        {
                            "displayValue": "Other",
                            "value": "16",
                            "dataValue": "16",
                            "likelihood": null
                        },
                        {
                            "displayValue": "Contracted",
                            "value": "32",
                            "dataValue": "32",
                            "likelihood": null
                        }
                    ],
                    "isDefault": false
                }
            ]
        }
    ]
}

Example 2 - Retrieve Tariff with Tariff Rates Populated

GET /rest/public/tariffs/823?populateProperties=true&populateRates=true&lookupVariableRates=true
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
1001
1002
1003
1004
1005
1006
1007
1008
1009
1010
1011
1012
1013
1014
1015
1016
1017
1018
1019
1020
1021
1022
1023
1024
1025
1026
1027
1028
1029
1030
1031
1032
1033
1034
1035
1036
1037
1038
1039
1040
1041
1042
1043
1044
1045
1046
1047
1048
1049
1050
1051
1052
1053
1054
1055
1056
1057
1058
1059
1060
1061
1062
1063
1064
1065
1066
1067
1068
1069
1070
1071
1072
1073
1074
1075
1076
1077
1078
1079
1080
1081
1082
1083
1084
1085
1086
1087
1088
1089
1090
1091
1092
1093
1094
1095
1096
1097
1098
1099
1100
1101
1102
1103
1104
1105
{
    "status": "success",
    "count": 1,
    "type": "Tariff",
    "results": [
        {
            "tariffId": 3284480,
            "masterTariffId": 823,
            "tariffCode": "R-1",
            "tariffName": "Residential",
            "lseId": 310,
            "lseName": "National Grid - Massachusetts",
            "priorTariffId": 3279572,
            "tariffType": "DEFAULT",
            "customerClass": "RESIDENTIAL",
            "customerCount": 1006774,
            "customerLikelihood": null,
            "territoryId": 328,
            "effectiveDate": "2017-05-01",
            "endDate": null,
            "timeZone": "US/Eastern",
            "billingPeriod": "MONTHLY",
            "currency": "USD",
            "chargeTypes": "FIXED_PRICE,CONSUMPTION_BASED,MINIMUM",
            "chargePeriod": "MONTHLY",
            "hasTimeOfUseRates": false,
            "hasTieredRates": false,
            "hasContractedRates": true,
            "hasRateApplicability": true,
            "isActive": true,
            "properties": [
                {
                    "keyName": "basicServiceChargeType",
                    "quantityKey": null,
                    "displayName": "Basic Service Charge Type",
                    "family": "billing",
                    "keyspace": "electricity",
                    "description": "Basic Service Charge Type can be either Fixed or Variable rate.",
                    "dataType": "CHOICE",
                    "propertyTypes": "RATE_CRITERIA",
                    "operator": "=",
                    "propertyValue": "Fixed",
                    "choices": [
                        {
                            "displayValue": "Fixed",
                            "value": "Fixed",
                            "dataValue": "Fixed",
                            "likelihood": null
                        },
                        {
                            "displayValue": "Variable",
                            "value": "Variable",
                            "dataValue": "Variable",
                            "likelihood": null
                        }
                    ],
                    "isDefault": true
                },
                {
                    "keyName": "consumption",
                    "quantityKey": null,
                    "displayName": "Consumption (kWh)",
                    "family": "load",
                    "keyspace": "electricity",
                    "description": "Quantity in kWh of load that is used for a period of time",
                    "dataType": "DECIMAL",
                    "propertyTypes": "RATE_CRITERIA",
                    "operator": "",
                    "isDefault": false
                },
                {
                    "keyName": "chargeClass",
                    "quantityKey": null,
                    "displayName": "Charge Class Type",
                    "family": "service",
                    "keyspace": "electricity",
                    "description": "The tariff has rates with the following charge class.",
                    "dataType": "CHOICE",
                    "propertyTypes": "SERVICE_TERMS",
                    "operator": "=",
                    "propertyValue": "SUPPLY, CONTRACTED, TRANSMISSION, DISTRIBUTION",
                    "choices": [
                        {
                            "displayValue": "Transmission",
                            "value": "1",
                            "dataValue": "1",
                            "likelihood": null
                        },
                        {
                            "displayValue": "Distribution",
                            "value": "2",
                            "dataValue": "2",
                            "likelihood": null
                        },
                        {
                            "displayValue": "Supply",
                            "value": "4",
                            "dataValue": "4",
                            "likelihood": null
                        },
                        {
                            "displayValue": "Tax",
                            "value": "8",
                            "dataValue": "8",
                            "likelihood": null
                        },
                        {
                            "displayValue": "Other",
                            "value": "16",
                            "dataValue": "16",
                            "likelihood": null
                        },
                        {
                            "displayValue": "Contracted",
                            "value": "32",
                            "dataValue": "32",
                            "likelihood": null
                        }
                    ],
                    "isDefault": false
                }
            ],
            "rates": [
                {
                    "tariffRateId": 17838923,
                    "tariffId": 3284480,
                    "tariffSequenceNumber": 22,
                    "rateGroupName": "Customer Charge",
                    "rateName": "Customer Charge",
                    "fromDateTime": "2017-05-01T00:00:00-04:00",
                    "toDateTime": null,
                    "chargeType": "FIXED_PRICE",
                    "chargeClass": "DISTRIBUTION",
                    "chargePeriod": "MONTHLY",
                    "rateBands": [
                        {
                            "tariffRateBandId": 11575434,
                            "tariffRateId": 17838923,
                            "rateSequenceNumber": 1,
                            "hasConsumptionLimit": false,
                            "hasDemandLimit": false,
                            "hasPropertyLimit": false,
                            "rateAmount": 5.5,
                            "rateUnit": "COST_PER_UNIT",
                            "isCredit": false,
                            "prevUpperLimit": null
                        }
                    ]
                },
                {
                    "tariffRateId": 17838924,
                    "tariffId": 3284480,
                    "tariffSequenceNumber": 23,
                    "rateGroupName": "Energy Efficiency Chg",
                    "rateName": "Energy Efficiency Chg",
                    "fromDateTime": "2017-05-01T00:00:00-04:00",
                    "toDateTime": null,
                    "chargeType": "CONSUMPTION_BASED",
                    "chargeClass": "DISTRIBUTION",
                    "chargePeriod": "MONTHLY",
                    "rateBands": [
                        {
                            "tariffRateBandId": 11575435,
                            "tariffRateId": 17838924,
                            "rateSequenceNumber": 1,
                            "hasConsumptionLimit": false,
                            "hasDemandLimit": false,
                            "hasPropertyLimit": false,
                            "rateAmount": 0.0025,
                            "rateUnit": "COST_PER_UNIT",
                            "isCredit": false,
                            "prevUpperLimit": null
                        }
                    ]
                },
                {
                    "tariffRateId": 17838925,
                    "tariffId": 3284480,
                    "tariffSequenceNumber": 24,
                    "rateGroupName": "Renewable Energy Chg",
                    "rateName": "Renewables Charge",
                    "fromDateTime": "2017-05-01T00:00:00-04:00",
                    "toDateTime": null,
                    "chargeType": "CONSUMPTION_BASED",
                    "chargeClass": "DISTRIBUTION",
                    "chargePeriod": "MONTHLY",
                    "rateBands": [
                        {
                            "tariffRateBandId": 11575436,
                            "tariffRateId": 17838925,
                            "rateSequenceNumber": 1,
                            "hasConsumptionLimit": false,
                            "hasDemandLimit": false,
                            "hasPropertyLimit": false,
                            "rateAmount": 0.0005,
                            "rateUnit": "COST_PER_UNIT",
                            "isCredit": false,
                            "prevUpperLimit": null
                        }
                    ]
                },
                {
                    "tariffRateId": 17838926,
                    "tariffId": 3284480,
                    "tariffSequenceNumber": 25,
                    "rateGroupName": "Energy Efficiency Chg",
                    "rateName": "Energy Efficiency Charge",
                    "fromDateTime": "2017-05-01T00:00:00-04:00",
                    "toDateTime": null,
                    "chargeType": "CONSUMPTION_BASED",
                    "chargeClass": "DISTRIBUTION",
                    "chargePeriod": "MONTHLY",
                    "variableRateKey": "energyEfficiencyReconcilingFactorR1",
                    "rateBands": [
                        {
                            "tariffRateBandId": 11575437,
                            "tariffRateId": 17838926,
                            "rateSequenceNumber": 1,
                            "hasConsumptionLimit": false,
                            "hasDemandLimit": false,
                            "hasPropertyLimit": false,
                            "rateAmount": 0.01833,
                            "rateUnit": "COST_PER_UNIT",
                            "isCredit": false,
                            "prevUpperLimit": null
                        }
                    ]
                },
                {
                    "tariffRateId": 17838927,
                    "tariffId": 3284480,
                    "tariffSequenceNumber": 26,
                    "rateGroupName": "Dist Chg",
                    "rateName": "Basic Service Adjustment",
                    "fromDateTime": "2017-05-01T00:00:00-04:00",
                    "toDateTime": null,
                    "chargeType": "CONSUMPTION_BASED",
                    "chargeClass": "DISTRIBUTION",
                    "chargePeriod": "MONTHLY",
                    "rateBands": [
                        {
                            "tariffRateBandId": 11575438,
                            "tariffRateId": 17838927,
                            "rateSequenceNumber": 1,
                            "hasConsumptionLimit": false,
                            "hasDemandLimit": false,
                            "hasPropertyLimit": false,
                            "rateAmount": 0.00228,
                            "rateUnit": "COST_PER_UNIT",
                            "isCredit": false,
                            "prevUpperLimit": null
                        }
                    ]
                },
                {
                    "tariffRateId": 17838928,
                    "tariffId": 3284480,
                    "tariffSequenceNumber": 26,
                    "rateGroupName": "Dist Chg",
                    "rateName": "Pension/PBOP Adjustment",
                    "fromDateTime": "2017-05-01T00:00:00-04:00",
                    "toDateTime": null,
                    "chargeType": "CONSUMPTION_BASED",
                    "chargeClass": "DISTRIBUTION",
                    "chargePeriod": "MONTHLY",
                    "rateBands": [
                        {
                            "tariffRateBandId": 11575439,
                            "tariffRateId": 17838928,
                            "rateSequenceNumber": 1,
                            "hasConsumptionLimit": false,
                            "hasDemandLimit": false,
                            "hasPropertyLimit": false,
                            "rateAmount": 0.00287,
                            "rateUnit": "COST_PER_UNIT",
                            "isCredit": false,
                            "prevUpperLimit": null
                        }
                    ]
                },
                {
                    "tariffRateId": 17838929,
                    "tariffId": 3284480,
                    "tariffSequenceNumber": 26,
                    "rateGroupName": "Dist Chg",
                    "rateName": "Residential Assistance Adjustment",
                    "fromDateTime": "2017-05-01T00:00:00-04:00",
                    "toDateTime": null,
                    "chargeType": "CONSUMPTION_BASED",
                    "chargeClass": "DISTRIBUTION",
                    "chargePeriod": "MONTHLY",
                    "rateBands": [
                        {
                            "tariffRateBandId": 11575440,
                            "tariffRateId": 17838929,
                            "rateSequenceNumber": 1,
                            "hasConsumptionLimit": false,
                            "hasDemandLimit": false,
                            "hasPropertyLimit": false,
                            "rateAmount": 0.00483,
                            "rateUnit": "COST_PER_UNIT",
                            "isCredit": false,
                            "prevUpperLimit": null
                        }
                    ]
                },
                {
                    "tariffRateId": 17838930,
                    "tariffId": 3284480,
                    "tariffSequenceNumber": 26,
                    "rateGroupName": "Dist Chg",
                    "rateName": "Base Distribution Charge - Energy Charge",
                    "fromDateTime": "2017-05-01T00:00:00-04:00",
                    "toDateTime": null,
                    "chargeType": "CONSUMPTION_BASED",
                    "chargeClass": "DISTRIBUTION",
                    "chargePeriod": "MONTHLY",
                    "rateBands": [
                        {
                            "tariffRateBandId": 11575441,
                            "tariffRateId": 17838930,
                            "rateSequenceNumber": 1,
                            "hasConsumptionLimit": false,
                            "hasDemandLimit": false,
                            "hasPropertyLimit": false,
                            "rateAmount": 0.04072,
                            "rateUnit": "COST_PER_UNIT",
                            "isCredit": false,
                            "prevUpperLimit": null
                        }
                    ]
                },
                {
                    "tariffRateId": 17838931,
                    "tariffId": 3284480,
                    "tariffSequenceNumber": 26,
                    "rateGroupName": "Dist Chg",
                    "rateName": "Revenue Decoupling Mechanism",
                    "fromDateTime": "2017-05-01T00:00:00-04:00",
                    "toDateTime": null,
                    "chargeType": "CONSUMPTION_BASED",
                    "chargeClass": "DISTRIBUTION",
                    "chargePeriod": "MONTHLY",
                    "rateBands": [
                        {
                            "tariffRateBandId": 11575442,
                            "tariffRateId": 17838931,
                            "rateSequenceNumber": 1,
                            "hasConsumptionLimit": false,
                            "hasDemandLimit": false,
                            "hasPropertyLimit": false,
                            "rateAmount": 0.00204,
                            "rateUnit": "COST_PER_UNIT",
                            "isCredit": false,
                            "prevUpperLimit": null
                        }
                    ]
                },
                {
                    "tariffRateId": 17838932,
                    "tariffId": 3284480,
                    "tariffSequenceNumber": 26,
                    "rateGroupName": "Dist Chg",
                    "rateName": "Attorney General Counsel Expense",
                    "fromDateTime": "2017-05-01T00:00:00-04:00",
                    "toDateTime": null,
                    "chargeType": "CONSUMPTION_BASED",
                    "chargeClass": "DISTRIBUTION",
                    "chargePeriod": "MONTHLY",
                    "rateBands": [
                        {
                            "tariffRateBandId": 11575443,
                            "tariffRateId": 17838932,
                            "rateSequenceNumber": 1,
                            "hasConsumptionLimit": false,
                            "hasDemandLimit": false,
                            "hasPropertyLimit": false,
                            "rateAmount": 0.00004,
                            "rateUnit": "COST_PER_UNIT",
                            "isCredit": false,
                            "prevUpperLimit": null
                        }
                    ]
                },
                {
                    "tariffRateId": 17838933,
                    "tariffId": 3284480,
                    "tariffSequenceNumber": 26,
                    "rateGroupName": "Dist Chg",
                    "rateName": "Market Settlement Credit",
                    "fromDateTime": "2017-05-01T00:00:00-04:00",
                    "toDateTime": null,
                    "chargeType": "CONSUMPTION_BASED",
                    "chargeClass": "DISTRIBUTION",
                    "chargePeriod": "MONTHLY",
                    "variableRateKey": "marketSettlementCredit",
                    "rateBands": [
                        {
                            "tariffRateBandId": 11575444,
                            "tariffRateId": 17838933,
                            "rateSequenceNumber": 1,
                            "hasConsumptionLimit": false,
                            "hasDemandLimit": false,
                            "hasPropertyLimit": false,
                            "rateAmount": 0,
                            "rateUnit": "COST_PER_UNIT",
                            "isCredit": false,
                            "prevUpperLimit": null
                        }
                    ]
                },
                {
                    "tariffRateId": 17838937,
                    "tariffId": 3284480,
                    "tariffSequenceNumber": 27,
                    "rateGroupName": "Transmission Charge",
                    "rateName": "Transmission Charge Adjustment",
                    "fromDateTime": "2017-05-01T00:00:00-04:00",
                    "toDateTime": null,
                    "chargeType": "CONSUMPTION_BASED",
                    "chargeClass": "TRANSMISSION",
                    "chargePeriod": "MONTHLY",
                    "rateBands": [
                        {
                            "tariffRateBandId": 11575448,
                            "tariffRateId": 17838937,
                            "rateSequenceNumber": 1,
                            "hasConsumptionLimit": false,
                            "hasDemandLimit": false,
                            "hasPropertyLimit": false,
                            "rateAmount": 0.00055,
                            "rateUnit": "COST_PER_UNIT",
                            "isCredit": false,
                            "prevUpperLimit": null
                        }
                    ]
                },
                {
                    "tariffRateId": 17838938,
                    "tariffId": 3284480,
                    "tariffSequenceNumber": 27,
                    "rateGroupName": "Transmission Charge",
                    "rateName": "Base Transmission Charge",
                    "fromDateTime": "2017-05-01T00:00:00-04:00",
                    "toDateTime": null,
                    "chargeType": "CONSUMPTION_BASED",
                    "chargeClass": "TRANSMISSION",
                    "chargePeriod": "MONTHLY",
                    "rateBands": [
                        {
                            "tariffRateBandId": 11575449,
                            "tariffRateId": 17838938,
                            "rateSequenceNumber": 1,
                            "hasConsumptionLimit": false,
                            "hasDemandLimit": false,
                            "hasPropertyLimit": false,
                            "rateAmount": 0.03001,
                            "rateUnit": "COST_PER_UNIT",
                            "isCredit": false,
                            "prevUpperLimit": null
                        }
                    ]
                },
                {
                    "tariffRateId": 17838939,
                    "tariffId": 3284480,
                    "tariffSequenceNumber": 28,
                    "rateGroupName": "Transition Charge",
                    "rateName": "Base Transition Charge",
                    "fromDateTime": "2017-05-01T00:00:00-04:00",
                    "toDateTime": null,
                    "chargeType": "CONSUMPTION_BASED",
                    "chargeClass": "DISTRIBUTION",
                    "chargePeriod": "MONTHLY",
                    "rateBands": [
                        {
                            "tariffRateBandId": 11575450,
                            "tariffRateId": 17838939,
                            "rateSequenceNumber": 1,
                            "hasConsumptionLimit": false,
                            "hasDemandLimit": false,
                            "hasPropertyLimit": false,
                            "rateAmount": 0.00025,
                            "rateUnit": "COST_PER_UNIT",
                            "isCredit": false,
                            "prevUpperLimit": null
                        }
                    ]
                },
                {
                    "tariffRateId": 17838940,
                    "tariffId": 3284480,
                    "tariffSequenceNumber": 28,
                    "rateGroupName": "Transition Charge",
                    "rateName": "Transition Charge Adjustment",
                    "fromDateTime": "2017-05-01T00:00:00-04:00",
                    "toDateTime": null,
                    "chargeType": "CONSUMPTION_BASED",
                    "chargeClass": "DISTRIBUTION",
                    "chargePeriod": "MONTHLY",
                    "rateBands": [
                        {
                            "tariffRateBandId": 11575451,
                            "tariffRateId": 17838940,
                            "rateSequenceNumber": 1,
                            "hasConsumptionLimit": false,
                            "hasDemandLimit": false,
                            "hasPropertyLimit": false,
                            "rateAmount": 0.00029,
                            "rateUnit": "COST_PER_UNIT",
                            "isCredit": false,
                            "prevUpperLimit": null
                        }
                    ]
                },
                {
                    "tariffRateId": 17838941,
                    "tariffId": 3284480,
                    "tariffSequenceNumber": 29,
                    "rateGroupName": "Dist Chg",
                    "rateName": "Smart Grid Distribution Adjmt",
                    "fromDateTime": "2017-05-01T00:00:00-04:00",
                    "toDateTime": null,
                    "chargeType": "CONSUMPTION_BASED",
                    "chargeClass": "DISTRIBUTION",
                    "chargePeriod": "MONTHLY",
                    "rateBands": [
                        {
                            "tariffRateBandId": 11575452,
                            "tariffRateId": 17838941,
                            "rateSequenceNumber": 1,
                            "hasConsumptionLimit": false,
                            "hasDemandLimit": false,
                            "hasPropertyLimit": false,
                            "rateAmount": 0.00037,
                            "rateUnit": "COST_PER_UNIT",
                            "isCredit": false,
                            "prevUpperLimit": null
                        }
                    ]
                },
                {
                    "tariffRateId": 17838945,
                    "tariffId": 3284480,
                    "tariffSequenceNumber": 31,
                    "rateGroupName": "Minimum Charge",
                    "rateName": "Minimum Charge",
                    "fromDateTime": "2017-05-01T00:00:00-04:00",
                    "toDateTime": null,
                    "chargeType": "MINIMUM",
                    "chargePeriod": "MONTHLY",
                    "rateBands": [
                        {
                            "tariffRateBandId": 11575456,
                            "tariffRateId": 17838945,
                            "rateSequenceNumber": 1,
                            "hasConsumptionLimit": false,
                            "hasDemandLimit": false,
                            "hasPropertyLimit": false,
                            "rateAmount": 5.5,
                            "rateUnit": "COST_PER_UNIT",
                            "isCredit": false,
                            "prevUpperLimit": null
                        }
                    ]
                },
                {
                    "tariffRateId": 17838934,
                    "tariffId": 3284480,
                    "tariffSequenceNumber": 26,
                    "rateGroupName": "Dist Chg",
                    "rateName": "Net CapEx Factor",
                    "fromDateTime": "2017-05-01T00:00:00-04:00",
                    "toDateTime": "2017-10-01T00:00:00-04:00",
                    "chargeType": "CONSUMPTION_BASED",
                    "chargeClass": "DISTRIBUTION",
                    "chargePeriod": "MONTHLY",
                    "variableRateKey": "netCapExFactorR1R2",
                    "rateBands": [
                        {
                            "tariffRateBandId": 11575445,
                            "tariffRateId": 17838934,
                            "rateSequenceNumber": 1,
                            "hasConsumptionLimit": false,
                            "hasDemandLimit": false,
                            "hasPropertyLimit": false,
                            "rateAmount": 0.00165,
                            "rateUnit": "COST_PER_UNIT",
                            "isCredit": false,
                            "prevUpperLimit": null
                        }
                    ]
                },
                {
                    "tariffRateId": 17838934,
                    "tariffId": 3284480,
                    "tariffSequenceNumber": 26,
                    "rateGroupName": "Dist Chg",
                    "rateName": "Net CapEx Factor",
                    "fromDateTime": "2017-10-01T00:00:00-04:00",
                    "toDateTime": "2018-01-31T19:00:00-05:00",
                    "chargeType": "CONSUMPTION_BASED",
                    "chargeClass": "DISTRIBUTION",
                    "chargePeriod": "MONTHLY",
                    "variableRateKey": "netCapExFactorR1R2",
                    "rateBands": [
                        {
                            "tariffRateBandId": 11575445,
                            "tariffRateId": 17838934,
                            "rateSequenceNumber": 1,
                            "hasConsumptionLimit": false,
                            "hasDemandLimit": false,
                            "hasPropertyLimit": false,
                            "rateAmount": 0,
                            "rateUnit": "COST_PER_UNIT",
                            "isCredit": false,
                            "prevUpperLimit": null
                        }
                    ]
                },
                {
                    "tariffRateId": 17838935,
                    "tariffId": 3284480,
                    "tariffSequenceNumber": 26,
                    "rateGroupName": "Dist Chg",
                    "rateName": "Solar Cost Adjustment",
                    "fromDateTime": "2017-05-01T00:00:00-04:00",
                    "toDateTime": "2017-10-01T00:00:00-04:00",
                    "chargeType": "CONSUMPTION_BASED",
                    "chargeClass": "DISTRIBUTION",
                    "chargePeriod": "MONTHLY",
                    "variableRateKey": "solarCostAdjustment310",
                    "rateBands": [
                        {
                            "tariffRateBandId": 11575446,
                            "tariffRateId": 17838935,
                            "rateSequenceNumber": 1,
                            "hasConsumptionLimit": false,
                            "hasDemandLimit": false,
                            "hasPropertyLimit": false,
                            "rateAmount": 0.00016,
                            "rateUnit": "COST_PER_UNIT",
                            "isCredit": false,
                            "prevUpperLimit": null
                        }
                    ]
                },
                {
                    "tariffRateId": 17838935,
                    "tariffId": 3284480,
                    "tariffSequenceNumber": 26,
                    "rateGroupName": "Dist Chg",
                    "rateName": "Solar Cost Adjustment",
                    "fromDateTime": "2017-10-01T00:00:00-04:00",
                    "toDateTime": "2018-01-31T19:00:00-05:00",
                    "chargeType": "CONSUMPTION_BASED",
                    "chargeClass": "DISTRIBUTION",
                    "chargePeriod": "MONTHLY",
                    "variableRateKey": "solarCostAdjustment310",
                    "rateBands": [
                        {
                            "tariffRateBandId": 11575446,
                            "tariffRateId": 17838935,
                            "rateSequenceNumber": 1,
                            "hasConsumptionLimit": false,
                            "hasDemandLimit": false,
                            "hasPropertyLimit": false,
                            "rateAmount": 0.00016,
                            "rateUnit": "COST_PER_UNIT",
                            "isCredit": false,
                            "prevUpperLimit": null
                        }
                    ]
                },
                {
                    "tariffRateId": 17838936,
                    "tariffId": 3284480,
                    "tariffSequenceNumber": 26,
                    "rateGroupName": "Dist Chg",
                    "rateName": "Storm Replenishment Adjustment",
                    "fromDateTime": "2017-05-01T00:00:00-04:00",
                    "toDateTime": "2017-07-01T00:00:00-04:00",
                    "chargeType": "CONSUMPTION_BASED",
                    "chargeClass": "DISTRIBUTION",
                    "chargePeriod": "MONTHLY",
                    "variableRateKey": "stormReplenishmentAdjustment",
                    "rateBands": [
                        {
                            "tariffRateBandId": 11575447,
                            "tariffRateId": 17838936,
                            "rateSequenceNumber": 1,
                            "hasConsumptionLimit": false,
                            "hasDemandLimit": false,
                            "hasPropertyLimit": false,
                            "rateAmount": 0.00266,
                            "rateUnit": "COST_PER_UNIT",
                            "isCredit": false,
                            "prevUpperLimit": null
                        }
                    ]
                },
                {
                    "tariffRateId": 17838936,
                    "tariffId": 3284480,
                    "tariffSequenceNumber": 26,
                    "rateGroupName": "Dist Chg",
                    "rateName": "Storm Replenishment Adjustment",
                    "fromDateTime": "2017-07-01T00:00:00-04:00",
                    "toDateTime": "2018-01-31T19:00:00-05:00",
                    "chargeType": "CONSUMPTION_BASED",
                    "chargeClass": "DISTRIBUTION",
                    "chargePeriod": "MONTHLY",
                    "variableRateKey": "stormReplenishmentAdjustment",
                    "rateBands": [
                        {
                            "tariffRateBandId": 11575447,
                            "tariffRateId": 17838936,
                            "rateSequenceNumber": 1,
                            "hasConsumptionLimit": false,
                            "hasDemandLimit": false,
                            "hasPropertyLimit": false,
                            "rateAmount": 0.00266,
                            "rateUnit": "COST_PER_UNIT",
                            "isCredit": false,
                            "prevUpperLimit": null
                        }
                    ]
                },
                {
                    "tariffRateId": 17838942,
                    "tariffId": 3284480,
                    "tariffSequenceNumber": 29,
                    "rateGroupName": "Dist Chg",
                    "rateName": "Renewable Energy Recovery",
                    "fromDateTime": "2017-05-01T00:00:00-04:00",
                    "toDateTime": "2017-11-01T00:00:00-04:00",
                    "chargeType": "CONSUMPTION_BASED",
                    "chargeClass": "DISTRIBUTION",
                    "chargePeriod": "MONTHLY",
                    "variableRateKey": "renewableEnergyRecovery310",
                    "rateBands": [
                        {
                            "tariffRateBandId": 11575453,
                            "tariffRateId": 17838942,
                            "rateSequenceNumber": 1,
                            "hasConsumptionLimit": false,
                            "hasDemandLimit": false,
                            "hasPropertyLimit": false,
                            "rateAmount": 0.0005,
                            "rateUnit": "COST_PER_UNIT",
                            "isCredit": false,
                            "prevUpperLimit": null
                        }
                    ]
                },
                {
                    "tariffRateId": 17838942,
                    "tariffId": 3284480,
                    "tariffSequenceNumber": 29,
                    "rateGroupName": "Dist Chg",
                    "rateName": "Renewable Energy Recovery",
                    "fromDateTime": "2017-11-01T00:00:00-04:00",
                    "toDateTime": "2018-01-31T19:00:00-05:00",
                    "chargeType": "CONSUMPTION_BASED",
                    "chargeClass": "DISTRIBUTION",
                    "chargePeriod": "MONTHLY",
                    "variableRateKey": "renewableEnergyRecovery310",
                    "rateBands": [
                        {
                            "tariffRateBandId": 11575453,
                            "tariffRateId": 17838942,
                            "rateSequenceNumber": 1,
                            "hasConsumptionLimit": false,
                            "hasDemandLimit": false,
                            "hasPropertyLimit": false,
                            "rateAmount": 0.0005,
                            "rateUnit": "COST_PER_UNIT",
                            "isCredit": false,
                            "prevUpperLimit": null
                        }
                    ]
                },
                {
                    "tariffRateId": 17838943,
                    "tariffId": 3284480,
                    "tariffSequenceNumber": 30,
                    "rateGroupName": "Supplier Services",
                    "rateName": "Fixed Price",
                    "fromDateTime": "2017-05-01T00:00:00-04:00",
                    "toDateTime": "2017-11-01T00:00:00-04:00",
                    "chargeType": "CONSUMPTION_BASED",
                    "chargeClass": "SUPPLY,CONTRACTED",
                    "chargePeriod": "MONTHLY",
                    "applicabilityKey": "basicServiceChargeType",
                    "variableRateKey": "supplementForBasicServiceResidentialFixed",
                    "rateBands": [
                        {
                            "tariffRateBandId": 11575454,
                            "tariffRateId": 17838943,
                            "rateSequenceNumber": 1,
                            "hasConsumptionLimit": false,
                            "hasDemandLimit": false,
                            "hasPropertyLimit": false,
                            "applicabilityValue": "Fixed",
                            "rateAmount": 0.09432,
                            "rateUnit": "COST_PER_UNIT",
                            "isCredit": false,
                            "prevUpperLimit": null
                        }
                    ]
                },
                {
                    "tariffRateId": 17838943,
                    "tariffId": 3284480,
                    "tariffSequenceNumber": 30,
                    "rateGroupName": "Supplier Services",
                    "rateName": "Fixed Price",
                    "fromDateTime": "2017-11-01T00:00:00-04:00",
                    "toDateTime": "2018-01-31T19:00:00-05:00",
                    "chargeType": "CONSUMPTION_BASED",
                    "chargeClass": "SUPPLY,CONTRACTED",
                    "chargePeriod": "MONTHLY",
                    "applicabilityKey": "basicServiceChargeType",
                    "variableRateKey": "supplementForBasicServiceResidentialFixed",
                    "rateBands": [
                        {
                            "tariffRateBandId": 11575454,
                            "tariffRateId": 17838943,
                            "rateSequenceNumber": 1,
                            "hasConsumptionLimit": false,
                            "hasDemandLimit": false,
                            "hasPropertyLimit": false,
                            "applicabilityValue": "Fixed",
                            "rateAmount": 0.12673,
                            "rateUnit": "COST_PER_UNIT",
                            "isCredit": false,
                            "prevUpperLimit": null
                        }
                    ]
                },
                {
                    "tariffRateId": 17838944,
                    "tariffId": 3284480,
                    "tariffSequenceNumber": 30,
                    "rateGroupName": "Supplier Services",
                    "rateName": "Variable Price",
                    "fromDateTime": "2017-05-01T00:00:00-04:00",
                    "toDateTime": "2017-06-01T00:00:00-04:00",
                    "chargeType": "CONSUMPTION_BASED",
                    "chargeClass": "SUPPLY,CONTRACTED",
                    "chargePeriod": "MONTHLY",
                    "applicabilityKey": "basicServiceChargeType",
                    "variableRateKey": "supplementForBasicServiceResidentialVariable",
                    "rateBands": [
                        {
                            "tariffRateBandId": 11575455,
                            "tariffRateId": 17838944,
                            "rateSequenceNumber": 1,
                            "hasConsumptionLimit": false,
                            "hasDemandLimit": false,
                            "hasPropertyLimit": false,
                            "applicabilityValue": "Variable",
                            "rateAmount": 0.07362,
                            "rateUnit": "COST_PER_UNIT",
                            "isCredit": false,
                            "prevUpperLimit": null
                        }
                    ]
                },
                {
                    "tariffRateId": 17838944,
                    "tariffId": 3284480,
                    "tariffSequenceNumber": 30,
                    "rateGroupName": "Supplier Services",
                    "rateName": "Variable Price",
                    "fromDateTime": "2017-06-01T00:00:00-04:00",
                    "toDateTime": "2017-07-01T00:00:00-04:00",
                    "chargeType": "CONSUMPTION_BASED",
                    "chargeClass": "SUPPLY,CONTRACTED",
                    "chargePeriod": "MONTHLY",
                    "applicabilityKey": "basicServiceChargeType",
                    "variableRateKey": "supplementForBasicServiceResidentialVariable",
                    "rateBands": [
                        {
                            "tariffRateBandId": 11575455,
                            "tariffRateId": 17838944,
                            "rateSequenceNumber": 1,
                            "hasConsumptionLimit": false,
                            "hasDemandLimit": false,
                            "hasPropertyLimit": false,
                            "applicabilityValue": "Variable",
                            "rateAmount": 0.09684,
                            "rateUnit": "COST_PER_UNIT",
                            "isCredit": false,
                            "prevUpperLimit": null
                        }
                    ]
                },
                {
                    "tariffRateId": 17838944,
                    "tariffId": 3284480,
                    "tariffSequenceNumber": 30,
                    "rateGroupName": "Supplier Services",
                    "rateName": "Variable Price",
                    "fromDateTime": "2017-07-01T00:00:00-04:00",
                    "toDateTime": "2017-08-01T00:00:00-04:00",
                    "chargeType": "CONSUMPTION_BASED",
                    "chargeClass": "SUPPLY,CONTRACTED",
                    "chargePeriod": "MONTHLY",
                    "applicabilityKey": "basicServiceChargeType",
                    "variableRateKey": "supplementForBasicServiceResidentialVariable",
                    "rateBands": [
                        {
                            "tariffRateBandId": 11575455,
                            "tariffRateId": 17838944,
                            "rateSequenceNumber": 1,
                            "hasConsumptionLimit": false,
                            "hasDemandLimit": false,
                            "hasPropertyLimit": false,
                            "applicabilityValue": "Variable",
                            "rateAmount": 0.09516,
                            "rateUnit": "COST_PER_UNIT",
                            "isCredit": false,
                            "prevUpperLimit": null
                        }
                    ]
                },
                {
                    "tariffRateId": 17838944,
                    "tariffId": 3284480,
                    "tariffSequenceNumber": 30,
                    "rateGroupName": "Supplier Services",
                    "rateName": "Variable Price",
                    "fromDateTime": "2017-08-01T00:00:00-04:00",
                    "toDateTime": "2017-09-01T00:00:00-04:00",
                    "chargeType": "CONSUMPTION_BASED",
                    "chargeClass": "SUPPLY,CONTRACTED",
                    "chargePeriod": "MONTHLY",
                    "applicabilityKey": "basicServiceChargeType",
                    "variableRateKey": "supplementForBasicServiceResidentialVariable",
                    "rateBands": [
                        {
                            "tariffRateBandId": 11575455,
                            "tariffRateId": 17838944,
                            "rateSequenceNumber": 1,
                            "hasConsumptionLimit": false,
                            "hasDemandLimit": false,
                            "hasPropertyLimit": false,
                            "applicabilityValue": "Variable",
                            "rateAmount": 0.09494,
                            "rateUnit": "COST_PER_UNIT",
                            "isCredit": false,
                            "prevUpperLimit": null
                        }
                    ]
                },
                {
                    "tariffRateId": 17838944,
                    "tariffId": 3284480,
                    "tariffSequenceNumber": 30,
                    "rateGroupName": "Supplier Services",
                    "rateName": "Variable Price",
                    "fromDateTime": "2017-09-01T00:00:00-04:00",
                    "toDateTime": "2017-10-01T00:00:00-04:00",
                    "chargeType": "CONSUMPTION_BASED",
                    "chargeClass": "SUPPLY,CONTRACTED",
                    "chargePeriod": "MONTHLY",
                    "applicabilityKey": "basicServiceChargeType",
                    "variableRateKey": "supplementForBasicServiceResidentialVariable",
                    "rateBands": [
                        {
                            "tariffRateBandId": 11575455,
                            "tariffRateId": 17838944,
                            "rateSequenceNumber": 1,
                            "hasConsumptionLimit": false,
                            "hasDemandLimit": false,
                            "hasPropertyLimit": false,
                            "applicabilityValue": "Variable",
                            "rateAmount": 0.09936,
                            "rateUnit": "COST_PER_UNIT",
                            "isCredit": false,
                            "prevUpperLimit": null
                        }
                    ]
                },
                {
                    "tariffRateId": 17838944,
                    "tariffId": 3284480,
                    "tariffSequenceNumber": 30,
                    "rateGroupName": "Supplier Services",
                    "rateName": "Variable Price",
                    "fromDateTime": "2017-10-01T00:00:00-04:00",
                    "toDateTime": "2017-11-01T00:00:00-04:00",
                    "chargeType": "CONSUMPTION_BASED",
                    "chargeClass": "SUPPLY,CONTRACTED",
                    "chargePeriod": "MONTHLY",
                    "applicabilityKey": "basicServiceChargeType",
                    "variableRateKey": "supplementForBasicServiceResidentialVariable",
                    "rateBands": [
                        {
                            "tariffRateBandId": 11575455,
                            "tariffRateId": 17838944,
                            "rateSequenceNumber": 1,
                            "hasConsumptionLimit": false,
                            "hasDemandLimit": false,
                            "hasPropertyLimit": false,
                            "applicabilityValue": "Variable",
                            "rateAmount": 0.10261,
                            "rateUnit": "COST_PER_UNIT",
                            "isCredit": false,
                            "prevUpperLimit": null
                        }
                    ]
                },
                {
                    "tariffRateId": 17838944,
                    "tariffId": 3284480,
                    "tariffSequenceNumber": 30,
                    "rateGroupName": "Supplier Services",
                    "rateName": "Variable Price",
                    "fromDateTime": "2017-11-01T00:00:00-04:00",
                    "toDateTime": "2017-12-01T00:00:00-05:00",
                    "chargeType": "CONSUMPTION_BASED",
                    "chargeClass": "SUPPLY,CONTRACTED",
                    "chargePeriod": "MONTHLY",
                    "applicabilityKey": "basicServiceChargeType",
                    "variableRateKey": "supplementForBasicServiceResidentialVariable",
                    "rateBands": [
                        {
                            "tariffRateBandId": 11575455,
                            "tariffRateId": 17838944,
                            "rateSequenceNumber": 1,
                            "hasConsumptionLimit": false,
                            "hasDemandLimit": false,
                            "hasPropertyLimit": false,
                            "applicabilityValue": "Variable",
                            "rateAmount": 0.10457,
                            "rateUnit": "COST_PER_UNIT",
                            "isCredit": false,
                            "prevUpperLimit": null
                        }
                    ]
                },
                {
                    "tariffRateId": 17838944,
                    "tariffId": 3284480,
                    "tariffSequenceNumber": 30,
                    "rateGroupName": "Supplier Services",
                    "rateName": "Variable Price",
                    "fromDateTime": "2017-12-01T00:00:00-05:00",
                    "toDateTime": "2018-01-01T00:00:00-05:00",
                    "chargeType": "CONSUMPTION_BASED",
                    "chargeClass": "SUPPLY,CONTRACTED",
                    "chargePeriod": "MONTHLY",
                    "applicabilityKey": "basicServiceChargeType",
                    "variableRateKey": "supplementForBasicServiceResidentialVariable",
                    "rateBands": [
                        {
                            "tariffRateBandId": 11575455,
                            "tariffRateId": 17838944,
                            "rateSequenceNumber": 1,
                            "hasConsumptionLimit": false,
                            "hasDemandLimit": false,
                            "hasPropertyLimit": false,
                            "applicabilityValue": "Variable",
                            "rateAmount": 0.1177,
                            "rateUnit": "COST_PER_UNIT",
                            "isCredit": false,
                            "prevUpperLimit": null
                        }
                    ]
                },
                {
                    "tariffRateId": 17838944,
                    "tariffId": 3284480,
                    "tariffSequenceNumber": 30,
                    "rateGroupName": "Supplier Services",
                    "rateName": "Variable Price",
                    "fromDateTime": "2018-01-01T00:00:00-05:00",
                    "toDateTime": "2018-01-31T19:00:00-05:00",
                    "chargeType": "CONSUMPTION_BASED",
                    "chargeClass": "SUPPLY,CONTRACTED",
                    "chargePeriod": "MONTHLY",
                    "applicabilityKey": "basicServiceChargeType",
                    "variableRateKey": "supplementForBasicServiceResidentialVariable",
                    "rateBands": [
                        {
                            "tariffRateBandId": 11575455,
                            "tariffRateId": 17838944,
                            "rateSequenceNumber": 1,
                            "hasConsumptionLimit": false,
                            "hasDemandLimit": false,
                            "hasPropertyLimit": false,
                            "applicabilityValue": "Variable",
                            "rateAmount": 0.14574,
                            "rateUnit": "COST_PER_UNIT",
                            "isCredit": false,
                            "prevUpperLimit": null
                        }
                    ]
                }
            ]
        }
    ]
}