The rule in plain words
dim:CE doesn't follow "^LEI/[A-Z0-9]{{20}}$" or "^SC/.*" pattern
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.
- 03This is a blocking check. A return that fails it is normally rejected, so fix it before you submit.
The cells it reads
Basic information - RFF and matching adjustment portfolios: list of all RFF/MAP (overlaps allowed) (S.01.03.04.01)
Columns
- C0010Legal name of the undertaking
- C0050Name of ring-fenced fund/Matching adjustment portfolio
- C0060RFF/MAP/Remaining part of a fund
- C0070RFF/MAP with sub RFF/MAP
- C0080Material
- C0090Article 304
List of assets: information on positions held (S.06.02.04.01)
Columns
- C0010Legal name of the undertaking
- C0060Portfolio
- C0090Asset held in unit linked and index linked contracts
- C0100Asset pledged as collateral
- C0110Country of custody
- C0130Quantity
- C0140Par amount
- C0145Long-term equity investment
- C0150Valuation method
- C0160Acquisition value
- C0170Total Solvency II amount
- C0180Accrued interest
Structured products (S.07.01.04.01)
Columns
- C0010Legal name of the undertaking
- C0060Collateral type
- C0070Type of structured product
- C0080Capital protection
- C0090Underlying security/index/portfolio
- C0100Callable or Putable
- C0110Synthetic structured product
- C0120Prepayment structured product
- C0130Collateral value
- C0140Collateral portfolio
- C0150Fixed Annual Return
- C0160Variable Annual Return
- C0170Loss given default
- C0180Attachment point
- C0190Detachment point
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
Information on gains/income and losses in the period (S.09.01.04.01)
Columns
- C0010Legal name of the undertaking
- C0040Asset category
- C0050Portfolio
- C0060Asset held in unit-linked and index-linked contracts
- C0070Dividends
- C0080Interest
- C0090Rent
- C0100Net gains and losses
- C0110Unrealised gains and losses
Securities lending and repos (S.10.01.04.01)
Columns
- C0010Legal name of the undertaking
- C0040Portfolio
- C0060Asset category
- C0070Counterparty Name
- C0080Counterparty code and type of code
- C0100Counterparty asset category
- C0110Assets held in unit-linked and index-linked contracts
- C0120Position in the Contract
- C0130Near leg amount
- C0140Far leg amount
- C0150Start date
- C0160Maturity date
- C0170Solvency II Value
Assets held as collateral: information on positions held (S.11.01.04.01)
Columns
- C0010Legal name of the undertaking
- C0060Name of counterparty pledging the collateral
- C0070Name of the group of the counterparty pledging the collateral
- C0080Country of custody
- C0090Quantity
- C0100Par amount
- C0110Valuation method
- C0120Total amount
- C0130Accrued interest
- C0140Type of asset for which the collateral is held
Liquidity risk for life business: portfolio detail (S.14.04.11.02)
Columns
- C0070Total amount of claims paid (year to date)
- C0074Administrative expenses
- C0180Best Estimate
- C0200Total amount of surrenders
- C0270Exit conditions at reporting date
- C0290Cash in-flows - Premiums - gross (year to date)
- C0300Net Reinsurance flows of the period (year to date)
Liquidity risk for non-life business: portfolio detail (S.14.05.11.02)
Columns
- C0070Total amount of claims paid (year to date)
- C0180Best Estimate
- C0290Cash in-flows - Premiums - gross (year to date)
- C0300Net Reinsurance flows of the period (year to date)
- C0310Unearned premium returned upon termination (year to date)
Share of reinsurers (including finite reinsurance and SPV's): share of reinsurers (S.31.01.04.01)
Columns
- C0010Legal name of reinsured undertaking
- C0060Reinsurance recoverables: Premium provision Non-life including Non-SLT Health
- C0070Reinsurance recoverables: Claims provisions Non-life including Non-SLT Health
- C0080Reinsurance recoverables: Technical provisions Life including SLT Health
- C0090Adjustment for expected losses due to counterparty default
- C0100Reinsurance recoverables: Total reinsurance recoverables
- C0110Net receivables
- C0120Assets pledged by reinsurer
- C0130Financial guarantees
- C0140Cash deposits
- C0150Total guarantees received
Special purpose vehicles (S.31.02.04.01)
Columns
- C0010Legal name of reinsured undertaking
- C0070Type of Trigger(s) in the SPV
- C0080Contractual trigger event
- C0090Same trigger as in underlying cedant's portfolio?
- C0100Basis risk arising from risk-transfer structure
- C0110Basis risk arising from contractual terms
- C0120SPV assets ring-fenced to settle cedant-specific obligations
- C0130Other non cedant-specific SPV Assets for which recourse may exist
- C0140Other recourse arising from securitisation
- C0150Total maximum possible obligations from SPV under reinsurance policy
- C0160SPV fully funded in relation to cedant obligations throughout the reporting period
- C0170Current recoverables from SPV
- C0180Identification of material investments held by cedant in SPV
- C0190Securitisation assets related to cedant held in trust with other third party than cedant / sponsor?
Undertakings in the scope of the group (S.32.01.04.01)
Columns
- C0010Country
- C0040Legal Name of the undertaking
- C0050Type of undertaking
- C0060Legal form
- C0070Category (mutual/non mutual)
- C0080Supervisory Authority
- C0090Total Balance Sheet (for (re)insurance undertakings)
- C0100Total Balance Sheet (for other regulated undertakings)
- C0110Total Balance Sheet (non-regulated undertakings)
- C0120Written premiums net of reinsurance ceded under IFRS or local GAAP for (re)insurance undertakings
- C0130Turn over defined as the gross revenue under IFRS or local GAAP for other types of undertakings, insurance holding companies or mixed financial holding companies
- C0140Underwriting performance
- C0150Investment performance
- C0160Total performance
- C0170Accounting standard
- C0180% capital share
- C0190% used for the establishment of consolidated accounts
- C0200% voting rights
- C0210Other criteria
- C0220Level of influence
- C0230Proportional share used for group solvency calculation
- C0240Yes/No
- C0250Date of decision if art. 214 is applied
- C0260Method used and under method 1, treatment of the undertaking
- C0270Covered by internal model for Group SCR calculations
- C0280Type of VA being used in the group internal model
Insurance and reinsurance individual requirements (S.33.01.04.01)
Columns
- C0010Legal name of the undertaking
- C0060SCR Market Risk
- C0070SCR Counterparty Default Risk
- C0080SCR Life Underwriting Risk
- C0090SCR Health Underwriting Risk
- C0100SCR Non-life Underwriting Risk
- C0110SCR Operational Risk
- C0120Individual SCR
- C0130Individual MCR
- C0140Eligible Individual Own Funds to cover the SCR
- C0150Use of undertaking specific parameters
- C0160Use of simplifications
- C0170Use of Partial Internal Model
- C0180Group or individual internal model
- C0190Date of initial approval of IM
- C0200Date of approval of latest major change of IM
- C0210Date of decision of capital add-on
- C0220Amount of capital add-on
- C0230Reason of capital add-on
- C0240Local capital requirement
- C0250Local minimum capital requirement
- C0260Eligible own funds in accordance with local rules
- C0270Contribution of solo SCR to the group SCR
Other regulated and non-regulated financial undertakings including insurance holding companies and mixed financial holding company individual requirements (S.34.01.04.01)
Columns
- C0010Legal name of the undertaking
- C0040Aggregated or not
- C0050Type of capital requirement
- C0060Notional SCR or Sectoral capital requirement
- C0070Notional MCR or Sectoral minimum capital requirement
- C0080Notional or Sectoral Eligible Own Funds
- C0085Contribution of solo (notional) SCR to the group SCR
Contribution to group technical provisions (S.35.01.04.01)
Columns
- C0040Method of group solvency calculation used
- C0050Amount of TP gross of IGT
- C0060Amount of TP net of IGT
- C0070Amount of TP gross of IGT
- C0080Amount of TP net of IGT
- C0090Net contribution to Group TP (%)
- C0100Amount of TP gross of IGT
- C0110Amount of TP net of IGT
- C0120Net contribution to Group TP (%)
- C0130Amount of TP gross of IGT
- C0140Amount of TP net of IGT
- C0150Net contribution to Group TP (%)
- C0160Amount of TP gross of IGT
- C0170Amount of TP net of IGT
- C0180Net contribution to Group TP (%)
- C0190Amount of TP gross of IGT
- C0200Amount of TP net of IGT
- C0210Net contribution to Group TP (%)
- C0220Amount of TP gross of IGT
- C0230Amount of TP net of IGT
- C0240Amount of TP gross of IGT
- C0250Amount of TP gross of IGT
- C0260Amount of TP gross of IGT
Risk concentration - exposure to counterparties: risk concentration - exposure to counteparties (S.37.01.04.01)
Columns
- C0010Name of the external counterparty
- C0040Country
- C0045Name of the group (in case of group of counterparties)
- C0080Rating
- C0090Nominated ECAI
- C0100Sector
- C0110Entity of the group
- C0150Total amount of the exposure
- C0160Currency
- C0180Equity
- C0190Bonds
- C0200Assets whose risks are mainly borne by the policyholders
- C0210Derivatives
- C0220Other investments
- C0230Loans and mortgages
- C0240Guarantees and Commitments
- C0250Insurance policies
- C0260External reinsurance
- C0270Others direct exposures
- C0280Description of others
- C0290Indirect exposures
- C0300Transactions where there is an exposure to underlying assets
- C0310Credit or insurance risk mitigation technique
- C0320Exemptions
- C0330Amount of the exposures after Credit or insurance risk mitigation technique and exemptions
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}.
if matches(dim({d: [s2c_dim:CE]},[s2c_dim:CE]), "^LEI/[A-Z0-9]{18}[0-9]{2}$") and not(matches(dim({d: [s2c_dim:CE]},[s2c_dim:CE]), "^LEI/[A-Z0-9]{18}(01|00)$")) then leiChecksum(substring(dim({d: [s2c_dim:CE]},[s2c_dim:CE]), 5)) else matches(dim({d: [s2c_dim:CE]},[s2c_dim:CE]), "^SC/.*") or isNull(dim({d: [s2c_dim:CE]},[s2c_dim:CE])) or matches(dim({d: [s2c_dim:CE]},[s2c_dim:CE]), "^LEI/(029200720E3M3A4D6D01|029200758D5M0AI3F601|315700X8JQ3IU0NGK501|3157007SCCESQAUH5Z01|315700TCC9NTEP7J8Z01|13250000000000000301|315700ADOXDR5PCY5400|315700A0UB9Q7DOQIZ00|315700BM9Z39TNTGQW00|315700BZ5F7DRYG2UM00|315700B8401GTFFY6X01|315700DJ07P6OX10FK01|315700DKCD4QSKLAMO01|315700D23JL5C1DZNT00|315700EIYO2TLSEGQ700|315700ET7M7VQ4C84R00|315700EZSEA51937KX01|315700GXBGM8DBYKHF01|315700GZA843JXKTJ400|315700G5G24XYL1TXH00|315700HS7WJ1B0SUWM01|315700HXOEOK58E58P01|315700HZU4SMI8LZTU00|315700I3W2AFHP8MNQ01|315700JICZ3SY5SAXX00|315700JKZH6I0067ND01|315700JO5E28SRE00Q01|315700JXUHL9H2C3P700|315700LDDN3RM7Y2MP00|315700LWYOZNQ7V1T100|315700MBYPT6PGKO7M01|315700MW2F0KFR45QW01|315700M5843O6DU83901|315700NNMGS8F3P2CN00|315700N0VEIBHP0NPQ01|315700OASRCM664PAW01|315700OFW4YCOBNX4U01|315700OVW93X0T3HP200|315700O666JVNCQU9X00|315700PLI0I7W8IOV400|315700PN3J57ZUNF1V00|315700PXKOSX7WQV4N00|315700P4N9VSLK5QZV01|315700P40OV6BT045900|315700P6TZOLP92KN801|315700P89WR82VNB8Z00|315700QGM4XWZE1I5N01|315700Q1S8O1UORF9700|315700RK8M4FAHMYAP01|315700RTEHY362KXWJ00|315700SNUXK41WMW5J00|315700S22RGYRIEEOT00|315700S3TF79ALV82F01|315700TF5Z7T28HZJK01|315700TWGZ89LLSRS000|315700TXNX10N8XH4K00|315700T2EEQAPBO0C301|315700T6T49EDM16YO01|315700UJ6N4LGKLNPB00|315700UKZXWXEO126601|315700UYFD5GF9R13F01|315700VG7PTE9EJJRX01|315700VITYR7AL4M9S01|315700VMAJZ9JZTXNQ00|315700WH3YMKHCVYW201|315700WKCDF4QGRRO200|315700WR4IHOO1M5LP00|315700WYOZ6994UATN00|315700WZPEIS41QDKE00|315700XEFYMA5EZ0P500|315700XE21UYOA3GAC01|315700XI4Z8GF5BDUJ01|315700XSCP1S8WOD8E01|315700X40GNCOUWJYR00|315700YS6RQ5TF3VBP01|315700Y1W7W1JHAUBW00|315700Y5JNQMMUF5ID01|3157000VAJWZ3P8ZED00|3157001KM8GOU7PXZY01|3157001K2LAL04D87901|3157001MLDD3SDFQA901|3157001TPR6K4GBTLN00|31570010000000006400|31570010000000009601|31570010000000019301|31570010000000025800|31570010000000029001|31570010000000035500|31570010000000038701|31570010000000045200|31570010000000048401|31570010000000054900|31570010000000064600|31570010000000067801|31570010000000077501|31570010000000084000|31570010000000087201|31570010000000096901|31570010000000103400|31570010000000106601|31570010000000116301|31570010000000122800|31570010000000126001|3157002CKDQOCIHE5H01|31570020000000005900|31570029808HJVCNFA01|3157003FQSSGS9OZ9E01|3157004PTVTDOKB46401|3157004R6CH6C1P4KX00|3157005RUI28M8FANK00|3157005VJE7A3MBUS201|3157005WT1SENAE17R00|31570058O0Z320C4GZ00|3157006B6JVZ5DFMSN00|3157006DE3SPNIUY9K01|3157006FR3JBBOLOMX01|3157006I3B6RSTPQLI00|3157006KT1EZ15OIXW00|315700659AALVVLVIO01|31570067WSCDST0S3F01|3157008VKYORMUNC5O01|3157008ZY7CW6LVU5J00|3157009FTHFDDK7FHW01|3157009OVCV07O4HXM00|315700T8U7IU4W8J3A01|315700BBRQHDWX6SHZ00|3157008KD17KROO7UT01)$")Other rules on List of assets (S.06.02)
- "Asset ID Code and Type of code" (S.06.02.01.02 C0040) does not follow correct ISIN pattern "^ISIN/[A-Z0-9]{12}$" (BV1237)Blocking
- The item "Issuer Code and Type of code" (S.06.02.01.02 C0210) does not follow LEI ("^LEI/[A-Z0-9]{18}[0-9]{2}$") or "^None$" pattern (BV1240)Blocking
- List of assets and assets held as collateral: the format of a code or text (BV1241)Blocking
- Item “Issuer Code” should be reported at least for items with CIC codes different from '##71', '##75', '##87', '##88', '##9#' or '##09' (BV1217)
- Item “Par amount ” should not be reported for items with CIC like '##71' or '##9#' (BV1215)
- Item “Quantity ” should not be reported for items with CIC like '##71' or '##9#' (BV1214)
- List of assets: values to report together, or not at all (BV1212)
- List of assets and 2 other templates: the format of a code or text (BV1250)Blocking
Every Solvency II rule on S.06.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.
