Metadata Rubric

100%

6 / 6

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_LENGTH

Entity (ENT) | Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:9573 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

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

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.

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.

No Child Items for this record.

No contact information is available for this record.

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

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 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.

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	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	SPECIES	NUMBER	A three-digit numeric code representing a marine species.
100	SEX	VARCHAR2	A one-digit alpha code indicating the sex of the organism. F = female, M = male, U = unknown.
100	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	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.

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

DATE

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

SPECIES

NUMBER

A three-digit numeric code representing a marine species.

100

SEX

VARCHAR2

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

100

SIZE_GROUP

NUMBER

100

FREQUENCY

NUMBER

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

100

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 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

Table: FOREIGN_LENGTH

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

CRUISE

VESSEL

YEAR

DT

HAUL

SPECIES

SEX

SIZE_GROUP

FREQUENCY

HAUL_JOIN

Catalog Details