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 >

Table: WATER_BODY_GRID_CODE

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:5531  |  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 Table

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: Table: WATER_BODY_GRID_CODE
Short Name: WATER_BODY_GRID_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 Table
Active Version?: Yes
Schema Name: SEFSC
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: 18095
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: 18094
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: 18093
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: 18092
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: 18091
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: 18090
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: 5531
GUID: gov.noaa.nmfs.inport:5531
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