Metadata Rubric

100%

6 / 6

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

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

Description

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

Entity Type
Data Table

Data Attribute / Type	Description
TRIPS_JOIN NUMBER	An assigned number (up to eight digits) that uniquely identifies each cruise_vessel trip.
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.
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.
DATE_OF_ENTRY DATE	The date in which this entry was made.
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).
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.
FORM_A VARCHAR2	A one digit code identifying whether data was collected for this form, N = no; Y = yes; blank = not applicable.
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).
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).
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).
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).
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).
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).
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).
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).
CREW_COUNT NUMBER	The number of crew members aboard the vessel.
CAPTAINS VARCHAR2	Responses are: Yes; No; blank. Uncertain what this means.
CAPTAIN1_NAME VARCHAR2	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	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	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	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	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	Is no longer used.
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.
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.
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.
MORE_CAPTAINS VARCHAR2	Responses are: Y; N. Uncertain what this means.
DATE_OF_CHANGE DATE	Date of the most recent change to the record.
VHS_OHS VARCHAR2	A one digit code identifying whether data was collected for this form, N = no; Y = yes; blank = not applicable.
DATA_VERIFICATION_FLAG VARCHAR2	A one digit code identifying whether data from this deployment has been verified or not, N = no; Y = yes.
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.
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.

Data Attribute / Type

Description

TRIPS_JOIN
NUMBER

An assigned number (up to eight digits) that uniquely identifies each cruise_vessel trip.

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.

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.

DATE_OF_ENTRY
DATE

The date in which this entry was made.

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).

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.

FORM_A
VARCHAR2

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

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).

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).

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).

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).

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).

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).

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).

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).

CREW_COUNT
NUMBER

The number of crew members aboard the vessel.

CAPTAINS
VARCHAR2

Responses are: Yes; No; blank. Uncertain what this means.

CAPTAIN1_NAME
VARCHAR2

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

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

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

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

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

Is no longer used.

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.

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.

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.

MORE_CAPTAINS
VARCHAR2

Responses are: Y; N. Uncertain what this means.

DATE_OF_CHANGE
DATE

Date of the most recent change to the record.

VHS_OHS
VARCHAR2

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

DATA_VERIFICATION_FLAG
VARCHAR2

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

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.

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.

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (AFSC) for inquiries on this record.

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 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.

Attribute Summary

	Name	Type	Description
100	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.

Name

Type

Description

100

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

100

DATE_OF_ENTRY

DATE

The date in which this entry was made.

100

VESSEL_TYPE

NUMBER

100

GEAR_TYPE

NUMBER

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

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 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

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

TRIPS_JOIN

CRUISE

VESSEL

DATE_OF_ENTRY

VESSEL_TYPE

GEAR_TYPE

FORM_A

FORM_1

FORM_2

FORM_3

FORM_3REP

FORM_7

FORM_9

FORM_10

FORM_11

CREW_COUNT

CAPTAINS

CAPTAIN1_NAME

CAPTAIN1_FROM_DATE

CAPTAIN1_TO_DATE

CAPTAIN2_NAME

CAPTAIN2_FROM_DATE

CAPTAIN2_TO_DATE

DEPLOYMENT_SCORE

DATA_STATUS

JOB_NUMBER

ZERO_SAMPLED_HAULS_FLAG

WOC_FLAG

GOA_FLAG

BSA_FLAG

MORE_CAPTAINS

DATE_OF_CHANGE

VHS_OHS

DATA_VERIFICATION_FLAG

DATA_MOVED_FLAG

DATA_COLLECTED_FLAG

Catalog Details