The rule in plain words
The item "Total Flood EEA Regions before diversifications" reported in Solvency Capital Requirement - Non-life and Health catastrophe risk (S.27.01) must be equal to the sum of the regions reported above
The headline gives only the template and the kind of check, because the rule is too long to say in a headline. The plain words above say all of it.
EIOPA writes it out as separate checks, one for each table or return it covers. Line4 Check runs two of them (BV277_1-1 and BV277_1-2), and a failure names the one that failed.
What to do if your return fails it
- 01Open the tables below and find the cells the rule reads.
- 02Add up the parts in your return and compare the result with the total.
- 03If they differ, a part is missing, a value sits in the wrong cell, or the total is out of date.
- 04EIOPA allows a small rounding difference, worked out from the decimals each value is reported with.
- 05It runs only when your filing indicators mark S.27.01 as reported.
- 06This is a blocking check. A return that fails it is normally rejected, so fix it before you submit.
The cells it reads
Solvency capital requirement - non-life and health catastrophe risk: natural catastrophe risk - flood (S.27.01.01.04)
Rows
- R1260Republic of Austria
- R1270Kingdom of Belgium
- R1280Republic of Bulgaria
- R1290Czech Republic
- R1291Denmark
- R1292Finland
- R1295Grand Duchy of Luxemburg
- R1300Swiss Confederation; Principality of Lichtenstein
- R1310French Republic [except Guadeloupe, Martinique, the Collectivity of Saint Martin and Réunion]; Principality of Monaco; Principality of Andorra
- R1320Federal Republic of Germany
- R1321Kingdom of the Netherlands
- R1325Norway
- R1330Republic of Hungary
- R1335Ireland
- R1340Italian Republic; Republic of San Marino; Vatican City State
- R1350Republic of Poland
- R1360Romania
- R1370Slovak Republic
- R1380Republic of Slovenia
- R1385Sweden
- R1390United Kingdom of Great Britain and Northern Ireland
- R1400Total Flood specified Regions before diversification
Columns
- C0220Exposure
- C0230Specified Gross Loss
- C0260Catastrophe Risk Charge before risk mitigation
- C0270Estimated Risk Mitigation
- C0280Estimated Reinstatement Premiums
- C0290Catastrophe Risk Charge after risk mitigation
Solvency capital requirement - non-life and health catastrophe risk: natural catastrophe risk - flood (S.27.01.04.04)
Rows
- R1260Republic of Austria
- R1270Kingdom of Belgium
- R1280Republic of Bulgaria
- R1290Czech Republic
- R1291Denmark
- R1292Finland
- R1295Grand Duchy of Luxemburg
- R1300Swiss Confederation; Principality of Lichtenstein
- R1310French Republic [except Guadeloupe, Martinique, the Collectivity of Saint Martin and Réunion]; Principality of Monaco; Principality of Andorra
- R1320Federal Republic of Germany
- R1321Kingdom of the Netherlands
- R1325Norway
- R1330Republic of Hungary
- R1335Ireland
- R1340Italian Republic; Republic of San Marino; Vatican City State
- R1350Republic of Poland
- R1360Romania
- R1370Slovak Republic
- R1380Republic of Slovenia
- R1385Sweden
- R1390United Kingdom of Great Britain and Northern Ireland
- R1400Total Flood specified Regions before diversification
Columns
- C0220Exposure
- C0230Specified Gross Loss
- C0260Catastrophe Risk Charge before risk mitigation
- C0270Estimated Risk Mitigation
- C0280Estimated Reinstatement Premiums
- C0290Catastrophe Risk Charge after risk mitigation
Which returns it applies to
Line4 Check runs it on annual solo (ARS), annual group (ARG) and annual branch (ARB) returns on EIOPA taxonomy 2.10.0. EIOPA applies it to annual branch (ARB), annual solo (ARS), annual ECB solo (AES), annual ECB branch (AEB) and annual group (ARG) returns, as a blocking check.
EIOPA’s own words and formula
In EIOPA’s list of validations, word for word:
The item "Total Flood EEA Regions before diversifications" reported in S.27.01 - Solvency Capital Requirement - Non-life and Health catastrophe risk must be equal to the sum of the regions reported above.
Show the formulaShowHide
EIOPA's formula, for BV277_1-1. Cells are written as {t: table, r: row, c: column}.
{t: S.27.01.01.04, r: R1400, z: Z0001} = sum({t: S.27.01.01.04, r: R1260; R1270; R1280; R1290; R1291; R1292; R1295; R1300; R1310; R1320; R1321; R1325; R1330; R1335; R1340; R1350; R1360; R1370; R1380; R1385; R1390, z: Z0001})BV277_1-2:
{t: S.27.01.04.04, r: R1400, z: Z0001} = sum({t: S.27.01.04.04, r: R1260; R1270; R1280; R1290; R1291; R1292; R1295; R1300; R1310; R1320; R1321; R1325; R1330; R1335; R1340; R1350; R1360; R1370; R1380; R1385; R1390, z: Z0001})Other rules on Solvency capital requirement - non-life and health catastrophe risk (S.27.01)
- Solvency capital requirement - non-life and health catastrophe risk: values must agree (BV276_1)Blocking
- Solvency capital requirement - non-life and health catastrophe risk: values must agree (BV278_1)Blocking
- Solvency capital requirement - non-life and health catastrophe risk: values must agree (BV275_1)Blocking
- Solvency capital requirement - non-life and health catastrophe risk: values must agree (BV279_1)Blocking
- Solvency capital requirement - non-life and health catastrophe risk: values must agree (BV274_1)Blocking
- Solvency capital requirement - non-life and health catastrophe risk: a total must equal the sum of its parts (BV273_1)Blocking
- Solvency capital requirement - non-life and health catastrophe risk: a total must equal the sum of its parts (BV281_1)Blocking
- Solvency capital requirement - non-life and health catastrophe risk: a total must equal the sum of its parts (BV272_1)Blocking
Every Solvency II rule on S.27.01
Checks like this one, run at the point of submission, are the first step to real-time supervision. Line4 builds SupTech software for financial regulators that runs checks like these as each return arrives.
