Touchstone 4.0 Database Documentation
tAnalysisExposureView Table
Description
When the analysis target is an exposure view, this table stores information about the analyzed exposure view and any filters used to create it.
Properties
Creation Date5/31/2016 9:45 AM
File GroupPRIMARY
Text File GroupPRIMARY
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 ExposureViewSID

Unique system-generated sequential identifier for the exposure view record.

For a complete list of records, see tExposureView Table.

Integer4   
 ExposureViewNameName of the exposure view.VarChar255   
 DescriptionUser-provided description of the exposure view.VarChar4000  
 SQLStringSQL representation of the exposure view filter.LongVarChar16  
 ExpressionXML string that defines the exposure view filter. Used internally by Touchstone.Xml16  
 IsCommercial

Indicates whether the filter needs to e applied at the contract level (vs. location level) for commercial contracts.

  • 1 = Yes (contract)
  • 0 = No (location)
Boolean1  
Objects that depend on tAnalysisExposureView
 Database ObjectObject TypeDescriptionDep Level
tAnalysisExposureViewDefinition tabletAnalysisExposureViewDefinitionTableWhen the analysis target is an exposure view, this table defines the exposure set(s) included in the exposure view.2
Objects that tAnalysisExposureView depends on
 Database ObjectObject TypeDescriptionDep Level
tAnalysisResult tabletAnalysisResultTableContains general information about the analyses that produced the results. The table contains one row for each analysis in the database, regardless of the analysis type (Loss, Loss Grouping, Catastrophe Excess of Loss, or Marginal Impact).1
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.