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

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

Summary

Item Identification

Physical Location

Entity Info

Data Attributes

Catalog Details

Abstract

A table which provides all of the three-digit numeric codes assigned by the NMFS Observer Program, complete with their common name, scientific name, associated RACE Division species code, and the maximum and minimum weights and lengths typically reported by observers.

Description

Entity Type
Data Table

Data Attribute / Type	Description
SPECIES_NO NUMBER	A three-digit numeric code assigned by the NMFS Observer Program to each different marine organism expected to be seen in the Bering Sea and northeast Pacific Ocean. Each number is uniquely associated with a SPECIES_NAME and a SCIENTIFIC_NAME.
SPECIES_NAME VARCHAR2	The common name of the marine organism.
PROHIB VARCHAR2	A one-digit alpha code indicating whether the species is allowed to be retained in the Alaska groundfish fishery and the West Coast Pacific whiting fishery, where: Y = Yes; N = No.
GENKEY VARCHAR2	The prohibited species grouping associated with the SPECIES_NAME. This fieldis NULL unless PROHIB = "Y". The groupings are: HALIBUT, KINGCRAB, OTHCRAB,SALMON.
RACE_SPECIE_NUM VARCHAR2	A 5-digit numeric code assigned by the RACE division that is associated withthe SPECIES_NAME
SCIENTIFIC_NAME VARCHAR2	The scientific name associated with the common SPECIES_NAME.
MAX_WT NUMBER	The maximum weight expected for an individual of this species. This value comes from several sources, the primary one being the NORPAC.DOMESTIC_SPCOMP_DETAIL table.
MIN_WT NUMBER	The minimum weight expected for an individual of this species. This value comes from several sources, the primary one being the NORPAC.DOMESTIC_SPCOMP_DETAIL table.
MAX_LEN NUMBER	The maximum length expected for an individual of this species. This value comes from several sources, the primary one being the NORPAC_DOMESTIC_LENGTH table.
MIN_LEN NUMBER	The minimum length expected for an individual of this species. This value comes from several sources, the primary one being the NORPAC.DOMESTIC_LENGTH table.
NICKNAME VARCHAR2	Nickname is the same as the common SPECIES_NAME.
AGGREGATION VARCHAR2	Indicates species aggregation and possible species_no in the aggregation.
AGE_TRAY NUMBER	For internal use by Age Determination Unit.
AGE_TRAY_X VARCHAR2	For internal use by Age Determination Unit.
AGE_TRAY_Y VARCHAR2	For internal use by Age Determination Unit.
AGE_TRAY_GOA NUMBER	For internal use by Age Determination Unit.
AGE_TRAY_GOA_X VARCHAR2	For internal use by Age Determination Unit.
AGE_TRAY_GOA_Y VARCHAR2	For internal use by Age Determination Unit.

Data Attribute / Type

Description

SPECIES_NO
NUMBER

A three-digit numeric code assigned by the NMFS Observer Program to each different marine organism expected to be seen in the Bering Sea and northeast Pacific Ocean. Each number is uniquely associated with a SPECIES_NAME and a SCIENTIFIC_NAME.

SPECIES_NAME
VARCHAR2

The common name of the marine organism.

PROHIB
VARCHAR2

A one-digit alpha code indicating whether the species is allowed to be retained in the Alaska groundfish fishery and the West Coast Pacific whiting fishery, where: Y = Yes; N = No.

GENKEY
VARCHAR2

The prohibited species grouping associated with the SPECIES_NAME. This fieldis NULL unless PROHIB = "Y". The groupings are: HALIBUT, KINGCRAB, OTHCRAB,SALMON.

RACE_SPECIE_NUM
VARCHAR2

A 5-digit numeric code assigned by the RACE division that is associated withthe SPECIES_NAME

SCIENTIFIC_NAME
VARCHAR2

The scientific name associated with the common SPECIES_NAME.

MAX_WT
NUMBER

