Metadata Rubric

100%

6 / 6

Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > Foreign Fishing Observer Data Dictionary > AFSC/FMA/North Pacific Observer Foreign Fishing >

Table: FOREIGN_FISHING_OPERATION

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

This table links the cruise and vessel in several of the major foreign tables (HAUL, SPCOMP, LENGTH, AGE) with pertinent information associated with the cruise and vessel.

Description

This table links the cruise and vessel in several of the major foreign tables (HAUL, SPCOMP, LENGTH, AGE) with pertinent information associated with the cruise and vessel.

Entity Type
Data Table

Data Attribute / Type	Description
CRUISE NUMBER	A unique four-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 B, followed by a three-digit number.
JV_Y_N VARCHAR2	A one-digit alpha code which identifies whether the data associated with this cruise and vessel are joint venture data or not. Y = Yes; N = No.
VESSEL_TYPE_CODE NUMBER	A one-digit numeric code associated with vessel type. NORPAC.FOREIGN_VESSEL_TYPE provides a description of the codes.
PROCESSING_TYPE_CODE NUMBER	A one-digit numeric code associated with processing type. NORPAC.FOREIGN_PROCESSING_TYPE provides a description of the codes.
OLD_CRUISE NUMBER	The original cruise number associated with this cruise and vessel. The original cruise number is the cruise number that is recorded on the paper forms.
OLD_VESSEL VARCHAR2	The original vessel code associated with this cruise and vessel. The original vessel code is the vessel code that is recorded on the paper forms.
COMMENTS VARCHAR2	This field is usually empty. It contains additional information about the cruise and vessel.
FILENAME_HAUL VARCHAR2	The original filename on the Burroughs computer system from which the haul data for this record came.
FILENAME_LENGTH VARCHAR2	The original filename on the Burroughs computer system from which the length data for this record came.
FILENAME_SPCOMP VARCHAR2	The original filename on the Burroughs computer system from which the species composition data for this record came.
FILENAME_AGE VARCHAR2	The original filename on the Burroughs computer system from which the age data for this record came.

Data Attribute / Type

Description

CRUISE
NUMBER

A unique four-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 B, followed by a three-digit number.

JV_Y_N
VARCHAR2

A one-digit alpha code which identifies whether the data associated with this cruise and vessel are joint venture data or not. Y = Yes; N = No.

VESSEL_TYPE_CODE
NUMBER

A one-digit numeric code associated with vessel type. NORPAC.FOREIGN_VESSEL_TYPE provides a description of the codes.

PROCESSING_TYPE_CODE
NUMBER

A one-digit numeric code associated with processing type. NORPAC.FOREIGN_PROCESSING_TYPE provides a description of the codes.

OLD_CRUISE
NUMBER

The original cruise number associated with this cruise and vessel. The original cruise number is the cruise number that is recorded on the paper forms.

OLD_VESSEL
VARCHAR2

The original vessel code associated with this cruise and vessel. The original vessel code is the vessel code that is recorded on the paper forms.

COMMENTS
VARCHAR2

This field is usually empty. It contains additional information about the cruise and vessel.

FILENAME_HAUL
VARCHAR2

The original filename on the Burroughs computer system from which the haul data for this record came.

FILENAME_LENGTH
VARCHAR2

The original filename on the Burroughs computer system from which the length data for this record came.

FILENAME_SPCOMP
VARCHAR2

The original filename on the Burroughs computer system from which the species composition data for this record came.

FILENAME_AGE
VARCHAR2

The original filename on the Burroughs computer system from which the age data for this record came.

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: FOREIGN_FISHING_OPERATION
Short Name:	FOREIGN_FISHING_OPERATION
Status:	Completed
Abstract:	This table links the cruise and vessel in several of the major foreign tables (HAUL, SPCOMP, LENGTH, AGE) with pertinent information associated with the cruise and vessel.
Notes:	Loaded by batch 2364, 06-29-2009 18:15

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	NORPAC
Description:	This table links the cruise and vessel in several of the major foreign tables (HAUL, SPCOMP, LENGTH, AGE) with pertinent information associated with the cruise and vessel.

Attribute Summary

	Name	Type	Description
100	CRUISE	NUMBER	A unique four-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 B, followed by a three-digit number.
100	JV_Y_N	VARCHAR2	A one-digit alpha code which identifies whether the data associated with this cruise and vessel are joint venture data or not. Y = Yes; N = No.
100	VESSEL_TYPE_CODE	NUMBER	A one-digit numeric code associated with vessel type. NORPAC.FOREIGN_VESSEL_TYPE provides a description of the codes.
100	PROCESSING_TYPE_CODE	NUMBER	A one-digit numeric code associated with processing type. NORPAC.FOREIGN_PROCESSING_TYPE provides a description of the codes.
100	OLD_CRUISE	NUMBER	The original cruise number associated with this cruise and vessel. The original cruise number is the cruise number that is recorded on the paper forms.
100	OLD_VESSEL	VARCHAR2	The original vessel code associated with this cruise and vessel. The original vessel code is the vessel code that is recorded on the paper forms.
100	COMMENTS	VARCHAR2	This field is usually empty. It contains additional information about the cruise and vessel.
100	FILENAME_HAUL	VARCHAR2	The original filename on the Burroughs computer system from which the haul data for this record came.
100	FILENAME_LENGTH	VARCHAR2	The original filename on the Burroughs computer system from which the length data for this record came.
100	FILENAME_SPCOMP	VARCHAR2	The original filename on the Burroughs computer system from which the species composition data for this record came.
100	FILENAME_AGE	VARCHAR2	The original filename on the Burroughs computer system from which the age data for this record came.

