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

Summary

Abstract

Materialized view of SCBI.VALID_PORTS; a translation table which joins the ACCSP/FIPS place coding system to the NE Region PORT coding system

Description

Materialized view of SCBI.VALID_PORTS; a translation table which joins the ACCSP/FIPS place coding system to the NE Region PORT coding system

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
FIPS_STATE_CODE
VARCHAR2
The 2 digit numeric state code for the port of landing: 07=CT; 08=DE; 22=ME; 23=MD; 24=MA; 32=NH; 33=NJ; 35=NY; 36=NC; 42=RI; 49=VA.
FIPS_PLACE_CODE
VARCHAR2
The 5 digit numeric code for a specific place (eg. Port, town, county, etc). Place code is unique in combination with the FIPS_STATE_CODE and FIPS_COUNTY_CODE
FIPS_COUNTY_CODE
VARCHAR2
The last 2 digits of the port code, indicating the county, or, in a few cases, the city in which a port is geographically located.
PORT
VARCHAR2
A combined code for state, port and county. The port in which the vessel landed the catch.
PORT_NAME
VARCHAR2
The name of the fishing port.
STATE_POSTAL
VARCHAR2
The 2 character alpha state code (CT, DE, MA, MD, ME, NC, NH, NJ, NY, RI, VA).
COUNTY_NAME
VARCHAR2
Name of county., ex.ESSEX.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (NEFSC) for inquiries on this record.

Item Identification

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

Materialized view of SCBI.VALID_PORTS; a translation table which joins the ACCSP/FIPS place coding system to the NE Region PORT coding system

Notes:

Loaded by batch 9209, 08-23-2016 08:38

Entity Information

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

Materialized view of SCBI.VALID_PORTS; a translation table which joins the ACCSP/FIPS place coding system to the NE Region PORT coding system

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key FIPS_STATE_CODE VARCHAR2 The 2 digit numeric state code for the port of landing: 07=CT; 08=DE; 22=ME; 23=MD; 24=MA; 32=NH; 33=NJ; 35=NY; 36=NC; 42=RI; 49=VA.
100
Primary Key FIPS_PLACE_CODE VARCHAR2 The 5 digit numeric code for a specific place (eg. Port, town, county, etc). Place code is unique in combination with the FIPS_STATE_CODE and FIPS_COUNTY_CODE
100
Primary Key FIPS_COUNTY_CODE VARCHAR2 The last 2 digits of the port code, indicating the county, or, in a few cases, the city in which a port is geographically located.
100
PORT VARCHAR2 A combined code for state, port and county. The port in which the vessel landed the catch.
100
PORT_NAME VARCHAR2 The name of the fishing port.
100
STATE_POSTAL VARCHAR2 The 2 character alpha state code (CT, DE, MA, MD, ME, NC, NH, NJ, NY, RI, VA).
100
COUNTY_NAME VARCHAR2 Name of county., ex.ESSEX.

Attribute Details

FIPS_STATE_CODE

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

The 2 digit numeric state code for the port of landing: 07=CT; 08=DE; 22=ME; 23=MD; 24=MA; 32=NH; 33=NJ; 35=NY; 36=NC; 42=RI; 49=VA.

General Data Type: VARCHAR2

FIPS_PLACE_CODE

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

The 5 digit numeric code for a specific place (eg. Port, town, county, etc). Place code is unique in combination with the FIPS_STATE_CODE and FIPS_COUNTY_CODE

General Data Type: VARCHAR2

FIPS_COUNTY_CODE

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

The last 2 digits of the port code, indicating the county, or, in a few cases, the city in which a port is geographically located.

General Data Type: VARCHAR2

PORT

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

A combined code for state, port and county. The port in which the vessel landed the catch.

General Data Type: VARCHAR2

PORT_NAME

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

The name of the fishing port.

General Data Type: VARCHAR2

STATE_POSTAL

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

The 2 character alpha state code (CT, DE, MA, MD, ME, NC, NH, NJ, NY, RI, VA).

General Data Type: VARCHAR2

COUNTY_NAME

CC ID: 345438
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Name of county., ex.ESSEX.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 34395
GUID: gov.noaa.nmfs.inport:34395
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-08-23 08:38+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-08-23
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-08-23
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-08-23