Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Species_code
Abstract:

List of Valid Species Codes

Purpose:

To validate species Codes upon Data Entry

Entity Information

Entity Type: Data Table
Description:

Species Code Table

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key Code Character Mnemonic Letter Code
100
Primary Key Num Numeric Numeric Code
100
Common Character Common Name
100
Genus Character Genus Associated With Common Name
100
Species Character Species Associated With Common Name
100
ITIS Numeric Integrated Taxonomic Information System Species Code

Attribute Details

Code

CC ID: 568240
Seq. Order: 10
Data Storage Type: Character
Max Length: 3
Required: Yes
Primary Key: Yes
Status: Active
Description:

Mnemonic Letter Code

Num

CC ID: 568244
Seq. Order: 20
Data Storage Type: Numeric
Required: Yes
Primary Key: Yes
Status: Active
Description:

Numeric Code

Common

CC ID: 568241
Seq. Order: 30
Data Storage Type: Character
Max Length: 45
Required: Yes
Primary Key: No
Status: Active
Description:

Common Name

Genus

CC ID: 568242
Seq. Order: 40
Data Storage Type: Character
Max Length: 30
Required: Yes
Primary Key: No
Status: Active
Description:

Genus Associated With Common Name

Species

CC ID: 568245
Seq. Order: 50
Data Storage Type: Character
Max Length: 30
Required: Yes
Primary Key: No
Status: Active
Description:

Species Associated With Common Name

ITIS

CC ID: 568243
Seq. Order: 60
Data Storage Type: Numeric
Required: No
Primary Key: No
Precision: 7
Status: Active
Description:

Integrated Taxonomic Information System Species Code

Catalog Details

Catalog Item ID: 46065
GUID: gov.noaa.nmfs.inport:46065
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2017-05-15 12:23+0000
Metadata Record Last Modified By: Lee M Weinberger
Metadata Record Last Modified: 2021-05-07 10:52+0000
Metadata Record Published: 2021-05-07
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Review Frequency: 1 Year