Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
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_POT_SNAILS

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:9580  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

This table contains snail meat catch information for years 1984, 1985, 1986, 1987, and 1989.

Description

This table contains snail meat catch information for years 1984, 1985, 1986, 1987, and 1989.

Entity Information

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.
DT
DATE 		Similar to NORPAC.DOMESTIC_HAUL.HAUL_DATE, this is the date in Greenwich Mean Time. Format is stored in the database as DD-MON-YY format (i.e., 15-MAR-86), and displayed as MM/DD/YYYY HH:MI:SS (i.e., 3/15/86 00:00:00).
YEAR
NUMBER 		A four-digit number identifying the year in which the gear retrieval of the haul began.
HAUL
NUMBER 		A unique number which identifies a specific occurrence of net, pot, or longline fishing effort. This table does not include "no fishing" days.
OBSERVER_EST_WHOLE_SNAILS
NUMBER 		The observer estimate of the whole weight of the catch of snails in metric tons (including shells).
VESSEL_EST_WHOLE_SNAILS
NUMBER 		The vessel estimate of the whole weight of the catch of snails in metric tons (including shells).
OBSERVER_EST_RAW_SNAIL_MEAT
NUMBER 		The observer estimate of the weight of the snail meat (metric tons).
VESSEL_EST_RAW_SNAIL_MEAT
NUMBER 		The vessel estimate of the weight of the snail meat (metric tons).
OBSERVER_EST_COOKED_SNAIL_MEAT
NUMBER 		The observer estimate of the weight of the cooked snail meat (metric tons).
FILENAME
VARCHAR2 		The original filename on the Burroughs computer system from which this data record came.
HAUL_JOIN
NUMBER 		An assigned, unique number (up to 6 digits) used to link records in this table back to a single haul record in the NORPAC.FOREIGN_HAUL table.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (AFSC) for inquiries on this record.

Item Identification

Title: Table: FOREIGN_POT_SNAILS
Short Name: FOREIGN_POT_SNAILS
Status: Completed
Abstract:

This table contains snail meat catch information for years 1984, 1985, 1986, 1987, and 1989.
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 contains snail meat catch information for years 1984, 1985, 1986, 1987, and 1989.

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
 DT DATE Similar to NORPAC.DOMESTIC_HAUL.HAUL_DATE, this is the date in Greenwich Mean Time. Format is stored in the database as DD-MON-YY format (i.e., 15-MAR-86), and displayed as MM/DD/YYYY HH:MI:SS (i.e., 3/15/86 00:00:00).
100
 YEAR NUMBER A four-digit number identifying the year in which the gear retrieval of the haul began.
100
 HAUL NUMBER A unique number which identifies a specific occurrence of net, pot, or longline fishing effort. This table does not include "no fishing" days.
100
 OBSERVER_EST_WHOLE_SNAILS NUMBER The observer estimate of the whole weight of the catch of snails in metric tons (including shells).
100
 VESSEL_EST_WHOLE_SNAILS NUMBER The vessel estimate of the whole weight of the catch of snails in metric tons (including shells).
100
 OBSERVER_EST_RAW_SNAIL_MEAT NUMBER The observer estimate of the weight of the snail meat (metric tons).
100
 VESSEL_EST_RAW_SNAIL_MEAT NUMBER The vessel estimate of the weight of the snail meat (metric tons).
100
 OBSERVER_EST_COOKED_SNAIL_MEAT NUMBER The observer estimate of the weight of the cooked snail meat (metric tons).
100
 FILENAME VARCHAR2 The original filename on the Burroughs computer system from which this data record came.
100
 Primary Key HAUL_JOIN NUMBER An assigned, unique number (up to 6 digits) used to link records in this table back to a single haul record in the NORPAC.FOREIGN_HAUL table.

Attribute Details

CRUISE

CC ID: 37349
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: 37357
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

DT

CC ID: 37350
Seq. Order: 3
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Similar to NORPAC.DOMESTIC_HAUL.HAUL_DATE, this is the date in Greenwich Mean Time. Format is stored in the database as DD-MON-YY format (i.e., 15-MAR-86), and displayed as MM/DD/YYYY HH:MI:SS (i.e., 3/15/86 00:00:00).
General Data Type: DATE

YEAR

CC ID: 37360
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

HAUL

CC ID: 37352
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

A unique number which identifies a specific occurrence of net, pot, or longline fishing effort. This table does not include "no fishing" days.
General Data Type: NUMBER

OBSERVER_EST_WHOLE_SNAILS

CC ID: 37356
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 2
Status: Active
Description:

The observer estimate of the whole weight of the catch of snails in metric tons (including shells).
General Data Type: NUMBER

VESSEL_EST_WHOLE_SNAILS

CC ID: 37359
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 2
Status: Active
Description:

The vessel estimate of the whole weight of the catch of snails in metric tons (including shells).
General Data Type: NUMBER

OBSERVER_EST_RAW_SNAIL_MEAT

CC ID: 37355
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 2
Status: Active
Description:

The observer estimate of the weight of the snail meat (metric tons).
General Data Type: NUMBER

VESSEL_EST_RAW_SNAIL_MEAT

CC ID: 37358
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 2
Status: Active
Description:

The vessel estimate of the weight of the snail meat (metric tons).
General Data Type: NUMBER

OBSERVER_EST_COOKED_SNAIL_MEAT

CC ID: 37354
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 2
Status: Active
Description:

The observer estimate of the weight of the cooked snail meat (metric tons).
General Data Type: NUMBER

FILENAME

CC ID: 37351
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 this data record came.
General Data Type: VARCHAR2

HAUL_JOIN

CC ID: 37353
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 6
Scale: 0
Status: Active
Description:

An assigned, unique number (up to 6 digits) used to link records in this table back to a single haul record in the NORPAC.FOREIGN_HAUL table.
General Data Type: NUMBER
Foreign Key Relations:

NORPAC.FOREIGN_HAUL

Catalog Details

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