Reinsurance

 

The following table details the validation rules for Reinsurance fields related to risk of cyber attack:

 

Please note that most fields are optional. While more information generates a more accurate analysis, you can generate a valid analysis with only mandatory fields.

Mandatory fields are highlighted. For your convenience, the table is sortable by column head.

 

Field

Description

Validation Rules

Default Value

Data Type

Mandatory/ Optional

Common Core

Reinsurance SID

Unique system-generated sequential identifier for the reinsurance record.

 

N/A

Integer

Mandatory

 

Program SID

Unique system-generated sequential identifier for the reinsurance program record.

 

N/A

Integer

Mandatory

 

Reinsurance Type Code

Code that represents the reinsurance treaty type.

       CATXOL (Catastrophe Excess of Loss

       FAC (Facultative)

       QS (Quota Share)

       SS (Surplus Share)

       XPR (Per-Risk Excess of Loss)

Must be one of the following:

       CATXOL

       FAC

       QS

       SS

       XPR

N/A

String

Mandatory

 

Reinsurance ID

User-defined identifier for the reinsurance treaty.

Can include up to 100 characters

 

String

Mandatory

 

Submit Status Code

Code for the submission status.

       B (Bound)

       C (Cancelled)

       Q (Quoted)

       R (Rejected)

       S (Submitted)

Must be one of the following:

       B

       C

       Q

       R

       S

 

String

Mandatory

 

Peril Set Code

Numeric code for the single peril or set of perils.

       131072 (Cyber security data and privacy breach)

       262144 (Cyber security property damage)

       393216 (Sum of the codes for Cyber security data and privacy breach and Cyber security property) damage

Can be one of the following:

       131072

        262144

       393216

N/A

Integer

Mandatory

Yes

Trigger Type Code

Code that represents when/how treaty coverage is applied.

       LOD (Losses Occurring During)

       RA (Risks Attaching)

Must be one of the following:

       LOD

       RA

 

String

Mandatory

 

Reins Target Type Code

Code that represents the objects to which the reinsurance treaty is applied.

       CON (Contract)

       LOC (Location)

       LOCLYR (Location or Layer)

       LYR (Layer)

       NA (N/A)

       PORT (Portfolio)

Must be one of the following:

       CON

       LOC

       LOCLYR

       LYR

       NA

       PORT

N/A

String

Mandatory

 

Preferred Exposure Type Code

Code that represents the preferred exposure type.

       CLF (Company Loss File)

       CLFMKT (CLF + Market Share)

       CLFNOR (CLF + Number Of Risks)

       CLFPAY (CLF + Payroll)

       CLFPRE (CLF + Premium)

       CLFSI (CLF + Sums Insured)

       MKT ( Market Share)

       NOR (Number Of Risks)

       PAY (Payroll)

       PRE (Premium)

       SI (Sums Insured)

Must be one of the following:

       CLF

       CLFMKT

       CLFNOR

       CLFPAY

       CLFPRE

       CLFSI

       MKT 

       NOR 

       PAY 

       PRE

       SI 

 

String

Optional

 

Cedant Name

Name of the primary insurer, which is the insurance company that purchases reinsurance.

Can include up to 60 characters

 

String

Optional

 

Reinsurer Name

Name of the insurer or reinsurer who assumes the cedant’s risk under the contract (treaty).

Can include up to 60 characters

 

String

Optional

 

Inception Date

Date of the first day on which the reinsurance treaty is effective. Also referred to as the Effective FROM Date.

You must use one of the following formats.

       MM/DD/YYYY

       DD/MM/YYYY

       YYYYMMDD

       YYYY-MM-DD

       Date format is specific to locale of end user.

       Must be the reinsurance treaty inception date

       Must be a date value between 1/1/1970 and 12/31/2038, inclusive

 

 

Date

Mandatory

 

Expiration Date

Date of the last day on which the reinsurance treaty is effective.  Also referred to as the Effective TO Date.

You must use one of the following formats.

       MM/DD/YYYY

       DD/MM/YYYY

       YYYYMMDD

       YYYY-MM-DD

       Date format is specific to locale of end user.

       Must be the reinsurance treaty expiration date

       Must be a date value between 1/1/1970 and 12/31/2038, inclusive

 

 

Date

Mandatory

 

Currency Code

ISO 3-character code for the currency.

3-letter currency code must come from this list:

Currency Codes

 

String

Mandatory

 

Risk Limit

Treaty limit for a single risk or layer.

Can include up to 9 characters

 

DOUBLE

Optional

 

Risk Retention

Treaty retention per single risk, or per layer for policies including layers.

Can include up to 9 characters

 

 

DOUBLE

Optional

 

Occurrence Limit

Maximum loss that the treaty can occur from each occurrence.

Can include up to 9 characters

 

 

DOUBLE

Optional

 

Occurrence Retention

Deductible amount 1. The treaty does not assume losses below the specified value.

Can include up to 9 characters

 

 

DOUBLE

Optional

 

Aggregate Limit

Maximum amount payable under reinsurance treaty that provides overall maximum loss limitation.

Can include up to 9 characters

 

 

DOUBLE

Optional

 

Aggregate Retention

Additional dollar amount or percentage of risk retained by the ceding company under a reinsurance treaty.

Can include up to 9 characters

 

 

DOUBLE

Optional

 

Ceded Amount

Ceded amount expressed as an amount of percentage. Note that this value is provided on the user interface as a whole number percentage (e.g. 30.00) but is stored in the database as a decimal (e.g. 0.3).

Can include up to 9 characters

 

 

DOUBLE

Mandatory

 

Placed Amount

Placed percentage.

Can include up to 9 characters

 

DOUBLE

Optional

 

Industry Loss Minimum

Minimum amount of industry loss.

Can include up to 9 characters

 

DOUBLE

Optional

 

Industry Loss Maximum

Maximum amount of industry loss.

Can include up to 9 characters

 

DOUBLE

Optional

 

Portfolio Loss Minimum

Minimum amount of portfolio loss.

Can include up to 9 characters

 

DOUBLE

Optional

 

Portfolio Loss Maximum

Maximum amount of portfolio loss.

Can include up to 9 characters

 

DOUBLE

Optional

 

Coinsurance Amount

Amount of co-insurance.

Can include up to 9 characters

 

DOUBLE

Mandatory

 

Premium Minimum

The minimum premium paid for coverage of the layer per reinstatement.  This value is not used during analysis.

Can include up to 9 characters

 

DOUBLE

Optional

 

Premium Estimated

The estimated premium paid for coverage of the layer per reinstatement.  This value is used when the analysis calculates premiums net-of-estimated losses.

Can include up to 9 characters

 

DOUBLE

Optional

 

Losses Paid

User-provided information regarding losses paid on the account. This value is not used during analysis.

Can include up to 9 characters

 

DOUBLE

Optional

 

Participation Net

Net participation amount or percent.

Can include up to 4 characters

 

SINGLE

Optional

 

Participation Gross

Gross participation amount or percent.

Can include up to 4 characters

 

SINGLE

Optional

 

Loss Modification Factor

User-defined factor used to modify losses.

Can include up to 4 characters

 

SINGLE

Optional

 

Starting Event Number

Event number at which the treaty was applied.

Can include up to 4 characters

 

Integer

Optional

 

Reinstatement

The maximum number of times the risk limit can be reinstated after the application of a loss amount during the coverage period, where “0” represents no reinstatements and “999” represents unlimited reinstatements.

Can include 1 character

 

UNSIGNED/ TINY INT

Optional

 

Reinst Provisional Amount

Handling of reinstatement premium payments based on loss amount (100%, 75%, 50%, or Pro-Rata). The value 100% specifies that the total premium amount (Estimated Premium) is paid for the reinstatement; Pro Rata specifies that the reinstatement premium amount paid is in proportion to the percent of the occurrence limit that is exhausted.

Can include up to 9 characters

 

 

DOUBLE

Optional

 

Reinst Provisional Time

Handling of reinstatement premium payments based on time of loss (100%, 75%, 50%, or Pro-Rata). The value 100% specifies that the total premium amount (Estimated Premium) is paid for the reinstatement adjusted only for Reinstatement Provisions by Amount. Pro Rata specifies that the premium amount paid is in proportion to the time remaining on the reinsurance treaty as of the day on which the layer loss occurred.

Can include up to 9 characters

 

 

DOUBLE

Optional

 

Is Match Loss To Limit

Indicates whether the loss is matched to limits.

       1 = Yes (matched)

       0 = No (not matched)

Can include 1 character:

       1

       0

 

Integer

Optional

 

Reins Applies To ULOB

User's Lines of Business  filter.

Can include up to 16 characters

 

String

Optional

 

Reins Applies To Event

XML String that defines the event filter for the treaty.

Can include up to 16 characters

 

XML

Optional

 

Inuring Sequence Number

Inuring order for the reinsurance treaty.

Can include up to 2 characters

 

SMALL Integer

Optional

 

Description

Description of the reinsurance treaty.

Can include up to 4000 characters

 

String

Optional

 

Entered Date

Date and time when the reinsurance treaty was created, based on U.S. regional settings.

You must use one of the following formats.

       MM/DD/YYYY HH:MM:SS

       DD/MM/YYYY HH:MM:SS

       YYYYMM/DD HH:MM:SS

       YYYY-MM-DDHH:MM:SS

       Datetime format is specific to locale of end user.

       Must be a date value between 1/1/1970 and 12/31/2038, inclusive

       Must be a time value between 00:00 and 24:00, inclusive

 

Date Time

Mandatory

 

Edited Date

Date and time when the reinsurance treaty was modified, based on U.S. regional settings.

You must use one of the following formats.

       MM/DD/YYYY HH:MM:SS

       DD/MM/YYYY HH:MM:SS

       YYYYMM/DD HH:MM:SS

       YYYY-MM-DDHH:MM:SS

       Datetime format is specific to locale of end user.

       Must be date value between 1/1/1970 and 12/31/2038, inclusive

       Must be a time value between 00:00 and 24:00, inclusive

 

Date Time

Mandatory

 

 

 

© 2016 AIR Worldwide. All rights reserved.