The rule in plain words
In column "Amount" (0010) of Breakdown of credit exposures relevant for the calculation of the countercyclical buffer by country and institution-specific countercyclical buffer rate (CCB) (C09.04.01.01): the sum of "Total own funds requirements for CCB" (row 0070) (for the rows the formula picks out) minus "Total own funds requirements for CCB" (row 0070) (where residence of the immediate obligor is "All countries") must equal "Total own funds requirements for CCB" (row 0070) (where residence of the immediate obligor is "All countries").
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.
This is a warning. It does not stop the return on its own, but your supervisor may ask you to explain it. It runs only when your filing indicators mark C09.04.01 as reported.
The cells it reads
Breakdown of credit exposures relevant for the calculation of the countercyclical buffer by country and institution-specific countercyclical buffer rate (CCB) (C09.04.01.01)
Row
- R0070Total own funds requirements for CCB
Column
- C0010Amount
Which returns it applies to
Line4 Check runs it on the own funds (PRA001) return on Bank of England banking taxonomy 4.1.1. The Bank of England applies it to own funds (PRA001) returns, as a warning.
The Bank’s own words and formula
The plain words above spell out the Bank’s formula, with each cell named from its templates. In the Bank of England’s list of validations, word for word:
[v8732_m];[sum({t: C09.04.01.01, r: 0070, c: 0010, filter: not([eba_dim:RIO] = [eba_GA:x0])}) - {t: C09.04.01.01, r: 0070, c: 0010, filter: [eba_dim:RIO] = [eba_GA:x1]} = {t: C09.04.01.01, r: 0070, c: 0010, filter: [eba_dim:RIO] = [eba_GA:x1]}]
Show the formulaShowHide
The Bank of England's formula. Cells are written as {t: table, r: row, c: column}.
sum({t: C09.04.01.01, r: 0070, c: 0010, filter: not([eba_dim:RIO] = [eba_GA:x0])}) - {t: C09.04.01.01, r: 0070, c: 0010, filter: [eba_dim:RIO] = [eba_GA:x1]} = {t: C09.04.01.01, r: 0070, c: 0010, filter: [eba_dim:RIO] = [eba_GA:x1]}Other rules on Breakdown of credit exposures relevant for the calculation of the countercyclical buffer by country and institution-specific countercyclical buffer rate (CCB) (C09.04.01.01)
- Breakdown of credit exposures relevant for the calculation of the countercyclical buffer by country and institution-specific countercyclical buffer rate (CCB): a conditional check (v8730_m)
- Breakdown of credit exposures relevant for the calculation of the countercyclical buffer by country and institution-specific countercyclical buffer rate (CCB): a total must equal the sum of its parts (v10627_m)
- Breakdown of credit exposures relevant for the calculation of the countercyclical buffer by country and institution-specific countercyclical buffer rate (CCB): a value must not be more than another (v10656_m)
- Breakdown of credit exposures relevant for the calculation of the countercyclical buffer by country and institution-specific countercyclical buffer rate (CCB): a value must not be negative (v4746_s)Blocking
- Every value in 9 rows in column "Amount" must be zero or more (v4745_s)
Every PRA banking rule on C09.04.01.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.
