| Column name |
Type |
Definition |
| TRIPS_JOIN |
number(8,0) |
An assigned number (up to eight digits) that uniquely identifies each
cruise_vessel trip. |
| CRUISE |
number(8,0) |
A unique five-digit number assigned to the observer for the length of their contract period. This number alone identifies and groups a set of observer information. |
| VESSEL |
varchar2(4) |
A unique four-digit, alpha-numeric code identifying each vessel that
contracts for observer coverage. All vessel codes begin with the alpha code A, followed by a three-digit
number, or for plants, the codes begin with the alpha code P, followed by a three-digit number. |
| DATE_OF_ENTRY |
date |
The date in which this entry was made. |
| VESSEL_TYPE |
number(2,0) |
A one-digit numeric code that indicates whether the vessel processes fish or
delivers it to a processing plant where: 1 = a catcher processor vessel, 2 = a mothership or a ship
that receives unsorted codends from other vessels, 3 = a catcher only vessel that delivers unprocessed fish
to a shoreside or floating plant or vessel, 4 = a mothership that receives sorted codends, 5 = a vessel
that sells the majority of their catch over the side to other fishing vessels who will utilize the fish
for bait, 6 = vessels that discard all catch from a haul; would be used for codend dumping of an entire
haul (added January 2004). |
| GEAR_TYPE |
number(2,0) |
A one- or two-digit numeric code that indicates the kind of fishing gear used by
the vessel, where: 1 = non-pelagic trawl, 2 = pelagic trawl, 3 = unknown or mixed trawl, 4 = pair trawl,
5 = shrimp trawl, 6 = pot or trap, 7 = jig, 8 = longline, 9 = gill net, and 10 = Scottish seine. |
| FORM_A |
varchar2(1) |
A one digit code identifying whether data was collected for this form, N = no; Y = yes; blank = not applicable. |
| FORM_1 |
varchar2(1) |
A one digit code identifying whether data was collected for this form, N = no; Y = yes; blank = not applicable (other characters have no meaning). |
| FORM_2 |
varchar2(1) |
A one digit code identifying whether data was collected for this form, N = no; Y = yes; blank = not applicable (other characters have no meaning). |
| FORM_3 |
varchar2(1) |
A one digit code identifying whether data was collected for this form, N = no; Y = yes; blank = not applicable (other characters have no meaning). |
| FORM_3REP |
varchar2(1) |
A one digit code identifying whether data was collected for this form, N = no; Y = yes; blank = not applicable (other characters have no meaning). |
| FORM_7 |
varchar2(1) |
A one digit code identifying whether data was collected for this form, N = no; Y = yes; blank = not applicable (other characters have no meaning). |
| FORM_9 |
varchar2(1) |
A one digit code identifying whether data was collected for this form, N = no; Y = yes; blank = not applicable (other characters have no meaning). |
| FORM_10 |
varchar2(1) |
A one digit code identifying whether data was collected for this form, N = no; Y = yes; blank = not applicable (other characters have no meaning). |
| FORM_11 |
varchar2(1) |
A one digit code identifying whether data was collected for this form, N = no; Y = yes; blank = not applicable (other characters have no meaning). |
| CREW_COUNT |
NUMBER(4,0) |
The number of crew members aboard the vessel. |
| CAPTAINS |
varchar2(3) |
Responses are: Yes; No; blank. Uncertain what this means. |
| CAPTAIN1_NAME |
varchar2(40) |
The name of the first captain during this deployment. |
| CAPTAIN1_FROM_DATE |
date |
The beginning date for the first captain. |
| CAPTAIN1_TO_DATE |
date |
The ending date for the first captain. |
| CAPTAIN2_NAME |
varchar2(40) |
The name of the second captain (if any) during this deployment. |
| CAPTAIN2_FROM_DATE |
date |
The beginning date for the second captain (if any). |
| CAPTAIN2_TO_DATE |
date |
The ending date for the second captain (if any). |
| DEPLOYMENT_SCORE |
number(1,0) |
The score awarded the observer for this deployment, 0 = did not meet expectations, 1 = met or exceeded expectations, 2 = exceeded expectations (was used prior to 2007), 9 = could not evaluate due to sickness. |
| DATA_STATUS |
varchar2(2) |
Old two digit alpha codes formerly used to identify the current status of a cruise-vessel as it went through the data entry process. |
| JOB_NUMBER |
varchar2(6) |
An assigned number (up to six digits) that identifies a set of cruises sent to an outside vendor for keying (is no longer used). |
| ZERO_SAMPLED_HAULS_FLAG |
varchar2(1) |
Is no longer used. |
| WOC_FLAG |
varchar2(1) |
A one digit code (Y = yes; N = no) which indicates whether the cruise-vessel deployment operated off the Washington-Oregon-California coast or not. |
| GOA_FLAG |
varchar2(1) |
A one digit code (Y = yes; N = no) which indicates whether the cruise-vessel deployment operated in the Gulf of Alaska or not. |
| BSA_FLAG |
varchar2(1) |
A one digit code (Y = yes; N = no) which indicates whether the cruise-vessel deployment operated in the Bering Sea/Aleutian Islands or not. |
| MORE_CAPTAINS |
varchar2(1) |
Responses are: Y; N. Uncertain what this means. |
| DATE_OF_CHANGE |
date |
Date of the most recent change to the record. |
| VHS_OHS |
varchar2(1) |
A one digit code identifying whether data was collected for this form, N = no; Y = yes; blank = not applicable. |
| DATA_VERIFICATION_FLAG |
varchar2(1) |
A one digit code identifying whether data from this deployment has been verified or not, N = no; Y = yes. |
| DATA_MOVED_FLAG |
varchar2(1) |
A one digit code identifying whether data from this deployment has been moved to the database, N = no; Y = yes. No longer collected after 2007. |
| DATA_COLLECTED_FLAG |
varchar2(1) |
A one digit code identifying whether data was collected during this deployment, N = no; Y = yes, blank = deployment not yet completed. |
