The rule in plain words
Double, trailing or leading whitespaces are not allowed
This is a blocking check. A return that fails it is normally rejected, so fix it before you submit.
The cells it reads
Life obligations analysis: portfolio product (S.14.01.01.05)
Columns
- C0060Total amount of Written premiums
- C0061of which: written directly by the insurance undertaking
- C0062of which: written via credit institutions
- C0063of which: written via other insurance distributors
- C0070Total amount of claims paid during year
- C0071Total amount of commissions due during year
- C0075Expected future premiums
- C0077Expected future commissions
- C0180Best Estimate and Technical Provisions as a whole
- C0190Capital-at-risk
- C0200Surrender value
- C0260Annualised guaranteed rate (over average duration of guarantee)
- C0261Yearly interest rate guarantee for the reporting year
- C0280Amount on which interest rate is guaranteed
Which returns it applies to
Line4 Check runs it on quarterly solo (QRS), quarterly group (QRG), quarterly branch (QRB), annual solo (ARS), annual group (ARG), annual branch (ARB), financial stability solo (QFS), financial stability group (QFG) and financial stability branch (QFB) returns on EIOPA taxonomy 2.10.0. EIOPA applies it to quarterly ECB branch (QEB), quarterly ECB solo (QES), annual branch (ARB), annual solo (ARS), financial stability group (QFG), quarterly group (QRG), financial stability solo (QFS), financial stability branch (QFB), quarterly branch (QRB), quarterly solo (QRS), annual ECB solo (AES), annual ECB branch (AEB) and annual group (ARG) returns, as a blocking check.
EIOPA’s own words and formula
The plain words above are EIOPA’s own, word for word, from its list of validations.
Show the formulaShowHide
EIOPA's formula. Cells are written as {t: table, r: row, c: column}.
not(matches(dim({d: [s2c_dim:NK]},[s2c_dim:NK]), "((^\s)|(\s\s)|(\s$))+"))Other rules on Life obligations analysis (S.14.01)
- The item "number of contracts at the end of the year" reported in table Life obligations analysis must be positive (BV837)Blocking
- The item "number of new contracts during year" reported in table Life obligations analysis must be positive (BV838)Blocking
- Life obligations analysis: a conditional check (BV1034)
- Items "Line of Business" and "Country" should always be provided (BV1592)
- Items "Pension entitlements", "Type of product", "Product denomination" and "Product still commercialised?" should always be provided (BV1593)
- Life obligations analysis: a value must not be less than another (BV1995)
- Life obligations analysis: a total must equal the sum of its parts (BV1996)
- Life obligations analysis: a conditional check (BV2584)
Every Solvency II rule on S.14.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.