The rule in plain words
In each of 106 columns (listed below) of PRA110. Monetisation Actions. Total (CL66.01.01.05): the size of "Level 2B Tradable Assets" (row 7360) (ignoring its sign) must not equal the size of the sum of "Level 2B Tradable Assets" (row 7280) and "Level 2B Tradable Assets" (row 7320) (ignoring its sign).
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 CL66.01.01 as reported.
The cells it reads
PRA110. Monetisation Actions. Total (CL66.01.01.05)
Rows
- R7280Level 2B Tradable Assets
- R7320Level 2B Tradable Assets
- R7360Level 2B Tradable Assets
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
- C090Greater than 7 days up to 2 weeks
- C100Greater than 2 weeks up to 3 weeks
- C110Greater than 3 weeks up to 30 days
- C120Greater than 30 days up to 5 weeks
- C130Greater than 5 weeks up to 2 months
- C140Greater than 2 months up to 3 months
- C150Greater than 3 months up to 4 months
- C160Greater than 4 months up to 5 months
- C170Greater than 5 months up to 6 months
- C180Greater than 6 months up to 9 months
- C190Greater than 9 months up to 12 months
- C200Greater than 12 months up to 2 years
- C210Greater than 2 years up to 5 years
- C220Greater than 5 years
- 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
And 66 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_b2017_m: T1: CL66.01.01.05; columns: {CL66.01.01.05, c020;c030;c040;c050;c060;c070;c080;c6020;c6030;c6040;c6050;c6060;c6070;c6080;c6090;c7000;c7010;c7020;c7030;c7040;c7050;c7060;c7070;c7080;c7090;c7100;c7110;c7120;c7130;c7140;c7150;c7160;c7170;c7180;c7190;c7200;c7210;c7220;c7230;c7240;c7250;c7260;c7270;c7280;c7290;c7300;c7310;c7320;c7330;c7340;c7350;c7360;c7370;c7380;c7390;c7400;c7410;c7420;c7430;c7440;c7450;c7460;c7470;c7480;c7490;c7500;c7510;c7520;c7530;c7540;c7550;c7560;c7570;c7580;c7590;c7600;c7610;c7620;c7630;c7640;c7650;c7660;c7670;c7680;c7690;c7700;c7710;c7720;c7730;c7740;c7750;c7760;c090;c100;c110;c120;c130;c140;c150;c160;c170;c180;c190;c200;c210;c220}; Expression: abs({CL66.01.01.05, r7360}) != abs({CL66.01.01.05, r7280} + {CL66.01.01.05, r7320})
Show the formulaShowHide
The Bank of England's formula. Cells are written as {t: table, r: row, c: column}.
abs({t: CL66.01.01.05, r: 7360}) i!= abs({t: CL66.01.01.05, r: 7280} + {t: CL66.01.01.05, r: 7320})Where it applies, in the Bank's words (its scope):
scope({t: CL66.01.01.05, c: 020; 030; 040; 050; 060; 070; 080; 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; 090; 100; 110; 120; 130; 140; 150; 160; 170; 180; 190; 200; 210; 220, seq: False, f: banking, fv: liquidity_pillarii})Other rules on PRA110. Monetisation Actions. Total (CL66.01.01.05)
- PRA110. Monetisation Actions. Total: a check on its values (boe_b2016_m)
- PRA110. Monetisation Actions. Total: a check on its values (boe_b2015_m)
- PRA110. Monetisation Actions. Total: every value in the cells it covers must be zero or more (boe_b2014_s)
- PRA110. Monetisation Actions. Total: every value in the cells it covers must be zero or more (boe_b2013_s)
- PRA110. Monetisation Actions. Total: every value in the cells it covers must be zero or more (boe_b2012_s)
- PRA110. Monetisation Actions. Total: every value in the cells it covers must be zero or less (boe_b2011_s)
- PRA110. Monetisation Actions. Total: every value in the cells it covers must be zero or less (boe_b2010_s)
- PRA110. Monetisation Actions. Total: every value in the cells it covers must be zero or less (boe_b2009_s)
Every PRA banking rule on CL66.01.01.05
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.