Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Fisheries Statistics Division > Fisheries Sampling Branch > Gulf shrimp system > Gulf Shrimp Code Tables >

View: GSS_WATER_BODY_CODE

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:5527  |  Updated: June 14, 2024  |  Published / External 
Summary
Item Identification
Keywords
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

View of Valid Water Body Codes For The Gulf Shrimp System. It is also used to translate GSS Port Codes to NMFS State and County Codes

Description

View of Valid Water Body Codes For The Gulf Shrimp System. It is also used to translate GSS Port Codes to NMFS State and County Codes

Entity Information

Entity Type
Data View

Data Attribute / Type Description
RIVER_CODE
NUMBER 		River Code
GRID_CODE
NUMBER 		Grid Code
SHORE_CODE
NUMBER 		Shore Code in GSS System
DESCRIPTION
VARCHAR2 		Description Of The Code
DATE_ADDED
DATE 		Date record was added to this table
CURRENT_YEAR
VARCHAR2 		Indicates whether this code set is used to validate at this time

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: View: GSS_WATER_BODY_CODE
Short Name: GSS_WATER_BODY_CODE
Status: Completed
Abstract:

View of Valid Water Body Codes For The Gulf Shrimp System. It is also used to translate GSS Port Codes to NMFS State and County Codes
Notes:

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

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None water body codes

Entity Information

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

View of Valid Water Body Codes For The Gulf Shrimp System. It is also used to translate GSS Port Codes to NMFS State and County Codes

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 RIVER_CODE NUMBER River Code
100
 GRID_CODE NUMBER Grid Code
100
 SHORE_CODE NUMBER Shore Code in GSS System
100
 DESCRIPTION VARCHAR2 Description Of The Code
100
 DATE_ADDED DATE Date record was added to this table
100
 CURRENT_YEAR VARCHAR2 Indicates whether this code set is used to validate at this time

Attribute Details

RIVER_CODE

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

River Code
General Data Type: NUMBER

GRID_CODE

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

Grid Code
General Data Type: NUMBER

SHORE_CODE

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

Shore Code in GSS System
General Data Type: NUMBER

DESCRIPTION

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

Description Of The Code
General Data Type: VARCHAR2

DATE_ADDED

CC ID: 18072
Seq. Order: 5
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date record was added to this table
General Data Type: DATE

CURRENT_YEAR

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

Indicates whether this code set is used to validate at this time
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 5527
GUID: gov.noaa.nmfs.inport:5527
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: 2024-06-14 14:05+0000
Metadata Record Published: 2024-06-14
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-05-07
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-05-07