Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Species_Codes
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: 347081
Seq. Order: 10
Data Storage Type: Character
Max Length: 3
Required: Yes
Primary Key: Yes
Status: Active
Description:

Mnemonic Letter Code

Num

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

Numeric Code

Common

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

Common Name

Genus

CC ID: 347084
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: 347085
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: 568217
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: 34540
GUID: gov.noaa.nmfs.inport:34540
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2016-08-30 19:58+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-05-07
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-05-07
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-05-07