Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

This table contains length-frequency data of prohibited species and commercially-important groundfish caught in the foreign and joint venture groundfish fishery. Also contains viability condition data for Pacific halibut.

Description

This table contains length-frequency data of prohibited species and commercially-important groundfish caught in the foreign and joint venture groundfish fishery. Also contains viability condition data for Pacific halibut.

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.
YEAR
NUMBER
A four-digit number identifying the year in which the gear retrieval of the haul began.
DT
DATE
Similar to NORPAC.DOMESTIC_LENGTH.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).
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.
SPECIES
NUMBER
A three-digit numeric code representing a marine species.
SEX
VARCHAR2
A one-digit alpha code indicating the sex of the organism. F = female, M = male, U = unknown.
SIZE_GROUP
NUMBER
Similar to NORPAC.DOMESTIC_LENGTH.LENGTH, this is the length measurement group for a species and sex. For fish, the fork length in centimeters. For crabs, the carapace width (Tanner crab) or carapace length (king crab) to the nearest 5 mm interval, ending in a 3 or an 8.
FREQUENCY
NUMBER
The number of individuals in the species, sex, and size group for the haul/set.
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_LENGTH
Short Name: FOREIGN_LENGTH
Status: Completed
Abstract:

This table contains length-frequency data of prohibited species and commercially-important groundfish caught in the foreign and joint venture groundfish fishery. Also contains viability condition data for Pacific halibut.

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 length-frequency data of prohibited species and commercially-important groundfish caught in the foreign and joint venture groundfish fishery. Also contains viability condition data for Pacific halibut.

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
YEAR NUMBER A four-digit number identifying the year in which the gear retrieval of the haul began.
100
DT DATE Similar to NORPAC.DOMESTIC_LENGTH.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
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
Primary Key SPECIES NUMBER A three-digit numeric code representing a marine species.
100
Primary Key SEX VARCHAR2 A one-digit alpha code indicating the sex of the organism. F = female, M = male, U = unknown.
100
Primary Key SIZE_GROUP NUMBER Similar to NORPAC.DOMESTIC_LENGTH.LENGTH, this is the length measurement group for a species and sex. For fish, the fork length in centimeters. For crabs, the carapace width (Tanner crab) or carapace length (king crab) to the nearest 5 mm interval, ending in a 3 or an 8.
100
FREQUENCY NUMBER The number of individuals in the species, sex, and size group for the haul/set.
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: 37287
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 5
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: 37295
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

YEAR

CC ID: 37296
Seq. Order: 3
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

DT

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

Similar to NORPAC.DOMESTIC_LENGTH.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

HAUL

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

SPECIES

CC ID: 37294
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
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

SEX

CC ID: 37292
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
Primary Key: Yes
Status: Active
Description:

A one-digit alpha code indicating the sex of the organism. F = female, M = male, U = unknown.

General Data Type: VARCHAR2

SIZE_GROUP

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

Similar to NORPAC.DOMESTIC_LENGTH.LENGTH, this is the length measurement group for a species and sex. For fish, the fork length in centimeters. For crabs, the carapace width (Tanner crab) or carapace length (king crab) to the nearest 5 mm interval, ending in a 3 or an 8.

General Data Type: NUMBER

FREQUENCY

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

The number of individuals in the species, sex, and size group for the haul/set.

General Data Type: NUMBER

HAUL_JOIN

CC ID: 37291
Seq. Order: 10
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: 9573
GUID: gov.noaa.nmfs.inport:9573
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