RX_INC_DEVICE_STEPS_HISTORY

OPERATION_ID

This field corresponds to the ID field in the RX_OPERATIONS 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).

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

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.

ACTUAL_STATUS

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

ACTION

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

PHASES

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