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

Summary

Abstract

Table Of Valid State/County Codes

Description

Table Of Valid State/County Codes

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
STATE_CODE
NUMBER
State Code
COUNTY_CODE
NUMBER
County Code
COUNTY_NAME
VARCHAR2
County Name

Child Items

No Child Items for this record.

Contact Information

Point of Contact
David Gloeckner
David.Gloeckner@noaa.gov
305-361-4257

Item Identification

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

Table Of Valid State/County Codes

Notes:

Loaded by batch 1743, 10-17-2007 04:25

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None code tables
None County Codes
None State Codes

Entity Information

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

Table Of Valid State/County Codes

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
STATE_CODE NUMBER State Code
100
COUNTY_CODE NUMBER County Code
100
COUNTY_NAME VARCHAR2 County Name

Attribute Details

STATE_CODE

CC ID: 17447
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

State Code

General Data Type: NUMBER

COUNTY_CODE

CC ID: 17446
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

County Code

General Data Type: NUMBER

COUNTY_NAME

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

County Name

General Data Type: VARCHAR2

Support Roles

Point of Contact

CC ID: 182684
Date Effective From: 2003-01-01
Date Effective To:
Contact (Person): Gloeckner, David
Address: 75 Virginia Beach Drive
Miami, FL 33139
Email Address: David.Gloeckner@noaa.gov
Phone: 305-361-4257
Fax: 305-361-4460

Catalog Details

Catalog Item ID: 5487
GUID: gov.noaa.nmfs.inport:5487
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-10-17 04:25+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-05-06
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-05-06