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 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 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:
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:
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 Allowed Values:
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:
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:
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:
Type: VARCHAR(30) Can Be Empty?: Yes. |