The rule in plain words
The item "Identification code and type of code for issuer / borrower" (IR.36.01.01.01 C0060, not a template of this return) is not in a valid format: it should be LEI/ followed by 18 capital letters or digits, then two digits (a valid LEI), SC/ followed by a code, 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.
- 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 (IR.36.01.01.01)
Columns
- C0020Investor/ lender name
- C0050Issuer/ borrower name
- C0100Transaction type
- C0110Transaction Issue date
- C0120Maturity date of transaction
- C0130Currency of transaction
- C0140Contractual amount of transaction/ Transaction price
- C0150Value of collateral/ asset
- C0160Amount of redemptions/ prepayments/ paybacks during reporting period
- C0170Amount of dividends/ interest/ coupon and other payments made during reporting period
- C0180Balance of contractual amount of transaction at reporting date
- C0190Coupon/ Interest rate
IGT - derivatives (IR.36.02.01.01)
Columns
- C0020Investor/ Buyer
- C0050Issuer/ Seller name
- C0100Transaction type
- C0110Transaction Trade date
- C0120Maturity date
- C0130Currency
- C0140Notional amount at transaction date
- C0150Notional amount at reporting date
- C0160Value of collateral
- C0170Use of derivatives (by buyer)
- C0180Identification code and type of code Asset / Liability underlying the derivative
- C0200Counterparty name for which credit protection is purchased
- C0210Swap delivered interest rate (for buyer)
- C0220Swap received interest rate (for buyer)
- C0230Swap delivered currency (for buyer)
- C0240Swap received currency (for buyer)
IGT - cost sharing, contingent liabilities, off BS and other items (IR.36.04.01.01)
Columns
- C0020Investor/ Buyer/ Beneficiary name
- C0050Issuer/ Seller/ Provider name
- C0080Transaction type
- C0090Transaction Issue date
- C0100Effective date of agreement/ contract underlying transaction
- C0110Expiry date of agreement/ contract underlying transaction
- C0120Currency of transaction
- C0130Trigger event
- C0140Value of transaction/ collateral / Guarantee
- C0150Maximum possible value of contingent liabilities
- C0160Maximum possible value of contingent liabilities not included in Solvency II Balance Sheet
- C0170Maximum value of letters of credit/ guarantees
- C0180Value of guaranteed assets
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:
dim:ZS doesn't follow "^LEI/[A-Z0-9]{{20}}$" or "^SC/.*" pattern.
Show the formulaShowHide
The Bank of England's formula. Cells are written as {t: table, r: row, c: column}.
if matches(dim($v0,$[s2c_dim:ZS]), "^LEI/[A-Z0-9]{18}[0-9]{2}$") and not(matches(dim($v0,$[s2c_dim:ZS]), "^LEI/[A-Z0-9]{18}(01|00)$")) then leiChecksum(substring(dim($v0,$[s2c_dim:ZS]), 5)) else matches(dim($v0,$[s2c_dim:ZS]), "^SC/.*") or isNull(dim($v0,$[s2c_dim:ZS])) or matches(dim($v0,$[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 (IR.36.01)
Every Solvency UK rule on IR.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.
