Slide Menu
Search Help Show/Hide Menu

Item Identification

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

state/county cross reference table

Notes:

Loaded by batch 2163, 03-26-2008 16:04

Entity Information

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

state/county cross reference table

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
STATE_ABRV VARCHAR2 state abbreviation
100
STATE_NAME VARCHAR2 state name
100
COUNTY_NAME VARCHAR2 county name
100
STATE VARCHAR2 fips state code
100
COUNTY VARCHAR2 fips county code
100
NMFS_STATE VARCHAR2 nmfs state code
100
NMFS_COUNTY VARCHAR2 nmfs county code
100
REGION VARCHAR2 region code

Attribute Details

STATE_ABRV

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

state abbreviation

General Data Type: VARCHAR2

STATE_NAME

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

state name

General Data Type: VARCHAR2

COUNTY_NAME

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

county name

General Data Type: VARCHAR2

STATE

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

fips state code

General Data Type: VARCHAR2

COUNTY

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

fips county code

General Data Type: VARCHAR2

NMFS_STATE

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

nmfs state code

General Data Type: VARCHAR2

NMFS_COUNTY

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

nmfs county code

General Data Type: VARCHAR2

REGION

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

region code

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 7302
GUID: gov.noaa.nmfs.inport:7302
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2008-03-26 16:04+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