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

Peak Time Rebates Sample Data

The peak time rebates file specifies pricing information related to the rebates that a customer can receive by participating in a peak day event. The table below provides an example of how the data might look.

account_id	rate_plan_identifier	rate_component	start_date	end_date	performance_ value	performance_ dollars
123	R_PTR	PEAK_TIME_REBATE	20120101 1300	20120101 1900	5.354	-10.3507471
456	RL_PTR	PEAK_TIME_REBATE	20100609 1200	20100609 1300	1.248	-2.1667152
456	RL_PTR	PEAK_TIME_REBATE	20100609 1300	20100609 1400	0.445	-0.7725868
456	RL_PTR	PEAK_TIME_REBATE	20100609 1400	20100609 1500	0.139	-0.2413249