Lookup_SpeciesCodes
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:27982 | Updated: August 9, 2022 | Published / External
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
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 |