Touchstone 4.0 Database Documentation
tScoringMaxStats_TC Table
Description

A scoring table that consists of a pre-calculated data matrix. This table contains, for each postal code, 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:43 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows21810960
Data Space Used3,617,856.00 KB
Index Space Used1,453,640.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
 ScoringSID

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  
 StateNameName of the area (state)VarChar50  
 StateCode

Code that represents the area (state).

For a complete list of codes, see tGeography Table.   

Integer4  
 CountyNameName of the country (subarea)VarChar100  
 CountyCode

Code that represents the area (county).

For a complete list of codes, see tGeography Table

Integer4  
 ZipCode

Postal code.

For a complete list of codes, see tGeography Table.

VarChar9  
 SumsInsured

Average value for total sums insured for the area.

Double9  
 TotRisks

Total number of risks in the area.

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  
 XreffZipCodeReference postal code.VarChar9  
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.