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_PRODUCT

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

Item Identification

Title:	Table: FOREIGN_PRODUCT
Short Name:	FOREIGN_PRODUCT
Status:	Completed
Abstract:	This table provides product information for a wide range of species and products, 1980-1990. Some information was provided by ship's personnel. Other information was collected by observers' monitoring and weighing the products as they were being processed. The product codes can be found in the Observer Program's collection of Manuals for Biologists Aboard Foreign Groundfish Vessels.
Notes:	Loaded by batch 2364, 06-29-2009 18:15

Entity Information

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	NORPAC
Description:	This table provides product information for a wide range of species and products, 1980-1990. Some information was provided by ship's personnel. Other information was collected by observers' monitoring and weighing the products as they were being processed. The product codes can be found in the Observer Program's collection of Manuals for Biologists Aboard Foreign Groundfish Vessels.

Data Attributes

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	MONTH	NUMBER	A two-digit number representing the month in which the haul or set gear retrieval began. Month is part of the day's date, which is recorded on all forms and used along with haul as a cross reference between data forms to link related sets of information.
100	YEAR	NUMBER	A four-digit number identifying the year in which the gear retrieval of the haul began.
100	INPFC_REGION	NUMBER	A two-digit numeric code representing the International North Pacific Fisheries Commission (INPFC) area or region in which the data were collected: 50 - Bering Sea/Aleutian Islands Region; 51 - Eastern Bering Sea Area; 52 - Central Bering Sea Area; 53 - Western Bering Sea Area; 54 - Aleutian Islands Area; 55 - Donut Hole Area; 60 - Gulf of Alaska Region; 61 - Shumagin Area; 62 - Chirikof Area; 63 - Kodiak Area; 64 - Yakutat/SE Alaska Area; 67 - Vancouver Area; 70 - Washington-Oregon-California Region; 71 - Columbia Area; 72 - Eureka Area; 73 - Monterey Area.
100	SPECIES	NUMBER	A three-digit numeric code representing a marine species.
100	PRODUCT_CODE	NUMBER	A two-digit numeric code identifying the type of product associated with the recovery rate. NORPAC.FOREIGN_PRODUCT_CODE provides a description of the codes.
100	H_M	VARCHAR2	A one-digit alpha code to identify whether the product was obtained by processing the fish by hand (H) or by machine (M).
100	VESSEL_PERCT_RECOVERY	NUMBER	The product recovery percentage used by vessel personnel to back-calculate to total weight.
100	VESSEL_UNIT_WEIGHT	NUMBER	The weight (in kg) of the standard sized packaging of the product as reported by the vessel (before freezing or addition of water).
100	OBSERVER_PERCT_RECOVERY	NUMBER	The product recovery percentage obtained by the observer by first weighing the fish before processing and then weighing the resultant product. If two product recovery percentages exist for the same vessel, date, area, species, and product, they represent a range of percentages for the product.
100	OBSERVER_UNIT_WEIGHT	NUMBER	The weight (in kg) of the standard sized packaging of the product as weighed by the observer (before freezing or addition of water).
100	FILENAME	VARCHAR2	The original filename on the Burroughs computer system from which this data record came.
100	PK_FPRD	NUMBER	For internal use only.

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

MONTH

NUMBER

A two-digit number representing the month in which the haul or set gear retrieval began. Month is part of the day's date, which is recorded on all forms and used along with haul as a cross reference between data forms to link related sets of information.

100

YEAR

NUMBER

A four-digit number identifying the year in which the gear retrieval of the haul began.

100

INPFC_REGION

NUMBER

A two-digit numeric code representing the International North Pacific Fisheries Commission (INPFC) area or region in which the data were collected: 50 - Bering Sea/Aleutian Islands Region; 51 - Eastern Bering Sea Area; 52 - Central Bering Sea Area; 53 - Western Bering Sea Area; 54 - Aleutian Islands Area; 55 - Donut Hole Area; 60 - Gulf of Alaska Region; 61 - Shumagin Area; 62 - Chirikof Area; 63 - Kodiak Area; 64 - Yakutat/SE Alaska Area; 67 - Vancouver Area; 70 - Washington-Oregon-California Region; 71 - Columbia Area; 72 - Eureka Area; 73 - Monterey Area.

100

SPECIES

NUMBER

A three-digit numeric code representing a marine species.

100

PRODUCT_CODE

NUMBER

A two-digit numeric code identifying the type of product associated with the recovery rate. NORPAC.FOREIGN_PRODUCT_CODE provides a description of the codes.

100

H_M

VARCHAR2

A one-digit alpha code to identify whether the product was obtained by processing the fish by hand (H) or by machine (M).

100