The maximum weight expected for an individual of this species. This value comes from several sources, the primary one being the NORPAC.DOMESTIC_SPCOMP_DETAIL table.

MIN_WT
NUMBER

The minimum weight expected for an individual of this species. This value comes from several sources, the primary one being the NORPAC.DOMESTIC_SPCOMP_DETAIL table.

MAX_LEN
NUMBER

The maximum length expected for an individual of this species. This value comes from several sources, the primary one being the NORPAC_DOMESTIC_LENGTH table.

MIN_LEN
NUMBER

The minimum length expected for an individual of this species. This value comes from several sources, the primary one being the NORPAC.DOMESTIC_LENGTH table.

NICKNAME
VARCHAR2

Nickname is the same as the common SPECIES_NAME.

AGGREGATION
VARCHAR2

Indicates species aggregation and possible species_no in the aggregation.

AGE_TRAY
NUMBER

For internal use by Age Determination Unit.

AGE_TRAY_X
VARCHAR2

For internal use by Age Determination Unit.

AGE_TRAY_Y
VARCHAR2

For internal use by Age Determination Unit.

AGE_TRAY_GOA
NUMBER

For internal use by Age Determination Unit.

AGE_TRAY_GOA_X
VARCHAR2

For internal use by Age Determination Unit.

AGE_TRAY_GOA_Y
VARCHAR2

For internal use by Age Determination Unit.

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: DOMESTIC_SPECIES
Short Name:	DOMESTIC_SPECIES
Status:	Completed
Abstract:	A table which provides all of the three-digit numeric codes assigned by the NMFS Observer Program, complete with their common name, scientific name, associated RACE Division species code, and the maximum and minimum weights and lengths typically reported by observers.
Notes:	Loaded by batch 2364, 06-29-2009 18:15

Organization:	Alaska Fisheries Science Center
City:	Seattle
State/Province:	WA
Country:	USA

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	NORPAC
Description:	A table which provides all of the three-digit numeric codes assigned by the NMFS Observer Program, complete with their common name, scientific name, associated RACE Division species code, and the maximum and minimum weights and lengths typically reported by observers.

Attribute Summary

	Name	Type	Description
100	SPECIES_NO	NUMBER	A three-digit numeric code assigned by the NMFS Observer Program to each different marine organism expected to be seen in the Bering Sea and northeast Pacific Ocean. Each number is uniquely associated with a SPECIES_NAME and a SCIENTIFIC_NAME.
100	SPECIES_NAME	VARCHAR2	The common name of the marine organism.
100	PROHIB	VARCHAR2	A one-digit alpha code indicating whether the species is allowed to be retained in the Alaska groundfish fishery and the West Coast Pacific whiting fishery, where: Y = Yes; N = No.
100	GENKEY	VARCHAR2	The prohibited species grouping associated with the SPECIES_NAME. This fieldis NULL unless PROHIB = "Y". The groupings are: HALIBUT, KINGCRAB, OTHCRAB,SALMON.
100	RACE_SPECIE_NUM	VARCHAR2	A 5-digit numeric code assigned by the RACE division that is associated withthe SPECIES_NAME
100	SCIENTIFIC_NAME	VARCHAR2	The scientific name associated with the common SPECIES_NAME.
100	MAX_WT	NUMBER	The maximum weight expected for an individual of this species. This value comes from several sources, the primary one being the NORPAC.DOMESTIC_SPCOMP_DETAIL table.
100	MIN_WT	NUMBER	The minimum weight expected for an individual of this species. This value comes from several sources, the primary one being the NORPAC.DOMESTIC_SPCOMP_DETAIL table.
100	MAX_LEN	NUMBER	The maximum length expected for an individual of this species. This value comes from several sources, the primary one being the NORPAC_DOMESTIC_LENGTH table.
100	MIN_LEN	NUMBER	The minimum length expected for an individual of this species. This value comes from several sources, the primary one being the NORPAC.DOMESTIC_LENGTH table.
100	NICKNAME	VARCHAR2	Nickname is the same as the common SPECIES_NAME.
100	AGGREGATION	VARCHAR2	Indicates species aggregation and possible species_no in the aggregation.
100	AGE_TRAY	NUMBER	For internal use by Age Determination Unit.
100	AGE_TRAY_X	VARCHAR2	For internal use by Age Determination Unit.
100	AGE_TRAY_Y	VARCHAR2	For internal use by Age Determination Unit.
100	AGE_TRAY_GOA	NUMBER	For internal use by Age Determination Unit.
100	AGE_TRAY_GOA_X	VARCHAR2	For internal use by Age Determination Unit.
100	AGE_TRAY_GOA_Y	VARCHAR2	For internal use by Age Determination Unit.

