Touchstone 4.0 Database Documentation
tEXPS_ByGeography Table
Description

A support table that contains the unique set of all geographies for anExposure Summary. Reserved for future use.

Properties
Creation Date5/31/2016 9:46 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows0
Data Space Used0.00 KB
Index Space Used0.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key ResultSID

Unique system-generated sequential identifier for the results record.

For a complete list of records, see tAnalysisResult Table.

Integer4   
Primary Key CountryCode

ISO 2-character code for the country in which the location resides. 

For a complete list of codes, see tCountry Table.

VarChar15   
Primary Key CRESTACode

CRESTA code for the location, when applicable.

For a complete list of codes, see tGeography Table.

VarChar15   
Primary Key AreaCode

Area code for the location.

For a complete list of codes, see tGeography Table.

VarChar15   
Primary Key SubareaCode

Subarea code for the location.

For a complete list of codes, see tGeography Table.

VarChar15   
Primary Key PostalCode

Postal code for the location.

For a complete list of codes, see tGeography Table.

VarChar15   
Primary Key Subarea2Code

Area level code at a finer resolution than postal.  This is populated when a country has more than four codes. This field is used by three countries:

  • Mexico: the PostalCode, which refers to the LocalityCode
  • New Zealand: contains CrestaPostalAreaUnit
  • Japan: contains Sonpo codes, which are remapped to a Prefecture, KU, or Yubin.

For a complete list of codes, see tGeography Table.

VarChar15   
 GeographySID

Unique system-generated sequential identifier for the geographic record.

For a complete list of records, see tGeography Table.

Integer4  
 CountryNameName of the country.VarChar255   
 CRESTANameName of the CRESTA, when applicable.VarChar255   
 AreaNameName of the area.VarChar255   
 SubareaNameName of the subarea.VarChar255   
 PostalNameName for the postal code.VarChar255   
 Subarea2NameName for the Subarea2 code.VarChar255   
 Locations

Total number of locations within the designated geography.

BigInt8  
 PercentOfLocations

Number of locations within the designated geography,  expressed as a percent of all the locations.

Single4  
 TotalReplacementValue

Accumulated replacement value for all locations

Double9  
 PercentOfTRV

Total combined replacement value for all locations within the designated Coverage band, expressed as a percent of the total replacement value.

Single4  
 ReplacementValueAAccumulated Coverage A replacement value for all locations within the designated geography.Double9  
 ReplacementValueBAccumulated Coverage B replacement value for all locations within the designated geography.Double9  
 ReplacementValueCAccumulated Coverage C replacement value for all locations within the designated geography.Double9  
 ReplacementValueDAccumulated Coverage D replacement value for all locations within the designated geography.Double9  
 Premium

Combined premiums for all locations within the designated geography.

Double9  
 RiskCount

Total number of risks within the designated geography. May differ from the Location Count value if any of your location records represent aggregate data.

BigInt8  
 Limit1Accumulated Coverage A limit for all locations within the designated geography.Double9  
 Limit2Accumulated Coverage B limit for all locations within the designated geography.Double9  
 Limit3Accumulated Coverage C limit for all locations within the designated geography.Double9  
 Limit4Accumulated Coverage D limit for all locations within the designated geography.Double9  
 Deductible1Accumulated Coverage A deductible amount for all locations within the designated geography.Double9  
 Deductible2Accumulated Coverage B deductible amount for all locations within the designated geography.Double9  
 Deductible3Accumulated Coverage C deductible amount for all locations within the designated geography.Double9  
 Deductible4Accumulated Coverage D deductible amount for all locations within the designated geography.Double9  
See Also

Related Objects

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