Touchstone 2022 Database Reference
tDQCountry Table
AIRReference Database : tDQCountry Table
Description

Stores country (and FIPS) information for use during a Data Quality analysis.

Properties
Creation Date5/16/2011 4:25 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows19
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key DQCountryCode

Code that represents the country during a Data Quality analysis.

  • AT = Austria (26)
  • BE = Belgium (2)
  • CH = Switzerland (10)
  • CZ = Czech Republic (77)
  • DE = Germany (5)
  • DK = Denmark (3)
  • EE = Estonia (84)
  • FI = Finland (89)
  • FR = France (4)
  • GB = United Kingdom (11)
  • IE = Ireland (27)
  • LT = Lithuania (131)
  • LU = Luxembourg (6)
  • LV = Latvia (127)
  • NL = Netherlands (7)
  • NO = Norway (8)
  • PL = Poland (171)
  • SE = Sweden (9)
  • US = United States (1)
varchar15   
 DQCountryName

Name of the country.

Corresponds to the code in DQCountryCode.

varchar255   
 DQCountryFips

Federal Information Processing Standards (FIPS) value for the country.

Corresponds to the code in DQCountryCode.

int4   
 DescriptionDescription of the country.varchar1024  
See Also

Related Objects

AIRReference Database

 

 

Verisk Analytics Client Confidential

© 2022. AIR Worldwide is now Extreme Event Solutions. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact Verisk Analytics with questions or comments.