Slide Menu
Search Help Show/Hide Menu

Item Identification

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

SEFSC.SPECIES_CODE_TEXAS gives a list of the cross tablebetween NMFS Species Codes and Texas Species Codes.

Notes:

Loaded by batch 1924, 11-09-2007 10:56

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None Cross Table
None Species Code

Spatial Keywords

Thesaurus Keyword
UNCONTROLLED
None Texas

Physical Location

Organization: Southeast Fisheries Science Center
City: Miami
State/Province: FL
Country: USA

Entity Information

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

SEFSC.SPECIES_CODE_TEXAS gives a list of the cross tablebetween NMFS Species Codes and Texas Species Codes.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
NMFS_CODE VARCHAR2 NMFS Species Code
100
Primary Key TEXAS_CODE NUMBER The TPWD (Texas) Species Code .
100
SOME_CODE NUMBER .
100
COMMON_NAME VARCHAR2 The common name of the species caught.

Attribute Details

NMFS_CODE

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

NMFS Species Code

General Data Type: VARCHAR2
Foreign Key Relations:

Must Be a Valid NMFS State Code

TEXAS_CODE

CC ID: 21673
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 5
Scale: 0
Status: Active
Description:

The TPWD (Texas) Species Code .

General Data Type: NUMBER

SOME_CODE

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

.

General Data Type: NUMBER

COMMON_NAME

CC ID: 21675
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

The common name of the species caught.

General Data Type: VARCHAR2

Access Information

Security Class: Unclassified
Data Use Constraints:

None

Metadata Use Constraints:

None

Catalog Details

Catalog Item ID: 6431
GUID: gov.noaa.nmfs.inport:6431
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-11-09 10:56+0000
Metadata Record Last Modified By: Lee M Weinberger
Metadata Record Last Modified: 2021-05-06 22:24+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Review Frequency: 1 Year