Touchstone 4.0 Database Documentation
tAnalysisReinsurance Table
Description
Stores information about any reinsurance treaties considered during the analyses.
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   
 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   
 ReinsuranceIDUser-provided 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 reinsurance 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

Code that represents the preferred exposure type.

Reserved for future use.

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 layers.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  
 CoinsuranceAmountThe minimum premium paid for coverage of the layer per reinstatement.  This value is not used during analysis.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  
 LossesPaidUser-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  
 LossModificationFactor

User-defined factor used to modify losses.

The loss engine scales the entire Ground-up distribution by this factor, not just the mean loss, and applies all policy conditions to the modified losses. It does not cap the modified losses at the total insurable value (TIV). Any loss modification factor that is applied to losses from a peril applies also to losses generated by the respective sub-perils.

Single4  
 StartingEventNumberEvent number at which the when 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  
 ReinsAppliesToULOBFilter that identifies the Lines to Business to which the reinsurance treaty applies.LongVarChar16  
 ReinsAppliesToEventXML string that defines the filter used to determine the event to which the reinsurance treaty applies.Xml16  
 InuringSequenceNumberInuring order for the reinsurance treaty.SmallInt2  
 DescriptionDescription of the reinsurance treaty.VarChar4000  
 EnteredDateDate and time when the reinsurance treaty was created.DBTimeStamp4   
 EditedDateDate and time when the reinsurance treaty was last modified.DBTimeStamp4   
Objects that depend on tAnalysisReinsurance
 Database ObjectObject TypeDescriptionDep Level
tAnalysisReinsAppliesToGeo tabletAnalysisReinsAppliesToGeoTableStores information about the geographic areas to which reinsurance treaties are applied.2
Objects that tAnalysisReinsurance depends on
 Database ObjectObject TypeDescriptionDep Level
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.