Touchstone 4.0 Database Documentation
tDQ_AMB_25I Table
Description

Stores information for A.M. Best reports, specificallyTIV percent, value, and count data of known attributes by personal property, commercial property, and worker's compensation.

See  tDQ_AMB_25K Table for the A.M. Best reports of "Most Frequency Observed Value" by personal property, commercial property, and worker's compensation.

Properties
Creation Date5/31/2016 9:46 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows0
Data Space Used0.00 KB
Index Space Used0.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key ResultSID

Unique system-generated sequential identifier for the results record.

For a complete list of records, see tAnalysisResult Table.

Integer4   
Primary Key OutputTypeCode

Unique system-generated sequential identifier for the category record.

For a complete list of codes, see tOutputType Table.

VarChar10   
Primary Key CategorySID

Unique system-generated sequential identifier for the category record.

Unique system-generated sequential identifier for the category record.

Integer4   
Primary Key PerilSetCode

Numeric code for the single peril or set of perils.

For a complete list of codes, see tPerilSet Table.

Integer4   
 PerilSet

Name corresponds to the PerilSetCode value.

VarChar255  
 CategoryGroupDescription of the Category value. VarChar255  
 Category

Type of category value:

  • Construction
  • Occupancy
  • Year Built
  • Building Height
VarChar50  
 PercentPersonalPercent of total replacement value for residential policies.Double9  
 PercentCommercialPercent of total replacement value for commercial policies.Double9  
 PercentWCPercent of total replacement value for workers' compensation policies.Double9  
 RVPersonalTotal replacement value for residential policies.Double9  
 RVCommercialTotal replacement value for commercial policies.Double9  
 RVWCTotal replacement value for workers' compensation policies.Double9  
 LocCountPersonalLocation count for residential policies.Integer4  
 LocCountCommercialLocation count for commercial policies.Integer4  
 LocCountWCLocation count for workers' compensation policies.Integer4  
See Also

Related Objects

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