RX_TRUCKS_HISTORY

Field Name

Description

TRUCK_ID

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

REGION

The region in which the truck is located. This field uses the REGION virtual 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 of the crew to which the truck has been assigned. This field corresponds to the ID field in the RX_CREWS table.

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.

TRUCK_NUMBER

The number assigned to the truck.

QR Code is a registered trademark of DENSO WAVE INCORPORATED in Japan and other countries.

Was this helpful?