Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Holds the DLS county codes.

Notes:

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

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None code table
None county codes

Entity Information

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

Holds the DLS county codes.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
DLS_COUNTY_CODE VARCHAR2 DLS County Code.
100
DLS_STATE_CODE VARCHAR2 State Code for the county code.
100
COUNTY_LABEL VARCHAR2 Name of the county that the code represents.
100
NMFS_COUNTY_CODE VARCHAR2 NMFS county code.

Attribute Details

DLS_COUNTY_CODE

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

DLS County Code.

General Data Type: VARCHAR2

DLS_STATE_CODE

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

State Code for the county code.

General Data Type: VARCHAR2
Foreign Key Relations:

DLS.DLS_STATE_CODES

COUNTY_LABEL

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

Name of the county that the code represents.

General Data Type: VARCHAR2

NMFS_COUNTY_CODE

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

NMFS county code.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 24489
GUID: gov.noaa.nmfs.inport:24489
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