Convert Event Loss Summary to ULF
Convert exceedance probability (EP) or return period (RP) summary loss curves to a user loss file (ULF) for importing into Touchstone Re.
Previously, the sourced EP summary points data were not conducive for use in Touchstone Re. The workflow for converting the EP points data into a format friendly to the software was tedious.
Now ILS investors or reinsurers can directly apply the EP summary losses into Touchstone Re and then set up aggregate program terms and include the curves in an aggregate loss analysis. This enables you to interpolate and extrapolate your summary loss points to a full 10,000 point EP curve, including disaggregation to area or sub-area level.
-
The resultant ULF format will not include Historical or RDS event losses.
-
AIR offers this feature only for clients who contract a legal license for program loss adjustment (PLA).
-
This feature does not support other perils such as Terrorism, Crop Hail, the Multi-Peril Crop Model event sets, Pandemic, Coastal Flood event sets, and any non-modeled regions and their corresponding perils.
Updated AIR.Services.Reinsurance.CompanyLossSetManagement.Data Namespace
AIR has implemented the ConvertEpToUlfOptions class in the Reinsurance Company Loss Set Management Data namespace for configuring the input comma-separated values (CSV) file. This class contains the following properties.
|
Property |
Type |
Description |
|---|---|---|
|
AreaDetail |
Enumeration GeoResolution
|
(Optional) Represent the resolution of the event loss tables.
|
|
CurrencyExchangeRateSetSid |
Integer |
(Optioal) Represents the currency exchange rate set table associated with the source EP file.
|
|
CurveAppliesToAreaPerils |
List CurveAppliesToAreaPerils |
(Required) Contains the properties that define Curve Applies To Area Perils filter. A Curve Applies To Area Perils filter specifies that a geographic location and peril applies only to a given curve.
|
|
EpFileCurrencyCode |
String |
(Required) Represents the currency code of the source EP file. |
|
EpFileLossNumberUnits |
Enumeration UnitType
|
(Optional) Indicates the monetary units such as ones, thousands, and millions in the input CSV file.
|
|
EpFilePath |
String |
(Required) Contains the Universal Naming Convention
(UNC) file path to the folder and filename (with extension) that you want to
convert to a binary format. For example,
|
|
EpOrRp |
Enumeration EpOrRpType
|
(Required) Indicates the type of curve.
|
|
EventSetSid |
Integer |
(Optional) Represents the unique sequential identifier for the event set.
|
|
ExtendedComment |
String |
(Optional) Indicates the user-specified comments. |
|
LossCurvesReflectDemandSurge |
Boolean
|
(Required) Indicates whether a loss curve already includes Demand Surge in loss computations. Note:
Demand Surge will not be added to loss curves during import, regardless of this property. |
|
LossSetName |
String |
(Required) Indicates the name of the event loss set associated with the request. |
|
TargetCurve |
Enumeration TargetCurveType
|
(Required) Indicates the output curve type for EP or RP loss summary.
|
|
UlfFileCurrencyCode |
String |
(Optional) Indicates the currency code for ULF.
|
|
UlfFileOutputDirectory |
String |
(Required) Contains the Universal Naming Convention
(UNC) file path to the folder where you want to store the ULF format file. For
example, |
AIR has implemented the CurveAppliesToAreaPerils class for configuring the perils and geographic location for each curve associated with the input request. This class contains the following properties.
|
Property |
Type |
Description |
|---|---|---|
|
AppliesToArea |
ReinsuranceAppliesToArea |
(Required) Contains the properties that define an Applies to Area filter. An Applies to Area filter specifies that a layer or reinsurance treaty applies only to a given geographic area. |
|
Name |
String |
(Required) Represents the name of the AppliesToArea selection. |
|
PerilSetCode |
PerilSetCode |
(Required) Represents the mapping between the geographic location and the user-selected perils. |
The AppliesToArea property leverages the existing ReinsuranceAppliesToArea sub-class for mapping the reinsurance programs with one or many geographic locations. You can specify countries and one or multiple states that apply for a reinsurance program.
|
Property |
Type |
Description |
|---|---|---|
|
GeographyItems |
GeographyLeafItem |
(Required) Represents a collection of countries, states, and counties in a geographic location. The system allows you to specify multiple countries and states for EP to ULF conversion. |
|
Name |
String |
(Required) Represents the user-specified geographic location for which the reinsurance program is applicable. |
|
Sid |
Integer |
(Required) Contains the sequential identifier associated with a geographic location. |
The existing GeographyLeafItem property is to capture the granularity of loss distribution in a geographic location. You can use this property to define country and state level resolution filter. For example, you can specify one or multiple countries, and then specify states within a country. Though you can specify country and state resolution, the system does not support with an option to specify county level resolution for EP to ULF conversion. The GeographyLeafItem class contains the following objects.
|
Object |
Type |
Description |
|---|---|---|
|
CededPercentage |
Double |
Not applicable for EP summary loss conversion to a binary format. Note:
The CededPercentage property is in baseline code across AIR products. For example, you must specify the ceded percentage value for creating reinsurance program request. |
|
GeographySid |
Integer |
(Required) Indicates the sequential identifier associated with the location. |
Updated AIR.Services.Reinsurance.CompanyLossSetManagement.Api Namespace
AIR has implemented the SubmitEpToUlfRequest and SubmitEpToUlfResponse classes in the existing Reinsurance Company Loss Set Management API namespace.
The SubmitEpToUlfRequest class submits an HPC job to convert the event losses CSV file to user loss file. This class contains the following properties.
|
Property |
Type |
Description |
|---|---|---|
|
MaximumCores |
Integer |
(Required) Specifies the maximum number of HPC core resources needed to submit a conversion job to HPC service. |
|
MinimumCores |
Integer |
(Required) Specifies the minimum number of HPC core resources, needed to submit a conversion job to HPC service. |
|
ConvertEpToUlfOptions |
<ConvertEpToUlfOptions> |
(Required) Contains options to configure the conversion of EP losses to ULF. |
The SubmitEpToUlfResponse class returns the activity sequential identifier associated with the request.
|
Property |
Type |
Description |
|---|---|---|
|
ActivitySid |
Integer |
Specifies a unique sequential identifier associated with the input request. |
