The rule in plain words
The item "Type 1 exposures, Code and type of code of single name exposure" (IRR.26.02.01.01 R0100 C0030) is not in a valid format: it should be LEI/ followed by 20 capital letters or digits (a valid LEI), SC/ followed by a code, LSY/ followed by four digits, or left empty
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
Solvency capital requirement - counterparty default risk - basic information (IRR.26.02.01.01)
Rows
- R0100Type 1 exposures
- R0110Single name exposure 1
- R0120Single name exposure 2
- R0130Single name exposure 3
- R0140Single name exposure 4
- R0150Single name exposure 5
- R0160Single name exposure 6
- R0170Single name exposure 7
- R0180Single name exposure 8
- R0190Single name exposure 9
- R0200Single name exposure 10
- R0300Type 2 exposures
- R0310Receivables from Intermediaries due for more than 3 months
- R0320All type 2 exposures other than receivables from Intermediaries due for more than 3 months
- R0330Diversification within counterparty default risk module
- R0400Total counterparty default risk
Column
- C0030Code and type of code of single name exposure
Solvency capital requirement - counterparty default risk - basic information (IR.26.02.01.01)
Rows
- R0100Type 1 exposures
- R0110Single name exposure 1
- R0120Single name exposure 2
- R0130Single name exposure 3
- R0140Single name exposure 4
- R0150Single name exposure 5
- R0160Single name exposure 6
- R0170Single name exposure 7
- R0180Single name exposure 8
- R0190Single name exposure 9
- R0200Single name exposure 10
- R0300Type 2 exposures
- R0310Receivables from Intermediaries due for more than 3 months
- R0320All type 2 exposures other than receivables from Intermediaries due for more than 3 months
- R0330Diversification within counterparty default risk module
- R0400Total counterparty default risk
Column
- C0030Code and type of code of single name exposure
Which returns it applies to
Line4 Check runs it on annual solo (ARS) return on Bank of England taxonomy 2.2.0. The Bank of England applies it to annual solo (ARS) returns, as a blocking check.
The Bank’s own words and formula
In the Bank of England’s list of validations, word for word:
si1495 doesn't follow "^LEI/[A-Z0-9]{{20}}$", "^SC/.*" or "^LSY/[0-9]{4}$" pattern.
Show the formulaShowHide
The Bank of England's formula. Cells are written as {t: table, r: row, c: column}.
if matches($v0, "^LEI/[A-Z0-9]{20}$") and not(matches($v0, "^LEI/[A-Z0-9]{18}(01|00)$")) then leiChecksum(substring($v0, 5)) else matches($v0, "^SC/.*$") or matches($v0, "^LSY/[0-9]{4}$") or isNull($v0) or matches($v0, "^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 Solvency capital requirement - counterparty default risk (IRR.26.02)
Every Solvency UK rule on IRR.26.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.