Measuring Component Fields

Measuring components are single points for which data is received and stored in the utility's meter data management system. A measuring component can be associated with a device, which can have one or more measuring components. The measuring component entity includes fields related to channel, class, units of measure, and time of use.

Note: Although the fields below are described separately from the other fields in the premise data file, any premise data that you send to Oracle Utilities must be included in the same file, with all columns included in every row of the file. See Premise Data File Specifications for more information.

Field Description

measuring_component_id

The measuring component or channel identifier in a utility's Customer Information System or other system of record. It should be a value that allows identification of a particular channel or register.

Note: This field is not a unique ID. The combination of this field with the device_id field should be unique. See Device Fields for more information about the device_id. It also acceptable to use either the measuring_component_type_code or channel_id fields below to serve as the measuring_component_id.

Type: VARCHAR(40)

Can Be Empty?: No.

measuring_component_external_id

The external identifier of the channel, used in external systems such as head-end systems.

Type: VARCHAR(60)

Can Be Empty?: Yes.

channel_id

The identifier of the channel for interval data. If scalar data is being used, then this field should contain the identifier of the register.

Type: VARCHAR(120)

Can Be Empty?: Yes.

number_of_digits_left

The number of digits to the left of the decimal point that the reading can contain.

Type: DECIMAL(5,0). See Supported Decimal Formats for details.

Can Be Empty?: Yes.

number_of_digits_right

The number of digits to the right of the decimal point that the reading can contain.

Type: DECIMAL(5,0). See Supported Decimal Formats for details.

Can Be Empty?: Yes.

channel_multiplier

The factor used for multiplying the measurement obtained from the measuring component.

Type: DECIMAL(12,6). See Supported Decimal Formats for details.

Can Be Empty?: Yes.

measuring_component_type_code

The code for the measuring component type. For records that are null and the type of measuring component is unknown, use the value UNK to signify that it is unknown.

Example Value: E-RES-KWH-60

Type: VARCHAR(30)

Can Be Empty?: No.

measuring_component_type_description

The description of the measuring component type.

Example Value: Electric kWh 60min

Type: VARCHAR(100)

Can Be Empty?: Yes.

measuring_component_class

The class of the measuring component.

Allowed Values:

  • D1AG

    Aggregator

  • D1PH

    Physical

  • D1SP

    Scratchpad

  • D1SR

    Standalone Data Request

  • D1SS

    Statistics

  • D1ST

    Standalone

Type: VARCHAR(4)

Can Be Empty?: Yes.

interval_size

The size of the intervals measured by the measuring component. This is represented as a number of seconds, such as 3600 for hourly intervals.

If the meter is scalar, use a value of 0.

Allowed Values:

  • 0
  • 300
  • 900
  • 1800
  • 3600
  • 86400

Type: DECIMAL(5,0). See Supported Decimal Formats for details.

Can Be Empty?: No.

interval_scalar_flag

A flag that identifies if the attribute is interval or scalar. If the meter is not interval, then this field should be populated with SCALAR.

Allowed Values:

  • INTERVAL
  • SCALAR
  • D1IN
  • D1SC

Type: VARCHAR(30)

Can Be Empty?: No.

allows_negative_consumption

A flag that indicates if measuring components of this type can record negative consumption, such as in the case of two-way meters.

Allowed Values: True, False

Type: BOOLEAN. See Supported Boolean Formats for more information.

Can Be Empty?: Yes.

unit_of_measure

The unit of measure for the quantity being recorded.

Allowed Values:

  • A

    Amps

  • C

    Celsius

  • CCF

    Hundred Cubic Feet

  • CF

    Cubic Feet

  • CGL

    Hundred Gallons

  • CT

    Count

  • F

    Fahrenheit

  • GAL

    Gallons

  • KL

    Kilolitres

  • KVA

    Kilovolt-Ampere

  • KVAH

    Kilovolt-Ampere Hours

  • KVAR

    Kilovolt-Ampere Reactive

  • KVARH

    Kilovolt-Ampere Reactive Hours

  • KW

    Kilowatt

  • KWH

    Kilowatt-Hours

  • L

    Litres

  • M3

    Cubic Metre

  • MCF

    Thousand Cubic Feet

  • MGL

    Mega Gallons

  • ML

    Megalitres

  • MWH

    Megawatt-Hours

  • PERC

    Percentage

  • PF

    Power Factor

  • TH

    Thermal Units

  • V

    Volts

  • VA

    Volt-Ampere

  • VAH

    Volt-Ampere Hours

  • VAR

    Volt-Ampere Reactive

  • VARH

    Volt-Ampere Reactive Hours

  • W

    Watt

  • WH

    Watt-Hours

Type: VARCHAR(30)

Can Be Empty?: No.

time_of_use

The modifier for a given unit of measure that indicates a period of time during which a quantity has been used, such as Critical Peak or On-Peak.

Example Values:

  • On-Peak

    The time when the greatest quantity of some consumable is being used.

  • Off-Peak

    The time when the least amount of some consumable is being used.

Type: VARCHAR(12)

Can Be Empty?: Yes.

service_quantity_identifier

An identifier for distinguishing between measured quantities that have identical unit of measure (UOM) and time of use (TOU) combinations.

Example Values:

  • ADU

    Average Daily Usage

  • COIN

    Coincident

  • CONSUMED

    Consumed

  • DELIVERED

    Delivered

  • GEN

    Generation

  • NET_USAGE

    Net Usage

  • OFFDMD

    Contract Off Peak Demand

  • RECEIVED

    Received

Type: VARCHAR(30)

Can Be Empty?: Yes.

Back to Top