RX_OPERATIONS_HISTORY

Field Name

Description

ORDER_ID

The ID associated with a switching order. This field corresponds to the ID field in the RX_SWITCHING_ORDERS 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 that was operated upon.

OID

Object ID of the feature that was operated upon.

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.

REMARKS

Remarks associated with the operation.

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.

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).

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.

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.

CONTEXT

Additional information to be included in the name of a Step on a Switch Order.

QR code for this page

Was this helpful?