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

Summary

Abstract

Table Of Valid Species Codes Used in NMFS Cooperative Tagging System

Description

Table Of Valid Species Codes Used in NMFS Cooperative Tagging System

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
SPECIES_ID
VARCHAR2
The 3 letter species code Used in the CTS System
COMMON_NAME
VARCHAR2
The common name for the fish species.
SCIENTIFIC_NAME
VARCHAR2
The scientific name for the fish's species.
MAX_SUST_VELOCITY
NUMBER
Maxium Sustained Velocity (often null)

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

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

Table Of Valid Species Codes Used in NMFS Cooperative Tagging System

Notes:

Loaded by batch 2083, 02-22-2008 12:10

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: CTSPAT
Description:

Table Of Valid Species Codes Used in NMFS Cooperative Tagging System

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key SPECIES_ID VARCHAR2 The 3 letter species code Used in the CTS System
100
COMMON_NAME VARCHAR2 The common name for the fish species.
100
SCIENTIFIC_NAME VARCHAR2 The scientific name for the fish's species.
100
MAX_SUST_VELOCITY NUMBER Maxium Sustained Velocity (often null)

Attribute Details

SPECIES_ID

CC ID: 26303
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 3
Required: Yes
Primary Key: Yes
Status: Active
Description:

The 3 letter species code Used in the CTS System

General Data Type: VARCHAR2

COMMON_NAME

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

The common name for the fish species.

General Data Type: VARCHAR2

SCIENTIFIC_NAME

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

The scientific name for the fish's species.

General Data Type: VARCHAR2

MAX_SUST_VELOCITY

CC ID: 26306
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Maxium Sustained Velocity (often null)

General Data Type: NUMBER

Catalog Details

Catalog Item ID: 7082
GUID: gov.noaa.nmfs.inport:7082
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2008-02-22 12:11+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-05-05
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-05-05
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-05-05