Touchstone 4.0 Database Documentation
tAnalysisType Table
Description
Stores the various analysis types that can be performed in Touchstone.
Properties
Creation Date2/16/2011 6:00 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows17
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key AnalysisTypeCode

Code that represents the analysis types that can be performed in Touchstone.

  • CATLOSS = CAT Loss Treaty
  • CLSH = Clash
  • CLSH_TMPLT = Clash Template
  • CMPLOSS = Comparative Loss
  • DQ = Data Quality
  • DQ_RPT = Data Quality Reports
  • DQ_TMPLT = Data Quality Template
  • EC = Geospatial
  • EXPS = Exposure Summary
  • HAZ = Hazard
  • HAZ_TMPLT = Hazard Template
  • IMPACT = Impact Analysis
  • LGRP = Detailed Loss Group
  • LOSS = Detailed Loss
  • LOSS_TMPLT = Detailed Loss Template
  • SPTL = Spatial
  • UW_RPT = Underwriting Report
VarChar10   
 AnalysisType

Name of the analysis type.

Corresponds to the code in AnalysisTypeCode.

VarChar40  
 DescriptionDescription of the analysis type.VarChar1024  
Objects that depend on tAnalysisType
 Database ObjectObject TypeDescriptionDep Level
tDQRuleSetType tabletDQRuleSetTypeTable

Stores the primary rule sets that can be applied during a Data Quality analysis.

2
tHazardAttribute tabletHazardAttributeTable

Stores the possible the attributes of a hazard.

2
tIntensityAttribute tabletIntensityAttributeTableStores information about the intensity attributes that may be used during a Hazard analysis.2
tOutputType tabletOutputTypeTable

Stores the possible types of output for each analysis type.

1
tOutputTypeTableXref tabletOutputTypeTableXrefTableSystem reference table used to associate the output type tables during a Loss analysis.2
tResultTemplate tabletResultTemplateTable

Stores the association between output types and the results.

1
tResultTemplateFilterAttributeXRef tabletResultTemplateFilterAttributeXRefTableSystem reference table used to determine the filter attributes that are applied to the results.2
See Also

Related Objects

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