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

Summary

Abstract

View of Valid Port Codes For The Gulf Shrimp System. It is also used to translate GSS Port Codes to NMFS State and County Codes

Description

View of Valid Port Codes For The Gulf Shrimp System. It is also used to translate GSS Port Codes to NMFS State and County Codes

Entity Information

Entity Type
Data View

Data Attribute / Type Description
PORT_NAME
VARCHAR2
Name Of The Port
NMFS_CODE
VARCHAR2
3 character NMFS County Code
PORT_CODE
VARCHAR2
Port Code in GSS System
STATE_CODE
VARCHAR2
Two character NMFS State Code

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

View of Valid Port Codes For The Gulf Shrimp System. It is also used to translate GSS Port Codes to NMFS State and County Codes

Notes:

Loaded by batch 1744, 10-17-2007 10:30

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None county codes
None port codes
None state codes

Entity Information

Entity Type: Data View
Active Version?: Yes
Schema Name: GSS
Description:

View of Valid Port Codes For The Gulf Shrimp System. It is also used to translate GSS Port Codes to NMFS State and County Codes

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
PORT_NAME VARCHAR2 Name Of The Port
100
NMFS_CODE VARCHAR2 3 character NMFS County Code
100
PORT_CODE VARCHAR2 Port Code in GSS System
100
STATE_CODE VARCHAR2 Two character NMFS State Code

Attribute Details

PORT_NAME

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

Name Of The Port

General Data Type: VARCHAR2

NMFS_CODE

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

3 character NMFS County Code

General Data Type: VARCHAR2

PORT_CODE

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

Port Code in GSS System

General Data Type: VARCHAR2

STATE_CODE

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

Two character NMFS State Code

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 5519
GUID: gov.noaa.nmfs.inport:5519
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-10-17 10:30+0000
Metadata Record Last Modified By: Lee M Weinberger
Metadata Record Last Modified: 2024-06-14 14:05+0000
Metadata Record Published: 2024-06-14
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-05-07
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-05-07