Touchstone 4.0 Database Documentation
tCountyMaxStats_TS Table
Description

A scoring table that consists of a pre-calculated data matrix. This table contains, for each county, the modeled loss cost for each possible combination of primary property characteristics (construction, occupancy, year built, height, and geocode location). 

This table is used during Data Quality - Scoring analysis to compute the Data Quality Score and Overall Risk Score.

Properties
Creation Date4/19/2012 1:42 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows2255760
Data Space Used272,576.00 KB
Index Space Used2,064.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
 CountyScoringSID

Unique system-generated sequential identifier for the scoring record.

BigInt8   
 CountryCode

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

Currently, Touchstone only supports scoring for the United States, so this value is always 1.

Integer4  
 StateCode

Code that represents the area (state).

For a complete list of codes, see tGeography Table.   

Integer4  
 CountyCode

Code that represents the area (county).

For a complete list of codes, see tGeography Table

Integer4  
 OccCat

Categorization for the typical occupancy type in the area.

VarChar29  
 ConcCat

Categorization for the typical construction type in the area.

VarChar11  
 YearBuilt

Average year the exposures in the area were built.

Integer4  
 Height

Average height of the exposures in the area.

Integer4  
 GeoMeanMean for a region, calculated using the values for OccCat, ConcCat, YearBuilt, and Height.Double9  
 GeoStdDevStandard deviation for a region, calculated using the values for OccCat, ConcCat, YearBuilt, and Height.Double9  
 AttribMeanAttribute mean for the county, calculated using each of the values for OccCat, ConcCat, YearBuilt, and Height.Double9  
 AttribStdDevAttribute standard deviation for the county, calculated using each of the values for OccCat, ConcCat, YearBuilt, and Height.Double9  
 GeoMultiplierMultiplier for the region.Double9  
 AttribMultiplierMultiplier for the attribute.Double9  
 Peril

Numeric code for the single peril or set of perils.

For a complete list of codes, see tPerilSet Table.

Char2  
See Also

Related Objects

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