RX_INCIDENT_DEVICES

Much of the data in this table may be viewed on Responder Explorer Incidents tab by right-clicking an incident device and selecting Edit Device.

Field Name

Description

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 acts as a foreign key to 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

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.

FACILITY_ID

The Facility ID of the incident device 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).

REGION

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

CANCEL_REASON

Reason the device was cancelled.

QR code for this page

Was this helpful?