RX_CREW_MEMBERS_HISTORY

CREW_MEMBER_ID

The unique identifier assigned to the crew member. This field corresponds to the ID field in the RX_CREW_MEMBERS table.

REGION

Indicates the region in which the crew member works primarily. This field uses the REGION virtual domain.

UTILITY_TYPE

Indicates the type of utility for which the crew member works (gas, electric, water, cable). This field uses the UTILITY_TYPE domain.

CREW_ID

Indicates the ID of the crew to which the members have been assigned. This field corresponds to the ID field in the RX_CREWS table.

FIRSTNAME

The crew member's first name.

LASTNAME

The crew member's last name.

TITLE

The crew member's title. This field uses the TITLE domain.

EMPLOYEE_ID

The crew member's employee ID.

MOBILE_PHONE

The crew member's mobile phone number.

HOME_PHONE

The crew member's home phone number.

PAGER

The crew member's pager number.

RADIO_NUMBER

The crew member's radio number.

COMPANY

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

AVAILABLE

Indicates the crew member's availability. This field uses the AVAILABLE domain.

EXPERTISE

Indicates the crew member's expertise. This field uses the EXPERTISE domain.

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.