Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Table: FLS_AREA_FISHED_BY_STATE
Short Name: FLS_AREA_FISHED_BY_STATE
Status: Completed
Abstract:

Table Of Area Fished Codes By State

Notes:

Loaded by batch 2103, 02-28-2008 14:10

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None Area
None Code Table

Entity Information

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

Table Of Area Fished Codes By State

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key STATE_CODE_NMFS VARCHAR2 State Code assigned by the National Marine Fisheries Service
100
Primary Key AREA_FISHED_CODE NUMBER Grid number that represents a body of water were fishing occurred.
100
AREA_CODING_SYSTEM VARCHAR2 Indicates which of the two grid systems: The Gulf Grid and the South Atlantic Statistical Grid.

Attribute Details

STATE_CODE_NMFS

CC ID: 27130
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 2
Required: Yes
Primary Key: Yes
Status: Active
Description:

State Code assigned by the National Marine Fisheries Service

General Data Type: VARCHAR2

AREA_FISHED_CODE

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

Grid number that represents a body of water were fishing occurred.

General Data Type: NUMBER

AREA_CODING_SYSTEM

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

Indicates which of the two grid systems: The Gulf Grid and the South Atlantic Statistical Grid.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 7145
GUID: gov.noaa.nmfs.inport:7145
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2008-02-28 14:10+0000
Metadata Record Last Modified By: Lee M Weinberger
Metadata Record Last Modified: 2021-05-06 22:24+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-05-07