Stores information about any reinsurance treaties applied during analyses.
Touchstone 2022 Database Reference
tAnalysisReinsurance Table
| Creation Date | 4/11/2022 5:46 PM |
| File Group | PRIMARY |
| Text File Group | PRIMARY |
| System Object |  |
| Published for Replication | |
| Rows | 0 |
| Data Space Used | 0.00 KB |
| Index Space Used | 0.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | ResultSID | Unique system-generated sequential identifier for the results record. For a complete list of records, see tAnalysisResult Table. | int | 4 | |||
| | ReinsuranceSID | Unique system-generated sequential identifier for the reinsurance record. For a complete list of records, see tReinsurance Table. | int | 4 | |||
| ProgramSID | Unique system-generated sequential identifier for the reinsurance program record. For a complete list of records, see tProgram Table. | int | 4 | ||||
| ReinsuranceTypeCode | Code that represents the type of reinsurance. For a complete list of codes, see tReinsuranceType Table. | varchar | 10 | ||||
| ReinsuranceID | User-provided identifier for the reinsurance treaty. | varchar | 100 | ||||
| SubmitStatusCode | Code for the submission status. For a complete list of codes, see tSubmitStatus Table. | varchar | 10 | ||||
| PerilSetCode | Numeric code for the single peril or set of perils. For a complete list of codes, see tPerilSet Table. | int | 4 | ||||
| TriggerTypeCode | Code that represents when/how reinsurance treaty coverage is applied. For a complete list of codes, see tTriggerType Table. | varchar | 10 | ||||
| ReinsTargetTypeCode | Code that represents the objects to which the reinsurance treaty is applied. For a complete list of codes, see tReinsTargetType Table. | varchar | 10 | ||||
| PreferredExposureTypeCode | Code that represents the preferred exposure type. Reserved for future use. For a complete list of codes, see tPreferredExposureType Table. | varchar | 10 |  | |||
| CedantName | Name of the primary insurer, which is the insurance company that purchases reinsurance. | varchar | 60 | | |||
| ReinsurerName | Name of the insurer or reinsurer who assumes the cedant’s risk under the contract (treaty). | varchar | 60 | | |||
| InceptionDate | Inception date of the reinsurance treaty. Also referred to as the Effective FROM Date. | date | 8 | ||||
| ExpirationDate | Reinsurance treaty expiration date. Also referred to as the Effective TO Date. | date | 8 | ||||
| CurrencyCode | ISO 3-character code for the currency. For a complete list of codes, see tCurrency Table. | char | 3 | ||||
| RiskLimit | Treaty limit for a single risk or layer. | float | 9 | | |||
| RiskRetention | Treaty retention per single risk, or per layer for policies including layers. | float | 9 | | |||
| OccurrenceLimit | Maximum loss that the treaty can occur from each occurrence. | float | 9 | | |||
| OccurrenceRetention | Deductible amount 1. The treaty does not assume losses below the specified value. | float | 9 | | |||
| AggregateLimit | Maximum amount payable under reinsurance treaty that provides overall maximum loss limitation. | float | 9 | | |||
| AggregateRetention | Additional dollar amount or percentage of risk retained by the ceding company under a reinsurance treaty. | float | 9 | | |||
| CededAmount | Ceded 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). | float | 9 | ||||
| PlacedAmount | Placed percentage. | float | 9 | | |||
| IndustryLossMinimum | Minimum amount of industry loss. | float | 9 | | |||
| IndustryLossMaximum | Maximum amount of industry loss. | float | 9 | | |||
| PortfolioLossMinimum | Minimum amount of portfolio loss. | float | 9 | | |||
| PortfolioLossMaximum | Maximum amount of portfolio loss. | float | 9 | | |||
| CoinsuranceAmount | Amount of co-insurance. | float | 9 | ||||
| PremiumMinimum | The minimum premium paid for coverage of the layer per reinstatement. This value is not used during analysis. | float | 9 | | |||
| PremiumEstimated | The estimated premium paid for coverage of the layer per reinstatement. This value is used when the analysis calculates premiums net-of-estimated losses. | float | 9 | | |||
| LossesPaid | User-provided information regarding losses paid on the account. This value is not used during analysis. | float | 9 | | |||
| ParticipationNet | Net participation amount or percent. | real | 4 | | |||
| ParticipationGross | Gross participation amount or percent. | real | 4 | | |||
| 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. | real | 4 | | |||
| StartingEventNumber | Event number at which the when treaty was applied. | int | 4 | | |||
| Reinstatement | The 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. | tinyint | 1 | | |||
| ReinstProvisionalAmount | Handling 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. | float | 9 | | |||
| ReinstProvisionalTime | Handling 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. | float | 9 | | |||
| IsMatchLossToLimit | Indicates whether the loss is matched to limits.
| bit | 1 | | |||
| ReinsAppliesToULOB | Filter that identifies the Lines to Business to which the reinsurance treaty applies. | varchar | 16 | | |||
| ReinsAppliesToEvent | XML string that defines the filter used to determine the event to which the reinsurance treaty applies. | xml | 0 | | |||
| InuringSequenceNumber | Inuring order for the reinsurance treaty. | smallint | 2 | | |||
| Description | Description of the reinsurance treaty. | varchar | 4000 | | |||
| EnteredDate | Date and time when the reinsurance treaty was created. | datetime | 4 | ||||
| EditedDate | Date and time when the reinsurance treaty was last modified. | datetime | 4 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tAnalysisReinsAppliesToGeo | Table | Stores information about the geographic areas to which reinsurance treaties are applied. | 1 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
| tAnalysisResult | Table | Contains general information about the analyses that produced the results. The table includes one row for each analysis in the database, regardless of the analysis type (Loss, Loss Grouping, Catastrophe Excess of Loss, or Marginal Impact). | 1 |