Slide Menu
Search Help Show/Hide Menu

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: 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