Touchstone 4.0 Database Documentation
tIndustryAggregate 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
Rows605457
Data Space Used98,952.00 KB
Index Space Used376.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key 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  
Primary Key StateID

Code that represents the area (state).

For a complete list of codes, see tGeography Table.   

VarChar15   
 STATEName of the area (state).VarChar60  
Primary Key CountyID

Code that represents the area (county).

For a complete list of codes, see tGeography Table

VarChar15   
 CountyName of the subarea (county).VarChar60  
 Zip

Postal code.

For a complete list of codes, see tGeography Table.

VarChar9  
 Currency

ISO 3-character code for the currency.

For a complete list of codes, see tCurrency Table.

Char3  
Primary Key LOBIDIdentifier for the Line of Business.SmallInt2   
 LOB

Name of the Line of Business

Corresponds to LOBID.

VarChar60  
Primary Key OccCodeCode that represents the occupancy type.SmallInt2   
 Occupancy

Name of the occupancy type.

Corresponds to OccCode.

VarChar60  
Primary Key ConsCodeCode that represents the construction type.SmallInt2   
 Construction

Name of the construction type.

Corresponds to ConsCode.

VarChar60  
 NumRisksTotal number of risks.Integer4  
 LimitCovABIndustry aggregate limit of all risks for Coverage A and B combined.Double9  
 LimitCovCIndustry aggregate limit of all risks for Coverage C.Double9  
 LimitCovDIndustry aggregate limit of all risks for Coverage D.Double9  
 RepCovDIndustry replacement value for Coverage DDouble9  
 EmpCountAverage employee count for all risks.Double9  
 GeographySID

Unique system-generated sequential identifier for the geographic record.

For a complete list of records, see tGeography Table.

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