Table: ZIP_CODE_DATA
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:7331 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
comprehensive zip code table, for cross referencing purpose
Descriptioncomprehensive 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |