Touchstone 4.0 Database Documentation
tUNICEDE2AreaTag Table
Description

Stores information regarding geographic Area types that can be used in UNICEDE/2. This information is used to enable the use of UNICEDE/2 areas types in Touchstone.

Properties
Creation Date1/10/2012 12:19 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows9
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key AreaTagCode

Code that represents the geographic Area type.

  • 10 = CRESTA
  • 11 = State County
  • 13 = FSA
  • 14 = Internal
  • 15 = Sector
  • 17 = Province County
  • 18 = StateDistrict
  • 20 = Nuts3
  • 27 = L1L2
UnsignedTinyInt1   
 AreaTag

Name of the Area type.

Corresponds to the code in AreaTagCode.

VarChar40  
 Description

Description of the Area type.

VarChar1024  
Objects that depend on tUNICEDE2AreaTag
 Database ObjectObject TypeDescriptionDep Level
tUNICEDE2CountryAreaTagXref tabletUNICEDE2CountryAreaTagXrefTable

System reference table used to identify the CATRADER countries that can be used in UNICEDE/2. This information is used to enable the use of UNICEDE/2 countries codes in Touchstone.

1
See Also

Related Objects

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