Slide Menu
Search Help Show/Hide Menu

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

Rubric Score Primary Key? 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
Primary Key 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