The rule in plain words
Mining and quarrying must equal these five added up:
- B.05 - Mining of coal and lignite
- B.06 - Extraction of crude petroleum and natural gas
- B.07 - Mining of metal ores
- B.08 - other mining and quarrying
- B.09 - Mining support service activities
All the values are in the average weighted maturity column (0160) of D 01.00.
EBA writes it out 15 times. These words are for the first; the others are the same rule on other cells.
The template it checks
Rows
- 0030B - Mining and quarrying
- 0040B.05 - Mining of coal and lignite
- 0050B.06 - Extraction of crude petroleum and natural gas
- 0060B.07 - Mining of metal ores
- 0070B.08 - Other mining and quarrying
- 0080B.09 - Mining support service activities
Column
- 0160Average weighted maturity
Show the rule as writtenShowHide
EBA's formula, as written out for the first of its checks. Cells are written as {template, row, column, sheet}.
{D_01.00,r0030,c0160,} = {D_01.00,r0040,c0160,} + {D_01.00,r0050,c0160,} + {D_01.00,r0060,c0160,} + {D_01.00,r0070,c0160,} + {D_01.00,r0080,c0160,}And 14 more, the same formula for the other cells it covers.
Other rules on D 01.00
- Gross carrying amount (Mln EUR) cannot be less than non-performing exposures (v89453_m)Warning
- Gross carrying amount (Mln EUR) cannot be less than stage 2 exposures (v89452_m)Warning
- C - Manufacturing: gross carrying amount (Mln EUR) cannot be less than environmentally sustainable (CCM) (v89451_m)Warning
- Gross carrying amount (Mln EUR) cannot be less than exposures towards companies excluded from EU Paris-aligned Benchmarks in accordance with Article 12(1) points (d) to (g) and Artic (v89450_m)Warning
- Transportation and storage must equal the sum of its five parts (row 0450, v89444_m)Warning
- Construction must equal the sum of its three parts (row 0400, v89443_m)Warning
- Manufacturing must equal the sum of its 24 parts (v89442_m)Warning
- Mining and quarrying must equal the sum of its five parts (row 0030, v89441_m)Warning
Checks like this one, run at the point of submission, are the first step to real-time supervision.
