Touchstone Re 2022 Database Reference
tAnalysisType Table
AIRReference Database : tAnalysisType Table
Description
Stores the analysis types available in the application.
Properties
Creation Date2/16/2011 6:00 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows23
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.

  • AGGR_LOSS = Aggregate Loss
  • 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
  • ECA_TMPLT = Geospatial Analysis Template
  • EXPS = Exposure Summary
  • HAZ = Hazard
  • HAZ_TMPLT = Hazard Template
  • IMPACT = Impact Analysis
  • LGRP = Detailed Loss Group
  • LGRP_MOD = Modified Detailed Loss Group
  • LOSS = Detailed Loss
  • LOSS_MOD = Modified Detailed Loss Analysis
  • LOSS_TMPLT = Detailed Loss Analysis Template
  • PGM_TMPLT = Program aggregate loss analysis template
  • PRT_TMPLT = Portfolio aggregate loss analysis 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  
See Also

Related Objects

AIRReference Database

 

 

Verisk Analytics Client Confidential

© 2022. AIR Worldwide is now Extreme Event Solutions. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact Verisk Analytics with questions or comments.