RX_CREW_MEMBERS_ARCHIVE

CREW_MEMBER_ID

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

ASSIGNMENT_ID

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

REGION

Indicates the region in which the crew member works primarily. This field uses the REGION 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 for the crew to which the member has 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

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.