VESSEL_PERCT_RECOVERY

NUMBER

The product recovery percentage used by vessel personnel to back-calculate to total weight.

100

VESSEL_UNIT_WEIGHT

NUMBER

The weight (in kg) of the standard sized packaging of the product as reported by the vessel (before freezing or addition of water).

100

OBSERVER_PERCT_RECOVERY

NUMBER

The product recovery percentage obtained by the observer by first weighing the fish before processing and then weighing the resultant product. If two product recovery percentages exist for the same vessel, date, area, species, and product, they represent a range of percentages for the product.

100

OBSERVER_UNIT_WEIGHT

NUMBER

The weight (in kg) of the standard sized packaging of the product as weighed by the observer (before freezing or addition of water).

100

FILENAME

VARCHAR2

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

100

PK_FPRD

NUMBER

For internal use only.

Attribute Details

CRUISE

CC ID: 37365

Seq. Order:	1
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
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
Foreign Key Relations:	NORPAC.FOREIGN_FISHING_OPERATI

VESSEL

CC ID: 37375

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	4
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 B, followed by a three-digit number.
General Data Type:	VARCHAR2
Foreign Key Relations:	Refers to more than one entity

MONTH

CC ID: 37369

Seq. Order:	3
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	A two-digit number representing the month in which the haul or set gear retrieval began. Month is part of the day's date, which is recorded on all forms and used along with haul as a cross reference between data forms to link related sets of information.
General Data Type:	NUMBER

YEAR

CC ID: 37378

Seq. Order:	4
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	A four-digit number identifying the year in which the gear retrieval of the haul began.
General Data Type:	NUMBER

INPFC_REGION

CC ID: 37368

Seq. Order:	5
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	A two-digit numeric code representing the International North Pacific Fisheries Commission (INPFC) area or region in which the data were collected: 50 - Bering Sea/Aleutian Islands Region; 51 - Eastern Bering Sea Area; 52 - Central Bering Sea Area; 53 - Western Bering Sea Area; 54 - Aleutian Islands Area; 55 - Donut Hole Area; 60 - Gulf of Alaska Region; 61 - Shumagin Area; 62 - Chirikof Area; 63 - Kodiak Area; 64 - Yakutat/SE Alaska Area; 67 - Vancouver Area; 70 - Washington-Oregon-California Region; 71 - Columbia Area; 72 - Eureka Area; 73 - Monterey Area.
General Data Type:	NUMBER

SPECIES

CC ID: 37374

Seq. Order:	6
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	A three-digit numeric code representing a marine species.
General Data Type:	NUMBER
Foreign Key Relations:	NORPAC.DOMESTIC_SPECIES

PRODUCT_CODE

CC ID: 37373

Seq. Order:	7
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	A two-digit numeric code identifying the type of product associated with the recovery rate. NORPAC.FOREIGN_PRODUCT_CODE provides a description of the codes.
General Data Type:	NUMBER
Foreign Key Relations:	NORPAC.FOREIGN_PRODUCT_CODE

H_M

CC ID: 37367

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	A one-digit alpha code to identify whether the product was obtained by processing the fish by hand (H) or by machine (M).
General Data Type:	VARCHAR2

VESSEL_PERCT_RECOVERY

CC ID: 37376

Seq. Order:	9
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	The product recovery percentage used by vessel personnel to back-calculate to total weight.
General Data Type:	NUMBER

VESSEL_UNIT_WEIGHT

CC ID: 37377

Seq. Order:	10
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	2
Status:	Active
Description:	The weight (in kg) of the standard sized packaging of the product as reported by the vessel (before freezing or addition of water).
General Data Type:	NUMBER

OBSERVER_PERCT_RECOVERY

CC ID: 37370

Seq. Order:	11
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	The product recovery percentage obtained by the observer by first weighing the fish before processing and then weighing the resultant product. If two product recovery percentages exist for the same vessel, date, area, species, and product, they represent a range of percentages for the product.
General Data Type:	NUMBER

OBSERVER_UNIT_WEIGHT

CC ID: 37371

Seq. Order:	12
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	2
Status:	Active
Description:	The weight (in kg) of the standard sized packaging of the product as weighed by the observer (before freezing or addition of water).
General Data Type:	NUMBER

FILENAME

CC ID: 37366

Seq. Order:	13
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 this data record came.
General Data Type:	VARCHAR2

PK_FPRD

CC ID: 37372

Seq. Order:	14
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	Yes
Precision:	6
Scale:	0
Status:	Active
Description:	For internal use only.
General Data Type:	NUMBER

Catalog Details

Catalog Item ID:	9583
GUID:	gov.noaa.nmfs.inport:9583
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