Touchstone 4.0 Database Documentation
tIndustryAggregatePercentage Table
Description

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.

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

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.

SmallInt2   
 CountryName of the country.VarChar60  
 AreaLevel2

Code that represents the area (state).

For a complete list of codes, see tGeography Table.   

VarChar15   
 AreaName of the area (state).VarChar60  
 AreaLevel3

Code that represents the area (county).

For a complete list of codes, see tGeography Table

VarChar15   
 SubAreaName of the subarea (county).VarChar60  
 Currency

ISO 3-character code for the currency.

For a complete list of codes, see tCurrency Table.

Char3  
 LOBIDIdentifier for the Line of Business.SmallInt2   
 LOB

Name of the Line of Business

Corresponds to LOBID.

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

Name of the detail.

Corresponds to DetailID.

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