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.
| Creation Date | 4/11/2022 6:17 PM |
| File Group | PRIMARY |
| Text File Group | |
| 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 | |
|---|---|---|---|---|---|---|---|
 | ReinsuranceEPCurveSID | Unique system-generated identifier for the reinsurance program. | int | 4 | |||
| ReinsuranceEPCurveSetSID | Unique system-generated identifier for the reinsurance program associated with the EP summary loss curve. | int | 4 | ||||
| CurveName | Name of the EP curve. | varchar | 255 | ||||
| AppliesToAreaSID | Unique system-generated sequential identifier for the user-specified area associated with the reinsurance treaty. For a complete list of records, see tAppliesToArea Table. | int | 4 | ||||
| PerilSetCode | Numeric code for the single peril or set of perils associated with the reinsurance treaty. For a complete list of codes, see tPerilSet Table. | int | 4 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | 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 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
| tReinsuranceEPCurveSet | Table | 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. | 2 |