Search Help Show/Hide Menu
Summary
Item Identification
Keywords
Physical Location
Entity Info
Data Attributes
Access Info
Activity Log
Catalog Details

Summary

Abstract

snapshot table for snapshot SEFSC.SPECIES_CODE_NMFS

Description

snapshot table for snapshot SEFSC.SPECIES_CODE_NMFS

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
NMFS_CODE
VARCHAR2
NMFS Species Code. This is the 4 digit code traditionally used by NMFS HQ and regions around the country. Not all codes were added to the data at the same time so just because a code does not exist in the landings does not mean there was no fishery for that species. Although the agency tries to be proactive in assigning codes there are cases where general coding has gradually evolved into more specific coding. Groupers, sharks, and amberjacks are examples.
COMMON_NAME
VARCHAR2
Common Name
SCIENTIFIC_NAME
VARCHAR2
Scientific Name
COMMENTS
VARCHAR2
Comments On Record

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

Title: Table: SPECIES_CODE_NMFS
Short Name: SPECIES_CODE_NMFS
Status: Completed
Abstract:

snapshot table for snapshot SEFSC.SPECIES_CODE_NMFS

Notes:

Loaded by batch 1924, 11-09-2007 10:56

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None Species Codes

Physical Location

Organization: Southeast Fisheries Science Center
City: Miami
State/Province: FL
Country: USA

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: SEFSC
Description:

snapshot table for snapshot SEFSC.SPECIES_CODE_NMFS

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key NMFS_CODE VARCHAR2 NMFS Species Code. This is the 4 digit code traditionally used by NMFS HQ and regions around the country. Not all codes were added to the data at the same time so just because a code does not exist in the landings does not mean there was no fishery for that species. Although the agency tries to be proactive in assigning codes there are cases where general coding has gradually evolved into more specific coding. Groupers, sharks, and amberjacks are examples.
100
COMMON_NAME VARCHAR2 Common Name
100
SCIENTIFIC_NAME VARCHAR2 Scientific Name
100
COMMENTS VARCHAR2 Comments On Record

Attribute Details

NMFS_CODE

CC ID: 21663
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 4
Required: Yes
Primary Key: Yes
Status: Active
Description:

NMFS Species Code. This is the 4 digit code traditionally used by NMFS HQ and regions around the country. Not all codes were added to the data at the same time so just because a code does not exist in the landings does not mean there was no fishery for that species. Although the agency tries to be proactive in assigning codes there are cases where general coding has gradually evolved into more specific coding. Groupers, sharks, and amberjacks are examples.

General Data Type: VARCHAR2

COMMON_NAME

CC ID: 21664
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Common Name

General Data Type: VARCHAR2

SCIENTIFIC_NAME

CC ID: 21665
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 46
Required: No
Primary Key: No
Status: Active
Description:

Scientific Name

General Data Type: VARCHAR2

COMMENTS

CC ID: 21666
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

Comments On Record

General Data Type: VARCHAR2

Access Information

Security Class: Unclassified
Security Classification System:

Codes are public data

Data Access Procedure:

by data request (oral or written)

Data Access Constraints:

none

Data Use Constraints:

none

Activity Log

Activity Log 1

CC ID: 365686
Activity Date/Time: 2016-12-20
Activity Type: INSERT of additional species records
Responsible Party: Joshua Bennett
Description:

Inserted the following records:

2859 STINGRAY, PELAGIC Dasyatis violacea

2864 MANTA RAY Mobulidae

3002 ROUGHIES Trachichthyidae

9020 SEA GULL

9021 GANNET (SEA BIRD)

9022 PELICAN (BROWN) Pelecanus occidentalis

9025 SEA BIRD UNC.

9026 WHALE, PILOT Globicephala spp.

9037 DOLPHIN, RISSO'S Gampus griseus

Activity Log 2

CC ID: 389071
Activity Date/Time: 2017-03-10
Activity Type: additions and edits to Landing location coding
Responsible Party: Joshua Bennett
Description:

Many codes were added for tropical aquarium species into the master table at HQ and also the local SEFSC.SPECIES_CODE_NMFS table.

Catalog Details

Catalog Item ID: 6429
GUID: gov.noaa.nmfs.inport:6429
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-11-09 10:56+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:10+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-05-06
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-05-06