Search Help Show/Hide Menu
Summary
Item Identification
Keywords
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Contains water body codes, grid numbers and descriptions of areas where finfish or invertebrates are caught.

Description

Contains water body codes, grid numbers and descriptions of areas where finfish or invertebrates are caught.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
CURRENT_YEAR
VARCHAR2
Current year (?)
GRID_NUMBER
VARCHAR2
Grid number assigned based on coordinates.
DESCRIPTION
VARCHAR2
Thorough description of the area the code represents.
DATE_ADDED
DATE
Date in which the code was added to the table.

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

Contains water body codes, grid numbers and descriptions of areas where finfish or invertebrates are caught.

Notes:

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

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None area descriptions
None grid codes
None water body codes

Entity Information

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

Contains water body codes, grid numbers and descriptions of areas where finfish or invertebrates are caught.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
CURRENT_YEAR VARCHAR2 Current year (?)
100
GRID_NUMBER VARCHAR2 Grid number assigned based on coordinates.
100
DESCRIPTION VARCHAR2 Thorough description of the area the code represents.
100
DATE_ADDED DATE Date in which the code was added to the table.

Attribute Details

CURRENT_YEAR

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

Current year (?)

General Data Type: VARCHAR2

GRID_NUMBER

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

Grid number assigned based on coordinates.

General Data Type: VARCHAR2

DESCRIPTION

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

Thorough description of the area the code represents.

General Data Type: VARCHAR2

DATE_ADDED

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

Date in which the code was added to the table.

General Data Type: DATE

Catalog Details

Catalog Item ID: 5528
GUID: gov.noaa.nmfs.inport:5528
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