This TEST file is for testing purposes only and not for use in any actual transaction. This TEST file, created by DTCC, contains randomly-selected records pertaining to participants active in the financial markets and consists of 1) a provisional legal entity identifier patterned after the Draft ISO 17442 LEI Standard, and 2) the core data attributes prescribed by the ISO standard. The entities contained in this TEST file were chosen simply to give indicative information to financial services firms that will have reporting obligations under recently enacted and pending regulations. This TEST file will assist financial services firms in their preparation to comply with this regulation as well as broader mandates from the G20 for improved transparency.
This TEST file is not exhaustive and represents a single snapshot of data attributes validated by Avox at the time the file was produced. The entity record precisely reflects the publically-available legal name and address information. The data may differ from what a firm uses in its internal client reference database depending on the source used by the firm to obtain the data. As a standalone TEST File, it is not being updated for accuracy on an on-going basis. The data in the TEST file is expected to not be pristine, but is illustrative. It is intended to provide firms with an illustration of what a downloaded LEI file is expected to look like in the future. The records were validated and the provisional legal entity identifiers assigned by DTCC and SWIFT in line with the recommendations made for the operation of the LEI Utility by the global financial industry coalition (July 8, 2011). No transaction or position information is contained in this file. Work continues to validate additional entities and updated versions will be made available periodically.
This TEST file should be used only for applications development planning. All other uses of this file shall be at your own risk. Nothing contained herein shall be deemed to be legal advice. All questions related to the structure/schema of the TEST file should be directed to leitestfile@dtcc.com.
Changes between April 1st and May test files
- There is an updated XSD (LEITestSchema_30April2012) which reflects a minor change to the ‘Legal Form’ field. The field definitions document has also been updated this month (LEITestDefinitions_30April2012) to include definitions of the Legal Form and Other Name fields.
- This 4th test file (LEITest_May2012) is a FULL file of all provisional LEI’s issued to date. The number of published records has increased to 15128 provisional LEI’s and will continue to grow as we review and issue more records.
- We don’t envisage any significant change to the latest file format prior to go-live but if changes are necessary the XSD will be updated and re-issued alongside further files.
Test File Formats
In this run the available file formats for the data files are once again XML (supported by an updated xsd schema) and TXT.
Please note that the XML format file should be used for all development coding. The text file is delivered to assist with manual review only and can be opened in excel if required.
Instructions to open TXT file in MS Excel.
- Save the .txt file locally
- Open Excel
- Within MS Excel open the .txt file you saved. Menu options will depend on version you are using - ‘Data-From Text’ is the option in MS Excel 2010. This will open the Text Import Wizard
- Step 1, select Delimited and change the file origin to “65001: Unicode (UTF-8)”. Click Next
- Step 2, select Tab as the Delimiter. Change Text Qualifier from “ to {None}. Click Next.
- Step 3, set all columns to have a data format of Text to prevent Excel from removing leading zeros. Particularly important for LEI and postcode fields. Click Finish
By clicking on the link below, you can read the terms and conditions pertaining to the file.
