Slide Menu
Search Help Show/Hide Menu

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: 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