Touchstone 4.0 Database Documentation
tReinsAppliesToExp Table
Description

Contains information about Facultative certificates and Surplus Share treaties that are applied to exposures such as location, contract, and layer.

Properties
Creation Date5/31/2016 9:46 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows0
Data Space Used0.00 KB
Index Space Used0.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key ReinsAppliesToExpSID

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

Integer4   
 ExposureSetSID

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

For a complete list of records, see tExposureSet Table.

Integer4   
 ReinsuranceIDUnique user-defined identifier for the reinsurance treaty.VarChar100   
 ReinsuranceTypeCode

Code that represents they type of reinsurance. 

For a complete list of codes, see tReinsuranceType Table.

VarChar10   
 PerilSetCode

Numeric code for the single peril or set of perils.

For a complete list of codes, see tPerilSet Table.

Integer4   
 CedantNameName of the cedant.VarChar60  
 ReinsurerNameName of the reinsurer.VarChar60  
 ReinsTargetTypeCode

Code that indicates the type of exposure to which the reinsurance treaty applies. 

For a complete list of codes, see tReinsTargetType Table.

VarChar10   
 ReinsTargetSID

Unique system-generated sequential identifier for the reinsurance target record.

For a complete list of records, see dbo.tReinsurance Table.

Integer4   
 AttachmentPointValue of the attachment point. Any values that are less than or equal to 1 will be interpreted as percentages (e.g., 0.12 as 12%). Double9   
 GrossLimitGross limit. Any values that are less than or equal to 1 will be interpreted as percentages (e.g., 0.12 as 12%). Double9  
 CededAmountCeded amount expressed as an amount of percentage. Note that this value is provided on the user interface as a whole number percentage (e.g. 30.00) but is stored in the database as a decimal (e.g. 0.3).Double9   
 CurrencyCode

ISO 3-character code for the currency.

For a complete list of codes, see tCurrency Table.

Char3   
 RowVersionUsed for version stamping.Binary8   
Objects that tReinsAppliesToExp depends on
 Database ObjectObject TypeDescriptionDep Level
tExposureSet tabletExposureSetTableContains exposure set information. An exposure set is a collection of contracts, locations, and other related information.3
See Also

Related Objects

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