SPECIES
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:35895 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Species codes and names for linking FISH_ID_CODE with tables in other schema.
DescriptionSpecies codes and names for linking FISH_ID_CODE with tables in other schema.
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
COMMON_NAME
VARCHAR2 |
Common name for a species |
SCIENTIFIC_NAME
VARCHAR2 |
Scientific name for a species |
ABBREVIATION
VARCHAR2 |
Three letter abbreviation for each species used in FLDRPILOT.FISH_ORGANISM.FISH_ID_CODE to differentiate species. First letter is from the genus and the next two are the first two letters of the specific name. |
SPECIES_ITIS
VARCHAR2 |
Integrated Taxonomic Information System Code for a species |
Child Items
No Child Items for this record.
Contact Information
No contact information is available for this record.
Please contact the owner organization (NEFSC) for inquiries on this record.
Item Identification
Title: | SPECIES |
---|---|
Short Name: | SPECIES |
Status: | Completed |
Abstract: |
Species codes and names for linking FISH_ID_CODE with tables in other schema. |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Description: |
Species codes and names for linking FISH_ID_CODE with tables in other schema. |
Data Attributes
Attribute Summary
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
COMMON_NAME | VARCHAR2 | Common name for a species | |
100
|
SCIENTIFIC_NAME | VARCHAR2 | Scientific name for a species | |
100
|
ABBREVIATION | VARCHAR2 | Three letter abbreviation for each species used in FLDRPILOT.FISH_ORGANISM.FISH_ID_CODE to differentiate species. First letter is from the genus and the next two are the first two letters of the specific name. | |
100
|
SPECIES_ITIS | VARCHAR2 | Integrated Taxonomic Information System Code for a species |
Attribute Details
COMMON_NAME
Seq. Order: | 1 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Common name for a species |
General Data Type: | VARCHAR2 |
SCIENTIFIC_NAME
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Scientific name for a species |
General Data Type: | VARCHAR2 |
ABBREVIATION
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Three letter abbreviation for each species used in FLDRPILOT.FISH_ORGANISM.FISH_ID_CODE to differentiate species. First letter is from the genus and the next two are the first two letters of the specific name. |
General Data Type: | VARCHAR2 |
SPECIES_ITIS
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Integrated Taxonomic Information System Code for a species |
General Data Type: | VARCHAR2 |
Catalog Details
Catalog Item ID: | 35895 |
---|---|
GUID: | gov.noaa.nmfs.inport:35895 |
Metadata Record Created By: | Patricia L Jones |
Metadata Record Created: | 2016-12-07 13:28+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2016-12-12 |
Owner Org: | NEFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2016-12-12 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2017-12-12 |