Touchstone 4.0 Database Documentation
tAnalysisExposureView Table
When the analysis target is an exposure view, this table stores information about the analyzed exposure view and any filters used to create it.
Creation Date5/31/2016 9:45 AM
Text File GroupPRIMARY
System Object
Published for Replication
Data Space Used0.00 KB
Index Space Used0.00 KB
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key ResultSID

Unique system-generated sequential identifier for the results record.

For a complete list of records, see tAnalysisResult Table.

Primary Key ExposureViewSID

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

For a complete list of records, see tExposureView Table.

 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  

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

  • 1 = Yes (contract)
  • 0 = No (location)
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

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.