Search Help Show/Hide Menu
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