RX_TRUCKS_ARCHIVE

TRUCK_ID

The unique identifier assigned to the truck. This field corresponds to the ID field in the RX_TRUCKS table.

ASSIGNMENT_ID

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

NUMBER

The number assigned to the truck as an identifier.

REGION

The region in which the truck is located. This field uses the REGION domain.

TRUCK_TYPE

The type of truck.

RADIO1

The radio frequency at which the crew can be reached.

RADIO2

An alternative radio frequency at which the crew can be reached.

COMPANY

The company to which the truck belongs. This field uses the COMPANY domain.

STATUS

The status of the truck. This field uses the STATUS domain.

CREW_ID

Indicates the ID for the crew to which the truck has been assigned. This field corresponds to the ID field in the RX_CREWS 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.