The rule in plain words
The item "CIC" should follow a pattern starting with two letters representing one of options as per ISO 3166-1
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 warning. It does not stop the return on its own, but your supervisor may ask you to explain it.
The cells it reads
Business model analysis - financial guarantee insurers: exposures (IR.05.07.01.01)
Column
- C0120CIC
List of assets - information on assets (IR.06.02.01.02)
Column
- C0290CIC
List of assets - information on assets (IR.06.02.04.02)
Column
- C0290CIC
Open derivatives - information on derivatives (IR.08.01.01.02)
Column
- C0380CIC
Open derivatives - information on derivatives (IR.08.01.04.02)
Column
- C0380CIC
Assets held as collateral - information on assets (IR.11.01.01.02)
Column
- C0250CIC
Assets held as collateral - information on assets (IR.11.01.04.02)
Column
- C0250CIC
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 group (QRG), annual group (ARG), quarterly solo (QRS), annual solo (ARS) and annual third-country branch (ARB) returns, as a warning.
The Bank’s own words and formula
The plain words above are the Bank of England’s own, word for word, from its list of validations.
Show the formulaShowHide
The Bank of England's formula. Cells are written as {t: table, r: row, c: column}.
matches($v1, "^((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 (IR.06.02)
- The item "External rating" in List of assets should not be reported in case "no rating available" was provided in "Credit quality step" (IR_bv1776_01)Blocking
- The item "External rating" in List of assets should not be reported in case "no rating available" was provided in "Credit quality step" (IR_bv1776_02)Blocking
- List of assets: a conditional check (IR_bv1774_01)Blocking
- List of assets: a conditional check (IR_bv1774_02)Blocking
- Item "quantity" in List of assets should not be reported if 'par amount' is reported for CIC codes different than '##71' and '##9#' (IR_bv1773_01)Blocking
- Item "quantity" in List of assets should not be reported if 'par amount' is reported for CIC codes different than '##71' and '##9#' (IR_bv1773_02)Blocking
- List of assets: a conditional check (IR_bv1772_01)Blocking
- List of assets: a conditional check (IR_bv1772_02)Blocking
Every Solvency UK rule on IR.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.