SubmitEpToUlf Method

Submits a request for converting the exceedance probability(EP) loss summary data for a single curve or multiple curves to a binary user loss file (ULF).

This feature enables to interpolate and extrapolate your summary loss points to a full 10,000 point EP curve, including disaggregation to area or sub-area level.

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 for aggregate loss analyses in Touchstone Re.

The resultant ULF format will not include Historical or RDS event losses.
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.

AIR offers this feature only for clients who contract a legal license for program loss adjustment (PLA).

Syntax

Visual Basic (Declaration)
Visual Basic (Usage)
C#

Public Function SubmitEpToUlf( _
   ByVal request As SubmitEpToUlfRequest _
) As SubmitEpToUlfResponse

Dim instance As ReinsuranceCompanyLossSetManagementServiceClient
Dim request As SubmitEpToUlfRequest
Dim value As SubmitEpToUlfResponse
 
value = instance.SubmitEpToUlf(request)

public SubmitEpToUlfResponse SubmitEpToUlf( 
   SubmitEpToUlfRequest request
)

Parameters

request: Contains a SubmitEpToUlfRequest() that specifies the Business Unit SID and SQL Instance SID associated with the identifies the summary loss file in the request.

Return Value

A SubmitEpToUlfResponse that contains the ActivitySidField that uniquely identifies the asynchronous web service call that you made to convert the EP uing the SubmitEPToUlf() method.

Remarks

To find the Business Unit SID to pass into this method, call the GetBusinessUnits() method.

To find the SQL Instance SID to pass into this method, call the GetSqlInstances() method.

Example

The following example shows how to retrieve the list of all company loss file sets or company loss association using the SubmitEPToUlf() method:

using AIR.Services.Common.Data;
using AIR.Services.Reinsurance.CompanyLossSetManagement.Api;
using AIR.Services.Reinsurance.CompanyLossSetManagement.Data;
using System;
using System.Collections.Generic;
             
class SnippetSubmitEpToUlfRequest
{
private static void SubmitEpToUlfRequest(int businessUnitSid, int sqlInstanceSid)
{
ReinsuranceCompanyLossSetManagementServiceClient client = new ReinsuranceCompanyLossSetManagementServiceClient();
SubmitEpToUlfRequest request = new SubmitEpToUlfRequest();
request.BusinessUnitSid = businessUnitSid;
request.SqlInstanceSid = sqlInstanceSid;
request.ConvertEpToUlfOptions = new AIR.Services.Reinsurance.CompanyLossSetManagement.Data.ConvertEpToUlfOptions()
{
AreaDetail = GeoResolution.Area,
EpFileCurrencyCode = "USD",
CurrencyExchangeRateSetSid = 5,
EpFileLossNumberUnits = UnitType.Ones,
EpFilePath = @\\Workarea\EP_file.csv,
EpOrRp = EpOrRpType.Ep,
EventSetSid = 46,
ExtendedComment = "Comments",
LossCurvesReflectDemandSurge = true,
LossSetName = "API_EPTOULF",
TargetCurve = TargetCurveType.Aggregate,
UlfFileCurrencyCode = "USD",
UlfFileOutputDirectory = @\\Workarea\output
             
};
request.ConvertEpToUlfOptions.CurveAppliesToAreaPerils = new List lt; CurveAppliesToAreaPeril gt; ()
{
new CurveAppliesToAreaPeril()
{
Name ="CurveA",
PerilSetCode = AIR.Services.Common.Data.PerilSetCode.Earthquake | AIR.Services.Common.Data.PerilSetCode.FireFollowingEarthquake,
AppliesToArea = new AIR.Services.Reinsurance.Common.Data.ReinsuranceAppliesToArea()
{
Name="CurveA AppliesToAreaUS",
GeographyItems = new List lt; AIR.Services.Geography.Data.GeographyLeafItem gt;()
{  
new AIR.Services.Geography.Data.GeographyLeafItem()
{ 
GeographySid = 234 }, //US
}
}
}
};
SubmitEpToUlfResponse response = client.SubmitEpToUlf(request);
if (response.Status.Code == StatusCode.Success)
{
Console.WriteLine("Submitted with activity Sid: " + response.ActivitySid);
}
    }
}

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

ReinsuranceCompanyLossSetManagementServiceClient Class
ReinsuranceCompanyLossSetManagementServiceClient Members