RX_INCIDENTS_ARCHIVE
Field Name |
Description |
---|---|
INCIDENT_ID |
The ID associated with the incident. This field corresponds with the ID field in the RX_INCIDENTS table. |
STATUS |
The status of the incident. This field uses the STATUS domain. |
REGION |
The region in which the incident is located. This field uses the REGION domain. |
OWNER |
The dispatcher to whom the incident has been assigned. |
CRITICAL |
Indicates if the incident is at a customer site that is critical. This field uses the CRITICAL domain. |
CAUSE |
Indicates the cause of the outage. This field uses the CAUSE domain. |
WEATHER |
Indicates the weather at the incident site. This field uses the WEATHER domain. |
TROUBLE |
Indicates the problem reported by the customer (e.g., no power, flickering lights, etc.). This field uses the TROUBLE domain. |
CUSTOMER_COUNT |
Indicates the number of customers affected by the incident. |
TIME_CREATED |
The time the incident was created. |
TIME_OUTAGE |
The time the outage occurred. |
TIME_RESTORED_EST |
The time power is estimated to be restored. |
TIME_RESTORED |
The time power is actually restored. |
REMARKS_DISPATCH |
Remarks from the dispatcher. |
REMARKS_FIELD |
Remarks from the field crew. |
USER_CREATED |
The name of the user who created the record. This field is populated automatically by Responder. |
USER_UPDATED |
The name of the user who updated the record. This field is populated automatically by Responder. |
CHANGE_DATE |
The time and date an operation was performed on the record. |
OPERATION |
The operation (e.g., insert, delete, update) performed on the record. |
CRITICAL_CUSTOMER_COUNT |
Indicates the number of critical customers affected by the incident. |
PRIORITY_CUSTOMER_COUNT |
Indicates the number of priority customers affected by the incident. |
FEEDER_ID |
The Feeder ID of the incident device. |
SUBSTATION |
The substation that feeds the incident device. |
CONFIRMED |
Indicates whether the device has been confirmed out. This field uses the CONFIRMED domain. |
ORIGINATION |
Indicates whether an incident was created by a user or by Prediction Services. |
USER_UPDATED_ARCH |
This field is not currently used by Responder. You may customize Responder to populate this field with the name of the user who updated the record. |
CANCEL_REASON |
Reason the incident was cancelled. |
NETWORK_LEVEL |
This value indicates the grouping to which the incident device belongs. For example, incidents may be grouped by distribution versus transmission. In this case all incident devices would have a Network Level value of distribution or transmission. |
ADDRESS |
The address where the incident is located. |
EQUIPMENT |
The equipment relevant to the incident. |
VOLTAGE |
The voltage of the incident or its related devices. |