Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Table of NMFS County Codes

Notes:

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

Entity Information

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

Table of NMFS County Codes

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key STATE_CODE_NMFS VARCHAR2 State where the Area Fished Code is valid. The State Codes are assigned and maintained by the National Marine Fisheries Service.Validation:There is a foreign key relationship on this column with the table FLS_STATE_CODES_NMFS. This means that no rows can be added to this table if the state code is not found in the state code table. This ensures that no mysterious codes are added to the table.This column is also mandatory, which means that it cannot be left empty.
100
Primary Key COUNTY_CODE_NMFS VARCHAR2 The official 3 digit NMFS county code. The code is left padded with zeroes.
100
COUNTY_NAME VARCHAR2 The name of the county. Names are uppercase.
100
GOLDEN_CRAB_COUNTY NUMBER County Code When Table is used By Gold Crab FIshery

Attribute Details

STATE_CODE_NMFS

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

State where the Area Fished Code is valid. The State Codes are assigned and maintained by the National Marine Fisheries Service.Validation:There is a foreign key relationship on this column with the table FLS_STATE_CODES_NMFS. This means that no rows can be added to this table if the state code is not found in the state code table. This ensures that no mysterious codes are added to the table.This column is also mandatory, which means that it cannot be left empty.

General Data Type: VARCHAR2

COUNTY_CODE_NMFS

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

The official 3 digit NMFS county code. The code is left padded with zeroes.

General Data Type: VARCHAR2

COUNTY_NAME

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

The name of the county. Names are uppercase.

General Data Type: VARCHAR2

GOLDEN_CRAB_COUNTY

CC ID: 27169
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

County Code When Table is used By Gold Crab FIshery

General Data Type: NUMBER

Catalog Details

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