RX_INCIDENT_DEVICES_HISTORY

INCIDENT_DEVICE_ID

The unique identifier assigned to the incident device. This field corresponds to the ID field in the RX_INCIDENT_DEVICES table.

DEVICE_OID

The object ID of the incident device (e.g., service point or transformer). This field links to the OID field in your geodatabase.

DEVICE_FCID

The feature class ID of the incident device (e.g., service point or transformer). This field utilizes the DEVICE_FCID domain.

INCIDENT_ID

The ID associated with the incident. This field corresponds with the ID field in the RX_INCIDENTS table.

TIME_OPERATION

The time the device was opened or closed for repair.

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.

DEVICE_OPERATION

Indicates the type of operation the device performs (Fault/Switching Operation). This field uses the DEVICE_OPERATION domain.

CUSTOMER_COUNT

Indicates the number of customers affected by the incident.

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.

USER_CREATED

This field is not currently used by Responder. You may customize Responder to populate this field with the name of the user who created the record.

USER_UPDATED

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.

CHANGE_DATE

The date an operation was performed on the incident record.

OPERATION

The operation (e.g., insert, delete, update) performed on the incident record.

FACILITY_ID

The Facility ID of the incident feature as defined in the geodatabase.

EXPECTED_STATUS

The expected or normal status of the device (open, closed).

ACTUAL_STATUS

The current actual status of the device (open, closed).

SUBID

The unique ID of each segment of a complex edge.

X

The x-coordinate of the incident device.

Y

The y-coordinate of the incident device.

CANCEL_REASON

Reason the device was cancelled.

ADDRESS

The address where the incident is located

REMARKS

Notes from the operator or dispatcher.