The rule in plain words
The item "Reinsurer identification code and type of code" (IR.30.04.01.01 C0050) 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, left empty, or LSY/ followed by four digits
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
Non-life outwards reinsurance contract reinsurer exposures (IR.30.04.01.01)
Columns
- C0100Share reinsurer (%)
- C0110Exposure ceded for reinsurer's share per risk or event
- C0120Type of collateral (if applicable)
- C0160Estimated outwards reinsurance premium for reinsurer's share
- C0170Annotations
- C0180Exposure ceded for reinsurer's share per contract
- C0190Value of collateral
- C0200Transaction with related party on an arms-length basis
Life outwards proportional reinsurance (IR.30.07.01.01)
Columns
- C0040Reinsured benefit / value of benefits (excluding longevity swaps)
- C0050Value of annuity premiums / payments to reinsurer
- C0060Value of annuity claims / payments from reinsurer
Life outwards non-proportional reinsurance (IR.30.08.01.01)
Columns
- C0040Cover event
- C0050Gross benefit for business covered
- C0060Amount of reinsurance cover
- C0070Lower threshold claims ratio
- C0080Upper threshold claims ratio
- C0090Proportion reinsured between thresholds
- C0100Annual premium
Outwards reinsurance balance sheet exposures (IR.31.01.01.01)
Columns
- C0060Reinsurance recoverables: Premium provision Non-life including Non-SLT Health
- C0070Reinsurance recoverables: Provision for claims outstanding Non-life including Non-SLT Health
- C0080Reinsurance recoverables: Technical provisions Life including SLT Health
- C0090Adjustment for expected losses due to counterparty default
- C0100Reinsurance recoverables: Total reinsurance recoverables
- C0110Net receivables
- C0120Asset arrangements as collateral to support the reinsurer exposure
- C0130Financial guarantees as collateral to support the reinsurer exposure
- C0140Cash deposits
- C0150Total guarantees / collateral in place
- C0160Reinsurance receivables - Non-life and life claims debts past due
- C0170Reinsurance receivable - Non-life and life Commissions and Premiums debts
- C0180Reinsurance recoverables in dispute
- C0190Reinsurance recoverables written-off
- C0200The reinsurer’s share of premiums written
- C0210Supporting comments
Outwards reinsurance balance sheet exposures (IR.31.01.04.01)
Columns
- C0010Legal name of reinsured undertaking
- C0060Reinsurance recoverables: Premium provision Non-life including Non-SLT Health
- C0070Reinsurance recoverables: Provision for claims outstanding Non-life including Non-SLT Health
- C0080Reinsurance recoverables: Technical provisions Life including SLT Health
- C0090Adjustment for expected losses due to counterparty default
- C0100Reinsurance recoverables: Total reinsurance recoverables
- C0110Net receivables
- C0120Asset arrangements as collateral to support the reinsurer exposure
- C0130Financial guarantees as collateral to support the reinsurer exposure
- C0140Cash deposits
- C0150Total guarantees / collateral in place
- C0160Reinsurance receivables - Non-life and life claims debts past due
- C0170Reinsurance receivable - Non-life and life Commissions and Premiums debts
- C0180Reinsurance recoverables in dispute
- C0190Reinsurance recoverables written-off
- C0200The reinsurer’s share of premiums written
- C0210Supporting comments
Which returns it applies to
Line4 Check runs it on 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 annual third-country branch (ARB), annual solo (ARS) 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:RF 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(dim($v0,$[s2c_dim:RF]), "^LEI/[A-Z0-9]{18}[0-9]{2}$") and not(matches(dim($v0,$[s2c_dim:RF]), "^LEI/[A-Z0-9]{18}(01|00)$")) then leiChecksum(substring(dim($v0,$[s2c_dim:RF]), 5)) else matches(dim($v0,$[s2c_dim:RF]), "^SC/.*") or isNull(dim($v0,$[s2c_dim:RF])) or matches(dim($v0,$[s2c_dim:RF]), "^LSY/[0-9]{4}$") or matches(dim($v0,$[s2c_dim:RF]), "^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 Non-life outwards reinsurance contract reinsurer exposures (IR.30.04)
- Non-life outwards reinsurance contract reinsurer exposures: if C0120 = hierarchy option 5 then C0190 = 0 (IR_bv2638)Blocking
- Non-life outwards reinsurance contract reinsurer exposures and 3 other templates: the format of a code or text (IR_bv2641)Blocking
- Reinsurer/collateral identifier in IR.30.05 (C0010) must be also present in either IR.30.04 (C0050 or C0140) OR IR.31.01 (C0040) (IR_bv2643)Blocking
- Non-life outwards reinsurance contract reinsurer exposures and reinsurer and collateral provider entity information: a conditional check (IR_bv0059_01)Blocking
- Non-life outwards reinsurance contract reinsurer exposures and reinsurer and collateral provider entity information: a conditional check (IR_bv0059_04)Blocking
- Non-life outwards reinsurance contract reinsurer exposures and reinsurer and collateral provider entity information: a conditional check (IR_bv0056)Blocking
- If "type of collateral" (C0120) is report as 5 - None then the value of collateral (C0190) should be zero (IR_bv0055_01)Blocking
- If the value of collateral (C0190) is zero then "type of collateral" (C0120) should be reported as 5 - None (IR_bv0055_02)Blocking
Every Solvency UK rule on IR.30.04
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.
