The rule in plain words
Exposures towards sectors that highly contribute to climate change must equal these nine added up:
- Agriculture, forestry and fishing
- Mining and quarrying
- Manufacturing
- Electricity, gas, steam and air conditioning supply
- Water supply; sewerage, waste management and remediation activities
- Construction
- Wholesale and retail trade; repair of motor vehicles and motorcycles
- Transportation and storage
- Real estate activities
All the values are in the <= 5 years column (0120) of D 01.00.
EBA writes it out 14 times. These words are for the first; the others are the same rule on other cells.
The template it checks
Rows
- 0010Exposures towards sectors that highly contribute to climate change
- 0020A - Agriculture, forestry and fishing
- 0030B - Mining and quarrying
- 0090C - Manufacturing
- 0340D - Electricity, gas, steam and air conditioning supply
- 0390E - Water supply; sewerage, waste management and remediation activities
- 0400F - Construction
- 0440G - Wholesale and retail trade; repair of motor vehicles and motorcycles
- 0450H - Transportation and storage
- 0520L - Real estate activities
Column
- 0120<= 5 years
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,r0010,c0120,} = {D_01.00,r0020,c0120,} + {D_01.00,r0030,c0120,} + {D_01.00,r0090,c0120,} + {D_01.00,r0340,c0120,} + {D_01.00,r0390,c0120,} + {D_01.00,r0400,c0120,} + {D_01.00,r0440,c0120,} + {D_01.00,r0450,c0120,} + {D_01.00,r0520,c0120,}And 13 more, the same formula for the other cells it covers.
Other rules on D 01.00
- Total must equal the sum of its two parts (v12722_m)Warning
- Gross carrying amount (Mln EUR) must equal the sum of its four parts (v12725_m)Warning
- None of the 560 values it checks in banking book- Indicators of potential climate change transition risk can be negative (v12826_s)Warning
- None of the 159 values it checks in banking book- Indicators of potential climate change transition risk can be negative (v12827_s)Warning
- Each of the 168 values it checks in banking book- Indicators of potential climate change transition risk cannot be more than zero (v12828_s)Warning
- Exposures towards sectors that highly contribute to climate change cannot be more than total (v89229_m)Warning
- Gross carrying amount (Mln EUR) cannot be less than environmentally sustainable (CCM) (row 0010, v89230_m)Warning
- Agriculture, forestry and fishing cannot be more than total (v89231_m)Warning
Checks like this one, run at the point of submission, are the first step to real-time supervision.
