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.

QR code for this page

Was this helpful?