Slide Menu
Search Help Show/Hide Menu

Item Identification

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

The list of FIPS port codes used within the Fishery Logbook System. It is a small set of named places in FIPS PUB 55-2 entitled, Guideline: Codes for named populated places, primary county divisions, and other locational entities of the United States and Outlying Areas. It is closely based upon fsragy.fips_55@shark.

Notes:

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

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None fips
None port codes

Entity Information

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

The list of FIPS port codes used within the Fishery Logbook System. It is a small set of named places in FIPS PUB 55-2 entitled, Guideline: Codes for named populated places, primary county divisions, and other locational entities of the United States and Outlying Areas. It is closely based upon fsragy.fips_55@shark.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key PORT_CODE_FIPS VARCHAR2 The fips port code. Leading zeroes were added.
100
PORT_NAME VARCHAR2 The name of the port.
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
COUNTY_CODE_NMFS VARCHAR2 The official 3 digit NMFS county code. The code is left padded with zeroes.
100
Primary Key COUNTRY_CODE_FIPS VARCHAR2 The official two character alphanumeric FIPS country code.

Attribute Details

PORT_CODE_FIPS

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

The fips port code. Leading zeroes were added.

General Data Type: VARCHAR2

PORT_NAME

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

The name of the port.

General Data Type: VARCHAR2

STATE_CODE_NMFS

CC ID: 27314
Seq. Order: 3
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: 27315
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 3
Required: Yes
Primary Key: No
Status: Active
Description:

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

General Data Type: VARCHAR2

COUNTRY_CODE_FIPS

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

The official two character alphanumeric FIPS country code.

General Data Type: VARCHAR2

Catalog Details

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