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.