Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Lookup_SpeciesCodes
Short Name: Lookup_SpeciesCodes
Status: In Work
Abstract:

-no description-

Notes:

Loaded by FGDC Metadata Uploader, batch 5630, 03-16-2015 18:08

Entity Information

Description:

-no description-

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
FMP_Salmon binary indicates (1) if species is a Federally Managed Species, (0) if not. Salmon.
100
Fam_ScientificName character varying Scientific name of family.
100
SpCode character varying Unique code for each species captured. This table is the complete list of Species. Links Lookup_speciesCode table to Catch table.
100
Taxa character varying Taxonomic Order of species caught. In drop-down menu: Fish, Crustacean, Octopus
100
Sp_CommonName character varying Common name of <SpCode>.
100
Sp_ScientificName character varying Scientific name of <SpCode>.
100
Fam_CommonName character varying Family common name of <SpCode>.
100
FMP_BSAI binary indicates (1) if species is a Federally Managed Species, (0) if not. Bering Sea Aleutian Islands.
100
FMP_GOA binary indicates (1) if species is a Federally Managed Species, (0) if not. Gulf of Alaska.
100
FMP binary indicates (1) if species is a Federally Managed Species, (0) if not.
100
FMP_Arctic binary indicates (1) if species is a Federally Managed Species, (0) if not. Arctic.

Attribute Details

FMP_Salmon

CC ID: 1187612
Seq. Order: 1
Data Storage Type: binary
Required: No
Primary Key: No
Status: Active
Description:

indicates (1) if species is a Federally Managed Species, (0) if not. Salmon.

Fam_ScientificName

CC ID: 228149
Data Storage Type: character varying
Required: No
Primary Key: No
Status: Active
Description:

Scientific name of family.

Allowed Values: No domain defined.

SpCode

CC ID: 228150
Data Storage Type: character varying
Required: No
Primary Key: No
Status: Active
Description:

Unique code for each species captured. This table is the complete list of Species. Links Lookup_speciesCode table to Catch table.

Allowed Values: No domain defined.

Taxa

CC ID: 228151
Data Storage Type: character varying
Required: No
Primary Key: No
Status: Active
Description:

Taxonomic Order of species caught. In drop-down menu: Fish, Crustacean, Octopus

Allowed Values: Field source not limited to list.

Sp_CommonName

CC ID: 228152
Data Storage Type: character varying
Required: No
Primary Key: No
Status: Active
Description:

Common name of <SpCode>.

Allowed Values: No domain defined.

Sp_ScientificName

CC ID: 228153
Data Storage Type: character varying
Required: No
Primary Key: No
Status: Active
Description:

Scientific name of <SpCode>.

Allowed Values: No domain defined.

Fam_CommonName

CC ID: 228154
Data Storage Type: character varying
Required: No
Primary Key: No
Status: Active
Description:

Family common name of <SpCode>.

Allowed Values: Field source not limited to list.

FMP_BSAI

CC ID: 228155
Data Storage Type: binary
Required: No
Primary Key: No
Status: Active
Description:

indicates (1) if species is a Federally Managed Species, (0) if not. Bering Sea Aleutian Islands.

Allowed Values: Free entry text field.

FMP_GOA

CC ID: 228156
Data Storage Type: binary
Required: No
Primary Key: No
Status: Active
Description:

indicates (1) if species is a Federally Managed Species, (0) if not. Gulf of Alaska.

Allowed Values: False, True

FMP

CC ID: 228157
Data Storage Type: binary
Required: No
Primary Key: No
Status: Active
Description:

indicates (1) if species is a Federally Managed Species, (0) if not.

Allowed Values: False, True

FMP_Arctic

CC ID: 228158
Data Storage Type: binary
Required: No
Primary Key: No
Status: Active
Description:

indicates (1) if species is a Federally Managed Species, (0) if not. Arctic.

Allowed Values: No domain defined.

Catalog Details

Catalog Item ID: 23999
GUID: gov.noaa.nmfs.inport:23999
Metadata Record Created By: Emily A Fergusson
Metadata Record Created: 2015-03-16 18:08+0000
Metadata Record Last Modified By: Emily A Fergusson
Metadata Record Last Modified: 2023-02-27 23:31+0000
Metadata Record Published: 2023-02-27
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