The rule in plain words
For "Health NSLT Catastrophe risk - Concentration accident", the item "Total Concentration accident all countries before diversification" reported in Solvency Capital Requirement - Non-life and Health catastrophe risk (SR.27.01) [RFF/MP/RM] must be equal to the sum of the countries 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 twelve of them (BV311_2-2 to BV311_2-13), 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.
- 02The check applies only when its first part holds in your return. When it does, the second part must hold too: fix the second part, or correct the first.
- 03EIOPA allows a small rounding difference, worked out from the decimals each value is reported with.
- 04It runs only when your filing indicators mark SR.01.01 and SR.27.01 as reported.
- 05This is a blocking check. A return that fails it is normally rejected, so fix it before you submit.
The cells it reads
Content of the submission (SR.01.01.01.01)
Row
- R0940SR.27.01.01 - Solvency Capital Requirement - Non-life and Health catastrophe risk
Column
- C0010Reporting status
Content of the submission (SR.01.01.04.01)
Row
- R0940SR.27.01.01 - Solvency Capital Requirement - Non-life and Health catastrophe risk
Column
- C0010Reporting status
Content of the submission (SR.01.01.07.01)
Row
- R0940SR.27.01.01 - Solvency Capital Requirement - Non-Life and Health catastrophe risk
Column
- C0010Reporting status
Solvency capital requirement - non-life and health catastrophe risk: health catastrophe risk - concentration accident (SR.27.01.01.21)
Rows
- R3700Republic of Austria
- R3710Kingdom of Belgium
- R3720Republic of Bulgaria
- R3730Republic of Croatia
- R3740Republic of Cyprus
- R3750Czech Republic
- R3760Kingdom of Denmark
- R3770Republic of Estonia
- R3780Republic of Finland
- R3790French Republic
- R3800Hellenic Republic
- R3810Federal Republic of Germany
- R3820Republic of Hungary
- R3830Republic of Iceland
- R3840Ireland
- R3850Italian Republic
- R3860Republic of Latvia
- R3870Republic of Lithuania
- R3880Grand Duchy of Luxemburg
- R3890Republic of Malta
- R3900Kingdom of the Netherlands
- R3910Kingdom of Norway
- R3920Republic of Poland
- R3930Portuguese Republic
- R3940Romania
- R3950Slovak Republic
- R3960Republic of Slovenia
- R3970Kingdom of Spain
- R3980Kingdom of Sweden
- R3990Swiss Confederation
- R4000United Kingdom of Great Britain and Northern Ireland
Columns
- C1370Catastrophe Risk Charge before risk mitigation
- C1380Estimated Risk Mitigation
- C1390Estimated Reinstatement Premiums
- C1400Catastrophe Risk Charge after risk mitigation
Solvency capital requirement - non-life and health catastrophe risk: health catastrophe risk - concentration accident. other countries to be considered in the concentration accident (SR.27.01.01.23)
Row
- R4010Other countries to be considered in the Concentration accident
Columns
- C1370Catastrophe Risk Charge before risk mitigation
- C1380Estimated Risk Mitigation
- C1390Estimated Reinstatement Premiums
- C1400Catastrophe Risk Charge after risk mitigation
Solvency capital requirement - non-life and health catastrophe risk: health catastrophe risk - concentration accident. total (SR.27.01.01.26)
Row
- R4020Total Concentration accident all countries before diversification
Columns
- C1370Catastrophe Risk Charge before risk mitigation
- C1380Estimated Risk Mitigation
- C1390Estimated Reinstatement Premiums
- C1400Catastrophe 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 ECB branch (AEB), annual group (ARG), annual solo (ARS) and annual ECB solo (AES) returns, as a blocking check.
EIOPA’s own words and formula
In EIOPA’s list of validations, word for word:
For "Health NSLT Catastrophe risk - Concentration accident", the item "Total Concentration accident all countries before diversification" reported in SR.27.01 - Solvency Capital Requirement - Non-life and Health catastrophe risk [RFF/MP/RM] must be equal to the sum of the countries reported above.
Show the formulaShowHide
EIOPA's formula, for BV311_2-10. Cells are written as {t: table, r: row, c: column}.
if ({t: SR.01.01.01.01, r: R0940, c: C0010, z: Z0001} = [s2c_CN:x1]) then {t: SR.27.01.01.26, r: R4020, c: C1400, z: Z0001} = {t: SR.27.01.01.21, r: R3700, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3710, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3720, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3730, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3740, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3750, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3760, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3770, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3780, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3790, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3800, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3810, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3820, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3830, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3840, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3850, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3860, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3870, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3880, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3890, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3900, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3910, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3920, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3930, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3940, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3950, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3960, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3970, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3980, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3990, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R4000, c: C1400, z: Z0001} + sum({t: SR.27.01.01.23, r: R4010, c: C1400, z: Z0001}) else true()BV311_2-2:
if ({t: SR.01.01.07.01, r: R0940, c: C0010, z: Z0001} = [s2c_CN:x1]) then {t: SR.27.01.01.26, r: R4020, c: C1400, z: Z0001} = {t: SR.27.01.01.21, r: R3700, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3710, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3720, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3730, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3740, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3750, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3760, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3770, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3780, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3790, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3800, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3810, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3820, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3830, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3840, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3850, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3860, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3870, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3880, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3890, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3900, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3910, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3920, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3930, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3940, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3950, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3960, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3970, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3980, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3990, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R4000, c: C1400, z: Z0001} + sum({t: SR.27.01.01.23, r: R4010, c: C1400, z: Z0001}) else true()BV311_2-3:
if ({t: SR.01.01.07.01, r: R0940, c: C0010, z: Z0001} = [s2c_CN:x1]) then {t: SR.27.01.01.26, r: R4020, c: C1390, z: Z0001} = {t: SR.27.01.01.21, r: R3700, c: C1390, z: Z0001} + {t: SR.27.01.01.21, r: R3710, c: C1390, z: Z0001} + {t: SR.27.01.01.21, r: R3720, c: C1390, z: Z0001} + {t: SR.27.01.01.21, r: R3730, c: C1390, z: Z0001} + {t: SR.27.01.01.21, r: R3740, c: C1390, z: Z0001} + {t: SR.27.01.01.21, r: R3750, c: C1390, z: Z0001} + {t: SR.27.01.01.21, r: R3760, c: C1390, z: Z0001} + {t: SR.27.01.01.21, r: R3770, c: C1390, z: Z0001} + {t: SR.27.01.01.21, r: R3780, c: C1390, z: Z0001} + {t: SR.27.01.01.21, r: R3790, c: C1390, z: Z0001} + {t: SR.27.01.01.21, r: R3800, c: C1390, z: Z0001} + {t: SR.27.01.01.21, r: R3810, c: C1390, z: Z0001} + {t: SR.27.01.01.21, r: R3820, c: C1390, z: Z0001} + {t: SR.27.01.01.21, r: R3830, c: C1390, z: Z0001} + {t: SR.27.01.01.21, r: R3840, c: C1390, z: Z0001} + {t: SR.27.01.01.21, r: R3850, c: C1390, z: Z0001} + {t: SR.27.01.01.21, r: R3860, c: C1390, z: Z0001} + {t: SR.27.01.01.21, r: R3870, c: C1390, z: Z0001} + {t: SR.27.01.01.21, r: R3880, c: C1390, z: Z0001} + {t: SR.27.01.01.21, r: R3890, c: C1390, z: Z0001} + {t: SR.27.01.01.21, r: R3900, c: C1390, z: Z0001} + {t: SR.27.01.01.21, r: R3910, c: C1390, z: Z0001} + {t: SR.27.01.01.21, r: R3920, c: C1390, z: Z0001} + {t: SR.27.01.01.21, r: R3930, c: C1390, z: Z0001} + {t: SR.27.01.01.21, r: R3940, c: C1390, z: Z0001} + {t: SR.27.01.01.21, r: R3950, c: C1390, z: Z0001} + {t: SR.27.01.01.21, r: R3960, c: C1390, z: Z0001} + {t: SR.27.01.01.21, r: R3970, c: C1390, z: Z0001} + {t: SR.27.01.01.21, r: R3980, c: C1390, z: Z0001} + {t: SR.27.01.01.21, r: R3990, c: C1390, z: Z0001} + {t: SR.27.01.01.21, r: R4000, c: C1390, z: Z0001} + sum({t: SR.27.01.01.23, r: R4010, c: C1390, z: Z0001}) else true()BV311_2-4:
if ({t: SR.01.01.07.01, r: R0940, c: C0010, z: Z0001} = [s2c_CN:x1]) then {t: SR.27.01.01.26, r: R4020, c: C1380, z: Z0001} = {t: SR.27.01.01.21, r: R3700, c: C1380, z: Z0001} + {t: SR.27.01.01.21, r: R3710, c: C1380, z: Z0001} + {t: SR.27.01.01.21, r: R3720, c: C1380, z: Z0001} + {t: SR.27.01.01.21, r: R3730, c: C1380, z: Z0001} + {t: SR.27.01.01.21, r: R3740, c: C1380, z: Z0001} + {t: SR.27.01.01.21, r: R3750, c: C1380, z: Z0001} + {t: SR.27.01.01.21, r: R3760, c: C1380, z: Z0001} + {t: SR.27.01.01.21, r: R3770, c: C1380, z: Z0001} + {t: SR.27.01.01.21, r: R3780, c: C1380, z: Z0001} + {t: SR.27.01.01.21, r: R3790, c: C1380, z: Z0001} + {t: SR.27.01.01.21, r: R3800, c: C1380, z: Z0001} + {t: SR.27.01.01.21, r: R3810, c: C1380, z: Z0001} + {t: SR.27.01.01.21, r: R3820, c: C1380, z: Z0001} + {t: SR.27.01.01.21, r: R3830, c: C1380, z: Z0001} + {t: SR.27.01.01.21, r: R3840, c: C1380, z: Z0001} + {t: SR.27.01.01.21, r: R3850, c: C1380, z: Z0001} + {t: SR.27.01.01.21, r: R3860, c: C1380, z: Z0001} + {t: SR.27.01.01.21, r: R3870, c: C1380, z: Z0001} + {t: SR.27.01.01.21, r: R3880, c: C1380, z: Z0001} + {t: SR.27.01.01.21, r: R3890, c: C1380, z: Z0001} + {t: SR.27.01.01.21, r: R3900, c: C1380, z: Z0001} + {t: SR.27.01.01.21, r: R3910, c: C1380, z: Z0001} + {t: SR.27.01.01.21, r: R3920, c: C1380, z: Z0001} + {t: SR.27.01.01.21, r: R3930, c: C1380, z: Z0001} + {t: SR.27.01.01.21, r: R3940, c: C1380, z: Z0001} + {t: SR.27.01.01.21, r: R3950, c: C1380, z: Z0001} + {t: SR.27.01.01.21, r: R3960, c: C1380, z: Z0001} + {t: SR.27.01.01.21, r: R3970, c: C1380, z: Z0001} + {t: SR.27.01.01.21, r: R3980, c: C1380, z: Z0001} + {t: SR.27.01.01.21, r: R3990, c: C1380, z: Z0001} + {t: SR.27.01.01.21, r: R4000, c: C1380, z: Z0001} + sum({t: SR.27.01.01.23, r: R4010, c: C1380, z: Z0001}) else true()BV311_2-5:
if ({t: SR.01.01.07.01, r: R0940, c: C0010, z: Z0001} = [s2c_CN:x1]) then {t: SR.27.01.01.26, r: R4020, c: C1370, z: Z0001} = {t: SR.27.01.01.21, r: R3700, c: C1370, z: Z0001} + {t: SR.27.01.01.21, r: R3710, c: C1370, z: Z0001} + {t: SR.27.01.01.21, r: R3720, c: C1370, z: Z0001} + {t: SR.27.01.01.21, r: R3730, c: C1370, z: Z0001} + {t: SR.27.01.01.21, r: R3740, c: C1370, z: Z0001} + {t: SR.27.01.01.21, r: R3750, c: C1370, z: Z0001} + {t: SR.27.01.01.21, r: R3760, c: C1370, z: Z0001} + {t: SR.27.01.01.21, r: R3770, c: C1370, z: Z0001} + {t: SR.27.01.01.21, r: R3780, c: C1370, z: Z0001} + {t: SR.27.01.01.21, r: R3790, c: C1370, z: Z0001} + {t: SR.27.01.01.21, r: R3800, c: C1370, z: Z0001} + {t: SR.27.01.01.21, r: R3810, c: C1370, z: Z0001} + {t: SR.27.01.01.21, r: R3820, c: C1370, z: Z0001} + {t: SR.27.01.01.21, r: R3830, c: C1370, z: Z0001} + {t: SR.27.01.01.21, r: R3840, c: C1370, z: Z0001} + {t: SR.27.01.01.21, r: R3850, c: C1370, z: Z0001} + {t: SR.27.01.01.21, r: R3860, c: C1370, z: Z0001} + {t: SR.27.01.01.21, r: R3870, c: C1370, z: Z0001} + {t: SR.27.01.01.21, r: R3880, c: C1370, z: Z0001} + {t: SR.27.01.01.21, r: R3890, c: C1370, z: Z0001} + {t: SR.27.01.01.21, r: R3900, c: C1370, z: Z0001} + {t: SR.27.01.01.21, r: R3910, c: C1370, z: Z0001} + {t: SR.27.01.01.21, r: R3920, c: C1370, z: Z0001} + {t: SR.27.01.01.21, r: R3930, c: C1370, z: Z0001} + {t: SR.27.01.01.21, r: R3940, c: C1370, z: Z0001} + {t: SR.27.01.01.21, r: R3950, c: C1370, z: Z0001} + {t: SR.27.01.01.21, r: R3960, c: C1370, z: Z0001} + {t: SR.27.01.01.21, r: R3970, c: C1370, z: Z0001} + {t: SR.27.01.01.21, r: R3980, c: C1370, z: Z0001} + {t: SR.27.01.01.21, r: R3990, c: C1370, z: Z0001} + {t: SR.27.01.01.21, r: R4000, c: C1370, z: Z0001} + sum({t: SR.27.01.01.23, r: R4010, c: C1370, z: Z0001}) else true()BV311_2-6:
if ({t: SR.01.01.04.01, r: R0940, c: C0010, z: Z0001} = [s2c_CN:x1]) then {t: SR.27.01.01.26, r: R4020, c: C1400, z: Z0001} = {t: SR.27.01.01.21, r: R3700, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3710, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3720, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3730, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3740, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3750, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3760, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3770, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3780, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3790, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3800, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3810, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3820, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3830, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3840, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3850, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3860, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3870, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3880, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3890, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3900, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3910, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3920, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3930, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3940, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3950, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3960, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3970, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3980, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R3990, c: C1400, z: Z0001} + {t: SR.27.01.01.21, r: R4000, c: C1400, z: Z0001} + sum({t: SR.27.01.01.23, r: R4010, c: C1400, z: Z0001}) else true()And 6 more, the same rule on other tables or returns.
Other rules on Content of the submission (SR.01.01)
- Content of the submission and solvency capital requirement - non-life and health catastrophe risk: a conditional check (BV310_2)Blocking
- Content of the submission and 2 other templates: a conditional check (BV312_2)Blocking
- Content of the submission and solvency capital requirement - non-life and health catastrophe risk: a conditional check (BV309_2)Blocking
- Content of the submission and balance sheet: a conditional check (BV313_2-1)Blocking
- Content of the submission and balance sheet: a conditional check (BV313_2-2)Blocking
- Content of the submission and solvency capital requirement - non-life and health catastrophe risk: a conditional check (BV308_2)Blocking
- Content of the submission and balance sheet: a conditional check (BV314_2-1)Blocking
- Content of the submission and balance sheet: a conditional check (BV314_2-2)Blocking
Every Solvency II rule on SR.01.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.
