The rule in plain words
The item "Total (Life other than health insurance, incl. Unit-Linked)" reported in Life and Health SLT Technical Provisions (SR.12.01) [RFF/MP/RM] must be equal to the sum of the relevant LoB
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 14 of them (BV242_2-14 to BV242_2-27), 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.12.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
- R0800SR.12.01.01 - Life and Health SLT Technical Provisions
Column
- C0010Reporting status
Content of the submission (SR.01.01.07.01)
Row
- R0800SR.12.01.01 - Life and Health SLT Technical Provisions
Column
- C0010Reporting status
Life and health SLT technical provisions (SR.12.01.01.01)
Rows
- R0010Technical provisions calculated as a whole
- R0020Total Recoverables from reinsurance/SPV and Finite Re after the adjustment for expected losses due to counterparty default associated to TP calculated as a whole
- R0100Risk Margin
- R0110Technical Provisions calculated as a whole
- R0130Risk margin
- R0200Technical provisions - total
- R0370Expected profits included in future premiums (EPIFP)
Columns
- C0020Insurance with profit participation
- C0030Index-linked and unit-linked insurance
- C0060Other life insurance
- C0090Annuities stemming from non-life insurance contracts and relating to insurance obligation other than health insurance obligations
- C0100Accepted reinsurance
- C0150Total (Life other than health insurance, including Unit-Linked)
Which returns it applies to
Line4 Check runs it on annual solo (ARS) and annual branch (ARB) returns on EIOPA taxonomy 2.10.0. EIOPA applies it to annual branch (ARB), annual ECB branch (AEB), 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:
The item "Total (Life other than health insurance, incl. Unit-Linked)" reported in SR.12.01 - Life and Health SLT Technical Provisions [RFF/MP/RM] must be equal to the sum of the relevant LoB.
Show the formulaShowHide
EIOPA's formula, for BV242_2-20. Cells are written as {t: table, r: row, c: column}.
if ({t: SR.01.01.01.01, r: R0800, c: C0010, z: Z0001} = [s2c_CN:x1]) then {t: SR.12.01.01.01, r: R0200, c: C0150, z: Z0001} = {t: SR.12.01.01.01, r: R0200, c: C0020, z: Z0001} + {t: SR.12.01.01.01, r: R0200, c: C0030, z: Z0001} + {t: SR.12.01.01.01, r: R0200, c: C0060, z: Z0001} + {t: SR.12.01.01.01, r: R0200, c: C0090, z: Z0001} + {t: SR.12.01.01.01, r: R0200, c: C0100, z: Z0001} else true()BV242_2-14:
if ({t: SR.01.01.07.01, r: R0800, c: C0010, z: Z0001} = [s2c_CN:x1]) then {t: SR.12.01.01.01, r: R0200, c: C0150, z: Z0001} = {t: SR.12.01.01.01, r: R0200, c: C0020, z: Z0001} + {t: SR.12.01.01.01, r: R0200, c: C0030, z: Z0001} + {t: SR.12.01.01.01, r: R0200, c: C0060, z: Z0001} + {t: SR.12.01.01.01, r: R0200, c: C0090, z: Z0001} + {t: SR.12.01.01.01, r: R0200, c: C0100, z: Z0001} else true()BV242_2-15:
if ({t: SR.01.01.07.01, r: R0800, c: C0010, z: Z0001} = [s2c_CN:x1]) then {t: SR.12.01.01.01, r: R0130, c: C0150, z: Z0001} = {t: SR.12.01.01.01, r: R0130, c: C0020, z: Z0001} + {t: SR.12.01.01.01, r: R0130, c: C0030, z: Z0001} + {t: SR.12.01.01.01, r: R0130, c: C0060, z: Z0001} + {t: SR.12.01.01.01, r: R0130, c: C0090, z: Z0001} + {t: SR.12.01.01.01, r: R0130, c: C0100, z: Z0001} else true()BV242_2-16:
if ({t: SR.01.01.07.01, r: R0800, c: C0010, z: Z0001} = [s2c_CN:x1]) then {t: SR.12.01.01.01, r: R0110, c: C0150, z: Z0001} = {t: SR.12.01.01.01, r: R0110, c: C0020, z: Z0001} + {t: SR.12.01.01.01, r: R0110, c: C0030, z: Z0001} + {t: SR.12.01.01.01, r: R0110, c: C0060, z: Z0001} + {t: SR.12.01.01.01, r: R0110, c: C0090, z: Z0001} + {t: SR.12.01.01.01, r: R0110, c: C0100, z: Z0001} else true()BV242_2-17:
if ({t: SR.01.01.07.01, r: R0800, c: C0010, z: Z0001} = [s2c_CN:x1]) then {t: SR.12.01.01.01, r: R0100, c: C0150, z: Z0001} = {t: SR.12.01.01.01, r: R0100, c: C0020, z: Z0001} + {t: SR.12.01.01.01, r: R0100, c: C0030, z: Z0001} + {t: SR.12.01.01.01, r: R0100, c: C0060, z: Z0001} + {t: SR.12.01.01.01, r: R0100, c: C0090, z: Z0001} + {t: SR.12.01.01.01, r: R0100, c: C0100, z: Z0001} else true()BV242_2-18:
if ({t: SR.01.01.07.01, r: R0800, c: C0010, z: Z0001} = [s2c_CN:x1]) then {t: SR.12.01.01.01, r: R0020, c: C0150, z: Z0001} = {t: SR.12.01.01.01, r: R0020, c: C0020, z: Z0001} + {t: SR.12.01.01.01, r: R0020, c: C0030, z: Z0001} + {t: SR.12.01.01.01, r: R0020, c: C0060, z: Z0001} + {t: SR.12.01.01.01, r: R0020, c: C0090, z: Z0001} + {t: SR.12.01.01.01, r: R0020, c: C0100, z: Z0001} else true()And 8 more, the same rule on other tables or returns.
Other rules on Content of the submission (SR.01.01)
- Content of the submission and life and health SLT technical provisions: a conditional check (BV243_2)Blocking
- Content of the submission and life and health SLT technical provisions: a conditional check (BV244_2)Blocking
- Content of the submission and life and health SLT technical provisions: a conditional check (BV245_2)Blocking
- The item "Total assets" reported in Balance sheet [RFF/MP/RM] must be equal to the sum of the different items reported above (BV238_2-1)Blocking
- The item "Total assets" reported in Balance sheet [RFF/MP/RM] must be equal to the sum of the different items reported above (BV238_2-2)Blocking
- Content of the submission and life and health SLT technical provisions: a conditional check (BV246_2)Blocking
- Content of the submission and life and health SLT technical provisions: a conditional check (BV247_2)Blocking
- Content of the submission and life and health SLT technical provisions: a conditional check (BV248_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.
