The Data Reference Guide (DRG) contains XML specifications and details of validations applied for all data items submitted to us using 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 Item Code | Data Item Name | Version | Status | Applicable From | Data Definition | Schema | Sample | Template |
|---|---|---|---|---|---|---|---|---|
AIF001 | AIFMD Manager Report | 1.2 | Latest | 01/10/2014 | n/a | 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 | |||
CCR004 | Consumer credit data: debt management firms | 1 | Previous | 01/10/2014 | unavailable | |||
CCR005 | Consumer credit data: client money and assets | 1 | Latest | 01/10/2014 | 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 | Latest | 01/10/2018 | ||||
FIN-APF | Authorised Professional Firms Questionnaire | 2.1 | Previous | 01/12/2015 | unavailable | |||
Complaints | Complaints DISP 1 Ann 1R | 5.3 | Latest | 20/08/2018 | unavailable | |||
Complaints | Complaints DISP 1 Ann 1R | 3 | Previous | 01/10/2014 | ||||
PS-Complaints | Electronic Money and Payment Services Complaints Return | 1 | Latest | 01/12/2018 | ||||
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 | |||
FSA001 | Balance sheet | 4.2 | Latest | 22/04/2013 | ||||
FSA002 | Income statement | 3.2 | Latest | 01/10/2010 | unavailable | |||
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 | Latest | 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 | |||
FSA017 | Interest rate gap | 5 | Latest | 31/01/2019 | unavailable | |||
FSA018 | UK integrated groups: large exposures | 5 | Latest | 31/03/2016 | ||||
FSA019 | Pillar 2 information | 6.1 | Latest | 22/11/2016 | unavailable | |||
FSA028 | Non-EEA sub groups | 5 | Latest | 31/10/2016 | ||||
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) Ch 9 only | 7 | Latest | 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 | Latest | 01/10/2018 | ||||
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 | |||
FSA042 | UCITS | 3 | Latest | 30/09/2017 | ||||
FSA045 | IRB portfolio risk | 6 | Latest | 04/03/2011 | 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 | |||
FSA053 | Retail, SME and large enterprises Type B Funding | 1 | Latest | 31/12/2010 | unavailable | |||
FSA054 | Currency analysis | 1 | Latest | 31/12/2010 | unavailable | |||
FSA055 | Systems and Controls Questionnaire | 1 | Latest | 31/12/2010 | unavailable | |||
MLA-A1-A2 | Balance sheet | 1.1 | Latest | 20/09/2010 | 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 | |||
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-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-M | Liquidity questionnaire | 1.1 | Latest | 01/10/2014 | ||||
RMA-A | Balance sheet | 2 | Latest | 31/12/2013 | ||||
RMA-B | Profit and loss account | 4 | Latest | 21/03/2016 | unavailable | |||
RMA-C | Client money and assets | 4 | Latest | 01/10/2018 | ||||
RMA-D1 | Regulatory capital | 5 | Latest | 30/06/2017 | unavailable | |||
RMA-E | Professional indemnity insurance (PII) self-certification | 8 | Latest | 01/10/2018 | ||||
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 | ||||
RMA-K | Adviser charges | 5 | Latest | 31/12/2016 | ||||
REP001 | Close Links Report | 2 | Latest | 01/11/2014 | ||||
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 | ||||
REP007a | Resolution Plans Notification | 1.1 | Latest | 19/09/2016 | ||||
REP008 | Notification of Disciplinary Action | 2 | Latest | 01/08/2017 | unavailable | |||
REP009 | Consumer Buy-To-Let Mortgage Aggregated Data | 1 | Latest | 01/04/2016 | unavailable | |||
REP010 | List of Overseas Regulators and Organogram | 1 | Latest | 01/04/2016 | ||||
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 | Latest | 30/09/2018 | ||||
REP016 | Retirement Income Stock and Withdrawals Flow Data | 1 | Latest | 30/09/2018 | ||||
REP017 | Payments Fraud Report | 1 | Latest | 31/12/2018 | unavailable | |||
REP018 | Operational and Security Risk | 1 | Latest | 30/09/2018 | unavailable | |||
REP-CRIM | Financial Crime Report | 2 | Latest | 31/03/2018 | ||||
PSD001 | Product Sales Data - Mortgage (accounts opened from 1 April 2017) | 2.1 | Latest | 24/09/2018 | n/a | |||
PSD001 | Product Sales Data - Mortgage (accounts opened between 1 January 2015 and 31 March 2017) | 1.7.8 | Previous | 14/03/2016 | n/a | |||
PSD001 | Product Sales Data - Mortgage (accounts opened before 1 January 2015) | 1.3 | Previous | 22/04/2013 | n/a | |||
PSD002 | Product Sales Data - Retail Investments | 1.5 | Latest | 22/04/2013 | n/a | |||
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 from 1 April 2017) | 2 | Latest | 01/04/2017 | n/a | |||
PSD007 | Product Sales Data - Mortgage Performance Data (date of balance before 1 April 2017) | 1.5 | Latest | 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 | ||
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) | 9 | Previous | 30/06/2015 | n/a | n/a | ||
Common | Common Data Types (referenced by all data items) | 8 | Previous | 01/09/2014 | n/a | n/a | ||
Common | Common Data Types (referenced by all data items) | 7 | Previous | 31/10/2013 | 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) | 5.2 | Previous | 20/12/2010 | 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 | Previous | 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 (PII definitions referenced in FSA031, FSA032 and RMA-E) | 4 | Previous | 05/06/2008 | 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 | ||
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 |