The rule in plain words
dim:OV doesn't follow "^LEI/[A-Z0-9]{20}$" or "^SC/.*" pattern
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
Special purpose vehicles (S.31.02.01.01)
Columns
- C0070Type of Trigger(s) in the SPV
- C0080Contractual trigger event
- C0090Same trigger as in underlying cedant's portfolio?
- C0100Basis risk arising from risk-transfer structure
- C0110Basis risk arising from contractual terms
- C0120SPV assets ring-fenced to settle cedant-specific obligations
- C0130Other non cedant-specific SPV Assets for which recourse may exist
- C0140Other recourse arising from securitisation
- C0150Total maximum possible obligations from SPV under reinsurance policy
- C0160SPV fully funded in relation to cedant obligations throughout the reporting period
- C0170Current recoverables from SPV
- C0180Identification of material investments held by cedant in SPV
- C0190Securitisation assets related to cedant held in trust with other third party than cedant / sponsor?
Special purpose vehicles: information on SPV (S.31.02.01.02)
Columns
- C0220Legal nature of SPV
- C0230Name of SPV
- C0240Incorporation no. of SPV
- C0250SPV country of authorisation
- C0260SPV authorisation conditions
- C0270External rating assessment by nominated ECAI
- C0280Nominated ECAI
- C0290Credit quality step
- C0300Internal rating
Special purpose vehicles (S.31.02.04.01)
Columns
- C0010Legal name of reinsured undertaking
- C0070Type of Trigger(s) in the SPV
- C0080Contractual trigger event
- C0090Same trigger as in underlying cedant's portfolio?
- C0100Basis risk arising from risk-transfer structure
- C0110Basis risk arising from contractual terms
- C0120SPV assets ring-fenced to settle cedant-specific obligations
- C0130Other non cedant-specific SPV Assets for which recourse may exist
- C0140Other recourse arising from securitisation
- C0150Total maximum possible obligations from SPV under reinsurance policy
- C0160SPV fully funded in relation to cedant obligations throughout the reporting period
- C0170Current recoverables from SPV
- C0180Identification of material investments held by cedant in SPV
- C0190Securitisation assets related to cedant held in trust with other third party than cedant / sponsor?
Special purpose vehicles: information on SPV (S.31.02.04.02)
Columns
- C0220Legal nature of SPV
- C0230Name of SPV
- C0240Incorporation no. of SPV
- C0250SPV country of authorisation
- C0260SPV authorisation conditions
- C0270External rating assessment by nominated ECAI
- C0280Nominated ECAI
- C0290Credit quality step
- C0300Internal rating
Which returns it applies to
Line4 Check runs it on quarterly solo (QRS), quarterly group (QRG), quarterly branch (QRB), annual solo (ARS), annual group (ARG), annual branch (ARB), financial stability solo (QFS), financial stability group (QFG) and financial stability branch (QFB) returns on EIOPA taxonomy 2.10.0. EIOPA applies it to quarterly ECB branch (QEB), quarterly ECB solo (QES), annual branch (ARB), annual solo (ARS), financial stability group (QFG), quarterly group (QRG), financial stability solo (QFS), financial stability branch (QFB), quarterly branch (QRB), quarterly solo (QRS), annual ECB solo (AES), annual ECB branch (AEB) and annual group (ARG) returns, as a blocking check.
EIOPA’s own words and formula
The plain words above are EIOPA’s own, word for word, from its list of validations.
Show the formulaShowHide
EIOPA's formula. Cells are written as {t: table, r: row, c: column}.
if matches(dim({d: [s2c_dim:OV]},[s2c_dim:OV]), "^LEI/[A-Z0-9]{18}[0-9]{2}$") and not(matches(dim({d: [s2c_dim:OV]},[s2c_dim:OV]), "^LEI/[A-Z0-9]{18}(01|00)$")) then leiChecksum(substring(dim({d: [s2c_dim:OV]},[s2c_dim:OV]), 5)) else matches(dim({d: [s2c_dim:OV]},[s2c_dim:OV]), "^SC/.*") or isNull(dim({d: [s2c_dim:OV]},[s2c_dim:OV])) or matches(dim({d: [s2c_dim:OV]},[s2c_dim:OV]), "^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 Special purpose vehicles (S.31.02)
- There is at least one SPV reported in Table 1 of S.31.02 that is not reported in Table 2 of S.31.02 (BV1292)Blocking
- There is at least one SPV reported in Table 1 of S.31.02 that is not reported in Table 2 of S.31.02 (BV1293)Blocking
- The item "Temporary identifier for country 1" must not be reported (BV1347)Blocking
- The item "Temporary identifier for country 2" must not be reported (BV1359)Blocking
- The item "Temporary identifier for country 3" must not be reported (BV1371)Blocking
- Special purpose vehicles: double, trailing or leading whitespaces are not allowed (TV9)Blocking
Every Solvency II rule on S.31.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.
