The rule in plain words
The item "Counterparty group code and type of code" (S.08.01.01.02 C0340) does not follow LEI ("^LEI/[A-Z0-9]{18}[0-9]{2}$"), "^SC/.*" pattern, or "^None$" in case of natural persons
The headline gives only the template and the kind of check, because the rule is too long to say in a headline. The plain words above say all of it.
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 derivatives (S.08.01.01.02)
Column
- C0340Counterparty group code and type of code
Open derivatives: information on derivatives (S.08.01.04.02)
Column
- C0340Counterparty group code and type of code
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), quarterly branch (QRB), quarterly solo (QRS), annual branch (ARB), annual solo (ARS), annual ECB solo (AES), annual ECB branch (AEB), quarterly group (QRG) and annual group (ARG) returns, as a blocking check.
EIOPA’s own words and formula
In EIOPA’s list of validations, word for word:
si1559 doesn't follow LEI ("^LEI/[A-Z0-9]{{18}}[0-9]{{2}}$"), "^SC/.*" pattern, or "^None$" in case of natural persons.
Show the formulaShowHide
EIOPA's formula. Cells are written as {t: table, r: row, c: column}.
if matches({ m: [s2md_met:si1559]}, "^LEI/[A-Z0-9]{18}[0-9]{2}$") and not(matches({ m: [s2md_met:si1559]}, "^LEI/[A-Z0-9]{18}(01|00)$")) then leiChecksum(substring({ m: [s2md_met:si1559]}, 5)) else matches({ m: [s2md_met:si1559]}, "^SC/.*") or matches({ m: [s2md_met:si1559]}, "^None$") or matches({ m: [s2md_met:si1559]}, "^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 Open derivatives (S.08.01)
- Open derivatives: the format of a code or text (BV1233)Blocking
- Open derivatives: the format of a code or text (BV1269)Blocking
- There is at least one derivative reported in Table 1 of S.08.01 that is not reported in Table 2 of S.08.01 (BV1282)Blocking
- There is at least one derivative reported in Table 1 of S.08.01 that is not reported in Table 2 of S.08.01 (BV1283)Blocking
- Open derivatives: the first two letters are not valid ISO3166 country code (BV1148)Blocking
- Item "Use of derivative" and "Unique Transactions Identifier" in Open Derivatives must be reported (BV1139)Blocking
- Open derivatives: the format of a code or text (BV1385)Blocking
- The item "Contract size" in Open Derivatives should be reported for futures and options (CIC '##A#' or '##B#' or '##C#' or ‘##F2’) (BV1071)
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.