Touchstone 4.0 Database Documentation
CITYZIP5 Table
Description
Stores information regarding the 5-digit ZIP Codes associated with a city.
Properties
Creation Date12/14/2006 4:57 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows41260
Data Space Used1,520.00 KB
Index Space Used2,280.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key STATECDCode that represents the state (area) where the 5-digit ZIP Code resides.Char2   
Primary Key AIRCOUNTYIDCode that represents the county (subarea) where the 5-digit ZIP Code resides.Integer4   
Primary Key CITYName of the city where the 5-digit ZIP Code resides.VarChar40   
Primary Key ZIP55-digit ZIP Code.Char5   
 ISPREFERRED

Identifies whether the 5-digit ZIP
Code is preferred over the 9-digit ZIP Code:

  • Yes = Yes (5-digit code preferred)
  • No = No (9-digit code preferred)
Char1  
Objects that CITYZIP5 depends on
 Database ObjectObject TypeDescriptionDep Level
CITIES tableCITIESTableStores city information.2
STATECOUNTIES tableSTATECOUNTIESTableStores county (subarea) information.3
STATES tableSTATESTableStores state (area) information.4
See Also

Related Objects

AIRAddressServer Database

 

 


AIR Client Confidential

© 2016. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact AIR Worldwide with questions or comments. For database questions. For documentation comments.