Touchstone 4.0 Database Documentation
tIndustryAggregatePercentage Table

A scoring table that stores pre-calculated aggregate industry data. This table is used during Data Quality - Scoring analysis to compute the Data Quality Score and Overall Risk Score.

Creation Date1/24/2014 5:12 PM
Text File Group
System Object
Published for Replication
Data Space Used40,048.00 KB
Index Space Used9,088.00 KB
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula

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.

 CountryName of the country.VarChar60  

Code that represents the area (state).

For a complete list of codes, see tGeography Table.   

 AreaName of the area (state).VarChar60  

Code that represents the area (county).

For a complete list of codes, see tGeography Table

 SubAreaName of the subarea (county).VarChar60  

ISO 3-character code for the currency.

For a complete list of codes, see tCurrency Table.

 LOBIDIdentifier for the Line of Business.SmallInt2   

Name of the Line of Business

Corresponds to LOBID.

 IndTypeType of industry data.VarChar12   
 DetailIDIdentifier for the detailed.SmallInt2   

Name of the detail.

Corresponds to DetailID.

 IndPctNumRisksPercent of risks that are included in the Detail classification.Double9   
 IndPctCoveragePercent of industry coverage for that Detail classification.Double9   
 IndNumRisksDetailNumber of risks that are included in the Detail classification.Integer4  
 IndCoverageDetailIndustry replacement value for coverage detail.Double9  
 IndNumRisksTotal number of risks.Integer4  
 IndCoverageIndustry replacement value for Coverage A.Double9  
 IndCoverageCIndustry replacement value for Coverage C.Double9  
 IndCoverageDIndustry replacement value for Coverage D.Double9  
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.