Working with Time of Use (TOU) Maps

This section describes information related to how data is stored for TOU Maps. For information about defining time of use codes and other related topics, refer to The Big Picture of Time of Use Mapping and Pricing.

For information about defining calculation rules for time of use mapping and pricing, refer to Calculation Rules for TOU Mapping and Pricing.

Note: Time of use mapping is supported to enable low volume interval data manipulation (for example, for mapping electric vehicle charging events into time of use quantities). A meter data management application, such as Oracle Utilities Meter Data Management, must be used to manipulate high volumes of interval data and calculating bill determinants for billing purposes.

About Time of Use (TOU) Maps

The data for a TOU map is a collection of date and time intervals and their corresponding time-of-use codes. Even though you may have several consecutive time periods referencing the same time-of-use code, each interval must be separately defined.

A TOU map is typically specified when configuring a calculation rule for TOU mapping. This TOU map's data will then be used when summarizing the interval data for each TOU period.

TOU Map Data are interval date/times and associated TOU periods as defined by a TOU map template. For example, if the schedule defined for a TOU map template specifies that the period on weekdays from 9 AM to 5 PM falls into On-Peak, and the data is hourly, TOU map data for that template would include records with the date/time 5/3/2010 at 10 AM, 5/3/2010 at 11 AM, 5/3/2010 at 12 PM, etc., each with a value of On-Peak.

Generating Time of Use (TOU) Map Data

In order to facilitate the creation of data for a TOU map, the system enables you to define TOU map templates and provides you with the ability to generate data for a TOU map based on this template.

TOU map templates may be used to define standard data for a TOU map as well as data for special periods, such as holidays. Refer to Designing Your TOU Map Templates for further information.

Data for a TOU Map may be created in the follow ways:

  • By using a button on the TOU Map portal that allows a user to generate TOU map data for the TOU Map
  • Through a background process that runs periodically

Creating TOU Maps

Use this procedure to create a new TOU map.

Prerequisites: You must define at least one TOU map type before you can create TOU maps.

  1. Select Menu > Usage > TOU Map > Add.
  2. Select the TOU map type that will define the TOU map.
  3. Click OK.
  4. Enter a description for the TOU map.
  5. Select the Override TOU map template for the TOU map.
  6. Click Save.

TOU Map Search

Use this procedure to search for a TOU map on the TOU Map Query portal.

  1. Select Menu > Usage > TOU Map > Search.
  2. Enter your search criteria. You can search by:
    • Description, TOU Map Type, or Creation Date
    • TOU Map ID
  3. Click Refresh.
  4. In the search results list, click the link for the TOU map you want to view or edit.

Maintaining TOU Maps

Use this procedure to maintain an existing TOU map.

You use the TOU Map portal to maintain TOU maps. This portal includes the following zones:
  • TOU Map: Defines basic information about the TOU map
  • TOU Map Data List: Lists TOU map data created from the TOU map

To maintain a TOU map:

  1. Select Menu > Usage > TOU Map > Search.
  2. Search for and select the appropriate TOU map.
  3. Click the Edit or Delete button as appropriate.
  4. To deactivate the TOU map, click the Deactivate button.
  5. To generate TOU map data for the TOU map, click the Generate TOU Map Data button, enter the Start and End date and time, and click Generate. The TOU Map Data List zone will refresh displayed the generated TOU map data.
  6. To edit TOU map data, click the Edit icon for the record you wish to change.