Slide Menu
Search Help Show/Hide Menu

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