Table: FOREIGN_PRODUCT

Alaska Fisheries Science Center
Entity (ENT) | ID: 9583 | Published / External
Created: 2009-06-29   |   Last Modified: 2022-08-09

Parent: AFSC/FMA/North Pacific Observer Foreign Fishing
Data Set (DS) | ID: 9556

ID: 9583
Entity (ENT)

* Discovery
• First Pass
» Metadata Rubric

Item Identification

* » Title Table: FOREIGN_PRODUCT
Short Name FOREIGN_PRODUCT
* Status Completed
Creation Date  
Revision Date  
• Publication Date  
* » 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.
* Purpose
Notes

Loaded by batch 2364, 06-29-2009 18:15
Other Citation Details
• Supplemental Information
DOI (Digital Object Identifier)  
DOI Registration Authority  
DOI Issue Date  

Keywords

Theme Keywords

Thesaurus Keyword
   
   
   

Temporal Keywords

Thesaurus Keyword
   
   
   

* Spatial Keywords

Thesaurus Keyword
   
   
   

Stratum Keywords

Thesaurus Keyword
   
   
   

Instrument Keywords

Thesaurus Keyword
   
   
   

Platform Keywords

Thesaurus Keyword
   
   
   

Physical Location

• » Organization  
• » City  
• » State/Province  
• Country  
• » Location Description

Entity Information

Entity Type Data Table
Active Version? Y
Alias  
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.
Change Summary

Data Attributes

Attribute Summary

Score Req'd? PKey? » Name Data Storage Type Description
100 Yes No 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 Yes No 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 Yes No 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 Yes No YEAR NUMBER A four-digit number identifying the year in which the gear retrieval of the haul began.
100 Yes No 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 Yes No SPECIES NUMBER A three-digit numeric code representing a marine species.
100 Yes No 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 No No 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 No No VESSEL_PERCT_RECOVERY NUMBER The product recovery percentage used by vessel personnel to back-calculate to total weight.
100 No No 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 No No 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 No No 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 No No FILENAME VARCHAR2 The original filename on the Burroughs computer system from which this data record came.
100 Yes Yes PK_FPRD NUMBER For internal use only.

Attribute Details

Attribute Name CRUISE
Seq. Order 1
Data Storage Type NUMBER
Max Length 22
Min Length  
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
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations

NORPAC.FOREIGN_FISHING_OPERATI
Derivation
Validation Rules
Attribute Name VESSEL
Seq. Order 2
Data Storage Type VARCHAR2
Max Length 4
Min Length  
Required Yes
Primary Key No
Precision  
Scale  
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
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations

Refers to more than one entity
Derivation
Validation Rules
Attribute Name MONTH
Seq. Order 3
Data Storage Type NUMBER
Max Length 22
Min Length  
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
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name YEAR
Seq. Order 4
Data Storage Type NUMBER
Max Length 22
Min Length  
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
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name INPFC_REGION
Seq. Order 5
Data Storage Type NUMBER
Max Length 22
Min Length  
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
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name SPECIES
Seq. Order 6
Data Storage Type NUMBER
Max Length 22
Min Length  
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
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations

NORPAC.DOMESTIC_SPECIES
Derivation
Validation Rules
Attribute Name PRODUCT_CODE
Seq. Order 7
Data Storage Type NUMBER
Max Length 22
Min Length  
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
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations

NORPAC.FOREIGN_PRODUCT_CODE
Derivation
Validation Rules
Attribute Name H_M
Seq. Order 8
Data Storage Type VARCHAR2
Max Length 7
Min Length  
Required No
Primary Key No
Precision  
Scale  
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
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name VESSEL_PERCT_RECOVERY
Seq. Order 9
Data Storage Type NUMBER
Max Length 22
Min Length  
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
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name VESSEL_UNIT_WEIGHT
Seq. Order 10
Data Storage Type NUMBER
Max Length 22
Min Length  
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
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name OBSERVER_PERCT_RECOVERY
Seq. Order 11
Data Storage Type NUMBER
Max Length 22
Min Length  
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
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name OBSERVER_UNIT_WEIGHT
Seq. Order 12
Data Storage Type NUMBER
Max Length 22
Min Length  
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
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name FILENAME
Seq. Order 13
Data Storage Type VARCHAR2
Max Length 8
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

The original filename on the Burroughs computer system from which this data record came.
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PK_FPRD
Seq. Order 14
Data Storage Type NUMBER
Max Length 22
Min Length  
Required Yes
Primary Key Yes
Precision 6
Scale 0
Status Active
Description

For internal use only.
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules
Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules
Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Support Roles

» At least one Distributor Org, one Metadata Contact, one Point of Contact, and one Data Steward should be listed.
* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions
* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions
* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions

Extents

Currentness Reference  

Extent Group 1

Extent Description

Extent Group 1 / Geographic Area

* » W° Bound
* » E° Bound
* » N° Bound
* » S° Bound
* » Description

Extent Group 1 / Vertical Extent

EPSG Code
Vertical Minimum
Vertical Maximum

Extent Group 1 / Time Frame

* » Time Frame Type
* » Start
End
Alternate Start as of Info
Alternate End as of Info
Description

Access Information

* » Security Class  
* Security Classification System  
 
Security Handling Description  
 
• Data Access Policy  
 
» Data Access Procedure  
 
• » Data Access Constraints  
 
• Data Use Constraints  
 
Metadata Access Constraints  
 
Metadata Use Constraints  
 

Distribution Information

Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status
Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status
Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status

Activity Log

Activity Time
Activity Type
Responsible Party
Description
Activity Time
Activity Type
Responsible Party
Description
Activity Time
Activity Type
Responsible Party
Description

Issues

Issue Date
Author
Issue
Issue Date
Author
Issue
Issue Date
Author
Issue

FAQs

Date
Author
Question
Answer

Child Items

Rubric scores updated every 15m

Score Type Title
     
     
     

Related Items

Item Type Relationship Type Title
     
     
     

Catalog Details

Catalog Item ID 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 Workflow State Published / External
Metadata Last Review Date 2016-05-18
Metadata Review Frequency 1 Year
Metadata Next Review Date 2017-05-18
Tags