Touchstone 4.0 Database Documentation
tDQ_AMB_25K Table
Description

Stores information for A.M. Best reports, specifically the "Most Frequency Observed Value" by personal property, commercial property, and worker's compensation.

See tDQ_AMB_25I Table for the A.M. Best reports of TIV percent, value, and count data of known attributes by personal property, commercial property, and worker's compensation.

Properties
Creation Date5/31/2016 9:45 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.

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  
 Category

Type of category value:

  • Construction
  • Occupancy
  • Year Built
  • Building Height
VarChar50  
 MFOVPersonalDescription of the specified Occupancy or Construction for residential policies.VarChar50  
 MFOVCommercialDescription of the specified Occupancy or Construction for commercial policies.VarChar50  
 MFOVWCDescription of the specified Occupancy or Construction for workers' compensation policies.VarChar50  
 PercentMFOVPersonalPercent of the replacement value in regards to specified Occupancy or Construction for personal policies.Double9  
 PercentMFOVCommercialPercent of the replacement value in regards to specified Occupancy or Construction for commercial policies.Double9  
 PercentMFOVWCPercent of the replacement value in regards to specified Occupancy or Construction for worker’s compensation policies.Double9  
 RVMFOVPersonalTotal replacement value in regards to specified Occupancy or Construction for worker’s compensation policies.Double9  
 RVMFOVCommercialTotal replacement value in regards to specified Occupancy or Construction for commercial policies.Double9  
 RVMFOVWCTotal replacement value in regards to specified Occupancy or Construction for worker’s compensation policies.Double9  
 LocationCountMFOVPersonalLocation count in regards to specified Occupancy or Construction for personal policies.Integer4  
 LocationCountMFOVCommercialLocation count in regards to specified Occupancy or Construction for commercial policies.Integer4  
 LocationCountMFOVWCLocation count in regards to specified Occupancy or Construction for worker’s compensation policies.Integer4  
 Attribute_183Reserved for future use.Char10  
See Also

Related Objects

AIRResult
Locating Results for a Specific Analysis

 

 


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.