RX_CREW_MEMBERS
Field Name |
Description |
---|---|
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 crew to which the member is assigned. This field acts as a foreign key to 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. |