Slide Menu
Search Help Show/Hide Menu

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