Name

Type

Description

100

CRUISE

NUMBER

A unique four-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 B, followed by a three-digit number.

100

JV_Y_N

VARCHAR2

A one-digit alpha code which identifies whether the data associated with this cruise and vessel are joint venture data or not. Y = Yes; N = No.

100

VESSEL_TYPE_CODE

NUMBER

A one-digit numeric code associated with vessel type. NORPAC.FOREIGN_VESSEL_TYPE provides a description of the codes.

100

PROCESSING_TYPE_CODE

NUMBER

A one-digit numeric code associated with processing type. NORPAC.FOREIGN_PROCESSING_TYPE provides a description of the codes.

100

OLD_CRUISE

NUMBER

The original cruise number associated with this cruise and vessel. The original cruise number is the cruise number that is recorded on the paper forms.

100

OLD_VESSEL

VARCHAR2

The original vessel code associated with this cruise and vessel. The original vessel code is the vessel code that is recorded on the paper forms.

100

COMMENTS

VARCHAR2

This field is usually empty. It contains additional information about the cruise and vessel.

100

FILENAME_HAUL

VARCHAR2

The original filename on the Burroughs computer system from which the haul data for this record came.

100

FILENAME_LENGTH

VARCHAR2

The original filename on the Burroughs computer system from which the length data for this record came.

100

FILENAME_SPCOMP

VARCHAR2

The original filename on the Burroughs computer system from which the species composition data for this record came.

100

FILENAME_AGE

VARCHAR2

The original filename on the Burroughs computer system from which the age data for this record came.

Attribute Details

CRUISE

CC ID: 37244

Seq. Order:	1
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	Yes
Precision:	4
Scale:	0
Status:	Active
Description:	A unique four-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

VESSEL

CC ID: 37253

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	Yes
Primary Key:	Yes
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 B, followed by a three-digit number.
General Data Type:	VARCHAR2
Foreign Key Relations:	NORPAC.FOREIGN_VESSEL

JV_Y_N

CC ID: 37249

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	Yes
Primary Key:	No
Status:	Active
Description:	A one-digit alpha code which identifies whether the data associated with this cruise and vessel are joint venture data or not. Y = Yes; N = No.
General Data Type:	VARCHAR2

VESSEL_TYPE_CODE

CC ID: 37254

Seq. Order:	4
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	1
Scale:	0
Status:	Active
Description:	A one-digit numeric code associated with vessel type. NORPAC.FOREIGN_VESSEL_TYPE provides a description of the codes.
General Data Type:	NUMBER
Foreign Key Relations:	NORPAC.FOREIGN_VESSEL_TYPE

PROCESSING_TYPE_CODE

CC ID: 37252

Seq. Order:	5
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	1
Scale:	0
Status:	Active
Description:	A one-digit numeric code associated with processing type. NORPAC.FOREIGN_PROCESSING_TYPE provides a description of the codes.
General Data Type:	NUMBER
Foreign Key Relations:	NORPAC.FOREIGN_PROCESSING_TYPE

OLD_CRUISE

CC ID: 37250

Seq. Order:	6
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	The original cruise number associated with this cruise and vessel. The original cruise number is the cruise number that is recorded on the paper forms.
General Data Type:	NUMBER

OLD_VESSEL

CC ID: 37251

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	Yes
Primary Key:	No
Status:	Active
Description:	The original vessel code associated with this cruise and vessel. The original vessel code is the vessel code that is recorded on the paper forms.
General Data Type:	VARCHAR2

COMMENTS

CC ID: 37243

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	200
Required:	No
Primary Key:	No
Status:	Active
Description:	This field is usually empty. It contains additional information about the cruise and vessel.
General Data Type:	VARCHAR2

FILENAME_HAUL

CC ID: 37246

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	8
Required:	No
Primary Key:	No
Status:	Active
Description:	The original filename on the Burroughs computer system from which the haul data for this record came.
General Data Type:	VARCHAR2

FILENAME_LENGTH

CC ID: 37247

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	8
Required:	No
Primary Key:	No
Status:	Active
Description:	The original filename on the Burroughs computer system from which the length data for this record came.
General Data Type:	VARCHAR2

FILENAME_SPCOMP

CC ID: 37248

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	8
Required:	No
Primary Key:	No
Status:	Active
Description:	The original filename on the Burroughs computer system from which the species composition data for this record came.
General Data Type:	VARCHAR2

FILENAME_AGE

CC ID: 37245

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	8
Required:	No
Primary Key:	No
Status:	Active
Description:	The original filename on the Burroughs computer system from which the age data for this record came.
General Data Type:	VARCHAR2

Catalog Item ID:	9571
GUID:	gov.noaa.nmfs.inport:9571
Metadata Record Created By:	Doug Turnbull
Metadata Record Created:	2009-06-29 18:15+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:11+0000
Metadata Record Published:	2016-05-18
Owner Org:	AFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2016-05-18
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2017-05-18

Table: FOREIGN_FISHING_OPERATION

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

CRUISE

VESSEL

JV_Y_N

VESSEL_TYPE_CODE

PROCESSING_TYPE_CODE

OLD_CRUISE

OLD_VESSEL

COMMENTS

FILENAME_HAUL

FILENAME_LENGTH

FILENAME_SPCOMP

FILENAME_AGE

Catalog Details