Table: PORT_CODE_ALL
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:6423 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Master Cross Table Of Port Codes
DescriptionMaster 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |