Slide Menu
Jump to Section...
Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > North Pacific (NORPAC) Groundfish and Halibut O... > AFSC/FMA/Observer Logistics System (OLS) >

Table: CRUISE_VESSEL

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:12280  |  Updated: August 9, 2022  |  Published / External 

Item Identification

Title: Table: CRUISE_VESSEL
Short Name: CRUISE_VESSEL
Status: Completed
Abstract:

This table provides information about the fishing operation that was performed on this cruise_vessel trip.
Notes:

Loaded by batch 3083, 04-19-2012 13:25

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: NORPAC
Description:

This table provides information about the fishing operation that was performed on this cruise_vessel trip.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key TRIPS_JOIN NUMBER An assigned number (up to eight digits) that uniquely identifies each cruise_vessel trip.
100
 CRUISE NUMBER 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.
100
 VESSEL VARCHAR2 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.
100
 DATE_OF_ENTRY DATE The date in which this entry was made.
100
 VESSEL_TYPE NUMBER 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).
100
 GEAR_TYPE NUMBER 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.
100
 FORM_A VARCHAR2 A one digit code identifying whether data was collected for this form, N = no; Y = yes; blank = not applicable.
100
 FORM_1 VARCHAR2 A one digit code identifying whether data was collected for this form, N = no; Y = yes; blank = not applicable (other characters have no meaning).
100
 FORM_2 VARCHAR2 A one digit code identifying whether data was collected for this form, N = no; Y = yes; blank = not applicable (other characters have no meaning).
100
 FORM_3 VARCHAR2 A one digit code identifying whether data was collected for this form, N = no; Y = yes; blank = not applicable (other characters have no meaning).
100
 FORM_3REP VARCHAR2 A one digit code identifying whether data was collected for this form, N = no; Y = yes; blank = not applicable (other characters have no meaning).
100
 FORM_7 VARCHAR2 A one digit code identifying whether data was collected for this form, N = no; Y = yes; blank = not applicable (other characters have no meaning).
100
 FORM_9 VARCHAR2 A one digit code identifying whether data was collected for this form, N = no; Y = yes; blank = not applicable (other characters have no meaning).
100
 FORM_10 VARCHAR2 A one digit code identifying whether data was collected for this form, N = no; Y = yes; blank = not applicable (other characters have no meaning).
100
 FORM_11 VARCHAR2 A one digit code identifying whether data was collected for this form, N = no; Y = yes; blank = not applicable (other characters have no meaning).
100
 CREW_COUNT NUMBER The number of crew members aboard the vessel.
100
 CAPTAINS VARCHAR2 Responses are: Yes; No; blank. Uncertain what this means.
100
 CAPTAIN1_NAME VARCHAR2 The name of the first captain during this deployment.
100
 CAPTAIN1_FROM_DATE DATE The beginning date for the first captain.
100
 CAPTAIN1_TO_DATE DATE The ending date for the first captain.
100
 CAPTAIN2_NAME VARCHAR2 The name of the second captain (if any) during this deployment.
100
 CAPTAIN2_FROM_DATE DATE The beginning date for the second captain (if any).
100
 CAPTAIN2_TO_DATE DATE The ending date for the second captain (if any).
100
 DEPLOYMENT_SCORE NUMBER 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.
100
 DATA_STATUS VARCHAR2 Old two digit alpha codes formerly used to identify the current status of a cruise-vessel as it went through the data entry process.
100
 JOB_NUMBER VARCHAR2 An assigned number (up to six digits) that identifies a set of cruises sent to an outside vendor for keying (is no longer used).
100
 ZERO_SAMPLED_HAULS_FLAG VARCHAR2 Is no longer used.
100
 WOC_FLAG VARCHAR2 A one digit code (Y = yes; N = no) which indicates whether the cruise-vessel deployment operated off the Washington-Oregon-California coast or not.
