RX_CREWS_ARCHIVE

CREW_ID

Unique identifier assigned to the crew. This is the table primary key.

CREW_NAME

The name of the crew.

CREW_TYPE

The type assigned to the crew.

REGION

The region in which the crew works. This field uses the REGION domain.

COMPANY

The company for which the crew works. This field uses the COMPANY domain.

STATUS

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

FOREMAN_EMP_ID

The employee ID of the crew's foreman.

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.

ASSIGNMENT_ID

The ID associated with the crew assignment. Corresponds to the ID field in the RX_CREW_ASSIGNMENTS table.

INCIDENT_ID

The ID associated with the incident. This field acts as a foreign key to the RX_INCIDENTS table.