Slide Menu
Search Help Show/Hide Menu

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: 2021-05-07 09:52+0000
Metadata Record Published: 2021-05-07
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-05-08