100
 GOA_FLAG VARCHAR2 A one digit code (Y = yes; N = no) which indicates whether the cruise-vessel deployment operated in the Gulf of Alaska or not.
100
 BSA_FLAG VARCHAR2 A one digit code (Y = yes; N = no) which indicates whether the cruise-vessel deployment operated in the Bering Sea/Aleutian Islands or not.
100
 MORE_CAPTAINS VARCHAR2 Responses are: Y; N. Uncertain what this means.
100
 DATE_OF_CHANGE DATE Date of the most recent change to the record.
100
 VHS_OHS VARCHAR2 A one digit code identifying whether data was collected for this form, N = no; Y = yes; blank = not applicable.
100
 DATA_VERIFICATION_FLAG VARCHAR2 A one digit code identifying whether data from this deployment has been verified or not, N = no; Y = yes.
100
 DATA_MOVED_FLAG VARCHAR2 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.
100
 DATA_COLLECTED_FLAG VARCHAR2 A one digit code identifying whether data was collected during this deployment, N = no; Y = yes, blank = deployment not yet completed.

Attribute Details

TRIPS_JOIN

CC ID: 65075
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 8
Scale: 0
Status: Active
Description:

An assigned number (up to eight digits) that uniquely identifies each cruise_vessel trip.
General Data Type: NUMBER

CRUISE

CC ID: 65076
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 8
Scale: 0
Status: Active
Description:

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.
General Data Type: NUMBER
Foreign Key Relations:

NORPAC.CRUISES

VESSEL

CC ID: 65077
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 6
Required: Yes
Primary Key: No
Status: Active
Description:

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.
General Data Type: VARCHAR2
Foreign Key Relations:

NORPAC.VESSPLNT

DATE_OF_ENTRY

CC ID: 65078
Seq. Order: 4
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

The date in which this entry was made.
General Data Type: DATE

VESSEL_TYPE

CC ID: 65079
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

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).
General Data Type: NUMBER

GEAR_TYPE

CC ID: 65080
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

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.
General Data Type: NUMBER
Foreign Key Relations:

NORPAC.DOMESTIC_GEAR

FORM_A

CC ID: 65081
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

A one digit code identifying whether data was collected for this form, N = no; Y = yes; blank = not applicable.
General Data Type: VARCHAR2

FORM_1

CC ID: 65082
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

A one digit code identifying whether data was collected for this form, N = no; Y = yes; blank = not applicable (other characters have no meaning).
General Data Type: VARCHAR2

FORM_2

CC ID: 65083
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

A one digit code identifying whether data was collected for this form, N = no; Y = yes; blank = not applicable (other characters have no meaning).
General Data Type: VARCHAR2

FORM_3

CC ID: 65084
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

A one digit code identifying whether data was collected for this form, N = no; Y = yes; blank = not applicable (other characters have no meaning).
General Data Type: VARCHAR2

FORM_3REP

CC ID: 65085
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

A one digit code identifying whether data was collected for this form, N = no; Y = yes; blank = not applicable (other characters have no meaning).
General Data Type: VARCHAR2

FORM_7

CC ID: 65086
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

A one digit code identifying whether data was collected for this form, N = no; Y = yes; blank = not applicable (other characters have no meaning).
General Data Type: VARCHAR2

FORM_9

CC ID: 65087
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

A one digit code identifying whether data was collected for this form, N = no; Y = yes; blank = not applicable (other characters have no meaning).
General Data Type: VARCHAR2

FORM_10

CC ID: 65088
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

A one digit code identifying whether data was collected for this form, N = no; Y = yes; blank = not applicable (other characters have no meaning).
General Data Type: VARCHAR2

FORM_11

CC ID: 65089
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

A one digit code identifying whether data was collected for this form, N = no; Y = yes; blank = not applicable (other characters have no meaning).
General Data Type: VARCHAR2

CREW_COUNT

CC ID: 65090
Seq. Order: 16
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

The number of crew members aboard the vessel.
General Data Type: NUMBER

