Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: CodeSpecies
Short Name: CodeSpecies
Abstract:

Code: Fish Species

Entity Information

Entity Type: Data Table
Active Version?: Yes
Description:

Code: Fish Species

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
SpeciesID AutoNumber for maintenance software
100
ITIScode Text No Description available
100
SpeciesCode Text Unique IFandW alpha code for each species
100
Species Text Common name for each species
100
ScientificName Text Scientific name for the species
100
FishCode Text Unique IFandW Fish Code
100
Habitat Text Freshwater Anadromous or Marine
100
TableEditDate Date/Time Most recent date of addition or change to record
100
Editor Text Name of person to add or most recently change record
100
EditorComments Memo Comments regarding the record added or changed
100
LastUpdate Date/Time for maintenance software

Attribute Details

SpeciesID

CC ID: 343150
Data Storage Type: AutoNumber
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

for maintenance software

General Data Type: Number

ITIScode

CC ID: 343151
Data Storage Type: Text
Max Length: 250
Required: No
Primary Key: No
Status: Active
Description:

No Description available

General Data Type: Text

SpeciesCode

CC ID: 343152
Data Storage Type: Text
Max Length: 10
Required: Yes
Primary Key: No
Status: Active
Description:

Unique IFandW alpha code for each species

General Data Type: Text

Species

CC ID: 343153
Data Storage Type: Text
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Common name for each species

General Data Type: Text

ScientificName

CC ID: 343154
Data Storage Type: Text
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Scientific name for the species

General Data Type: Text

FishCode

CC ID: 343155
Data Storage Type: Text
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Unique IFandW Fish Code

General Data Type: Text

Habitat

CC ID: 343156
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Freshwater Anadromous or Marine

General Data Type: Text

TableEditDate

CC ID: 343157
Data Storage Type: Date/Time
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Most recent date of addition or change to record

General Data Type: Date/Time

Editor

CC ID: 343158
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Name of person to add or most recently change record

General Data Type: Text

EditorComments

CC ID: 343159
Data Storage Type: Memo
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Comments regarding the record added or changed

General Data Type: Memo

LastUpdate

CC ID: 343160
Data Storage Type: Date/Time
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

for maintenance software

General Data Type: Date/Time

Catalog Details

Catalog Item ID: 34118
GUID: gov.noaa.nmfs.inport:34118
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-08-08 13:34+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-08-08
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-08-08
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-08-08