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.

QR Code is a registered trademark of DENSO WAVE INCORPORATED in Japan and other countries.

Was this helpful?