RX_OPERATIONS_ARCHIVE

Field Name

Description

OPERATION_ID

This field corresponds to the ID field in the RX_OPERATIONS table.

ORDER_ID

The ID associated with a switching order. This field corresponds to the ID field in the RX_SWITCHING_ORDERS table.

INCIDENT_ID

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

SEQUENCE

The sequence number of the operation (the step number in the switching order).

TYPE

Indicates the type of operation (custom, tag, or device).

DESCRIPTION

Description of the operation (e.g., "Open", "Remove Ground", "Place Tag").

FCID

Feature class ID of the feature associated with the tag.

OID

Object ID of the feature associated with the tag.

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.

FACILITY_ID

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

SUBSTATION_ID

The ID of the substation that feeds the incident device.

FEEDER_ID

The Feeder ID of the incident device.

OPERATION_STATUS

Indicates whether the operation has been executed, not executed, or cancelled.

EXECUTED_BY

User name of the person who executed the operation.

TIME_EXECUTED

The time the operation was executed.

OWNER_STATE

This field tracks the state of a switching operation with regard to an external owner of a device. This field uses the Owner_State domain.

TIME_OWNER_APPROVED

This field tracks the time of approval by an external owner of the device (e.g., OASyS).

REMARKS

Notes from the operator or dispatcher.

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.

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.

EXECUTED_BY_NAME

The name of the user who executed the switching order operation.

LINE_TYPE

Indicates the type of operation (e.g., open close, tag, etc.).

SUMMARY

Any summary comments included by the user on the switching order operation.

FEATURE_CLASS_NAME

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

PARENT_SEQUENCE_ID

This value acts as a group number when grouping operations within a switching order. All operations in the same group share the same PARENT_SEQUENCE_ID.

QR code for this page

Was this helpful?