RX_CREW_ASSIGNMENTS

Much of the data in this table may be viewed in Responder Explorer by right-clicking a crew and selecting Edit Crew.

Field Name	Description
INCIDENT_ID	Indicates the ID of the incident to which the crew has been assigned. This field is a foreign key to the RX_INCIDENTS table.
CREW_ID	Indicates the ID of the crew that has been assigned to the incident. This field is a foreign key to 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.
IS_LEAD_CREW	Indicates whether the crew is the lead crew. This field uses the IS_LEAD_CREW domain.
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.
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.
PREVIOUS_TIME	This is the original time that the crew's status was set.
MOBILE_CREW_ENABLED	A value that indicates whether the crew has been assigned a Mobile status.