Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Code: Fish Species

Description

Code: Fish Species

Entity Information

Entity Type
Data Table

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

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

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