RX_INC_DEVICE_STEPS_ARCHIVE

INCIDENT_DEVICE_STEP_ID

The ID associated with the device step.

OPERATION_ID

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

INCIDENT_ID

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

EXPECTED_STATUS

The expected or normal status of the device (open, closed).

PLANNED_STATUS

The planned status of the device (e.g. Open, Closed).

ACTUAL_STATUS

The current actual status of the device (open, closed).

PLANNED_CUSTOMER_COUNT

The number of customers affected by a planned step. This value indicates a net change in the number of energized customers. It will be either a positive number (power restored to customers) or negative number (customers losing power).

PLANNED_CRITICAL_COUNT

The number of critical customers affected by a planned step. This value indicates a net change in the number of energized customers. It will be either a positive number (power restored to customers) or negative number (customers losing power).

PLANNED_CONNECTED_LOAD

Amount (in kVA) by which the total system connected load will change due to the planned step.

EXECUTED_CUSTOMER_COUNT

The number of customers affected by an executed step. This value indicates a net change in the number of energized customers. It will be either a positive number (power restored to customers) or negative number (customers losing power).

EXECUTED_CRITICAL_COUNT

The number of critical customers affected by an executed step. This value indicates a net change in the number of energized customers. It will be either a positive number (power restored to customers) or negative number (customers losing power).

EXECUTED_CONNECTED_LOAD

Amount (in kVA) by which the total system connected load will change due to the executed step.

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.

FCID

Feature class ID of the feature associated with the tag.

FEATURE_CLASS_NAME

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

ACTION

The action to be taken by the operation (e.g., open, close).

PHASES

The phase(s) to be operated by the step.