Touchstone 4.0 Database Documentation
tReinsurance Table
Description

Stores information regarding the reinsurance treaty.

Properties
Creation Date5/31/2016 9:46 AM
File GroupPRIMARY
Text File GroupPRIMARY
System Object
Published for Replication
Rows9
Data Space Used8.00 KB
Index Space Used40.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key ReinsuranceSIDUnique system-generated sequential identifier for the reinsurance record.Integer4   
 ProgramSID

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

For a complete list of records, see tProgram Table.

Integer4   
 ReinsuranceTypeCode

Code that represents the type of reinsurance.

For a complete list of codes, see tReinsuranceType Table.

VarChar10   
 ReinsuranceID

User-defined identifier for the reinsurance treaty.

VarChar100   
 SubmitStatusCode

Code for the submission status.

For a complete list of codes, see tSubmitStatus Table.

VarChar10   
 PerilSetCode

Numeric code for the single peril or set of perils.

For a complete list of codes, see tPerilSet Table.

Integer4   
 TriggerTypeCode

Code that represents when/how treaty coverage is applied.

For a complete list of codes, see tTriggerType Table.

VarChar10   
 ReinsTargetTypeCode

Code that represents the objects to which the reinsurance treaty is applied.

For a complete list of codes, see tReinsTargetType Table.

VarChar10   
 PreferredExposureTypeCode

Reserved for future use.

Code that represents the preferred exposure type.

For a complete list of codes, see tPreferredExposureType Table.

VarChar10  
 CedantNameName of the primary insurer, which is the insurance company that purchases reinsurance.VarChar60  
 ReinsurerNameName of the insurer or reinsurer who assumes the cedant’s risk under the contract (treaty).VarChar60  
 InceptionDateInception date of the reinsurance treaty.  Also referred to as the Effective FROM Date.VarWChar10   
 ExpirationDateReinsurance treaty expiration date. Also referred to as the Effective TO Date.VarWChar10   
 CurrencyCode

ISO 3-character code for the currency.

For a complete list of codes, see tCurrency Table.

Char3   
 RiskLimitTreaty limit for a single risk or layer.Double9  
 RiskRetentionTreaty retention per single risk, or per layer for policies including layers.Double9  
 OccurrenceLimitMaximum loss that the treaty can occur from each occurrence.Double9  
 OccurrenceRetentionDeductible amount 1. The treaty does not assume losses below the specified value.Double9  
 AggregateLimitMaximum amount payable under reinsurance treaty that provides overall maximum loss limitation.Double9  
 AggregateRetentionAdditional dollar amount or percentage of risk retained by the ceding company under a reinsurance treaty.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   
 PlacedAmountPlaced percentage.Double9  
 IndustryLossMinimumMinimum amount of industry loss.Double9  
 IndustryLossMaximumMaximum amount of industry loss.Double9  
 PortfolioLossMinimumMinimum amount of portfolio loss.Double9  
 PortfolioLossMaximumMaximum amount of portfolio loss.Double9  
 CoinsuranceAmountAmount of co-insurance.Double9   
 PremiumMinimumThe minimum premium paid for coverage of the layer per reinstatement.  This value is not used during analysis.Double9  
 PremiumEstimatedThe estimated premium paid for coverage of the layer per reinstatement.  This value is used when the analysis calculates premiums net-of-estimated losses.Double9  
 LossesPaid

User-provided information regarding losses paid on the account. This value is not used during analysis.

Double9  
 ParticipationNetNet participation amount or percent.Single4  
 ParticipationGrossGross participation amount or percent.Single4  
 LossModificationFactorUser-defined factor used to modify losses.Single4  
 StartingEventNumberEvent number at which the treaty was applied.Integer4  
 ReinstatementThe maximum number of times the risk limit can be reinstated after the application of a loss amount during the coverage period, where “0” represents no reinstatements and “999” represents unlimited reinstatements.UnsignedTinyInt1  
 ReinstProvisionalAmountHandling of reinstatement premium payments based on loss amount (100%, 75%, 50%, or Pro-Rata). The value 100% specifies that the total premium amount (Estimated Premium) is paid for the reinstatement; Pro Rata specifies that the reinstatement premium amount paid is in proportion to the percent of the occurrence limit that is exhausted.Double9  
 ReinstProvisionalTimeHandling of reinstatement premium payments based on time of loss (100%, 75%, 50%, or Pro-Rata). The value 100% specifies that the total premium amount (Estimated Premium) is paid for the reinstatement adjusted only for Reinstatement Provisions by Amount. Pro Rata specifies that the premium amount paid is in proportion to the time remaining on the reinsurance treaty as of the day on which the layer loss occurred.Double9  
 IsMatchLossToLimit

Indicates whether the loss is matched to limits.

  • 1 = Yes (matched)
  • 0 = No (not matched)
Boolean1  
 ReinsAppliesToULOBUser's Lines of Business  filter.LongVarChar16  
 ReinsAppliesToEventXML string that defines the event filter for the treaty.Xml16  
 InuringSequenceNumberInuring order for the reinsurance treaty.SmallInt2  
 DescriptionDescription of the reinsurance treaty.VarChar4000  
 EnteredDateDate and time when the reinsurance treaty was created.DBTimeStamp4 
(getutcdate())
 
 EditedDateDate and time when the reinsurance treaty was last modified.DBTimeStamp4 
(getutcdate())
 
Objects that depend on tReinsurance
 Database ObjectObject TypeDescriptionDep Level
tReinsAppliesToGeo tabletReinsAppliesToGeoTableStores information regarding the geographic/area filter applied for the reinsurance treaty. Using reinsurance treaty geographic filter is optional.1
Objects that tReinsurance 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
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.