Stores information about the input configuration of the exceedance probability (EP) summary loss curve.
Touchstone Re generates this table to store the EP curve set information including the unique identifier for the curve, user-provided reinsurance curve name, loss applies to area, and the associated perils for each EP curve.
| Creation Date | 4/11/2022 6:17 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 | |
|---|---|---|---|---|---|---|---|
 | ReinsuranceEPCurveSetSID | Unique system-generated sequential identifier for the EP curve associated with the reinsurance program. | int | 4 | |||
| CurveSetName | User-defined curve set name. | varchar | 255 | ||||
| CurrencyCode | Currency code of the input EP file. | char | 3 | ||||
| CurrencyExchangeRateSetSID | Unique sequential identifier of the currency exchange rate set associated with the input EP binary file. | int | 4 | ||||
| ReinsuranceEventSetSID | Unique system-generated sequential identifier for the event set catalog associated with the reinsurance program. | int | 4 | ||||
| EPAnnualTypeCode | Code that represents the 'TargetCurve' type in Touchstone Re.
| varchar | 3 | ||||
| LOBCode | Code that represents the line-of-business. | int | 4 |  | |||
| ULFFileName | Represents the user-defined file name of the output ULF file. | sysname | 128 | ||||
| ULFComments | User comments. | varchar | 16 | | |||
| ULFGeoResolution | Indicates the loss disaggregation level of the output ULF file. | char | 4 | | |||
| CompanySID | Unique sequential identifier associated with the company. | bigint | 8 | | |||
| IsGenerateLMS | Reserved for future use. | bit | 1 | | |||
| ULFCurrencyCode | Currency code of the ULF file. | char | 3 | ||||
| ULFCurrencyExchangeRateSetSID | Represents the currency exchange rate set identifier for the output ULF file. | int | 4 | ||||
| IsDefault | Reserved for future use. | bit | 1 | | |||
| Author | Reserved for future use. | varchar | 255 | | |||
| IsDemandSurgeOn | bit | 1 | ((0)) |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tReinsuranceEPCurve | Table | This table stores information about the exceedance probability (EP) summary losses curve for reinsurance programs. Touchstone Re generates this table during the time of conversion of EP summary losses to ULF for further analyses in Touchstone Re. | 1 |
| tReinsuranceEPCurveAdjustmentPoint | Table | Stores information about the curve adjustment value generated at the time of conversion of EP to ULF files. Touchstone Re generates this table to store the adjusted EP curve data after converting the exceedance probability loss summary to the user loss file format for the selected reinsurance program. | 2 |