Peak Time Rebates File

In order to support rate plans with rebate components, the Rate Engine must receive the calculated rebates for each customer. This peak time rebates file should be transmitted after the event date and after the rebates have been calculated by the utility billing system. The file must follow a specific naming convention. See File Name Conventions for more information.

Note: This file is only if applicable if your utility needs to provide peak time rebates data in support of certain products. Your Delivery Team will work with you to determine if it is required in your situation.

Column Name Description

account_id

Account identifier.

Type: VARCHAR

Can Be Empty?: No.

rate_plan_identifier

The rate plan for which the rebate is applicable. This may be a wildcard (*) if the rebate applies to all rate plans for which the Service Agreement (SA) is eligible.

Type: VARCHAR

Can Be Empty?: No.

rate_component

The unique identifier of the type of rate component to which the rebate applies.

Type: VARCHAR

Can Be Empty?: No.

start_date

Effective start date of the specified rebate value.

Type: DATETIME. See Date and Time Handling for details.

Can Be Empty?: Yes.

end_date

Effective end date of the specified rebate value. This should be exclusive. For example, if the rebate is calculated in hourly increments and ends at 11:00, the end_date should be 20120101 1100. The hour from 11:00-12:00 will not be included.

Type: DATETIME. See Date and Time Handling for details.

Can Be Empty?: Yes.

performance_value

kWh or Therm value used to calculate the rebate amount for this period. A positive value should be sent for customers who used less than their baseline. A negative value should be sent for customers who used more than their baseline.

Type: DECIMAL (12,6). See Supported Decimal Formats for details.

Can Be Empty?: No.

performance_dollars

Rebate earned during this period of time. Prices should always be provided in dollars, not cents. Rebates should be negative or zero amounts. No positive amounts should be provided.

Type: DECIMAL (12,6). See Supported Decimal Formats for details.

Can Be Empty?: Yes.