FMA norpac.domestic_species Table Documentation

Note: You need to enable scripting and Javascript in your browser settings to best view and navigate our website. Otherwise, use our keyboard navigation and search page. For keyboard tabbing on this page you can bypass the top menu bar navigation and jump to the page sidebar navigation (if applicable), or jump to the page body. Our print link for screen media is scripted. Your computer's normal print command will print this page. Please contact us if you have difficulty in accessing our web pages.

Mobile users can use the Site Map to access the principal pages

FMA norpac.domestic_species Table Documentation

Table name	Definition
NORPAC.DOMESTIC_SPECIES	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.

Column name	Type	Definition
SPECIES_NO	number(3,0)	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(60)	The common name of the marine organism.
PROHIB	varchar2(1)	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(10)	The prohibited species grouping associated with the SPECIES_NAME. This field is NULL unless PROHIB = "Y". The groupings are: HALIBUT, KINGCRAB, OTHCRAB, SALMON.
RACE_SPECIE_NUM	varchar2(5)	A five-digit numeric code assigned by the RACE division that is associated with the SPECIES_NAME.
SCIENTIFIC_NAME	varchar2(41)	The scientific name associated with the common SPECIES_NAME.
MAX_WT	number(11,2)	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(11,2)	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(3,0)	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(3,0)	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(60)	Nickname is the same as the common SPECIES_NAME.
AGGREGATION	varchar2(60)	Indicates species aggregation and possible species_no in the aggregation.
AGE_TRAY	number(6,0)	For internal use by Age Determination Unit.
AGE_TRAY_X	varchar2(2)	For internal use by Age Determination Unit.
AGE_TRAY_Y	varchar2(2)	For internal use by Age Determination Unit.
AGE_TRAY_GOA	number(6,0)	For internal use by Age Determination Unit.
AGE_TRAY_GOA_X	varchar2(2)	For internal use by Age Determination Unit.
AGE_TRAY_GOA_Y	varchar2(2)	For internal use by Age Determination Unit.

Return to Domestic_tables

Last Updated 28 - May - 2009