The template it checks
Show the rule as writtenShowHide
EBA's formula. Cells are written as {template, row, column, sheet}.
if ((sum({R_01.00,r0010,c0010,},{R_01.00,r0010,c0020,}) + sum({R_01.00,r0020,c0040,},{R_01.00,r0020,c0030,},{R_01.00,r0020,c0070,},{R_01.00,r0020,c0080,},{R_01.00,r0020,c0050,},{R_01.00,r0020,c0060,})) > 1000000 * (sum({R_01.00,r0040,c0030,},{R_01.00,r0040,c0020,},{R_01.00,r0040,c0060,},{R_01.00,r0040,c0080,},{R_01.00,r0040,c0010,},{R_01.00,r0040,c0040,},{R_01.00,r0040,c0070,},{R_01.00,r0040,c0050Other rules on R 01.00
- A check on general information and information on remuneration of all staff, and additional information on remuneration of identified staff (R 02.00, v12457_m)Not run yet
- A check on general information and information on remuneration of all staff, and additional information on remuneration of identified staff (R 02.00, v12456_m)Not run yet
- The sum of six columns cannot be less than total amount of variable remuneration awarded for multi-year periods under programmes which are not revolved annually, other identified staff (v12455_m)Warning
- The sum of six columns cannot be less than total amount of variable remuneration awarded for multi-year periods under programmes which are not revolved annually, other senior management (v12454_m)Warning
- Variable remuneration cannot be less than total amount of variable remuneration awarded for multi-year periods under programmes which are not revolved annually (row 0050, v12453_m)Warning
- Variable remuneration cannot be less than total amount of variable remuneration awarded for multi-year periods under programmes which are not revolved annually (row 0050, v12452_m)Warning
- The sum of six columns cannot be less than total amount of contributions to discretionary pension benefits in year N (included in other forms of variable remuneration), other identified staff (v12451_m)Warning
- The sum of six columns cannot be less than total amount of contributions to discretionary pension benefits in year N (included in other forms of variable remuneration), other senior management (v12450_m)Warning
Every REM benchmarking rule, by template
Checks like this one, run at the point of submission, are the first step to real-time supervision.
