Defining Standard Measurement Identifiers

Oracle Utilities Data Intelligence (OUDI) can perform data aggregation and enrichment on Advanced Metering Infrastructure (AMI) data extracted from Oracle Utilities Meter Solution Cloud Service and Oracle Utilities Customer Cloud Service. Data is extracted using Measurement Data Extract.

Enabling the extract process requires defining the data to extract which involves defining the "standard measurement identifiers" used by Data Intelligence in Meter Solution Cloud Service and Customer Cloud Service, and mapping those identifiers to specific combinations of Units of Measure (UOM), Time of Use (TOU), and Service Quantity Identifiers (SQI) for specific service types.

Extendable Lookups

The Standard Measurement Identifier (D1-StdMsrmtIdentifierLookup) extendable lookup is used to define standard measurement identifiers. Values for this extendable lookup include the following:

  • Standard Measurement Identifier: A code for the identifier
  • Standard Service Type: The basic or standard service type for the identifier, from the Standard Service Type (STD_​SVC_​TYPE_​FLG) lookup.
  • Status: The current status of the identifier
  • Description: The label used for the identifier in the Meter Solution Cloud Service and Customer Cloud Service user interface.

As an example, the standard measurement identifier for consumed electric kilowatt hours is defined as follows:

  • Standard Measurement Identifier: E-KWH-CONS
  • Standard Service Type: Electric
  • Status: Active
  • Description: Electric kWh - Consumed

The base package includes the following predefined standard measurement identifiers:

Standard Measurement Identifier Standard Service Type Status Description
E-KW Electric Active Electric Kilowatt
E-KWH-CONS Electric Active Electric kWh - Consumed
E-KWH-GEN Electric Active Electric kWh - Generated
G-THERMS Gas Active Gas Therms
W-CCF Water Active Water - 100 Cubic Feet

Master Configurations

A set of "Measurement Identification Configuration" master configurations are used to map relationships between "standard measurement identifiers" defined in the Standard Measurement Identifier (D1-StdMsrmtIdentifierLookup) extendable lookup and specific UOM/TOU/SQIs combinations per service type. There are three of these master configurations, one for each of the Standard Service Types used in the extendable lookup. These are:

  • Measurement Identification - Electric Configuration (D1-MsrmtIdentifyElectricConfig)
  • Measurement Identification - Gas Configuration (D1-MsrmtIdentifyGasConfig)
  • Measurement Identification - Water Configuration (D1-MsrmtIdentifyWaterConfig)

Mappings in these master configurations are defined by the following:

  • Service Type: The service type associated with a channel (see Service Types (LINK) for more information)
  • Channel Identification: Details regarding how to identify data for a channel, including
    • Standard Measurement Identifier: One or more standard measurement identifiers (from the Standard Measurement Identifier (D1-StdMsrmtIdentifierLookup) extendable lookup) for the channel
    • Color Option: The color used to display measurement data for this channel (from the Color Option (F1-Color) extendable lookup)
    • Measurement Value Identification: One more UOM/TOU/SQI combinations that defines what the channel measures
      • Unit of Measure: The unit of measure for the combination, such as kWh, kW, and so on
      • Time of Use: The time of use period for the combination, such as On-Peak, Off-Peak, and so on
      • Service Quantity Identifier: The service quantity identifier for the combination, such as "Generated", "Consumed", and so on

For example, the following configuration could be used to map three standard measurement identifiers (Electric kWh - Consumed, Electric kWh - Generated, and Electric kW) to the "Electric Services" service type and define the UOM/TOU/SQI combinations for each.

  • Service Type: Electric Service
  • Channel Identification:
    • Standard Measurement Identifier: Electric kWh - Consumed
    • Color Option: Green 010
    • Measurement Value Identification:
      • Unit of Measure: Kilowatt Hour
      • Service Quantity Identifier: Consumed
    • Measurement Value Identification:
      • Unit of Measure: Kilowatt Hour
    • Standard Measurement Identifier: Electric kWh - Generated
    • Color Option: Blue 010
    • Measurement Value Identification:
      • Unit of Measure: Kilowatt Hour
      • Service Quantity Identifier: Generated
    • Standard Measurement Identifier: Electric Kilowatt
    • Color Option: Orange 010
    • Measurement Value Identification:
      • Unit of Measure: Kilowatt