The rule in plain words
If the aggregate of SA exposures for each individual country where the exposure is generated less the total exposure amount across all countries (GA:x1) isn’t zero, then the difference between {the sum of exposures for each country} and the {total “All countries” amount} must be the same as the “All countries” amount reported in row 0170.
In each of 10 columns (listed below) of Geographical breakdown of exposures by residence of the obligor: SA exposures (OF CR GB 1) (OF09.01.01.01): if the sum of "Total exposures" (row 0170) minus "Total exposures" (row 0170) (where country where the exposure is generated is "All countries") is not zero, the sum of "Total exposures" (row 0170) minus "Total exposures" (row 0170) (where country where the exposure is generated is "All countries") must equal "Total exposures" (row 0170) (where country where the exposure is generated 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.
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.
- 03The Bank of England allows a small rounding difference, worked out from the decimals each value is reported with.
- 04It runs only when your filing indicators mark OF09.01.01 as reported.
- 05This is a blocking check. A return that fails it is normally rejected, so fix it before you submit.
The cells it reads
Geographical breakdown of exposures by residence of the obligor: SA exposures (OF CR GB 1) (OF09.01.01.01)
Row
- R0170Total exposures
Columns
- C0010Original exposure pre conversion factors
- C0020Defaulted exposures
- C0040Observed new defaults for the period
- C0050General credit risk adjustments
- C0055Specific credit risk adjustments
- C0060Write offs
- C0061Additional value adjustments and other own funds reductions
- C0070Credit risk adjustments/write-offs for observed new defaults
- C0075Exposure value
- C0090Risk-weighted exposure amount
Geographical breakdown of exposures by residence of the obligor (SA EXPOSURES) (CR GB 1) (SC09.01.01.01)
Row
- R0170Total exposures
Columns
- C0010Original exposure pre conversion factors
- C0020Defaulted exposures
- C0040Observed new defaults for the period
- C0050General credit risk adjustments
- C0055Specific credit risk adjustments
- C0060Write offs
- C0061Additional value adjustments and other own funds reductions
- C0070Credit risk adjustments/write-offs for observed new defaults
- C0075Exposure value
- C0090Risk-weighted exposure amount
Which returns it applies to
Line4 Check runs it on the own funds (PRA001) and own funds for SDDTs (PRA116) returns on Bank of England banking taxonomy 4.1.1. The Bank of England applies it to own funds for SDDTs (PRA116) and own funds (PRA001) returns, as a blocking check.
The Bank’s own words and formula
The first paragraph of the plain words above is the Bank of England’s own, word for word, from its list of validations. The second spells out its formula, with each cell named from its templates.
Show the formulaShowHide
The Bank of England's formula. Cells are written as {t: table, r: row, c: column}.
if sum({t: OF09.01.01.01, r: 0170}) - {t: OF09.01.01.01, r: 0170, filter: [eba_dim:CEG] = [eba_GA:x1]} != 0 then sum({t: OF09.01.01.01, r: 0170}) - {t: OF09.01.01.01, r: 0170, filter: [eba_dim:CEG] = [eba_GA:x1]} = {t: OF09.01.01.01, r: 0170, filter: [eba_dim:CEG] = [eba_GA:x1]} else true()Where it applies, in the Bank's words (its scope):
scope({t: OF09.01.01.01, c:0010;0020;0040;0050;0055;0060;0061;0070;0075;0090, f: banking, fv: banking_reporting})Other rules on Geographical breakdown of exposures by residence of the obligor: SA exposures (OF CR GB 1) (OF09.01.01.01)
- Geographical breakdown of exposures by residence of the obligor: SA exposures (OF CR GB 1): a value must not be less than another (boe_b0968)Blocking
- Geographical breakdown of exposures by residence of the obligor: SA exposures (OF CR GB 1): two values must match (boe_b0969)
- Geographical breakdown of exposures by residence of the obligor: SA exposures (OF CR GB 1): two values must match (boe_b0970)
- Geographical breakdown of exposures by residence of the obligor: SA exposures (OF CR GB 1): two values must match (boe_b0971)
- R0095 should be less than or equal to r0090 as it's an 'of which' row (boe_b0972)
- Geographical breakdown of exposures by residence of the obligor: SA exposures (OF CR GB 1): two values must match (boe_b0973)
- Exposure value cross-template consistency for Specialised lending - Object finance exposures (boe_b0974)
- Risk-weighted exposure amount cross-template consistency for Specialised lending - Object finance exposures (boe_b0975)
Every PRA banking rule on OF09.01.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.