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 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. |