Crew CSV Columns

The columns in the Crew CSV file matches the CREWS database table column names:

CREW_KEY: numerical key for the crew

CREW_TYPE: CREW_TYPES.CREW_TYPE value

TEMP_FLAG: temporary crew Y/N flag

ZONE_NAME: CONTROL_ZONES.NAME value

ZONE_CLS: CONTROL_ZONES.NCG_CLASS value

ZONE_IDX: CONTROL_ZONES.NCG_ID value

CREW_SIZE: the crew size

CONTACT: the contact name

CREW_NAME: the crew name

MOBILE_NUM: the mobile number

MOBILE_CARRIER: the mobile carrier

ALTERNATE_NUM: the alternate contact number

ALTERNATE_NUM_TYPE: the alternate contact number type

PAGER_NUM: the pager number

MDT_CREW: MDT crew Y/N flag

EXTERNAL_KEY: external ID of the crew

OUT_OF_RANGE: out of range Y/N flag

MOBILE_FLAG: Y, N, or O (mobile overridden for NMS)

MEMBERS: colon-separated list of MEMBER_EMP_NUMB

VEHICLES: colon-separated list of VEHICLE_NUMB