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_DETAIL_PROHIBS

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

Item Identification

Title:	Table: FOREIGN_DETAIL_PROHIBS
Short Name:	FOREIGN_DETAIL_PROHIBS
Status:	Completed
Abstract:	This table contains the original (corrected) observer data for foreign trawlers, motherships, snail pot vessels, and joint venture operations. No data have been extrapolated in this database. These data are from all species of king crab (species 2), Tanner crab (species 3), Pacific halibut (species 101), and Pacific salmon (species 220 and 226) that were found in the prohibited species samples.
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 the original (corrected) observer data for foreign trawlers, motherships, snail pot vessels, and joint venture operations. No data have been extrapolated in this database. These data are from all species of king crab (species 2), Tanner crab (species 3), Pacific halibut (species 101), and Pacific salmon (species 220 and 226) that were found in the prohibited species samples.

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	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_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	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	SAMPLE_NUMBER	NUMBER	In sampling a longline set or a day's mothership operation or a day's joint venture operation, each portion of the set or delivery that was sampled received a unique sample_number within the set (usually, a 1, 2, or 3).
100	SPECIES	NUMBER	A three-digit numeric code representing a marine species.
100	NUMBER_IN_SAMPLE	NUMBER	The number (count) of the specified species which occurred within the sample.
100	WEIGHT_IN_SAMPLE	NUMBER	The total weight in kilograms of the specified species which occurred within the sample.
100	NUMBER_OF_SKATES_SAMPLED	NUMBER	The number of hachi (skates) that were sampled for prohibited species.
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.
100	WEIGHT_SAMPLED	NUMBER	The total weight in kilograms of all of the sampled species in the sample.
100	PK_FDP	NUMBER	For internal use only.

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

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

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

SAMPLE_NUMBER

NUMBER

In sampling a longline set or a day's mothership operation or a day's joint venture operation, each portion of the set or delivery that was sampled received a unique sample_number within the set (usually, a 1, 2, or 3).

100

SPECIES

NUMBER

A three-digit numeric code representing a marine species.

100

NUMBER_IN_SAMPLE

NUMBER

The number (count) of the specified species which occurred within the sample.

100

WEIGHT_IN_SAMPLE

NUMBER

The total weight in kilograms of the specified species which occurred within the sample.

100

NUMBER_OF_SKATES_SAMPLED

NUMBER

The number of hachi (skates) that were sampled for prohibited species.

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.

100

WEIGHT_SAMPLED

NUMBER

The total weight in kilograms of all of the sampled species in the sample.

100

PK_FDP

NUMBER

For internal use only.

Attribute Details

CRUISE

CC ID: 37201

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

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

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

Seq. Order:	4
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

HAUL

CC ID: 37203

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

SAMPLE_NUMBER

CC ID: 37208

Seq. Order:	6
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	In sampling a longline set or a day's mothership operation or a day's joint venture operation, each portion of the set or delivery that was sampled received a unique sample_number within the set (usually, a 1, 2, or 3).
General Data Type:	NUMBER

SPECIES

CC ID: 37209

Seq. Order:	7
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

NUMBER_IN_SAMPLE

CC ID: 37205

Seq. Order:	8
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	6
Scale:	0
Status:	Active
Description:	The number (count) of the specified species which occurred within the sample.
General Data Type:	NUMBER

WEIGHT_IN_SAMPLE

CC ID: 37211

Seq. Order:	9
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	10
Scale:	2
Status:	Active
Description:	The total weight in kilograms of the specified species which occurred within the sample.
General Data Type:	NUMBER

NUMBER_OF_SKATES_SAMPLED

CC ID: 37206

Seq. Order:	10
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	The number of hachi (skates) that were sampled for prohibited species.
General Data Type:	NUMBER

HAUL_JOIN

CC ID: 37204

Seq. Order:	11
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
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

WEIGHT_SAMPLED

CC ID: 37212

Seq. Order:	12
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	10
Scale:	2
Status:	Active
Description:	The total weight in kilograms of all of the sampled species in the sample.
General Data Type:	NUMBER

PK_FDP

CC ID: 37207

Seq. Order:	13
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	Yes
Precision:	7
Scale:	0
Status:	Active
Description:	For internal use only.
General Data Type:	NUMBER

Catalog Details

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