Touchstone 4.0 Database Documentation
tAnalysisReinsAppliesToGeo Table
Description
Stores information about the geographic areas to which reinsurance treaties are applied.
Properties
Creation Date5/31/2016 9:46 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 ReinsuranceSID

Unique system-generated sequential identifier for the reinsurance record.

For a complete list of records, see tReinsurance Table.

Integer4   
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.

Integer4   
 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

AIRExposureSummary Database

 

 


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.