The rule in plain words
The item "Entity identification code and type of code" (IR.01.02.01.01 R0025 C0010) is not in a valid format: it should be LEI/ followed by 20 capital letters or digits (a valid LEI), LSY/ followed by four digits, or SC/ followed by a code
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
Basic information - general (IR.01.02.01.01)
Row
- R0025Entity identification code and type of code
Column
- C0010c
Basic information - general (IR.01.02.04.01)
Row
- R0025Entity identification code and type of code
Column
- C0010c
Basic information - general (IR.01.02.07.01)
Row
- R0025Entity identification code and type of code
Column
- C0010c
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:
si1899 doesn't follow "^LEI/[A-Z0-9]{{20}}$", "^LSY/[0-9]{4}$" or "^SC/.*" 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, "^LSY/[0-9]{4}$") or matches($v0, "^SC/.*") 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 Basic information - general (IR.01.02)
- Basic information - general: a total must equal the sum of its parts (IR_bv1718)Blocking
- Basic information - general: there is at least one monetary fact reported in reporting currency not matching basic information data (IR_bv1706)Blocking
- Basic information - general and impact of long term guarantees measures and transitionals: a conditional check (IR_bv1737_01)Blocking
- Basic information - general and impact of long term guarantees measures and transitionals: a conditional check (IR_bv1737_02)Blocking
- Basic information - general and impact of long term guarantees measures and transitionals: a conditional check (IR_bv1738)Blocking
- Basic information - general and impact of long term guarantees measures and transitionals: a conditional check (IR_bv1739_01)Blocking
- Basic information - general and impact of long term guarantees measures and transitionals: a conditional check (IR_bv1739_02)Blocking
- Basic information - general and impact of long term guarantees measures and transitionals: a conditional check (IR_bv1740)Blocking
Every Solvency UK rule on IR.01.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.