Table: ZIP_CODE_DATA
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:7331 | Updated: August 9, 2022 | Published / External
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
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 |