RX_LOADPOINTS_ARCHIVE

Field Name

Description

LOADPOINT_ID

The unique identifier assigned to the loadpoint. This field corresponds to the ID field in the RX_LOADPOINTS table.

DEVICE_OID

The object ID of the incident device affecting the loadpoint (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 affecting the loadpoint (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_OUTAGE

The time the outage occurred.

TIME_RESTORED

The time power is actually restored.

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.

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.

INCIDENT_DEVICE_OID

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

INCIDENT_DEVICE_FCID

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

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.

FEEDER_ID

The Feeder ID of the incident device.

CUSTOMER_ACCOUNT

Account number of the customer associated with the loadpoint.

FEATURE_CLASS_NAME

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

INC_DEV_FEATURE_CLASS_NAME

The name of the Feature Class for this Incident Device, as it was configured/named when the Incident Device was archived.

QR code for this page

Was this helpful?