Slide Menu
System Maintenance Notice, Sunday, January 16, 2022 @ 8am-10pm Eastern. The Operations Team will be performing system maintenance on all server environments. During this scheduled downtime, InPort will not be available.
View All
Search Help Show/Hide Menu

Item Identification

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

The official list of NMFS state codes. Columns names have been standardized and codes were converted to uppercase. The table will be automatically synchronized with the official table, fips_state_county_code_xref located on the shark. A trigger on the snapshot makes certain changes to eliminate the number of duplicates in the table, as well as to add missing values. The country code of US is added to most codes, as well as RQ for state 53 and VQ for state 54. The following state names were added: FLORIDA EAST COAST for state code 10, FLORIDA WEST COAST 11, and FLORIDA INLAND LAKES, for state code 12. The official source of the data is the database located on the shark. Headquarters is in charge of maintaining these codes and they are presumed to be correct.

Notes:

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

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None code table
None states

Entity Information

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

The official list of NMFS state codes. Columns names have been standardized and codes were converted to uppercase. The table will be automatically synchronized with the official table, fips_state_county_code_xref located on the shark. A trigger on the snapshot makes certain changes to eliminate the number of duplicates in the table, as well as to add missing values. The country code of US is added to most codes, as well as RQ for state 53 and VQ for state 54. The following state names were added: FLORIDA EAST COAST for state code 10, FLORIDA WEST COAST 11, and FLORIDA INLAND LAKES, for state code 12. The official source of the data is the database located on the shark. Headquarters is in charge of maintaining these codes and they are presumed to be correct.

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
STATE_NAME VARCHAR2 The name of the state. Names have been converted to uppercase to simplify searching for codes. Use INITCAP(state_label) to return mixed case state labels, i.e. Alabama or New York.Validation:None.
100
COUNTRY_CODE_FIPS VARCHAR2 Country where the dealership is located.Validation:The country code must be a valid FIPS country.The country code is mandatory and cannot be left empty.
100
STATE_ABBREVIATION VARCHAR2 Two Character State Abbreviation

Attribute Details

STATE_CODE_NMFS

CC ID: 27359
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

STATE_NAME

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

The name of the state. Names have been converted to uppercase to simplify searching for codes. Use INITCAP(state_label) to return mixed case state labels, i.e. Alabama or New York.Validation:None.

General Data Type: VARCHAR2

COUNTRY_CODE_FIPS

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

Country where the dealership is located.Validation:The country code must be a valid FIPS country.The country code is mandatory and cannot be left empty.

General Data Type: VARCHAR2

STATE_ABBREVIATION

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

Two Character State Abbreviation

General Data Type: VARCHAR2

Catalog Details

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