Touchstone 4.0 Database Documentation
tReinsAppliesToGeo Table
Description
Stores information regarding the geographic/area filter applied for the reinsurance treaty. Using reinsurance treaty geographic filter is optional.
Properties
Creation Date5/31/2016 9:46 AM
File GroupPRIMARY
Text File GroupPRIMARY
System Object
Published for Replication
Rows5
Data Space Used8.00 KB
Index Space Used40.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key ReinsAppliesToGeoSIDUnique system-generated sequential identifier for the record that associates the reinsurance layer and geographic filter.Integer4   
 ReinsuranceSID

Unique system-generated sequential identifier for the reinsurance record.

For a complete list of records, see tReinsurance Table.

Integer4   
 SQLStringSQL representation of the geographic filter.LongVarChar16   
 ExpressionXML expression of the geographic filter. Used internally by Touchstone.Xml16   
Objects that tReinsAppliesToGeo depends on
 Database ObjectObject TypeDescriptionDep Level
tProgram tabletProgramTableStores information regarding the collection of reinsurance contracts. A reinsurance program includes one or more related reinsurance contracts. The reinsurance applies to locations or layers, not to contracts.1
tReinsurance tabletReinsuranceTable

Stores information regarding the reinsurance treaty.

1
See Also

Related Objects

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