Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Holds the DLS Port Codes information.

Notes:

Loaded by batch 5871, 04-20-2015 08:47

Entity Information

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

Holds the DLS Port Codes information.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key DLS_STATE_CODE VARCHAR2 DLS State Code
100
DLS_COUNTY_CODE VARCHAR2 County Code.
100
Primary Key DLS_PORT_CODE VARCHAR2 DLS Port Code.
100
PORT_LABEL VARCHAR2 Port Name.

Attribute Details

DLS_STATE_CODE

CC ID: 197669
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 2
Required: Yes
Primary Key: Yes
Status: Active
Description:

DLS State Code

General Data Type: VARCHAR2

DLS_COUNTY_CODE

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

County Code.

General Data Type: VARCHAR2

DLS_PORT_CODE

CC ID: 197671
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 3
Required: Yes
Primary Key: Yes
Status: Active
Description:

DLS Port Code.

General Data Type: VARCHAR2

PORT_LABEL

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

Port Name.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 24496
GUID: gov.noaa.nmfs.inport:24496
Metadata Record Created By: Allison Shideler
Metadata Record Created: 2015-04-20 08:47+0000
Metadata Record Last Modified By: Lee M Weinberger
Metadata Record Last Modified: 2021-05-06 22:24+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-05-07