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

Summary

Abstract

Master Cross Table Of Port Codes

Description

Master Cross Table Of Port Codes

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
COUNTY_NAME
VARCHAR2
County Name
PORT_NAME
VARCHAR2
Port name
STATE_NAME
VARCHAR2
State Name
STATE_ALPHA
VARCHAR2
Alpha State (Postal) Code
NMFS_COUNTY_CODE
NUMBER
NMFS County Code
NMFS_STATE_CODE
NUMBER
NMFS State Code
FL_COUNTY_CODE
NUMBER
County Code In State Of Florida System
LA_COUNTY_CODE
NUMBER
County Code In State Of Louisiana System
TX_COUNTY_CODE
NUMBER
County Code In State Of Texas System
MS_COUNTY_CODE
NUMBER
County Code In State Of Mississippi System
AL_COUNTY_CODE
NUMBER
County Code In State Of Alabama System
GSHR_PORT_CODE
NUMBER
Port Code In Gulf Shrimp System
SASHR_PORT_CODE
NUMBER
Port Code In South Atlantic Shrimp System
DOM_LONGLINE_CODE
NUMBER
Port Code In Domestic Longline System
GA_COUNTY_CODE
NUMBER
County Code In System From State Of Georgia
SC_COUNTY_CODE
NUMBER
County Code In State Of South Carolina System
NC_COUNTY_CODE
NUMBER
County Code In State Of North Carolina System

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

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

Master Cross Table Of Port Codes

Notes:

Loaded by batch 1924, 11-09-2007 10:56

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None code
None Port Codes

Spatial Keywords

Thesaurus Keyword
UNCONTROLLED
None alabama
None florida
None georgia
None gulf coast
None louisiana
None mississippi
None nirth carolina
None se atlantic coast
None south carolina

Stratum Keywords

Thesaurus Keyword
UNCONTROLLED
None state

Entity Information

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

Master Cross Table Of Port Codes

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
COUNTY_NAME VARCHAR2 County Name
100
PORT_NAME VARCHAR2 Port name
100
STATE_NAME VARCHAR2 State Name
100
STATE_ALPHA VARCHAR2 Alpha State (Postal) Code
100
NMFS_COUNTY_CODE NUMBER NMFS County Code
100
NMFS_STATE_CODE NUMBER NMFS State Code
100
FL_COUNTY_CODE NUMBER County Code In State Of Florida System
100
LA_COUNTY_CODE NUMBER County Code In State Of Louisiana System
100
TX_COUNTY_CODE NUMBER County Code In State Of Texas System
100
MS_COUNTY_CODE NUMBER County Code In State Of Mississippi System
100
AL_COUNTY_CODE NUMBER County Code In State Of Alabama System
100
GSHR_PORT_CODE NUMBER Port Code In Gulf Shrimp System
100
SASHR_PORT_CODE NUMBER Port Code In South Atlantic Shrimp System
100
DOM_LONGLINE_CODE NUMBER Port Code In Domestic Longline System
100
GA_COUNTY_CODE NUMBER County Code In System From State Of Georgia
100
SC_COUNTY_CODE NUMBER County Code In State Of South Carolina System
100
NC_COUNTY_CODE NUMBER County Code In State Of North Carolina System

Attribute Details

COUNTY_NAME

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

County Name

General Data Type: VARCHAR2

PORT_NAME

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

Port name

General Data Type: VARCHAR2

STATE_NAME

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

State Name

General Data Type: VARCHAR2

STATE_ALPHA

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

Alpha State (Postal) Code

General Data Type: VARCHAR2

NMFS_COUNTY_CODE

CC ID: 21633
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

NMFS County Code

General Data Type: NUMBER

NMFS_STATE_CODE

CC ID: 21634
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

NMFS State Code

General Data Type: NUMBER

FL_COUNTY_CODE

CC ID: 21635
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

County Code In State Of Florida System

General Data Type: NUMBER

LA_COUNTY_CODE

CC ID: 21636
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

County Code In State Of Louisiana System

General Data Type: NUMBER

TX_COUNTY_CODE

CC ID: 21637
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

County Code In State Of Texas System

General Data Type: NUMBER

MS_COUNTY_CODE

CC ID: 21638
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

County Code In State Of Mississippi System

General Data Type: NUMBER

AL_COUNTY_CODE

CC ID: 21639
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

County Code In State Of Alabama System

General Data Type: NUMBER

GSHR_PORT_CODE

CC ID: 21640
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Port Code In Gulf Shrimp System

General Data Type: NUMBER

SASHR_PORT_CODE

CC ID: 21641
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Port Code In South Atlantic Shrimp System

General Data Type: NUMBER

DOM_LONGLINE_CODE

CC ID: 21642
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Port Code In Domestic Longline System

General Data Type: NUMBER

GA_COUNTY_CODE

CC ID: 21643
Seq. Order: 15
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

County Code In System From State Of Georgia

General Data Type: NUMBER

SC_COUNTY_CODE

CC ID: 21644
Seq. Order: 16
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

County Code In State Of South Carolina System

General Data Type: NUMBER

NC_COUNTY_CODE

CC ID: 21645
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

County Code In State Of North Carolina System

General Data Type: NUMBER

Access Information

Security Class: Unclassified

Catalog Details

Catalog Item ID: 6423
GUID: gov.noaa.nmfs.inport:6423
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-11-09 10:56+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:10+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-05-06
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-05-06