Search Help Show/Hide Menu
Metadata Rubric
83%
5 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Auke Bay Laboratories > AFSC/ABL: Yukon Delta Juvenile Chinook Salmon -... >

Lookup_SpeciesCodes

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:27982  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

-no description-

Description

-no description-

Entity Information

Data Attribute / Type Description
SpCodeID
Unknown 		Arbitrary yet unique number for each species.
SpCode
Unknown 		Unique code for each species captured. This table is the complete list of Species. Links SpeciesCodes table to SeineCatch, JigCatch, and DipNet tables.
Taxa
Unknown 		Taxonomic Order of species caught. In drop-down menu: Fish, Crustacean, Octopus
Sp_CommonName
Unknown 		Common name of <SpCode>.
Sp_ScientificName
Unknown 		Scientific name of <SpCode>.
Fam_CommonName
Unknown 		Family common name of <SpCode>.
ForageFish
VARCHAR2 		indicates if species is a forage fish
FMP
VARCHAR2 		indicates if species is a Federally Managed Species

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

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

-no description-
Notes:

Loaded by FGDC Metadata Uploader, batch 7304, 10-14-2015 17:37

Entity Information

Description:

-no description-

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 SpCodeID Unknown Arbitrary yet unique number for each species.
100
 SpCode Unknown Unique code for each species captured. This table is the complete list of Species. Links SpeciesCodes table to SeineCatch, JigCatch, and DipNet tables.
100
 Taxa Unknown Taxonomic Order of species caught. In drop-down menu: Fish, Crustacean, Octopus
100
 Sp_CommonName Unknown Common name of <SpCode>.
100
 Sp_ScientificName Unknown Scientific name of <SpCode>.
100
 Fam_CommonName Unknown Family common name of <SpCode>.
100
 ForageFish VARCHAR2 indicates if species is a forage fish
100
 FMP VARCHAR2 indicates if species is a Federally Managed Species

Attribute Details

SpCodeID

CC ID: 232833
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Arbitrary yet unique number for each species.
Allowed Values: No domain defined.

SpCode

CC ID: 232834
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Unique code for each species captured. This table is the complete list of Species. Links SpeciesCodes table to SeineCatch, JigCatch, and DipNet tables.
Allowed Values: No domain defined.

Taxa

CC ID: 232835
Data Storage Type: Unknown
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: 232836
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Common name of <SpCode>.
Allowed Values: No domain defined.

Sp_ScientificName

CC ID: 232837
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Scientific name of <SpCode>.
Allowed Values: No domain defined.

Fam_CommonName

CC ID: 232838
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Family common name of <SpCode>.
Allowed Values: Field source not limited to list.

ForageFish

CC ID: 232839
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

indicates if species is a forage fish
Allowed Values: False, True

FMP

CC ID: 232840
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

indicates if species is a Federally Managed Species
Allowed Values: False, True

Catalog Details

Catalog Item ID: 27982
GUID: gov.noaa.nmfs.inport:27982
Metadata Record Created By: Emily A Fergusson
Metadata Record Created: 2015-10-14 17:37+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