Community and History
SEDOL Masterfile – Changes to the BULK Upload Template & Inclusion of CFI 10962: 2015
2017-06-23
SEDOL Masterfile will be making changes to the Bulk Upload template that customers currently use.
The Bulk Upload feature enables permissioned users to create multiple SEDOLs quickly and easily. Rather than creating individual records through the User Interface, users can manually upload a file into SEDOL Masterfile providing that all the mandatory fields are populated to enable error free generation of a SEDOL code for the requested instruments in real-time.
An additional 11 columns will be appended to the end of the External Bulk Upload template which users can populate accordingly:
| Field Name | Format | Description |
| ExchangeSymbol | VARCHAR (50) | International ticker/exchange/trading code |
| LocalCode | VARCHAR(50) | Local trading code |
| CFICode2015 | VARCHAR (6) | ISO 10962:2015 Classification of Financial Instruments code (CFI) |
| Tranche | VARCHAR(12) | Can apply to Debt / Equities / Other |
| Series | VARCHAR(12) | Can apply to Debt / Equities / Other |
| Class | VARCHAR(12) | Can apply to Debt / Equities / Other |
| Tenor | VARCHAR(12) | Applicable to Cross Rates |
| BondSeniority | VARCHAR(12) | Senior / Mezzanine / Subordinated / Junior Debt |
| OptnExSty | VARCHAR(12) | Option Exercise Style - American / European / Bermudan / Asian / Other |
| GreenBondIndicator | TRUE or FALSE | True / False |
| FISN | VARCHAR(35) | ISO 18774 Financial Issuer Short Name |
How does this affect me?
This change only affects existing permissioned users who use the existing BulkUpload template as part of SEDOL requests. This can either be via email or manual import by logging on at www.sedol.co.uk. You will need to download the new template from the link <here>.
These changes have been updated in the latest version of our SEDOL Service & Technical Guide v8.2 which will come into effect from 12th July 2017. Please refer to the Mandatory & Optional Field table for clarification on the new Field additions.
CFI Code 2015
Commencing 12th July, we will begin populating the CFICode2015 field. Over time, coverage of this field will increase where applicable.
If you have any queries, please email smfnewissues@lseg.com