The rule in plain words
Double, trailing or leading whitespaces are not allowed
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
Open derivatives: information on positions held (S.08.01.01.01)
Columns
- C0041Unique Transactions Identifier
- C0060Portfolio
- C0080Derivatives held in index-linked and unit-linked contracts
- C0110Use of derivative
- C0131Notional amount of the derivative
- C0140Buyer / Seller
- C0150Premium paid to date
- C0160Premium received to date
- C0170Number of contracts
- C0180Contract size
- C0190Maximum loss under unwinding event
- C0200Swap outflow amount
- C0210Swap inflow amount
- C0220Initial date
- C0230Duration
- C0240Solvency II value
- C0250Valuation method
Open derivatives: information on positions held (S.08.01.04.01)
Columns
- C0010Legal name of the undertaking
- C0041Unique Transactions Identifier
- C0060Portfolio
- C0080Derivatives held in index-linked and unit-linked contracts
- C0110Use of derivative
- C0131Notional amount of the derivative
- C0140Buyer / Seller
- C0150Premium paid to date
- C0160Premium received to date
- C0170Number of contracts
- C0180Contract size
- C0190Maximum loss under unwinding event
- C0200Swap outflow amount
- C0210Swap inflow amount
- C0220Initial date
- C0230Duration
- C0240Solvency II value
- C0250Valuation method
Which returns it applies to
Line4 Check runs it on quarterly solo (QRS), quarterly group (QRG) and quarterly branch (QRB) 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:XB]},[s2c_dim:XB]), "((^\s)|(\s\s)|(\s$))+"))Other rules on Open derivatives (S.08.01)
- The item "Maximum loss under unwinding event" in Open Derivatives must be reported for credit derivatives (CIC ##F#) (BV800)Blocking
- Open derivatives: a cell must be left empty (BV801)
- The item "Buyer / Seller" in Open Derivatives must be reported for derivatives other than forwards (CIC ##E#) (BV803)Blocking
- The item "Buyer / Seller" in Open Derivatives should not be reported for forwards (CIC ##E#) (BV804)
- Open derivatives: the format of a code or text (BV805)
- The item "Trigger value" in Open Derivatives is not applicable to interest rate and currency Swaps (CIC '##D3') (BV807)
- Open derivatives: a cell must be left empty (BV808)Blocking
- Open derivatives: a cell must be left empty (BV809)Blocking
Every Solvency II rule on S.08.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.
