RX_CREWS_HISTORY

CREW_ID

Indicates the ID of the crew. This field corresponds to the ID field in the RX_CREWS table.

CREW_NAME

The name of the crew.

REGION

The region in which the crew works. This field uses the REGION virtual 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

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.

CREW_TYPE

The type assigned to the crew.