RX_INCIDENT_DEVICES_ARCHIVE

Field Name

Description

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.

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.

INCIDENT_ID

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

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.

FEEDER_ID

The Feeder ID of the incident device.

FACILITY_ID

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

REGION

The region in which the device is located. This field uses the REGION domain.

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.

EXPECTED_STATUS

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

ACTUAL_STATUS

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

CUSTOMER_COUNT

Indicates the number of customers affected by the incident.

TIME_OPERATION

The time the device was opened or closed for repair.

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_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 device was cancelled.

FEATURE_CLASS_NAME

The name of the Feature Class on which the incident occurred, as it was configured/named when the Incident was archived.

ADDRESS

The address where the incident is located

REMARKS

Notes from the operator or dispatcher.

QR code for this page

Was this helpful?