The rule in plain words
Since row 0026 is a subset of row 0023 and the columns 0030, 0035, 0050, 0060, 0070, 0080, 0090, 0130, 0140 are negatives, then row 0026 should be less negative (i.e. larger than or equal to) row 0023 for the total exposure input (higher negative)
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): "Real estate exposures" (row 0090) must not be less than "of which: SME" (row 0095).
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.
- 02Compare the values in your return. If the first is smaller than it may be, one of them is wrong: check both before you change either.
- 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)
Rows
- R0090Real estate exposures
- R0095of which: SME
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)
Rows
- R0090Real estate exposures
- R0095of which: SME
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}.
{t: OF09.01.01.01, r: 0090} >= {t: OF09.01.01.01, r: 0095}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): 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)
- Original exposure pre conversion factors cross-template consistency for specialised lending - commodities finance exposures (boe_b0976)
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.