Name

Type

Description

100

SPECIES_NO

NUMBER

100

SPECIES_NAME

VARCHAR2

The common name of the marine organism.

100

PROHIB

VARCHAR2

A one-digit alpha code indicating whether the species is allowed to be retained in the Alaska groundfish fishery and the West Coast Pacific whiting fishery, where: Y = Yes; N = No.

100

GENKEY

VARCHAR2

The prohibited species grouping associated with the SPECIES_NAME. This fieldis NULL unless PROHIB = "Y". The groupings are: HALIBUT, KINGCRAB, OTHCRAB,SALMON.

100

RACE_SPECIE_NUM

VARCHAR2

A 5-digit numeric code assigned by the RACE division that is associated withthe SPECIES_NAME

100

SCIENTIFIC_NAME

VARCHAR2

The scientific name associated with the common SPECIES_NAME.

100

MAX_WT

NUMBER

The maximum weight expected for an individual of this species. This value comes from several sources, the primary one being the NORPAC.DOMESTIC_SPCOMP_DETAIL table.

100

MIN_WT

NUMBER

The minimum weight expected for an individual of this species. This value comes from several sources, the primary one being the NORPAC.DOMESTIC_SPCOMP_DETAIL table.

100

MAX_LEN

NUMBER

The maximum length expected for an individual of this species. This value comes from several sources, the primary one being the NORPAC_DOMESTIC_LENGTH table.

100

MIN_LEN

NUMBER

The minimum length expected for an individual of this species. This value comes from several sources, the primary one being the NORPAC.DOMESTIC_LENGTH table.

100

NICKNAME

VARCHAR2

Nickname is the same as the common SPECIES_NAME.

100

AGGREGATION

VARCHAR2

Indicates species aggregation and possible species_no in the aggregation.

100

AGE_TRAY

NUMBER

For internal use by Age Determination Unit.

100

AGE_TRAY_X

VARCHAR2

For internal use by Age Determination Unit.

100

AGE_TRAY_Y

VARCHAR2

For internal use by Age Determination Unit.

100

AGE_TRAY_GOA

NUMBER

For internal use by Age Determination Unit.

100

AGE_TRAY_GOA_X

VARCHAR2

For internal use by Age Determination Unit.

100

AGE_TRAY_GOA_Y

VARCHAR2

For internal use by Age Determination Unit.

Attribute Details

SPECIES_NO

CC ID: 37114

Seq. Order:	1
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	Yes
Precision:	3
Scale:	0
Status:	Active
Description:	A three-digit numeric code assigned by the NMFS Observer Program to each different marine organism expected to be seen in the Bering Sea and northeast Pacific Ocean. Each number is uniquely associated with a SPECIES_NAME and a SCIENTIFIC_NAME.
General Data Type:	NUMBER

SPECIES_NAME

CC ID: 37113

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	60
Required:	Yes
Primary Key:	No
Status:	Active
Description:	The common name of the marine organism.
General Data Type:	VARCHAR2

PROHIB

