Table: CTS_SPECIES
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:7082 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Table Of Valid Species Codes Used in NMFS Cooperative Tagging System
DescriptionTable 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
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
![]() |
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
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
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
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
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 |