The rule in plain words
dim:ZS 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
IGT - equity-type transactions, debt and asset transfer (S.36.01.01.01)
Columns
- C0020Investor/ lender name
- C0050Issuer/ borrower name
- C0200Coupon/ interest rate
- C0210Comments
- NC0040Sector of the investor / lender
- NC0070Sector of the issuer / borrower
- NC0080Indirect transactions
- NC0090Single economic operation
- NC0110Type of instrument
- NC0120Instrument
- NC0130Issue date
- NC0140Maturity date
- NC0150Currency of transaction
- NC0160Amount at transaction date
- NC0170Amount at reporting date
- NC0180Value of collateral
- NC0190Amount of dividends/ interest/coupon and other payments made during the period
IGT - derivatives (S.36.02.01.01)
Columns
- C0020Investor/ Buyer name
- C0050Issuer/ Seller name
- C0250Swap received currency (for buyer)
- C0260Revenues stemming from derivatives
- C0270Comments
- NC0040Sector of the investor / buyer
- NC0070Financial sector of the issuer / seller
- NC0080Indirect transactions
- NC0090Single economic operation
- NC0110Type of instrument
- NC0120Type of protection
- NC0130Purpose of the instrument
- NC0140Starting date
- NC0150Maturity date
- NC0160Currency of transaction
- NC0170Notional amount
- NC0180Carrying amount
- NC0190Value of collateral
- NC0200Identification code and type of code Asset / Liability underlying the derivative
- NC0210Counterparty name for which credit protection is purchased
- NC0220Swap delivered interest rate (for buyer)
- NC0230Swap received interest rate (for buyer)
- NC0240Swap delivered currency (for buyer)
IGT - off-balance sheet and contingent liabilities (S.36.06.01.01)
Columns
- C0020Provider name
- C0040Financial sector of the provider
- C0050Beneficiary name
- C0070Financial sector of the beneficiary
- C0080Indirect transactions
- C0090Single economic operation
- C0100Transaction type
- C0110Transaction issue date
- C0120Expiry date of agreement / contract underlying transaction
- C0130Currency of transaction
- C0140Trigger event
- C0150Value of transaction at starting date
- C0160Value of transaction at reporting date
- C0170Maximum possible value of contingent liabilities
- C0180Value of guaranteed assets
- C0190Revenues stemming from the off-balance sheet items
- C0200Comments
IGT - insurance-reinsurance (S.36.07.01.01)
Columns
- C0020Insured party / Cedent name
- C0040Sector of the insured party / cedent
- C0050Insurer / Reinsurer name
- C0070Sector of the insurer / reinsurer
- C0080Indirect transactions
- C0090Single economic operation
- C0100Type of transaction
- C0110Transaction (for reinsurance)
- C0120Starting date
- C0130Expiry date
- C0140Currency of transaction (for reinsurance)
- C0150Maximum cover by transaction (for reinsurance)
- C0160Net receivables
- C0170Total reinsurance recoverables
- C0180Reinsurance technical result (for reinsurance)
- C0190Premiums (for insurance)
- C0200Claims (for insurance)
- C0210Line of business
- C0220Comments
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:ZS]},[s2c_dim:ZS]), "^LEI/[A-Z0-9]{18}[0-9]{2}$") and not(matches(dim({d: [s2c_dim:ZS]},[s2c_dim:ZS]), "^LEI/[A-Z0-9]{18}(01|00)$")) then leiChecksum(substring(dim({d: [s2c_dim:ZS]},[s2c_dim:ZS]), 5)) else matches(dim({d: [s2c_dim:ZS]},[s2c_dim:ZS]), "^SC/.*") or isNull(dim({d: [s2c_dim:ZS]},[s2c_dim:ZS])) or matches(dim({d: [s2c_dim:ZS]},[s2c_dim:ZS]), "^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 IGT - equity-type transactions, debt and asset transfer (S.36.01)
Every Solvency II rule on S.36.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.
