The rule in plain words
In PRA110. Overnight and higher maturity. Total (CL66.01.01.01): every value in the cells it covers must be zero or more.
What to do if your return fails it
- 01Open the table below and find the cells the rule reads.
- 02Look for a value below zero in these cells, such as an amount entered as a negative number.
- 03It runs only when your filing indicators mark CL66.01.01 as reported.
- 04This 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
PRA110. Overnight and higher maturity. Total (CL66.01.01.01)
Rows
- R6160Of which: derogated stable retail deposits (3% category)
- R6170Of which: other (10% category)
- R6180Of which: not covered by DGS
- R6190Of which: higher outflow retail: category 1 (10-15% category)
- R6200Of which: not covered by DGS
- R6210Of which: higher outflow retail: category 2 (15-20% category)
- R6220Of which: not covered by DGS
- R6230Of which: deposits in third countries where a higher outflow is applied
- R6240Of which: not covered by DGS
- R6250Of which: deposits where the payout has been agreed (100% category)
Columns
- C020Overnight
- C030Greater than overnight up to 2 days
- C040Greater than 2 days up to 3 days
- C050Greater than 3 days up to 4 days
- C060Greater than 4 days up to 5 days
- C070Greater than 5 days up to 6 days
- C080Greater than 6 days up to 7 days
- C6010Of which: open
- C6020Day 8
- C6030Day 9
- C6040Day 10
- C6050Day 11
- C6060Day 12
- C6070Day 13
- C6080Day 14
- C6090Day 15
- C7000Day 16
- C7010Day 17
- C7020Day 18
- C7030Day 19
- C7040Day 20
- C7050Day 21
- C7060Day 22
- C7070Day 23
- C7080Day 24
- C7090Day 25
- C7100Day 26
- C7110Day 27
- C7120Day 28
- C7130Day 29
- C7140Day 30
- C7150Day 31
- C7160Day 32
- C7170Day 33
- C7180Day 34
- C7190Day 35
- C7200Day 36
- C7210Day 37
- C7220Day 38
- C7230Day 39
And 53 more.
Which returns it applies to
Line4 Check runs it on the liquidity pillar II (PRA110) return on Bank of England banking taxonomy 4.1.1. The Bank of England applies it to liquidity pillar II (PRA110) 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:
[boe_b2060_s]; [CL66.01.01.01 ]; [scope({t:CL66.01.01.01,y:6160;6170;6180;6190;6200;6210;6220;6230;6240;6250,x:020;030;040;050;060;070;080;6010;6020;6030;6040;6050;6060;6070;6080;6090;7000;7010;7020;7030;7040;7050;7060;7070;7080;7090;7100;7110;7120;7130;7140;7150;7160;7170;7180;7190;7200;7210;7220;7230;7240;7250;7260;7270;7280;7290;7300;7310;7320;7330;7340;7350;7360;7370;7380;7390;7400;7410;7420;7430;7440;7450;7460;7470;7480;7490;7500;7510;7520;7530;7540;7550;7560;7570;7580;7590;7600;7610;7620;7630;7640;7650;7660;7670;7680;7690;7700;7710;7720;7730;7740;7750;7760})]; [{t:CL66.01.01.01} >= 0]
Show the formulaShowHide
The Bank of England's formula. Cells are written as {t: table, r: row, c: column}.
{t: CL66.01.01.01} >= 0Where it applies, in the Bank's words (its scope):
scope({t: CL66.01.01.01, r: 6160; 6170; 6180; 6190; 6200; 6210; 6220; 6230; 6240; 6250, c: 020; 030; 040; 050; 060; 070; 080; 6010; 6020; 6030; 6040; 6050; 6060; 6070; 6080; 6090; 7000; 7010; 7020; 7030; 7040; 7050; 7060; 7070; 7080; 7090; 7100; 7110; 7120; 7130; 7140; 7150; 7160; 7170; 7180; 7190; 7200; 7210; 7220; 7230; 7240; 7250; 7260; 7270; 7280; 7290; 7300; 7310; 7320; 7330; 7340; 7350; 7360; 7370; 7380; 7390; 7400; 7410; 7420; 7430; 7440; 7450; 7460; 7470; 7480; 7490; 7500; 7510; 7520; 7530; 7540; 7550; 7560; 7570; 7580; 7590; 7600; 7610; 7620; 7630; 7640; 7650; 7660; 7670; 7680; 7690; 7700; 7710; 7720; 7730; 7740; 7750; 7760, seq: False, f: banking, fv: liquidity_pillarii})Other rules on PRA110. Overnight and higher maturity. Total (CL66.01.01.01)
- PRA110. Overnight and higher maturity. Total: every value in the cells it covers must be zero or more (boe_b2059_s)
- PRA110. Overnight and higher maturity. Total: every value in the cells it covers must be zero or more (boe_b2061_s)
- PRA110. Overnight and higher maturity. Total: every value in the cells it covers must be zero or more (boe_b2007_s)Blocking
- PRA110. Overnight and higher maturity. Total: every value in the cells it covers must be zero or more (boe_b2000_s)
Every PRA banking rule on CL66.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.
