RX_INC_FEAT_ASSIGN_ARCHIVE

INC_FEATURE_ASSIGN_ID

ID from the incident feature assignment table. Corresponds to the ID field in the RX_INC_FEAT_ASSIGNMENTS table.

INCIDENT_FEATURE_ID

The unique identifier assigned to the incident feature. This field corresponds to the ID field in the RX_INCIDENT_FEATURES table.

CREW_ASSIGNMENT_ID

The unique identifier assigned to each crew assignment. This field corresponds with the ID field in the RX_CREW_ASSIGNMENTS table.

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.

INCIDENT_ID

The ID associated with the incident. This field acts as a foreign key to the RX_INCIDENTS table.