CAPTAINS

CC ID: 65091
Seq. Order: 17
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Responses are: Yes; No; blank. Uncertain what this means.
General Data Type: VARCHAR2

CAPTAIN1_NAME

CC ID: 65092
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

The name of the first captain during this deployment.
General Data Type: VARCHAR2

CAPTAIN1_FROM_DATE

CC ID: 65093
Seq. Order: 19
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

The beginning date for the first captain.
General Data Type: DATE

CAPTAIN1_TO_DATE

CC ID: 65094
Seq. Order: 20
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

The ending date for the first captain.
General Data Type: DATE

CAPTAIN2_NAME

CC ID: 65095
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

The name of the second captain (if any) during this deployment.
General Data Type: VARCHAR2

CAPTAIN2_FROM_DATE

CC ID: 65096
Seq. Order: 22
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

The beginning date for the second captain (if any).
General Data Type: DATE

CAPTAIN2_TO_DATE

CC ID: 65097
Seq. Order: 23
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

The ending date for the second captain (if any).
General Data Type: DATE

DEPLOYMENT_SCORE

CC ID: 65098
Seq. Order: 24
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

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.
General Data Type: NUMBER
Foreign Key Relations:

NORPAC.DEPLOYMENT_SCORE

DATA_STATUS

CC ID: 65099
Seq. Order: 25
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Old two digit alpha codes formerly used to identify the current status of a cruise-vessel as it went through the data entry process.
General Data Type: VARCHAR2
Foreign Key Relations:

NORPAC.DATA_STATUS_CODES

JOB_NUMBER

CC ID: 65100
Seq. Order: 26
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

An assigned number (up to six digits) that identifies a set of cruises sent to an outside vendor for keying (is no longer used).
General Data Type: VARCHAR2

ZERO_SAMPLED_HAULS_FLAG

CC ID: 65101
Seq. Order: 27
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Is no longer used.
General Data Type: VARCHAR2

WOC_FLAG

CC ID: 65102
Seq. Order: 28
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

A one digit code (Y = yes; N = no) which indicates whether the cruise-vessel deployment operated off the Washington-Oregon-California coast or not.
General Data Type: VARCHAR2

GOA_FLAG

CC ID: 65103
Seq. Order: 29
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

A one digit code (Y = yes; N = no) which indicates whether the cruise-vessel deployment operated in the Gulf of Alaska or not.
General Data Type: VARCHAR2

BSA_FLAG

CC ID: 65104
Seq. Order: 30
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

A one digit code (Y = yes; N = no) which indicates whether the cruise-vessel deployment operated in the Bering Sea/Aleutian Islands or not.
General Data Type: VARCHAR2

MORE_CAPTAINS

CC ID: 65105
Seq. Order: 31
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Responses are: Y; N. Uncertain what this means.
General Data Type: VARCHAR2

DATE_OF_CHANGE

CC ID: 65106
Seq. Order: 32
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date of the most recent change to the record.
General Data Type: DATE

VHS_OHS

CC ID: 65107
Seq. Order: 33
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

A one digit code identifying whether data was collected for this form, N = no; Y = yes; blank = not applicable.
General Data Type: VARCHAR2

DATA_VERIFICATION_FLAG

CC ID: 65108
Seq. Order: 34
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

A one digit code identifying whether data from this deployment has been verified or not, N = no; Y = yes.
General Data Type: VARCHAR2

DATA_MOVED_FLAG

CC ID: 65109
Seq. Order: 35
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

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.
General Data Type: VARCHAR2

DATA_COLLECTED_FLAG

CC ID: 65110
Seq. Order: 36
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

A one digit code identifying whether data was collected during this deployment, N = no; Y = yes, blank = deployment not yet completed.
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 12280
GUID: gov.noaa.nmfs.inport:12280
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2012-04-19 13:25+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2018-09-26
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2018-09-26
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2019-09-26