Touchstone 4.0 Database Documentation
tAnalysisReinsAppliesToGeo Table
Stores information about the geographic areas to which reinsurance treaties are applied.
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 ReinsuranceSID

Unique system-generated sequential identifier for the reinsurance record.

For a complete list of records, see tReinsurance Table.

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.

 SQLStringSQL representation of the geography filter.LongVarChar16   
 ExpressionXML string that defines the geography filter. Used internally by Touchstone.Xml16   
Objects that tAnalysisReinsAppliesToGeo depends on
 Database ObjectObject TypeDescriptionDep Level
tAnalysisReinsurance tabletAnalysisReinsuranceTableStores information about any reinsurance treaties considered during the analyses.1
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.