CC ID: 37110

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	A one-digit alpha code indicating whether the species is allowed to be retained in the Alaska groundfish fishery and the West Coast Pacific whiting fishery, where: Y = Yes; N = No.
General Data Type:	VARCHAR2

GENKEY

CC ID: 37104

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	10
Required:	No
Primary Key:	No
Status:	Active
Description:	The prohibited species grouping associated with the SPECIES_NAME. This fieldis NULL unless PROHIB = "Y". The groupings are: HALIBUT, KINGCRAB, OTHCRAB,SALMON.
General Data Type:	VARCHAR2

RACE_SPECIE_NUM

CC ID: 37111

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	5
Required:	No
Primary Key:	No
Status:	Active
Description:	A 5-digit numeric code assigned by the RACE division that is associated withthe SPECIES_NAME
General Data Type:	VARCHAR2

SCIENTIFIC_NAME

CC ID: 37112

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	41
Required:	No
Primary Key:	No
Status:	Active
Description:	The scientific name associated with the common SPECIES_NAME.
General Data Type:	VARCHAR2

MAX_WT

CC ID: 37106

Seq. Order:	7
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	11
Scale:	2
Status:	Active
Description:	The maximum weight expected for an individual of this species. This value comes from several sources, the primary one being the NORPAC.DOMESTIC_SPCOMP_DETAIL table.
General Data Type:	NUMBER

MIN_WT

CC ID: 37108

Seq. Order:	8
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	11
Scale:	2
Status:	Active
Description:	The minimum weight expected for an individual of this species. This value comes from several sources, the primary one being the NORPAC.DOMESTIC_SPCOMP_DETAIL table.
General Data Type:	NUMBER

MAX_LEN

CC ID: 37105

Seq. Order:	9
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	The maximum length expected for an individual of this species. This value comes from several sources, the primary one being the NORPAC_DOMESTIC_LENGTH table.
General Data Type:	NUMBER

MIN_LEN

CC ID: 37107

Seq. Order:	10
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	The minimum length expected for an individual of this species. This value comes from several sources, the primary one being the NORPAC.DOMESTIC_LENGTH table.
General Data Type:	NUMBER

NICKNAME

CC ID: 37109

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	60
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Nickname is the same as the common SPECIES_NAME.
General Data Type:	VARCHAR2

AGGREGATION

CC ID: 37103

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	60
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicates species aggregation and possible species_no in the aggregation.
General Data Type:	VARCHAR2

AGE_TRAY

CC ID: 37097

Seq. Order:	13
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	0
Status:	Active
Description:	For internal use by Age Determination Unit.
General Data Type:	NUMBER

AGE_TRAY_X

CC ID: 37101

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	For internal use by Age Determination Unit.
General Data Type:	VARCHAR2

AGE_TRAY_Y

CC ID: 37102

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	For internal use by Age Determination Unit.
General Data Type:	VARCHAR2

AGE_TRAY_GOA

CC ID: 37098

Seq. Order:	16
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	0
Status:	Active
Description:	For internal use by Age Determination Unit.
General Data Type:	NUMBER

AGE_TRAY_GOA_X

CC ID: 37099

Seq. Order:	17
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	For internal use by Age Determination Unit.
General Data Type:	VARCHAR2

AGE_TRAY_GOA_Y

CC ID: 37100

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	For internal use by Age Determination Unit.
General Data Type:	VARCHAR2

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

Summary

Entity Information

Child Items

Contact Information

Item Identification

Physical Location

Entity Information

Data Attributes

Attribute Summary

Attribute Details

SPECIES_NO

SPECIES_NAME

PROHIB

GENKEY

RACE_SPECIE_NUM

SCIENTIFIC_NAME

MAX_WT

MIN_WT

MAX_LEN

MIN_LEN

NICKNAME

AGGREGATION

AGE_TRAY

AGE_TRAY_X

AGE_TRAY_Y

AGE_TRAY_GOA

AGE_TRAY_GOA_X

AGE_TRAY_GOA_Y

Catalog Details