Table AMR_CU_METERS contains information about all meters known to the Oracle Utilities Network Management System. This table is also used to cache the latest known meter status information to reduce the number of requests to the AMR system.
Field
DataType
Nullable
Comments
METER_ID
VARCHAR2(14)
No
Meter identifier in Oracle Utilities Network Management System.
METER_NO
VARCHAR2(20)
Yes
Meter identifier used by the AMR system.
RESULT_TIME
DATE
Yes
Timestamp of the latest meter status update.
POWER_UP_TIME
DATE
Yes
Timestamp of the latest power-up message.
LAST_GASP_TIME
DATE
Yes
Timestamp of the latest "last gasp" message.
ALT_METER_NO
VARCHAR2(256)
Yes
Alternative meter number.
AMR_ENABLED
VARCHAR2(1)
Yes
Indicator that meter is AMR-enabled.
STATUS
VARCHAR2(256)
Yes
Latest known meter status.
Possible values:
•
ON - meter has power
•
OFF - meter does not have power
REQUEST_IDX
NUMBER
Yes
AMR request id for the latest received meter status.
PROBABILITY
NUMBER
Yes
Latest known probability of the meter having power (0 - no power; 100 - meter has power).