Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Cross Table Between NMFS, ERDMAN, and NODC Species Code. This was put together by IRM staff in the mid 1990s. Actually it is a cross reference going from erdman code (pr_species) to NMFS_CODE and to NODC code. This table is now obsolete as it was replaced by the more comprehensive als.PR_SPECIES_ERDMAN_ITIS_XREF table.

Notes:

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

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None Cross Table
None Erdman Codes
None Species Codes

Spatial Keywords

Thesaurus Keyword
UNCONTROLLED
None Puerto Rico
None Virgin Islands

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:

Cross Table Between NMFS, ERDMAN, and NODC Species Code. This was put together by IRM staff in the mid 1990s

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
SCIENTIFIC_NAME VARCHAR2 Scientific Name
100
COMMON_NAME VARCHAR2 Common Name
100
ERDMAN_CODE VARCHAR2 Erdman Species Code
100
NMFS_CODE VARCHAR2 NMFS Species Code
100
NODC_CODE VARCHAR2 NODC Species Code

Attribute Details

SCIENTIFIC_NAME

CC ID: 21667
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 24
Required: No
Primary Key: No
Status: Active
Description:

Scientific Name

General Data Type: VARCHAR2

COMMON_NAME

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

Common Name

General Data Type: VARCHAR2

ERDMAN_CODE

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

Erdman Species Code

General Data Type: VARCHAR2

NMFS_CODE

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

NMFS Species Code

General Data Type: VARCHAR2

NODC_CODE

CC ID: 21671
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

NODC Species Code

General Data Type: VARCHAR2

Access Information

Security Class: Unclassified
Data Use Constraints:

None

Metadata Use Constraints:

None

Catalog Details

Catalog Item ID: 6430
GUID: gov.noaa.nmfs.inport:6430
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-11-09 10:56+0000
Metadata Record Last Modified By: Lee M Weinberger
Metadata Record Last Modified: 2021-05-06 22:24+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-05-07