The rule in plain words
The first two letters are not valid ISO3166 country code
EIOPA writes it out as separate checks, one for each table or return it covers. Line4 Check runs three of them (BV1147-2 to BV1147-5), and a failure names the one that failed.
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.
- 03It runs only when your filing indicators mark S.06.02 as reported.
- 04This is a blocking check. A return that fails it is normally rejected, so fix it before you submit.
The cells it reads
List of assets: information on assets (S.06.02.01.02)
Column
- C0290CIC
List of assets: information on assets (S.06.02.04.02)
Column
- C0290CIC
List of assets: information on assets (S.06.02.07.02)
Column
- C0290CIC
Which returns it applies to
Line4 Check runs it on quarterly solo (QRS), quarterly group (QRG) and quarterly branch (QRB) returns on EIOPA taxonomy 2.10.0. EIOPA applies it to quarterly branch (QRB), annual branch (ARB), financial stability group (QFG), quarterly group (QRG), annual group (ARG), quarterly solo (QRS) and annual solo (ARS) 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, for BV1147-5. Cells are written as {t: table, r: row, c: column}.
matches({t: S.06.02.01.02, c: C0290, z: Z0001}, "^((AF)|(AX)|(AL)|(DZ)|(AS)|(AD)|(AO)|(AQ)|(AG)|(AR)|(AM)|(AW)|(AU)|(AT)|(AZ)|(BS)|(BH)|(BD)|(BB)|(BY)|(BE)|(BZ)|(BJ)|(BT)|(BO)|(BQ)|(BA)|(BW)|(BV)|(BR)|(BN)|(BG)|(BF)|(BI)|(KH)|(CM)|(CA)|(CV)|(CF)|(TD)|(CL)|(CN)|(CX)|(CC)|(CO)|(KM)|(CG)|(CD)|(CK)|(CR)|(CI)|(HR)|(CU)|(CW)|(CY)|(CZ)|(DK)|(DJ)|(DM)|(DO)|(EC)|(EG)|(SV)|(GQ)|(ER)|(EE)|(ET)|(FO)|(FJ)|(FI)|(FR)|(GF)|(PF)|(TF)|(GA)|(GM)|(GE)|(DE)|(GH)|(GR)|(GL)|(GD)|(GP)|(GU)|(GT)|(GG)|(GN)|(GW)|(GY)|(HT)|(HM)|(VA)|(HN)|(HK)|(HU)|(IS)|(IN)|(ID)|(IR)|(IQ)|(IE)|(IM)|(IL)|(IT)|(JM)|(JP)|(JE)|(JO)|(KZ)|(KE)|(KI)|(KP)|(KR)|(XK)|(KW)|(KG)|(LA)|(LV)|(LB)|(LS)|(LR)|(LY)|(LI)|(LT)|(LU)|(MO)|(MK)|(MG)|(MW)|(MY)|(MV)|(ML)|(MT)|(MH)|(MQ)|(MR)|(MU)|(YT)|(MX)|(FM)|(MD)|(MC)|(MN)|(ME)|(MA)|(MZ)|(MM)|(NA)|(NR)|(NP)|(NL)|(NC)|(NZ)|(NI)|(NE)|(NG)|(NU)|(NF)|(MP)|(NO)|(OM)|(PK)|(PW)|(PS)|(PA)|(PG)|(PY)|(PE)|(PH)|(PL)|(PT)|(PR)|(QA)|(RE)|(RO)|(RU)|(RW)|(BL)|(KN)|(LC)|(MF)|(PM)|(VC)|(WS)|(SM)|(ST)|(SA)|(SN)|(RS)|(SC)|(SL)|(SG)|(SX)|(SK)|(SI)|(SB)|(SO)|(ZA)|(ES)|(LK)|(SD)|(SR)|(SJ)|(SZ)|(SE)|(CH)|(SY)|(TW)|(TJ)|(TZ)|(TH)|(TL)|(TG)|(TK)|(TO)|(TT)|(TN)|(TR)|(TM)|(TV)|(UG)|(UA)|(AE)|(GB)|(AI)|(BM)|(IO)|(VG)|(KY)|(FK)|(GI)|(MS)|(PN)|(SH)|(GS)|(TC)|(US)|(UM)|(UY)|(UZ)|(VU)|(VE)|(VN)|(VI)|(WF)|(EH)|(YE)|(ZM)|(ZW)|(SS)|(XV)|(XL)|(XT))..$")BV1147-2:
matches({t: S.06.02.07.02, c: C0290, z: Z0001}, "^((AF)|(AX)|(AL)|(DZ)|(AS)|(AD)|(AO)|(AQ)|(AG)|(AR)|(AM)|(AW)|(AU)|(AT)|(AZ)|(BS)|(BH)|(BD)|(BB)|(BY)|(BE)|(BZ)|(BJ)|(BT)|(BO)|(BQ)|(BA)|(BW)|(BV)|(BR)|(BN)|(BG)|(BF)|(BI)|(KH)|(CM)|(CA)|(CV)|(CF)|(TD)|(CL)|(CN)|(CX)|(CC)|(CO)|(KM)|(CG)|(CD)|(CK)|(CR)|(CI)|(HR)|(CU)|(CW)|(CY)|(CZ)|(DK)|(DJ)|(DM)|(DO)|(EC)|(EG)|(SV)|(GQ)|(ER)|(EE)|(ET)|(FO)|(FJ)|(FI)|(FR)|(GF)|(PF)|(TF)|(GA)|(GM)|(GE)|(DE)|(GH)|(GR)|(GL)|(GD)|(GP)|(GU)|(GT)|(GG)|(GN)|(GW)|(GY)|(HT)|(HM)|(VA)|(HN)|(HK)|(HU)|(IS)|(IN)|(ID)|(IR)|(IQ)|(IE)|(IM)|(IL)|(IT)|(JM)|(JP)|(JE)|(JO)|(KZ)|(KE)|(KI)|(KP)|(KR)|(XK)|(KW)|(KG)|(LA)|(LV)|(LB)|(LS)|(LR)|(LY)|(LI)|(LT)|(LU)|(MO)|(MK)|(MG)|(MW)|(MY)|(MV)|(ML)|(MT)|(MH)|(MQ)|(MR)|(MU)|(YT)|(MX)|(FM)|(MD)|(MC)|(MN)|(ME)|(MA)|(MZ)|(MM)|(NA)|(NR)|(NP)|(NL)|(NC)|(NZ)|(NI)|(NE)|(NG)|(NU)|(NF)|(MP)|(NO)|(OM)|(PK)|(PW)|(PS)|(PA)|(PG)|(PY)|(PE)|(PH)|(PL)|(PT)|(PR)|(QA)|(RE)|(RO)|(RU)|(RW)|(BL)|(KN)|(LC)|(MF)|(PM)|(VC)|(WS)|(SM)|(ST)|(SA)|(SN)|(RS)|(SC)|(SL)|(SG)|(SX)|(SK)|(SI)|(SB)|(SO)|(ZA)|(ES)|(LK)|(SD)|(SR)|(SJ)|(SZ)|(SE)|(CH)|(SY)|(TW)|(TJ)|(TZ)|(TH)|(TL)|(TG)|(TK)|(TO)|(TT)|(TN)|(TR)|(TM)|(TV)|(UG)|(UA)|(AE)|(GB)|(AI)|(BM)|(IO)|(VG)|(KY)|(FK)|(GI)|(MS)|(PN)|(SH)|(GS)|(TC)|(US)|(UM)|(UY)|(UZ)|(VU)|(VE)|(VN)|(VI)|(WF)|(EH)|(YE)|(ZM)|(ZW)|(SS)|(XV)|(XL)|(XT))..$")BV1147-3:
matches({t: S.06.02.04.02, c: C0290, z: Z0001}, "^((AF)|(AX)|(AL)|(DZ)|(AS)|(AD)|(AO)|(AQ)|(AG)|(AR)|(AM)|(AW)|(AU)|(AT)|(AZ)|(BS)|(BH)|(BD)|(BB)|(BY)|(BE)|(BZ)|(BJ)|(BT)|(BO)|(BQ)|(BA)|(BW)|(BV)|(BR)|(BN)|(BG)|(BF)|(BI)|(KH)|(CM)|(CA)|(CV)|(CF)|(TD)|(CL)|(CN)|(CX)|(CC)|(CO)|(KM)|(CG)|(CD)|(CK)|(CR)|(CI)|(HR)|(CU)|(CW)|(CY)|(CZ)|(DK)|(DJ)|(DM)|(DO)|(EC)|(EG)|(SV)|(GQ)|(ER)|(EE)|(ET)|(FO)|(FJ)|(FI)|(FR)|(GF)|(PF)|(TF)|(GA)|(GM)|(GE)|(DE)|(GH)|(GR)|(GL)|(GD)|(GP)|(GU)|(GT)|(GG)|(GN)|(GW)|(GY)|(HT)|(HM)|(VA)|(HN)|(HK)|(HU)|(IS)|(IN)|(ID)|(IR)|(IQ)|(IE)|(IM)|(IL)|(IT)|(JM)|(JP)|(JE)|(JO)|(KZ)|(KE)|(KI)|(KP)|(KR)|(XK)|(KW)|(KG)|(LA)|(LV)|(LB)|(LS)|(LR)|(LY)|(LI)|(LT)|(LU)|(MO)|(MK)|(MG)|(MW)|(MY)|(MV)|(ML)|(MT)|(MH)|(MQ)|(MR)|(MU)|(YT)|(MX)|(FM)|(MD)|(MC)|(MN)|(ME)|(MA)|(MZ)|(MM)|(NA)|(NR)|(NP)|(NL)|(NC)|(NZ)|(NI)|(NE)|(NG)|(NU)|(NF)|(MP)|(NO)|(OM)|(PK)|(PW)|(PS)|(PA)|(PG)|(PY)|(PE)|(PH)|(PL)|(PT)|(PR)|(QA)|(RE)|(RO)|(RU)|(RW)|(BL)|(KN)|(LC)|(MF)|(PM)|(VC)|(WS)|(SM)|(ST)|(SA)|(SN)|(RS)|(SC)|(SL)|(SG)|(SX)|(SK)|(SI)|(SB)|(SO)|(ZA)|(ES)|(LK)|(SD)|(SR)|(SJ)|(SZ)|(SE)|(CH)|(SY)|(TW)|(TJ)|(TZ)|(TH)|(TL)|(TG)|(TK)|(TO)|(TT)|(TN)|(TR)|(TM)|(TV)|(UG)|(UA)|(AE)|(GB)|(AI)|(BM)|(IO)|(VG)|(KY)|(FK)|(GI)|(MS)|(PN)|(SH)|(GS)|(TC)|(US)|(UM)|(UY)|(UZ)|(VU)|(VE)|(VN)|(VI)|(WF)|(EH)|(YE)|(ZM)|(ZW)|(SS)|(XV)|(XL)|(XT))..$")Other rules on List of assets (S.06.02)
- Each asset reported in List of Assets with CIC '##4#' must also be reported in Collective investment undertakings - look-through approach (BV1134)Blocking
- Item “Issuer Group Code” in List of assets must not be reported for items with CIC like '##71', '##75', '##87', '##88' or '##9#' (BV1133)Blocking
- Item “Issuer Group” in List of assets must not be reported for items with CIC like '##71', '##75', '##87', '##88' or '##9#' (BV1132)Blocking
- Item “Issuer Code” in List of assets must not be reported for items with CIC like '##71', '##75', '##87', '##88' or '##9#' (BV1131)Blocking
- Item “Valuation method” in List of assets must be reported (BV1130)Blocking
- Item “Asset pledged as collateral” in List of assets must be reported (BV1129)Blocking
- The item "External rating" in List of assets must not be reported in case "no rating available" was provided in "Credit quality step" (BV1195)Blocking
- There must be no nominated ECAI appointed in case "no rating available" was reported for "Credit quality step" (BV1197)Blocking
Every Solvency II rule on S.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.