The rule in plain words
The item "Issuer Group Code and Type of code" (IR.06.02.01.02 C0250) is not in a valid format: it should be LEI/ followed by 20 capital letters or digits (a valid LEI) or "None"
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
Business model analysis - financial guarantee insurers: exposures (IR.05.07.01.01)
Column
- C0090Issuer Group Code
List of assets - information on assets (IR.06.02.01.02)
Column
- C0250Issuer Group Code and Type of code
List of assets - information on assets (IR.06.02.04.02)
Column
- C0250Issuer Group Code and Type of code
Assets held as collateral - information on assets (IR.11.01.01.02)
Column
- C0210Issuer Group Code and Type of code
Assets held as collateral - information on assets (IR.11.01.04.02)
Column
- C0210Issuer Group Code and Type of code
Which returns it applies to
Line4 Check runs it on quarterly solo (QRS), quarterly group (QRG), annual solo (ARS), annual group (ARG) and annual third-country branch (ARB) returns on Bank of England taxonomy 2.2.0. The Bank of England applies it to quarterly solo (QRS), annual third-country branch (ARB), annual solo (ARS), quarterly group (QRG) and annual group (ARG) returns, as a blocking check.
The Bank’s own words and formula
In the Bank of England’s list of validations, word for word:
si1553 doesn't follow "^LEI/[A-Z0-9]{{20}}$" or "^None" 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, "^None$") 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 List of assets (IR.06.02)
- List of assets and 2 other templates: the format of a code or text (IR_bv1709)Blocking
- List of assets and 10 other templates: a conditional check (IR_bv1714)Blocking
- The item "CIC" reported in List of assets is not valid (IR_bv1704)Blocking
- The item "CIC" reported in List of assets is not valid (IR_bv1701)Blocking
- List of assets: the format of a code or text (IR_bv1721)
- There is at least one security reported in Table 1 of IR.06.02 that is not reported in Table 2 of IR.06.02 (IR_bv1727)Blocking
- The item "Temporary identifier for country 3" must not be reported (IR_bv1692)Blocking
- The item "Temporary identifier for country 2" must not be reported (IR_bv1691)Blocking
Every Solvency UK rule on IR.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.