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

Summary

Abstract

Port Codes Look Up Table

Entity Information

Data Attribute / Type Description
PORT_CODE
VARCHAR2
Code for this port.
PORT_NAME
VARCHAR2
Name for this port.
STATE_ABBR
VARCHAR2
Abbreviation for the state in which this port is located.
COUNTY
VARCHAR2
Name of the county in which this port is located.

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: EMPORT
Short Name: EMPORT
Status: Completed
Abstract:

Port Codes Look Up Table

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key PORT_CODE VARCHAR2 Code for this port.
100
PORT_NAME VARCHAR2 Name for this port.
100
STATE_ABBR VARCHAR2 Abbreviation for the state in which this port is located.
100
COUNTY VARCHAR2 Name of the county in which this port is located.

Attribute Details

PORT_CODE

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

Code for this port.

PORT_NAME

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

Name for this port.

STATE_ABBR

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

Abbreviation for the state in which this port is located.

COUNTY

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

Name of the county in which this port is located.

Catalog Details

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