The Data Reference Guide (DRG) contains XML specifications and details of validations applied for all data items submitted to us using Gabriel.
These also apply to our new regulatory reporting system RegData, which is replacing Gabriel.
The DRG specifications published on this page only apply to FCA data items. For other data items see information on Common Reporting (COREP) & Financial Reporting (FINREP) and information on PRA and RFB data items.
For each version of a data item we publish the following:
- Data Definition* - a spreadsheet (XLS) containing details on data types, validations and the Handbook layout with sample data.
- Schema - a document (XSD) defining the XML structure and data type requirements.
- Sample* - a document (XML) demonstrating the XML structure and data types in line with the schema.
- Template - a spreadsheet (XLS) facilitating the import of XML data from Gabriel to view and save (only available for certain data items).
*All sample data provided is for illustrative purposes only.
See our DRG change log for a history of changes made to the specifications.
Please enter the data item code or name in the search field below to filter the results displayed in the table.
Data reference guides table
Data Item Code |
Data Item Name |
Version |
Status |
Applicable From |
Data Definition |
Schema |
Sample |
Template |
---|---|---|---|---|---|---|---|---|
PSD001 |
Product Sales Data - Mortgage (accounts opened before 1 January 2015) |
1.3 |
Previous |
22/04/2013 |
n/a |
|||
REP011 |
Monthly Breach Report from Depositaries |
1 |
Latest |
01/01/2017 |
||||
REP012 |
Quarterly Oversight Report from Depositaries |
1 |
Latest |
01/01/2017 |
||||
REP015 |
Retirement Income Flow Data |
1 |
Previous |
30/09/2018 |
unavailable |
|||
REP016 |
Retirement Income Stock and Withdrawals Flow Data |
1 |
Previous |
30/09/2018 |
unavailable |
|||
REP017 |
Payments Fraud Report |
1 |
Previous |
31/12/2018 |
unavailable |
|||
REP018 |
Operational and Security Risk |
1 |
Previous |
30/09/2018 |
unavailable |
|||
REP-CRIM |
Financial Crime Report |
2 |
Latest |
31/03/2018 |
||||
PSD001 |
Product Sales Data - Mortgage (accounts opened between 1 January 2015 and 31 March 2017) |
1.7.8 |
Previous |
14/03/2016 |
n/a |
|||
PSD002 |
Product Sales Data - Retail Investments |
1.5 |
Latest |
22/04/2013 |
n/a |
|||
REP009 |
Consumer Buy-To-Let Mortgage Aggregated Data |
1 |
Latest |
01/04/2016 |
unavailable |
|||
PSD003 |
Product Sales Data - Pure Protection |
1.3 |
Latest |
22/04/2013 |
n/a |
|||
PSD004 |
Product Sales Data - Home Reversion Plans |
2.1 |
Latest |
22/04/2013 |
n/a |
|||
PSD005 |
Product Sales Data - Home Purchase Plans |
2.1 |
Latest |
01/09/2012 |
n/a |
|||
PSD006 |
Product Sales Data - Short Term Loans |
1 |
Latest |
01/10/2014 |
n/a |
|||
PSD007 |
Product Sales Data - Mortgage Performance Data (date of balance between 1 April 2017 and 31 December 2020) |
2 |
Latest |
01/04/2017 |
n/a |
|||
PSD007 |
Product Sales Data - Mortgage Performance Data (date of balance from 1 January 2021) |
3 |
Future |
01/01/2021 |
n/a |
|||
PSD007 |
Product Sales Data - Mortgage Performance Data (date of balance before 1 April 2017) |
1.5 |
Previous |
14/03/2016 |
n/a |
|||
Common |
Common Data Types (referenced by all data items) |
12 |
Latest |
31/03/2018 |
n/a |
n/a |
||
Common |
Common Data Types (referenced by all data items) |
11 |
Previous |
31/05/2016 |
n/a |
n/a |
||
REP010 |
List of Overseas Regulators and Organogram |
1 |
Latest |
01/04/2016 |
||||
REP008 |
Notification of Disciplinary Action |
2 |
Previous |
01/08/2017 |
unavailable |
|||
Common |
Common Data Types (referenced by all data items) |
9 |
Previous |
30/06/2015 |
n/a |
n/a |
||
RMA-K |
Adviser charges |
5 |
Latest |
31/12/2016 |
||||
RMA-D1 |
Regulatory capital |
5 |
Latest |
30/06/2017 |
unavailable |
|||
RMA-E |
Professional indemnity insurance (PII) self-certification |
8 |
Previous |
01/10/2018 |
n/a |
|||
RMA-F |
Threshold conditions |
2 |
Latest |
31/05/2013 |
unavailable |
|||
RMA-G |
Training and competence |
6 |
Latest |
28/02/2018 |
||||
RMA-H |
Conduct of Business Sourcebook (COBS) data |
3.2 |
Latest |
31/10/2013 |
unavailable |
|||
RMA-I |
Supplementary product sales data |
3 |
Latest |
31/12/2010 |
unavailable |
|||
RMA-J |
Data required for collection of fees |
7 |
Latest |
01/04/2019 |
||||
RMA-J |
Data required for collection of fees |
6 |
Previous |
01/04/2018 |
||||
REP001 |
Close Links Report |
2 |
Latest |
01/11/2014 |
||||
REP007a |
Resolution Plans Notification |
1.1 |
Latest |
19/09/2016 |
||||
REP001a |
Close Links Notification |
2 |
Latest |
01/11/2014 |
||||
REP002 |
Controllers Report |
2.1 |
Latest |
01/11/2014 |
unavailable |
|||
REP003 |
Persistency Reporting |
1 |
Latest |
31/12/2014 |
||||
REP004 |
Remuneration Benchmarking Report |
1.1 |
Latest |
14/03/2016 |
||||
REP005 |
High Earners Report |
1.2 |
Latest |
22/05/2017 |
unavailable |
|||
REP005 |
High Earners Report - Template to generate XML file & Nil Return Sample |
1.2 |
Latest |
22/05/2017 |
n/a |
n/a |
||
REP006 |
Recovery Plans |
1.1 |
Latest |
19/09/2016 |
||||
REP006a |
Recovery Plans Notification |
1.1 |
Latest |
19/09/2016 |
||||
REP007 |
Resolution Plans |
1.1 |
Latest |
19/09/2016 |
||||
Common |
Common Data Types (referenced by all data items) |
10 |
Previous |
30/11/2015 |
n/a |
n/a |
||
Common |
Common Data Types (referenced by all data items) |
8 |
Previous |
01/09/2014 |
n/a |
n/a |
||
RMA-B |
Profit and loss account |
4 |
Latest |
21/03/2016 |
unavailable |
|||
PSD001 |
Product Sales Data – Mortgage (accounts opened between 1 April 2017 and 31 March 2021) |
2.2 |
Latest |
23/03/2020 |
n/a |
|||
REP008 |
Notification of Disciplinary Action relating to conduct rules staff (other than SMF managers) |
3 |
Latest |
31/08/2019 |
unavailable |
|||
REP020 |
Quarterly statistics on availability and performance of dedicated interfaces |
1.1 |
Latest |
30/09/2019 |
unavailable |
|||
REP018 |
Operational and Security Risk |
2.1 |
Latest |
30/09/2019 |
||||
REP017 |
Payments Fraud Report |
3.1 |
Latest |
31/12/2019 |
||||
REP017a |
Payments Fraud Report |
1 |
Latest |
31/12/2019 |
||||
REP017b |
Payments Fraud Report |
1 |
Latest |
31/12/2019 |
||||
REP015 |
Retirement Income Flow Data |
2 |
Latest |
01/12/2019 |
unavailable |
|||
REP016 |
Retirement Income Stock and Withdrawals Flow Data |
2 |
Latest |
01/12/2019 |
unavailable |
|||
PSD001 |
Product Sales Data - Mortgage (accounts opened from 1 April 2021) |
3.1 |
Future |
01/04/2021 |
n/a |
|||
REP017 |
Payments Fraud Report |
2 |
Previous |
30/06/2019 |
||||
REP017a |
Payments Fraud Report |
2 |
Future |
31/12/2020 |
n/a |
|||
FIN060a |
Authorised Electronic Money Institution Questionnaire |
1 |
Latest |
31/07/2020 |
n/a |
|||
FIN060b |
Small Electronic Money Institution Questionnaire |
1 |
Latest |
31/07/2020 |
n/a |
|||
FSA065 |
Small Electronic Money Institution -Total Electronic Money Outstanding |
1 |
Latest |
31/07/2020 |
n/a |
|||
RMA-M |
Pension Transfer Specialist advice |
1 |
Latest |
01/10/2020 |
n/a |
|||
FIN-APF |
Authorised Professional Firms Questionnaire |
4 |
Latest |
01/10/2020 |
n/a |
|||
FSA031 |
Capital adequacy (for exempt CAD firms subject to IPRU (INV) Chapter 9) |
8 |
Latest |
01/10/2020 |
n/a |
|||
FSA032 |
Capital adequacy (for exempt CAD firms subject to IPRU (INV) Chapter 13) |
9 |
Latest |
01/10/2020 |
n/a |
|||
RMA-E |
Professional indemnity insurance (PII) self-certification |
9 |
Latest |
01/10/2020 |
n/a |
|||
PS-Complaints |
Electronic Money and Payment Service Complaints Return |
2 |
Latest |
01/07/2019 |
unavailable |
|||
FSA045 |
IRB portfolio risk |
7 |
Latest |
31/01/2019 |
unavailable |
|||
Common |
Common Data Types (referenced by all data items) |
7 |
Previous |
31/10/2013 |
n/a |
n/a |
||
SDS001 |
Shared Definitions (PII definitions referenced in FSA031, FSA032 and RMA-E) |
4 |
Previous |
05/06/2008 |
n/a |
n/a |
||
Common |
Common Data Types (referenced by all data items) |
6.1 |
Previous |
01/03/2012 |
n/a |
n/a |
||
Common |
Common Data Types (referenced by all data items) |
4 |
Previous |
25/01/2008 |
n/a |
n/a |
||
Common |
Common Data Types (referenced by all data items) |
3 |
Previous |
16/11/2007 |
n/a |
n/a |
||
PSD |
PSD Common Data Types (referenced by Product Sales Data (PSD) items) |
2 |
Latest |
22/11/2010 |
n/a |
n/a |
||
SDS001 |
Shared Definitions (PII definitions referenced in FSA031, FSA032 and RMA-E) |
9 |
Latest |
21/11/2016 |
n/a |
n/a |
||
SDS001 |
Shared Definitions (PII definitions referenced in FSA031, FSA032 and RMA-E) |
8 |
Previous |
01/12/2011 |
n/a |
n/a |
||
SDS001 |
Shared Definitions (PII definitions referenced in FSA031, FSA032 and RMA-E) |
7 |
Previous |
16/08/2010 |
n/a |
n/a |
||
SDS001 |
Shared Definitions (PII definitions referenced in FSA031, FSA032 and RMA-E) |
6 |
Previous |
01/06/2010 |
n/a |
n/a |
||
SDS001 |
Shared Definitions (PII definitions referenced in FSA031, FSA032 and RMA-E) |
5 |
Previous |
01/12/2009 |
n/a |
n/a |
||
SDS001 |
Shared Definitions (complex types referenced in FSA031, FSA032 and RMA-E) |
3 |
Previous |
19/12/2007 |
n/a |
n/a |
||
FSA005 |
Market risk |
8 |
Latest |
31/01/2019 |
unavailable |
|||
SDS002 |
Shared Definitions (complex types referenced in MLA-F, MLA-F1, MLA-H and MLA-H1) |
3 |
Latest |
21/11/2016 |
n/a |
n/a |
||
SDS002 |
Shared Definitions (complex types referenced in MLA-F, MLA-F1, MLA-H and MLA-H1) |
2 |
Previous |
25/01/2008 |
n/a |
n/a |
||
SDS003 |
Shared Definitions (referenced by consolidated basis group data items). |
4 |
Latest |
07/10/2009 |
n/a |
n/a |
||
SDS003 |
Shared Definitions (referenced by consolidated basis group data items). |
3 |
Previous |
25/01/2008 |
n/a |
n/a |
||
SDS003 |
Shared Definitions (referenced by consolidated basis group data items). |
2 |
Previous |
16/11/2007 |
n/a |
n/a |
||
SDS004 |
Shared Definitions (complex types referenced in RMA-D1) |
1 |
Latest |
05/06/2008 |
n/a |
n/a |
||
Meta |
Meta Data (supports individual data item schemas) |
1 |
Latest |
23/03/2007 |
n/a |
n/a |
||
Common |
Cross Validation Rules |
13 |
Latest |
17/08/2016 |
n/a |
n/a |
n/a |
|
Common |
Common Data Types (referenced by all data items) |
5.2 |
Previous |
20/12/2010 |
n/a |
n/a |
||
RMA-C |
Client money and assets |
4 |
Latest |
01/10/2018 |
||||
RMA-A |
Balance sheet |
2 |
Latest |
31/12/2013 |
||||
AIF001 |
AIFMD Manager Report |
1.2 |
Latest |
01/10/2014 |
n/a |
unavailable |
||
FSA001 |
Balance sheet |
4.2 |
Latest |
22/04/2013 |
||||
RIA-Complaints |
Complaints by Retail Investment Advisers |
2.1 |
Latest |
19/09/2016 |
||||
FIN-A |
Annual report and accounts |
2 |
Latest |
31/12/2017 |
||||
FIN-CAP |
Capital adequacy |
3 |
Latest |
31/03/2017 |
||||
FIN066 |
Capital adequacy (for collective portfolio management firms) |
1.1 |
Latest |
01/12/2015 |
unavailable |
|||
FIN067 |
Capital adequacy: supplemental (for collective portfolio management investment firms subject to IFPRU) |
1.1 |
Latest |
01/12/2015 |
unavailable |
|||
FIN068 |
Capital adequacy (for collective portfolio management firms subject to BIPRU) |
1.2 |
Latest |
01/12/2015 |
unavailable |
|||
FIN069 |
Financial resources requirements for operators of an electronic system in relation to lending |
1.1 |
Latest |
22/05/2017 |
unavailable |
|||
FIN070 |
Information on Peer to Peer agreements |
1 |
Latest |
01/10/2014 |
unavailable |
|||
FSA002 |
Income statement |
3.2 |
Latest |
01/10/2010 |
unavailable |
|||
Complaints |
Complaints DISP 1 Ann 1R |
3 |
Previous |
01/10/2014 |
||||
FSA003 |
Capital adequacy |
6.2 |
Latest |
22/04/2013 |
||||
FSA004 |
Further breakdown of certain credit risk data |
5.1 |
Latest |
30/06/2011 |
unavailable |
|||
FSA005 |
Market risk |
7.1 |
Previous |
31/12/2011 |
unavailable |
|||
FSA007 |
Operational risk |
2.1 |
Latest |
29/01/2009 |
unavailable |
|||
FSA008 |
Large exposures |
5.1 |
Latest |
22/04/2013 |
||||
FSA011 |
Building society liquidity |
4 |
Latest |
07/10/2009 |
unavailable |
|||
FSA014 |
Forecast data from firms |
2 |
Latest |
16/11/2007 |
unavailable |
|||
FSA015 |
Sectoral information, including arrears and impairment |
4.4 |
Latest |
01/03/2011 |
unavailable |
|||
FSA016 |
Solo consolidated data |
2 |
Latest |
16/11/2007 |
unavailable |
|||
PS-Complaints |
Electronic Money and Payment Services Complaints Return |
1 |
Previous |
01/12/2018 |
||||
Complaints |
Complaints DISP 1 Ann 1R |
5.3 |
Latest |
20/08/2018 |
unavailable |
|||
FSA018 |
UK integrated groups: large exposures |
5 |
Latest |
31/03/2016 |
||||
CCR004 |
Consumer credit data: debt management firms |
1 |
Previous |
01/10/2014 |
unavailable |
|||
AIF002 |
Fund Transparency Report |
1.2 |
Latest |
01/10/2014 |
n/a |
unavailable |
||
AIFMD |
AIFMD Data Types |
1.2 |
Latest |
01/10/2014 |
n/a |
n/a |
n/a |
|
AIFMD |
ESMA Resources and Sample XML |
n/a |
Latest |
n/a |
n/a |
n/a |
unavailable |
|
CCR001 |
Consumer credit data: financial data |
1 |
Latest |
01/10/2014 |
||||
CCR002 |
Consumer credit data: volumes |
4.1 |
Latest |
01/12/2017 |
||||
CCR002 |
Consumer credit data: volumes |
4 |
Previous |
31/10/2016 |
||||
CCR003 |
Consumer credit data: lenders |
2.1 |
Latest |
21/11/2016 |
||||
CCR003 |
Consumer credit data: lenders |
1 |
Previous |
01/10/2014 |
unavailable |
|||
CCR004 |
Consumer credit data: debt management firms |
2 |
Latest |
31/12/2014 |
unavailable |
|||
CCR005 |
Consumer credit data: client money and assets |
1 |
Latest |
01/10/2014 |
unavailable |
|||
FIN-APF |
Authorised Professional Firms Questionnaire |
2.1 |
Previous |
01/12/2015 |
unavailable |
|||
CCR006 |
Consumer credit data: debt collection |
1 |
Latest |
01/10/2014 |
unavailable |
|||
CCR007 |
Consumer credit data: key data for credit firms with limited permissions |
2.2 |
Latest |
01/12/2017 |
unavailable |
|||
CCR008 |
Consumer credit data: credit broking |
1 |
Latest |
30/06/2015 |
||||
CCR-Complaints |
CCR-Complaints Return |
2.1 |
Latest |
30/12/2016 |
unavailable |
|||
CCR-Complaints |
CCR-Complaints Return |
1 |
Previous |
01/10/2014 |
unavailable |
|||
CMAR |
Client Money and Asset Return |
5 |
Latest |
30/06/2015 |
||||
CMAR |
Client Money and Asset Return |
4.2 |
Previous |
22/04/2013 |
||||
FSA039 |
Client Money and Client Assets |
1 |
Latest |
12/10/2007 |
unavailable |
|||
FIN-APF |
Authorised Professional Firms Questionnaire |
3 |
Previous |
01/10/2018 |
n/a |
|||
FSA017 |
Interest rate gap |
5 |
Latest |
31/01/2019 |
unavailable |
|||
FSA019 |
Pillar 2 information |
6.1 |
Latest |
22/11/2016 |
unavailable |
|||
MLA-M |
Liquidity questionnaire |
1.1 |
Latest |
01/10/2014 |
||||
MLA-E |
Residential lending to individuals - new business profile |
3 |
Future |
01/04/2021 |
unavailable |
|||
MLA-A3 |
Analysis of loans to customers |
1 |
Latest |
12/10/2007 |
unavailable |
|||
MLA-A4 |
Analysis of second-charge loans to customers |
1 |
Latest |
21/03/2016 |
unavailable |
|||
MLA-B1 |
Income statement |
1 |
Latest |
12/10/2007 |
unavailable |
|||
MLA-B2 |
Provisions analysis |
1 |
Latest |
12/10/2007 |
unavailable |
|||
MLA-C |
Capital |
2.4 |
Latest |
14/03/2016 |
||||
MLA-D |
Lending - business flows and rates |
2.1 |
Latest |
31/05/2013 |
||||
MLA-D1 |
Second-charge lending – business flow and rates |
2 |
Latest |
31/10/2017 |
unavailable |
|||
MLA-E |
Residential lending to individuals - new business profile |
2 |
Latest |
25/01/2008 |
unavailable |
|||
MLA-E1 |
Second-charge lending – loans to individuals |
1.1 |
Latest |
09/07/2016 |
unavailable |
|||
FSA055 |
Systems and Controls Questionnaire |
1 |
Latest |
31/12/2010 |
unavailable |
|||
MLA-F |
Mortgage lending – arrears analysis |
3 |
Latest |
31/12/2016 |
unavailable |
|||
MLA-F1 |
Second-charge lending – arrears analysis |
2 |
Latest |
31/12/2016 |
unavailable |
|||
MLA-G |
Mortgage administration - business profile |
1.1 |
Latest |
22/04/2013 |
||||
MLA-G |
Mortgage administration - business profile |
2 |
Future |
31/12/2020 |
unavailable |
|||
MLA-G1 |
Second-charge mortgage administration – business profile |
1 |
Future |
31/12/2020 |
||||
MLA-H |
Mortgage administration – arrears analysis |
3 |
Latest |
31/12/2016 |
unavailable |
|||
MLA-H1 |
Second-charge mortgage administration – arrears analysis |
2 |
Latest |
31/12/2016 |
unavailable |
|||
MLA-J |
Fee tariff measures |
2 |
Latest |
22/04/2013 |
unavailable |
|||
MLA-L |
Credit risk |
1.2 |
Latest |
01/10/2014 |
||||
MLA-A1-A2 |
Balance sheet |
1.1 |
Latest |
20/09/2010 |
unavailable |
|||
FSA054 |
Currency analysis |
1 |
Latest |
31/12/2010 |
unavailable |
|||
FSA028 |
Non-EEA sub groups |
5 |
Latest |
31/10/2016 |
||||
FSA042 |
UCITS |
3 |
Latest |
30/09/2017 |
||||
FSA029 |
Balance sheet |
2 |
Latest |
01/11/2010 |
||||
FSA030 |
Income statement |
1.1 |
Latest |
23/06/2014 |
||||
FSA031 |
Capital adequacy (for exempt CAD firms subject to IPRU (INV) Chapter 9) |
7 |
Previous |
01/10/2018 |
||||
FSA032 |
Capital adequacy for exempt CAD personal investment firms subject to IPRU (INV) Ch 13 choosing to carry out activities under MiFID Article 67(3) |
8 |
Previous |
01/10/2018 |
n/a |
|||
FSA033 |
Capital adequacy for firms subject to IPRU (INV) Ch 3 |
1 |
Latest |
12/10/2007 |
unavailable |
|||
FSA034 |
Capital adequacy for firms subject to IPRU (INV) Ch 5 not subject to exemption in IPRU (INV) 5.2.3(2)R |
2 |
Latest |
05/06/2008 |
unavailable |
|||
FSA035 |
Capital adequacy for firms subject to IPRU (INV) Ch 5 subject to exemption in IPRU (INV) 5.2.3(2)R |
1.5 |
Latest |
24/09/2010 |
unavailable |
|||
FSA038 |
Volumes and type of business |
1 |
Latest |
12/10/2007 |
unavailable |
|||
FSA040 |
CFTC data: Specialist data for firms subject to CFTC part 30 exemption order in respect of open positions for LME transactions of US customers |
2 |
Latest |
05/06/2008 |
unavailable |
|||
FSA045 |
IRB portfolio risk |
6 |
Previous |
04/03/2011 |
unavailable |
|||
FSA053 |
Retail, SME and large enterprises Type B Funding |
1 |
Latest |
31/12/2010 |
unavailable |
|||
FSA046 |
Securitisation: Non-Trading Book |
8 |
Latest |
04/11/2011 |
unavailable |
|||
FSA056 |
Authorised Payment Institution Capital Adequacy Return |
4.1 |
Latest |
19/11/2018 |
||||
FSA057 |
Payment Services Directive Transactions |
2 |
Latest |
13/01/2018 |
||||
FSA058 |
Securitisation: Trading Book |
3 |
Latest |
04/11/2011 |
unavailable |
|||
FSA047 |
Daily Flows |
2.3 |
Latest |
04/03/2011 |
||||
FSA048 |
Enhanced Mismatch Report |
1 |
Latest |
06/09/2010 |
||||
FSA050 |
Liquidity Buffer Qualifying Securities |
2 |
Latest |
31/10/2012 |
unavailable |
|||
FSA051 |
Funding Concentration |
1 |
Latest |
30/11/2010 |
unavailable |
|||
FSA052 |
Pricing Data |
1.1 |
Latest |
30/09/2012 |
unavailable |
|||
SDS001 |
Shared Definitions (PII definitions referenced in FSA031, FSA032 and RMA-E) |
10 |
Latest |
01/10/2020 |
n/a |
n/a |