Rates Data File Name Conventions

All files transferred to Oracle Utilities must follow the standard naming convention. Your Delivery Team will work with you to define the appropriate file names for any other files that must be automatically generated and transferred.

File name components enclosed in angle brackets (<>) must be populated. File name components enclosed in square brackets ([]) are optional and can be included or left out. Any components without brackets must be part of the file name and should not be changed.

Note: Not all files listed below are applicable or required for every utility. Your Delivery Team will work with you to determine which files are required.

Rate Attributes File:

opwr_<utility>_<population token>_<specification version number>_customer_rates_attributes_<yyyyMMddHHmmss>.gz

Baselines File:

opwr_<utility>_<population token>_<specification version number>_peak_time_rebate_baselines_<yyyyMMddHHmmss>.gz

Rate Prices File:

opwr_<utility>_<population token>_<specification version number>_rate_prices_<yyyyMMddHHmmss>.gz

Rate Tier Definitions File:

opwr_<utility>_<population token>_<specification version number>_rate_tier_definition_<yyyyMMddHHmmss>.gz

Rate Period Definition File:

opwr_<utility>_<population token>_<specification version number>_rate_period_definition_<yyyyMMddHHmmss>.gz

Holidays and Seasons File:

opwr_<utility>_<population token>_<specification version number>_rate_holidays_seasons_definition_<yyyyMMddHHmmss>.gz

Peak Pricing Event File:

opwr_<utility>_<population token>_<specification version number>_peak_events_<yyyyMMddHHmmss>.gz

Peak Time Rebates File:

opwr_<utility>_<population token>_<specification version number>_peak_time_rebates_<yyyyMMddHHmmss>.gz

The naming convention is made up of the following components:

  • Prefix: The opwr prefix, which is the standard abbreviation for Oracle Utilities Opower.
  • Utility Identifier: A three- or four-character code that identifies the utility sending the file. Your Delivery Team will work with you to choose the utility code early in the implementation process. The code needs to be a unique identifier for the utility in the Oracle Utilities Opower system. For example, “The Great Energy Company” might have an identifier of gec.
  • Population Token: An abbreviation that indicates whether the data is applicable to residential (res) or non-residential (nonres) customer populations. For the non-residential category, there are additional segmentations available to designate Small and Medium Business populations (nonres-smb) or Large Commercial Industrial populations (nonres-lci). Consult your Service Delivery Manager to determine which is the most appropriate population token if you need to use additional segmentations.
  • Specification Version Number: A three-digit version number of the data transfer specification. Each digit must be separated by a hyphen (-) and not a period or an underscore. This must match the latest number shown in the Specification Version Number column in Rates Data Version History.
  • Data Type: The filename should identify the type of rate data the file contains, such as customer_rates_attributes, peak_time_rebate_baselines, or rate_prices.
  • Date: The date that the file was generated, in the format yyyyMMddHHmmss.
  • File Extension: All files should be gzipped and should end with .gz, or be zipped and end with .zip. If you choose to PGP encrypt your files, then the .pgp extension should be used. In the case of PGP encryption, compression is not required since the encryption process includes file compression. Files can be up to one gigabyte compressed, or up to four gigabytes uncompressed.

Back to Top

Example Names

Suppose the population token is residential, the specification version number of the document is v1-0-0, and your utility is named "The Great Energy Company.” Some examples of your utility’s filenames would be as follows:

opwr_gec_res_v1-0-0_customer_rates_attributes_20210316131415.gz

opwr_gec_res_v1-0-0_peak_time_rebate_baselines_20210316131415.gz

opwr_gec_res_v1-0-0_peak_events_20210316131415.gz

Suppose your utility is using PGP-encrypted files. An example of your utility’s filename would be as follows:

opwr_gec_res_v1-0-0_customer_rates_attributes_20210316131415.pgp

Back to Top

Additional Notes

The filename must not exceed 183 characters and must not contain a period (.) unless the period comes right before the file extension. The Oracle Utilities Opower file reception system considers the first period in the file name to be the beginning of a file extension. For example, the following file name is invalid and cannot be processed:

opwr.gec.res.v1.0.0.customer.rates.attributes.20210316131415.gz

Back to Top