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. |
Attribute Details
CRUISE
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |