AMR_REQUESTS is populated by the outage prediction engine when a request for meter information is submitted. There is one row per request, and each request can involve multiple meters.
Field
DataType
Nullable
Comments
REQUEST_IDX
NUMBER
No
AMR request id.
PRIMARY KEY
EVENT_CLS
NUMBER
No
The class part of the handle of the event for which the AMR request was made.
EVENT_IDX
NUMBER
No
The index part of the handle of the event for which the AMR request was made.
REQUEST_TIME
DATE
No
The timestamp when the AMR request was created.
WHO_REQUESTED
VARCHAR2(32)
Yes
User name of the operator who created the AMR request.
AMR_COMPLETE_TIME
DATE
Yes
The timestamp when the AMR request was completed or cancelled.
WHO_COMPLETED
VARCHAR2(32)
Yes
User name of the operator who completed or cancelled the AMR request.
REQUEST_TYPE
NUMBER
Yes
Request type.
Possible values:
•
1 - PSO Verification
•
2 - PDO Verification
•
3 - Restoration Verification
•
4 - Manual
QUERY_TYPE
NUMBER
Yes
Query type.
Possible values:
•
0 - simple meter status query
•
1 - complex meter information query
STATUS
NUMBER
Yes
Status of the AMR request.
Possible values:
1- active
2 - explicitly completed
3 -cancelled
DEVICE_CLS
NUMBER
Yes
The class part of the handle of the device for which the AMR request was made.
DEVICE_IDX
NUMBER
Yes
The index part of the handle of the device for which the AMR request was made.
NCG
NUMBER
Yes
NCG of the device for which the AMR request was made.