Slide Menu
Search Help Show/Hide Menu

Item Identification

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

List of valid gss species codes and their equivalent NMFS Codes and the conversion factor to get the reported wigth to whole poundst

Notes:

Loaded by batch 1744, 10-17-2007 10:30

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None shrimp species codes
None species code

Entity Information

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

List of valid gss species codes and their equivalent NMFS Codes and the conversion factor to get the reported wigth to whole poundst

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
GSS_CODE VARCHAR2 Gulf Shrimp System specific code.
100
SCIENTIFIC_NAME VARCHAR2 Scientific name.
100
COMMON_NAME VARCHAR2 Common name.
100
CONVERSION_FACTOR NUMBER Conversion factor from heads off to heads on.
100
NMFS_CODE VARCHAR2 Official NMFS code.

Attribute Details

GSS_CODE

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

Gulf Shrimp System specific code.

General Data Type: VARCHAR2

SCIENTIFIC_NAME

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

Scientific name.

General Data Type: VARCHAR2

COMMON_NAME

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

Common name.

General Data Type: VARCHAR2

CONVERSION_FACTOR

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

Conversion factor from heads off to heads on.

General Data Type: NUMBER

NMFS_CODE

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

Official NMFS code.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 5530
GUID: gov.noaa.nmfs.inport:5530
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-10-17 10:30+0000
Metadata Record Last Modified By: Lee M Weinberger
Metadata Record Last Modified: 2021-05-07 09:52+0000
Metadata Record Published: 2021-05-07
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-05-08