RX_OPERATIONS

Field Name

Description

ORDER_ID

The ID associated with a switching order (foreign key to RX_SWITCHING_ORDERS).

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

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.

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.

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

QR code for this page

Was this helpful?