RX_CREW_ASSIGNMENTS_HISTORY

ASSIGNMENT_ID

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

INCIDENT_ID

The ID associated with the incident to which the crew has been assigned. This field corresponds with the ID field in the RX_INCIDENTS table.

CREW_ID

Indicates the ID for the crew that has been assigned to the incident. This field corresponds to the ID field in the RX_CREWS table.

STATUS

Indicates the status of the crew. This field uses the STATUS domain.

TIME ASSIGNED

The time the crew was assigned to the incident.

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.

IS_LEAD_CREW

Indicates whether the crew is the lead crew. This field uses the IS_LEAD_CREW domain.

TIME_STATUS_CHANGED

This is the time that a crew's status was changed (e.g., from Dispatched to Working) after it was modified by a dispatcher.