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.

Note:
  • 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

  • Subarea = 1

  • Area = 0

(Optional) Represent the resolution of the event loss tables.

  • Area: Touchstone Re saves losses by area.

  • Sub-area: Touchstone Re saves losses by sub-area.

  • Default = Area

CurrencyExchangeRateSetSid

Integer

(Optioal) Represents the currency exchange rate set table associated with the source EP file.

  • Default = AIR Default

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.

  • You must specify one or multiple peril types from the following options.

    • Earthquake

    • FireFollowingEarthquake

    • TropicalCyclone

    • SevereThunderstorm

    • WinterStorm

    • InlandFlood

    • Wildfire

EpFileCurrencyCode

String

(Required) Represents the currency code of the source EP file.

EpFileLossNumberUnits

Enumeration UnitType

  • Ones = 0

  • Thousands = 1

  • Millions = 2

  • Billions = 3

(Optional) Indicates the monetary units such as ones, thousands, and millions in the input CSV file.

  • Default = Ones

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, \\host-name\Directory\file.csv.

EpOrRp

Enumeration EpOrRpType

  • Unknown = 0

  • Ep = 1

  • Rp = 2

(Required) Indicates the type of curve.

  • Exceedence probability = Ep

    Note:

    If you define Ep, then the first column in the CSV file must contain values [0,1]. You can specify both decimal and integer values.

  • Return period = Rp

    Note:

    If you define Rp, then the first column in the imported CSV file must contain values of range [1,10000]. You must specify only integer values.

  • Default = Unknown

EventSetSid

Integer

(Optional) Represents the unique sequential identifier for the event set.

  • Default = World All Perils (10K Time Dependent Hybrid)

    Note:

    This feature is restricted to the World All Perils event sets only.

ExtendedComment

String

(Optional) Indicates the user-specified comments.

LossCurvesReflectDemandSurge

Boolean

  • True

  • False

(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

  • Unknown = 0

  • Aggregate = 1

  • Occurrence = 2

(Required) Indicates the output curve type for EP or RP loss summary.

  • Aggregate or Occurrence

UlfFileCurrencyCode

String

(Optional) Indicates the currency code for ULF.

  • Default = U.S. Dollar or Local (LCL)

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, \\host-name\Directory\

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.