Touchstone 4.0 Database Documentation
tCountry Table
Description
Stores information about the county in regards to whether it is modeled or an offshore location.
Properties
Creation Date10/24/2013 4:30 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows280
Data Space Used16.00 KB
Index Space Used16.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key CountryCode

ISO 2-character code for the country. Modeled countries are indicated in bold.

For a complete list of county aliases, see TblCountryAlias Table.

  • AD = Andorra
  • AE = United Arab Emirates
  • AF = Afghanistan
  • AG = Antigua and Barbuda
  • AI = Anguilla
  • AL = Albania
  • ALO = Alaska Offshore
  • AM = Armenia
  • AN = Netherlands Antilles
  • ANO = Angola Offshore
  • AO = Angola
  • AQ = Antarctica
  • AR = Argentina
  • ARO = Arctic Offshore
  • AS = American Samoa
  • AT = Austria
  • AU = Australia
  • AUO = Australasia Offshore
  • AW = Aruba
  • AX = Åland Islands
  • AZ = Azerbaijan
  • BA = Bosnia and Herzegovina
  • BB = Barbados
  • BCO = Bay of Campeche Offshore
  • BD = Bangladesh
  • BE = Belgium
  • BF = Burkina Faso
  • BG = Bulgaria
  • BH = Bahrain
  • BI = Burundi
  • BJ = Benin
  • BL = Saint Barthélemy
  • BM = Bermuda
  • BN = Brunei
  • BO = Bolivia
  • BR = Brazil
  • BRO = Brazil Offshore
  • BS = Bahamas
  • BSO = Baltic Sea Offshore
  • BT = Bhutan
  • BV = Bouvet Island
  • BW = Botswana
  • BY = Belarus
  • BZ = Belize
  • CA = Canada
  • CAO = Canada Offshore
  • CAS = Caspian Sea
  • CC = Cocos Islands
  • CD = Congo  Republic Of
  • CF = Central African Republic
  • CG = Congo
  • CH = Switzerland
  • CI = Côte D'Ivoire
  • CK = Cook Islands
  • CL = Chile
  • CM = Cameroon
  • CN = China
  • CNO = China Offshore
  • CO = Colombia
  • CR = Costa Rica
  • CU = Cuba
  • CV = Cape Verde
  • CX = Christmas Island
  • CY = Cyprus
  • CZ = Czech Republic
  • DE = Germany
  • DJ = Djibouti
  • DK = Denmark
  • DM = Dominica
  • DO = Dominican Republic
  • DZ = Algeria
  • AO = East Africa Offshore
  • EC = Ecuador
  • EE = Estonia
  • EG = Egypt
  • EGO = Egypt Offshore
  • EH = Western Sahara
  • ER = Eritrea
  • ES = Spain
  • ET = Ethiopia
  • FAO = Far East Offshore
  • FI = Finland
  • FJ = Fiji
  • FK = Falkland Islands
  • FM = Micronesia
  • FO = Faeroe Islands
  • FR = France
  • GA = Gabon
  • GAO = Gabon Offshore
  • GB = United Kingdom
  • GD = Grenada
  • GE = Georgia
  • GF = French Guiana
  • GG = Guernsey
  • GH = Ghana
  • GI = Gibraltar
  • GL = Greenland
  • GM = Gambia
  • GN = Guinea
  • GOM = Gulf Of Mexico
  • GP =  Guadeloupe
  • GQ = Equatorial Guinea
  • GR =  Greece
  • GS = South Georgia and the South Sandwich Islands
  • GT = Guatemala
  • GU = Guam
  • GW = Guinea-bissau
  • GY = Guyana
  • HK = Hong Kong
  • HM = Heard Island and Mcdonald Islands
  • HN = Honduras
  • HR =  Croatia
  • HT = Haiti
  • HU = Hungary
  • ID = Indonesia
  • IE =  Ireland
  • IL = Israel
  • IM = Isle Of Man
  • IN = India
  • INO = Indian Subcontinent Offshore
  • IO = British Indian Ocean Territory
  • IQ = Iraq
  • IR = Iran
  • IS = Iceland
  • IT = Italy
  • JE =  Jersey
  • JKO = Japan/Korea Offshore
  • JM = Jamaica
  • JO = Jordan
  • JP =  Japan
  • KE = Kenya
  • KG = Kyrgyzstan
  • KH =  Cambodia
  • KI =  Kiribati
  • KM = Comoros
  • KN =  Saint Kitts and Nevis
  • KP = Korea
  • KR = South Korea
  • KW =  Kuwait
  • KY =  Cayman Islands
  • KZ = Kazakhstan
  • LA = Lao People's Democratic Republic
  • LB = Lebanon
  • LC = Saint Lucia
  • LI = Liechtenstein
  • LK  = Sri Lanka
  • LR =  Liberia
  • LS = Lesotho
  • LT =  Lithuania
  • LU =  Luxembourg
  • LV =  Latvia
  • LY = Libya
  • MA =  Morocco
  • MC = Monaco
  • MD = Moldova
  • ME = Montenegro
  • MEO = Mediterranean Offshore
  • MF = St. Martin
  • MG = Madagascar
  • MH =  Marshall Islands
  • MIO =  Middle East Offshore
  • MK =  Macedonia
  • ML = Mali
  • MM = Myanmar
  • MN = Mongolia
  • MO = Macau
  • MP = Saipan
  • MQ =  Martinique
  • MR = Mauritania
  • MS =  Montserrat
  • MT = Malta
  • MU = Mauritius
  • MV =  Maldives
  • MW = Malawi
  • MX =  Mexico
  • MXO =  Mexico Offshore
  • MY =  Malaysia
  • MZ = Mozambique
  • NA = Namibia
  • NC =  New Caledonia
  • NE =  Niger
  • NF =  Norfolk Island
  • NG = Nigeria
  • NI = Nicaragua
  • NIO =  Nigeria Offshore
  • NL =  Netherlands
  • NO = Norway
  • NOO = Norway Offshore
  • NP = Nepal
  • NR = Nauru
  • NSO =  North Sea Offshore
  • NU = Niue
  • NZ = New Zealand
  • OM = Oman
  • PA = Panama
  • PE = Peru
  • PF = French Polynesia
  • PG = Papua New Guinea
  • PH = Philippines
  • PK = Pakistan
  • PL = Poland
  • PM = Saint Pierre and Miquelon
  • PN = Pitcairn
  • PR = Puerto Rico
  • PS =  Palestinian Territories
  • PT = Portugal
  • PW = Palau
  • PY = Paraguay
  • QA = Qatar
  • RE = Reunion
  • RO = Romania
  • RS = Serbia
  • RU = Russian Federation
  • RUO = Russia Offshore
  • RW = Rwanda
  • SA = Saudi Arabia
  • SAO = South America Offshore
  • SB = Solomon Islands
  • SC = Seychelles
  • SD = Sudan
  • SE = Sweden
  • SEO = Sweden Offshore
  • SG = Singapore
  • SH = Saint Helena
  • SI = Slovenia
  • SJ = Svalbard and Jan Mayen
  • SK = Slovakia
  • SL = Sierra Leone
  • SM = San Marino
  • SN = Senegal
  • SO = Somalia
  • SR = Suriname
  • SSO = South Asia Offshore
  • ST = Sao Tome and Principe
  • SV = El Salvador
  • SX = St. Maarten
  • SY = Syrian Arab Republic
  • SZ = Swaziland
  • TC = Turks and Caicos Islands
  • TD = Chad
  • TF = French Southern Territories
  • TG = Togo
  • TH = Thailand
  • TJ = Tajikistan
  • TK = Tokelau
  • TL = Timor-leste
  • TM = Turkmenistan
  • TN = Tunisia
  • TO = Tonga
  • TR = Turkey
  • TT = Trinidad and Tobago
  • TTO = Trinidad and Tobago Offshore
  • TV = Tuvalu
  • TW = Taiwan
  • TZ = Tanzania
  • UA = Ukraine
  • UG = Uganda
  • UKO = United Kingdom Offshore
  • UM = United States Minor Outlying Islands
  • US = United States
  • UY = Uruguay
  • UZ = Uzbekistan
  • VA = Vatican City
  • VC = Saint Vincent and the Grenadines
  • VE = Venezuela
  • VEO = Venezuela Offshore
  • VG = Virgin Islands British
  • VI = Virgin Islands (US)
  • VN = Vietnam
  • VNO = Vietnam Offshore
  • VU = Vanuatu
  • WAO = West Africa Offshore
  • WF = Wallis and Futuna
  • WS = Samoa
  • WUO = West US/California Offshore
  • YE = Yemen
  • YT Mayotte
  • ZA = South Africa
  • ZM = Zambia
  • ZW = Zimbabwe 
VarChar15   
 DescriptionDescription of the county.VarChar1024  
 IsModeled

Indicates whether the country is modeled.

  • 1 = Yes (modeled)
  • 0 = No (not modeled)
Boolean1   
 IsOffshore

Indicates whether the country is an offshore location.

  • 1 = Yes (offshore)
  • 0 = No (not offshore)
Boolean1   
Objects that depend on tCountry
 Database ObjectObject TypeDescriptionDep Level
tAIRConstOccRegionCountryXref tabletAIRConstOccRegionCountryXrefTable

System reference table used to determine the construction and occupancy class types that are associated with a region and country.

1
tAIROccConSpecial tabletAIROccConSpecialTableUsed to map Construction Occupancy Region codes to AIR Occupancy and Construction codes.1
tCLFIndustryLOB tabletCLFIndustryLOBTableStores the Industry Line of Business data; its order in the CLF file is 1) country, 2) peril, and 3) INF version.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.