The rule in plain words
Column Year must follow "yyyy" pattern
What to do if your return fails it
- 01Open the tables below and find the cells the rule reads.
- 02Compare the code or text in your return with the format the rule sets out, character by character, including any prefix and any spaces.
- 03This is a blocking check. A return that fails it is normally rejected, so fix it before you submit.
The cells it reads
Catastrophe data - loss data: insurance loss data - reporting for direct business (S.27.02.01.01)
Columns
- C0060Gross loss
- C0070Number of claims
- C0071Number of claims reported closed without payment
- C0072Number of claims reported closed with payment
Catastrophe data - loss data: reinsurance loss data - reporting for gross direct business (S.27.02.01.02)
Columns
- C0080Non proportional reinsurer’s share - loss
- C0090Proportional reinsurer’s share - loss
Catastrophe data - loss data: reinsurance loss data - reporting for reinsurance business (S.27.02.01.03)
Columns
- C0100Non proportional reinsurance accepted: loss - All asset
- C0110Proportional reinsurance accepted: loss - All asset
- C0120Retrocession's share: loss - All asset type
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}.
matches(dim({d: [s2c_dim:NH]},[s2c_dim:NH]), "^\d{4}$")Other rules on Catastrophe data - loss data (S.27.02)
- Items "Number of claims reported closed without payment" and "Number of claims reported closed with payment" should be reported (BV2186)
- Items "Gross loss" and "Number of claims" must be reported (BV2185)Blocking
- Catastrophe data - loss data: number of claims reported closed with payment cannot be reported as a negative number (BV2183)Blocking
- Catastrophe data - loss data: number of claims reported closed without payment cannot be reported as a negative number (BV2182)Blocking
- Catastrophe data - loss data: number of claims cannot be reported as a negative number (BV2181)Blocking
- Catastrophe data - loss data: gross loss cannot be reported as negative amount (BV2180)Blocking
- Catastrophe data - loss data: values reported in Reinsurance loss data template must be greater than or equal zero (BV2533)Blocking
- Items "Non proportional reinsurer’s share - loss" and "Proportional reinsurer’s share - loss" must be reported (BV2534)Blocking
Every Solvency II rule on S.27.02
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.