The rule in plain words
Aggregation by competent authority must be reported.
EBA checks it for nine rows, from total number of institutions that have their legal seat within the Member State (additional information to be provided below) – e.g. derived (0010) to aggregated total number of identified staff that has been in fact awarded a remuneration that leads to a ratio of variable to fixed remunera (0110). That makes nine checks. A failure names the one that failed.
How the Line4 Check report words itShowHide
The first of its checks, word for word as the report shows it when it fails. The others read the same, with their own column, row or sheet.
Total number of institutions that have their legal seat within the Member State (additional information to be provided below) – e.g. derived is reported
What to do if your filing fails it
- 01Open the template below and find the cells the rule reads.
- 02Report a value in this cell. A 0 counts as reported; a cell left out of the file does not.
- 03It runs only when your filing indicators mark R 08.00 as reported.
- 04This is a warning. It does not stop the filing on its own, but your authority may ask you to explain it.
The cells it reads
Rows
- 0010Total number of institutions that have their legal seat within the Member State (additional information to be provided below) – e.g. derived
- 0020Aggregated total number of staff of all institutions within the Member State
- 0030Aggregated total number of identified staff of institutions within the Member State(where available, otherwise N/A)
- 0040Aggregated balance sheet total of institutions within the Member State
- 0050Number of institutions where shareholders have approved a higher ratio that have their legal seat within the Member State (additional inform
- 0070Aggregated total number of staff of these institutions
- 0080Aggregated total number of identified staff of these institutions
- 0090Aggregated balance sheet total of these institutions
- 0110Aggregated total number of identified staff that has been in fact awarded a remuneration that leads to a ratio of variable to fixed remunera
Column
- 0010Aggregation by competent authority
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}.
not(empty({R_08.00,r0010,c0010,}))The next five:
not(empty({R_08.00,r0030,c0010,}))not(empty({R_08.00,r0050,c0010,}))not(empty({R_08.00,r0090,c0010,}))not(empty({R_08.00,r0070,c0010,}))not(empty({R_08.00,r0110,c0010,}))And 3 more, the same formula for the other cells it covers.
Other rules on R 08.00
- Changes versus the previous data submission: an upper-limit check on approved higher ratios between variable and fixed remuneration (v12553_m)Warning
- An upper-limit check on approved higher ratios between variable and fixed remuneration (row 0030, v12551_m)Warning
- Number of institutions where shareholders have approved a higher ratio that have their legal seat within the Member State (additional information to be provided below): an upper-limit check on approved higher ratios between variable and fixed remuneration (v12550_m)Warning
- An upper-limit check on approved higher ratios between variable and fixed remuneration (row 0050, v12549_m)Warning
- Aggregated total number of identified staff of these institutions cannot be more than aggregated total number of staff of these institutions (v12548_m)Warning
- Aggregated total number of staff of these institutions cannot be more than aggregated total number of staff of all institutions within the Member State (v12546_m)Warning
- Aggregated balance sheet total of these institutions cannot be more than aggregated balance sheet total of institutions within the Member State (v12545_m)Warning
- Aggregated total number of identified staff potentially benefitting from an approved ratio above 100% cannot be more than aggregated total number of identified staff of these institutions (v12680_m)Warning
Every REM higher ratios rule, by template
Checks like this one, run at the point of submission, are the first step to real-time supervision.
