Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Fisheries Statistics Division > FISHERIES MONITORING > Standardization of permits > Dealer Management System > Standardization Of Dealers >

Table: ZIP_CODE_DATA

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:7331  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

comprehensive zip code table, for cross referencing purpose

Description

comprehensive zip code table, for cross referencing purpose

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
CDC
VARCHAR2 		Coded Value
ZIP_CODE
VARCHAR2 		five digit zip code
CITY_STATE_KEY
VARCHAR2 		Control key For City State Combination
ZIP_CLASS_CODE
VARCHAR2 		Zip Code Class Code
CITY_STATE_NAME
VARCHAR2 		city name
CITY_STATE_NAME_ABBREV
VARCHAR2 		abbreviated city state name
CTYST_NAME_FACILITY_CODE
VARCHAR2 		County State Name Facility Code
CTYST_MAILING_NAME_IND
VARCHAR2 		County State Mailing Name Indicator
PREFD_LAST_LINE_CTYST_KEY
VARCHAR2 		Preffered Last Line County State Key
PREFD_LAST_LINE_CTYST_NAM
VARCHAR2 		Preffered Last Line County State Name
CTYST_DELVVV_IND
VARCHAR2 		Control Column
CARR_RTE_RATE_SORT_IND
VARCHAR2 		Sorting Indicator
UNIQUE_ZIP_NAME_INC
VARCHAR2 		Control Column (often blank)
FINANCE_NO
VARCHAR2 		Finance Number
STATE_ABBREV
VARCHAR2 		state abbreviation
COUNTY_NO
VARCHAR2 		fips county code
COUNTY_NAME
VARCHAR2 		county name
LOAD_DATE
DATE 		FIN specific load date

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (SEFSC) for inquiries on this record.

Item Identification

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

comprehensive zip code table, for cross referencing purpose
Notes:

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

Entity Information

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

comprehensive zip code table, for cross referencing purpose

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 CDC VARCHAR2 Coded Value
100
 ZIP_CODE VARCHAR2 five digit zip code
100
 CITY_STATE_KEY VARCHAR2 Control key For City State Combination
100
 ZIP_CLASS_CODE VARCHAR2 Zip Code Class Code
100
 CITY_STATE_NAME VARCHAR2 city name
100
 CITY_STATE_NAME_ABBREV VARCHAR2 abbreviated city state name
100
 CTYST_NAME_FACILITY_CODE VARCHAR2 County State Name Facility Code
100
 CTYST_MAILING_NAME_IND VARCHAR2 County State Mailing Name Indicator
100
 PREFD_LAST_LINE_CTYST_KEY VARCHAR2 Preffered Last Line County State Key
100
 PREFD_LAST_LINE_CTYST_NAM VARCHAR2 Preffered Last Line County State Name
100
 CTYST_DELVVV_IND VARCHAR2 Control Column
100
 CARR_RTE_RATE_SORT_IND VARCHAR2 Sorting Indicator
100
 UNIQUE_ZIP_NAME_INC VARCHAR2 Control Column (often blank)
100
 FINANCE_NO VARCHAR2 Finance Number
100
 STATE_ABBREV VARCHAR2 state abbreviation
100
 COUNTY_NO VARCHAR2 fips county code
100
 COUNTY_NAME VARCHAR2 county name
100
 LOAD_DATE DATE FIN specific load date

Attribute Details

CDC

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

Coded Value
General Data Type: VARCHAR2

ZIP_CODE

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

five digit zip code
General Data Type: VARCHAR2

CITY_STATE_KEY

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

Control key For City State Combination
General Data Type: VARCHAR2

ZIP_CLASS_CODE

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

Zip Code Class Code
General Data Type: VARCHAR2

CITY_STATE_NAME

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

city name
General Data Type: VARCHAR2

CITY_STATE_NAME_ABBREV

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

abbreviated city state name
General Data Type: VARCHAR2

CTYST_NAME_FACILITY_CODE

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

County State Name Facility Code
General Data Type: VARCHAR2

CTYST_MAILING_NAME_IND

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

County State Mailing Name Indicator
General Data Type: VARCHAR2

PREFD_LAST_LINE_CTYST_KEY

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

Preffered Last Line County State Key
General Data Type: VARCHAR2

PREFD_LAST_LINE_CTYST_NAM

CC ID: 28214
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 28
Required: No
Primary Key: No
Status: Active
Description:

Preffered Last Line County State Name
General Data Type: VARCHAR2

CTYST_DELVVV_IND

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

Control Column
General Data Type: VARCHAR2

CARR_RTE_RATE_SORT_IND

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

Sorting Indicator
General Data Type: VARCHAR2

UNIQUE_ZIP_NAME_INC

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

Control Column (often blank)
General Data Type: VARCHAR2

FINANCE_NO

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

Finance Number
General Data Type: VARCHAR2

STATE_ABBREV

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

state abbreviation
General Data Type: VARCHAR2

COUNTY_NO

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

fips county code
General Data Type: VARCHAR2

COUNTY_NAME

CC ID: 28221
Seq. Order: 17
Data Storage Type: VARCHAR2
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

county name
General Data Type: VARCHAR2

LOAD_DATE

CC ID: 28222
Seq. Order: 18
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

FIN specific load date
General Data Type: DATE

Catalog Details

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