Touchstone 2022 Database Reference
tAnalysisReinsAppliesToGeo Table
AIRResult : tAnalysisReinsAppliesToGeo Table
Description
Stores information about the geographic areas to which reinsurance treaties are applied.
Properties
Creation Date4/11/2022 5:46 PM
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.

int4   
Primary Key ReinsuranceSID

Unique system-generated sequential identifier for the reinsurance record.

For a complete list of records, see tReinsurance Table.

int4   
Primary Key ReinsAppliesToGeoSID

Unique system-generated sequential identifier for the geography filter record to which the reinsurance applies.

For a complete list of records, see tReinsAppliesToGeo Table.

int4   
 SQLStringSQL representation of the geography filter.varchar16   
 ExpressionXML string that defines the geography filter. Used internally by Touchstone.xml0   
Objects that tAnalysisReinsAppliesToGeo depends on
 Database ObjectObject TypeDescriptionDep Level
tAnalysisReinsurance tabletAnalysisReinsuranceTableStores information about any reinsurance treaties applied during analyses.1
tAnalysisResult tabletAnalysisResultTable

Contains general information about the analyses that produced the results.

The table includes one row for each analysis in the database, regardless of the analysis type (Loss, Loss Grouping, Catastrophe Excess of Loss, or Marginal Impact).

2
See Also

Related Objects

AIRResult
Locating Results for a Specific Analysis

 

 

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.