Table: FVTR_PORTS
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:34395 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Materialized view of SCBI.VALID_PORTS; a translation table which joins the ACCSP/FIPS place coding system to the NE Region PORT coding system
DescriptionMaterialized 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
Name | Type | Description | ||
---|---|---|---|---|
100
|
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
|
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
|
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
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
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
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
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
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
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
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 |