Touchstone 4.0 Database Documentation
TblAreaScheme Table
Description
Stores the internal scheme definitions.
Properties
Creation Date9/8/2004 2:11 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows55
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key tuidSchemeIdentifier for the area scheme.SmallInt2   
 strType

Type of area scheme.

  • 0 = None
  • 1 = FIPS, County
  • 2 = FIPS, State
  • 3 = FIPS, County
  • 4 = ZIP3, Zip3
  • 5 = ZIP5, Zip5
  • 6 = ZIP9, Zip9
  • 7 = AMBEST, State
  • 8 = ISO, State
  • 9 = Standard, Province
  • 10 = Standard, FSA
  • 11 = Standard, FSA-LDU
  • 12 = Standard, Prefecture
  • 13 = Standard, PrefectureKu
  • 14 = CRESTA, CRESTA
  • 100 = AIR, Region
  • 101 = AIR, Country
  • 102 = AIR, State
  • 103 = AIR, County
  • 104 = AIR, Zip3
  • 105 = AIR, StateCountyZip5
  • 106 = AIR, Zip5
  • 107 = AIR, StateCountyZip9
  • 109 = AIR, Prefecture
  • 110 = AIR, PrefectureKu
  • 111 = AIR, CRESTA
  • 112 = AIR, Province
  • 113 = AIR, FSA
  • 114 = AIR, FSA-LDU
  • 115 = AIR,CRESTA2
  • 116 = AIR, NUTS1
  • 117 = AIR, NUTS2
  • 118 = AIR, NUTS3
  • 119 = AIR, District
  • 120 = AIR, Parish
  • 121 = AIR, Municipality
  • 122 = AIR, Postal
  • 123 = AIR, Sector
  • 124 = AIR, District
  • 125 = AIR, Parish
  • 126 = AIR, Municipality
  • 127 = AIR, District Postal
  • 128 = AIR, Parish Postal
  • 129 = AIR, Municipality Postal
  • 130 = AIR, Region2
  • 131 = AIR, Region2 District
  • 132 = AIR,CountyPostal
  • 133 = AIR, Region2DistPostal
  • 134 = AIR, ProvincePostal
  • 135 = AIR, Region2Postal
  • 136 = AIR, Province District
  • 137 = AIR, CRESTA 3
  • 138 = AIR, ProvinceCounty
  • 139 = AIR, ProvinceCountyPostal
  • 140 = AIR, State District
VarChar10  
 strNameName of the area scheme.VarChar20   
 strDescDescription of the area scheme.VarChar100  
See Also

Related Objects

AIRGeography 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.