Rate Prices Sample Data

The rate prices file describes the prices to charge for each rate attribute, period, and charge. The table below shows an example of how the rate prices file might look.

rate_plan_identifier

rate_component

rate_group

season

period

price_type

tier

start_time

price

effective_start_date

effective_end_date

Rate-1

TOU_TIERED

 

SUMMER

ON_PEAK

CHARGE

1

 

0.20776

20080501

 

Rate-1

TOU_TIERED

 

SUMMER

ON_PEAK

CHARGE

2

 

0.22023

20080501

 

Rate-1

TOU_TIERED

 

SUMMER

ON_PEAK

CHARGE

3

 

0.22023

20080501

 

Rate-1

TOU_TIERED

 

SUMMER

ON_PEAK

CHARGE

4

 

0.22023

20080501

 

Rate-1

TOU_TIERED

 

SUMMER

ON_PEAK

CHARGE

5

 

0.22023

20080501

 

*

PDP

 

 

CRITICAL_PEAK

CHARGE

 

 

0.60000

20080501

 

Rate-2

TOU

 

SUMMER

ON_PEAK

CHARGE

 

 

0.29108

20080501

 

Rate-2

TOU

 

SUMMER

OFF_PEAK

CHARGE

 

 

0.13111

20080501

 

Rate-2

TOU

 

WINTER

PART_PEAK

CHARGE

 

 

0.13612

20080501

 

Rate-2

TOU

 

WINTER

OFF_PEAK

CHARGE

 

 

0.11289

20080501

 

Rate-2

DEMAND/CONNECTED_LOAD

 

SUMMER

 

CHARGE

 

 

4.73

20080501

 

Rate-2

DEMAND/CONNECTED_LOAD

 

WINTER

 

CHARGE

 

 

0.66

20080501

 

Rate-3

FLAT/CUSTOMER

 

 

 

CHARGE

 

 

0.47310

20080501

 

Rate-4

DEMAND/MAXIMUM

 

SUMMER

 

CHARGE

 

 

6.45

20080501

 

Rate-4

DEMAND/MAXIMUM

 

WINTER

 

CHARGE

 

 

1.36

20080501

 

Rate-4

DEMAND/PRIMARY_VOLTAGE

 

SUMMER

 

CREDIT

 

 

-0.77

20080501

 

Rate-4

DEMAND/PRIMARY_VOLTAGE

 

WINTER

 

CREDIT

 

 

-0.21

20080501