SubmitEventLossToUlf Method

Submits a request for converting the event loss tables (ELT) in a text to a binary user loss file (ULF) for further analysis in Touchstone Re. You can also import the ULF data to a company in Touchstone Re. Additionally, you can save the user loss file in a currency of your choice.

ILS Clients and Retro Reinsurers receive the event-level losses from their respective clients. Now you can import a comma-separated value (CSV) file containing the event loss tables and convert the ELT data to the ULF format. Subsequently, you can attach the binary file containing ULF to a reinsurance program in Touchstone Re and then run an aggregate loss analysis. Enabling you to analyze the financial impact specific to events in a georesolution and lines of business.

Syntax

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

Public Function SubmitEventLossToUlf( _
   ByVal request As SubmitEventLossToUlfRequest _
) As SubmitEventLossToUlfResponse

Dim instance As ReinsuranceCompanyLossSetManagementServiceClient
Dim request As SubmitEventLossToUlfRequest
Dim value As SubmitEventLossToUlfResponse
 
value = instance.SubmitEventLossToUlf(request)

public SubmitEventLossToUlfResponse SubmitEventLossToUlf( 
   SubmitEventLossToUlfRequest request
)

Parameters

request: Contains a SubmitEventLossToUlfRequest that specifies the Business Unit SID and SQL Instance SID associated with the event loss file.

Return Value

A SubmitEventLossToUlfResponse that contains the ActivitySidField that uniquely identifies the asynchronous web service call that you made to convert the ELT text file uing the SubmitEventLossToUlf() method.

After successful completion of the request, navigate to the host directory path to view the ULF file. Attach the binary file to a reinsurance program in Touchstone Re. Submit an aggregate loss analysis request using any one of the methods: SubmitMultiProgramAggregateLossAnalysisRequest(), SubmitPortfolioAggregateLossAnalysisRequest(), and SubmitProgramAggregateLossAnalysisRequest() available in the Reinsurance Aggregate Loss Analysis API namespace.

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 SubmitEventLossToUlf() 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 SnippetSubmitEventLossToUlfRequest
{
private static void SubmitEventLossToUlfRequest(int businessUnitSid, int sqlInstanceSid)
{
ReinsuranceCompanyLossSetManagementServiceClient client = new ReinsuranceCompanyLossSetManagementServiceClient();
SubmitEventLossToUlfRequest request = new SubmitEventLossToUlfRequest();
request.BusinessUnitSid = businessUnitSid;
request.SqlInstanceSid = sqlInstanceSid;
request.ConvertEventLossToUlfOptions = new ConvertEventLossToUlfOptions();
request.ConvertEventLossToUlfOptions.LossSetName = @"EltM13_" + string.Format(@"{0:d_M_yyyy_HH_mm_ss}", DateTime.Now);
request.ConvertEventLossToUlfOptions.EventLossFilePath = @\\YourSharedDir\EltM13.csv;
request.ConvertEventLossToUlfOptions.EventLossFileColumnMappings = new List<EventLossColumnMapping>() {
new EventLossColumnMapping() { Index = 0, EventLossColumn = EventLossFileColumn.Event },
new EventLossColumnMapping() { Index = 1, EventLossColumn = EventLossFileColumn.Model },
new EventLossColumnMapping() { Index = 2, EventLossColumn = EventLossFileColumn.Loss },
};
             
request.ConvertEventLossToUlfOptions.EventLossFileCurrencyCode = "USD";
request.ConvertEventLossToUlfOptions.UlfFileOutputDirectory = @\\YourSharedDir\ELTtoULF\;
             
SubmitEventLossToUlfResponse response = client.SubmitEventLossToUlf(request);
        if (response.Status.Code == StatusCode.Success)
   {
Console.WriteLine("Request 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