Security
Reference File
Reference File
The Security Reference File service provides up-to-date information on over 450,000 securities including all securities currently traded on the London Stock Exchange’s domestic and international markets. The service covers listed and non-listed securities; local authority mortgage bonds; traded options; authorised unit trusts and many other types of securities. The feed covers over 40 fields, for example Country of Register; CFI Code; Security Class; or Industrial Classification.
The Security Reference File has grown into a comprehensive global database, which enables us to identify the majority of listed securities along with the associated standing data, for example, Sedol, ISIN and Issuer Name. We can provide a tailored feed based on any combination of the data fields contained in the Security Reference File feed. This data can be supplied on a daily basis with history, via FTP client or via modem link to a bulletin board server.
Security Reference File Specification
| Accrued Interest | ||
| Field | Type | Description |
| Action Identifier | char(1) | U - Update, I - Insert, D - Delete, F - Full |
| Security ID * | int | Unique internal identifier for Security |
| Accrued ID * | int | Unique internal identifier for Accrued Interest record |
| Accrued Interest Pay Date | date | This field specifies the date on which accrued interest is paid. This field is only used for London Listed Securities |
| Accrued Interest Rate | float | This field specifies the rate at which accrued interest is paid and is only used from London Listed Securities |
| Last Action Timestamp | timestamp | Time of last change or NULL for a full download |
| Distribution | ||
| Field | Type | Description |
| Effective Date | Date() | n/a |
| Overseas Tax Rate | float | Overseas Tax Rate |
| Pay Date | date | Its meaning is dependent on the Distribution Type:
DD means this date is the pay date. Other distribution type means it is the Distribution end date. Situation means Situation end date. |
| Splitting Nil Paid Date | date | When Distribution Type is DR this date will be the Splitting Nil Paid Date, otherwise this field is blank |
| Stock Situation Number | int | Indicates the notice number that has been assigned for Stock Situation Notice |
| UK Tax Rate | float | The UK tax rate applicable to dividends |
| Overseas Tax Currency | char(3) | ISO currency code used in cash distribution processing |
| Business Year To | Date() | n/a |
| Splitting Fully Paid Date | date | When Distribution Type is DR this date will indicate the Splitting Fully Paid Date, otherwise this field is blank |
| Business Year From | Date() | n/a |
| Acceptance Date | date | The meaning for this date field is determined by what Distribution Type is set as follows: Distributions: DC = Settlement Due Date or Registration Date DE = Application Date DP = Distribution Payment DR = Call Date DS = Election Date Situations: SA = Effective Date SB = Effective Date SC = Late Date for Lodgement SD = Effective Date SE = Application Date SM = Call Date SN = Effective Date SO = Election Date SR = Last Day for Lodgement SS = Effective Date ST = Last Day for Acceptance |
| Stock Situation Number Year | char(4) | Indicates the year that has been assigned for Stock Situation Notice |
| Net of Tax Indicator | char(1) | This indicator denotes if the security is paying net or gross of tax. N indicates NetBlank; G indicates Gross |
| Action Identifier | char(1) | U - Update, I - Insert, D - Delete, F - Full |
| Security ID * | int | Key to relate back to which security this applies |
| Books Close Date | date | Meaning is dependant on the Distribution Type. If the distribution Type is a Distribution (i.e. 1st char is D) this date is the date the registrar closes the register. If the Distribution Type is a Situation ( i.e. 1st character is S ) this is the Settlement Due Date |
| Last Action Timestamp | timestamp | Time of last change or NULL for a full download |
| Distribution Currency Code | char(3) | Currency used for a distribution |
| Distribution Type Payment/Repayment | char(2) | Indicates the type of Distribution or Situation that applies in a corporate action as follows: Distribution: DC = Capitalisation DD = Dividend DE = Entitlements DP = Capital DR = Rights DS = Scrip Options Situations: SA = Renounceable to Registered SB = Subdivision SC = Conversion SD = Pari-Passu SE = Entitlement Issue SF = Forfeiture Payment SM = Call Payment/Repayment SN = Consolidation SO = Benefits with Options SP = Priority Issues SR = Redemptions SS = Scheme of Arrangement ST = Takeover SV = Reverse Elections |
| Ex Date | date | The meaning is dependent on the Distribution Type Distribution - ExDividend Date Situation - Last day for deposit in the UK |
| Distribution ID * | int | Reference number to uniquely identify a Distribution within the system |
| Element | ||
| Field | Type | Description |
| Action Identifier | char(1) | U - Update, I - Insert (F, I - Insert, D - Delete, F - Full) |
| First Day of Dealing in the Resultant Stock | date | If Distribution Type is DE or DS this date field will indicate the First Day of Dealing in the Resultant Stock, otherwise this field is blank |
| Security Code of Distribution | char(7) | This SEDOL is used to show the resultant line in a Stock Situation |
| Results Type | char(1) | This field indicates how the results of a Stock Situation will be handled: C = Crest R = Residual N = Cash O = Other |
| Numerator | float | The number of new shares allowed for a set number of old shares. This field would be used in a Stock Situation |
| Minimum Fraction Value used | float | The smallest fraction amount in the calculation of Stock Situations |
| Element Comment | char(100) | Comment relating to this element |
| Denominator | float | Used in Stock situations and denotes the number of new shares applicable |
| Cash distribution rate/Call | float | The amount paid for Cash Payment Rate Distributions and Call Rates |
| Security ID * | int | Relates this element back to a specific Security |
| Element ID * | int | Unique element identifier |
| Last Action Timestamp | timestamp | Time of last change or NULL for a full download. |
| Distribution ID * | int | Relates this element back to a specific Distribution |
| Dividend Type | char(15) | Has the following values: Final Special Interim Quarterly Maiden Half year First Payment Dividend Details 1st Interim 2nd Interim 3rd Interim 4th Interim 5th Interim 6th Interim 7th Interim 8th Interim 9th Interim 10th Interim 11th Interim 12th Interim |
| Issuer | ||
| Field | Type | Description |
| Action Identifier | char(1) | U - Update, I - Insert, D - Delete, F - Full |
| Issuer ID * | int | Unique issuer identifier |
| Country of Incorporation | char(2) | The country in which the security is incorporated |
| Industrial Classification | char(3) | Shows what sector the security is in, only applies to Equities |
| Issuer Code | char(6) | The Issuer Code field from the current SMF system - this is included for synchronisation purposes during go-live of the new service. It will not be updated after go live. Issuer Name or Issuer ID should be used in preference |
| Issuer Name | char(35) | This is the company name |
| Last Action Timestamp | timestamp | Time of last change or NULL for a full download. |
| Security | ||
| Field | Type | Description |
| Unit of Quotation Currency | char(3) | ISO currency code used to determine the currency of quotation. |
| Security Description | char(40) | Free text description field |
| Short Description | char(18) | Free text description field |
| Security Event | char(2) | This code identifies the last event relevant to the security. |
| Security Event Date | date | Date of last security event |
| Security Form | char(1) | Indicates the form the security takes: A = Registered B = Quasi Bearer C = Renounceable P = Bearer Issued by a Second Party: R = Registered (sub share) T = Quasi Bearer W = Renounceable X = Bearer (Depository receipts) Y = Unknown |
| Security Status | char(1) | This code indicates the status of a security as follow: C = The security is set for valuation and pricing processes T = The security can be reported for trading purposes D = The security is no longer current (defunct) |
| Security Type | Char(1) | Indicates what type a security is i.e. preference, debenture etc. A = Equity C = Equity option - including warrants and option certificates E = Preference, Preferred J = Redeemable Debenture - includes any redeemable security with the word ‘debenture’ appearing in the description (excluding a Government Security) K = Irredeemable Debenture - includes any irredeemable security with the word ‘irredeemable debenture’ appearing in the security description (excluding a Government Security) L = Loan stock of joint company - includes any registered security and its bearer variant M = Loan stock of a government, local authority or public board other than mortgage bonds -includes any registered security and its bearer variant P = Convertible - includes any security described as having conversion rights attaching R = Bond to bearer -issued by a joint stock company including any loan and note to bearer and its registered variant T = Bond to bearer - issued by government, local authority of public board included any security issued by public body and described as a Bond, Note or Debenture |
| SEDOL Code | char(7) | UK Domestic number used to identify securities |
| System Indicator | char(20) | Zero, one or more of the following values concatenated: L = London Listed B = Bulldog securities A = AIM Securities E = Eurobonds U = Unit trusts C = Crest S = Sequence O = Offex W = When Issued Dealings |
| Unit Of Quotation | float | Shows the number of shares/stock that the price represents. |
| IssuerID | int | Unique identifier for the Issuer of this Security |
| Type of Accrual | char(1) | Has the following values: 1 = shown as 1k in DOL (Daily Official List) and calculated on a 365 day basis 2 = shown as 4t in DOL and calculated on a 360 day basis 3 = shown as 1m in DOL and calculated on a 365 day basis |
| Coupon Interest Rate | numeric(8,6) | N/A |
| Parvalue | numeric(8,6) | n/a |
| Parvalue Curr | char(3) | As per existing 'Currency' value |
| Previous Sedol code | char(7) | n/a |
| Previous Issuer Name | char(3) | n/a |
| TI Display Mnemonic | char(4) | Tradable Instrument Display Mnemonic |
| CFI Code | char(6) | Classification of Financial Instruments is an ISO standard used to reflect characteristics of a security |
| Last Action Timestamp | timestamp | Time of last change or NULL for a full download |
| Action Identifier | char(1) | U - Update, I - Insert, D - Delete, F - Full |
| Security ID * | int | Unique internal identifier for Security |
| Amount of Transfer 1 | float | The number of units that the share/stock is transferable in. |
| Amount of Transfer 2 | float | As above - second amount |
| Amount of Transfer 3 | float | As above - third amount |
| Amount of Transfer 4 | float | As above - fourth amount |
| Redemption Date | date | The final redemption date for a security |
| British Fund Indicator | char(1) | Security issued by the bank of England as UK Gilt. 1 implies this security is a Gilt |
| Security Class | char(1) | Used for statistical purpose to group securities into the following classes: 1 = British Government (less than 5 years to run) 2 = Other British Government 3 = UK Local Authority 4 = Overseas Government 5 = Fixed Interest Stocks including preference and preferred ordinary 6 = Ordinary shares 7 = Irish Local Authority and Public Boards |
| Country of Register | char(2) | The country in which the share register is maintained . This is an ISO country code |
| Country of Register Status | char(1) | This field indicates if there is more than one register the values are as follows: Bank = one register 0 = no register 1 = separate register 2 = duplicate register |
| Dealing Convention | char(1) | Indicates if the security is dealt as a stock or a share 1 = share 2 = stock |
| Security Background | char(100) | Free format field that shows the history of a security, i.e. name changes |
| Information Source | char(3) | Shows the prime information source for a security. e.g. LON for London. In most cases this is the Exchange where the security is primarily listed. See attachment 3 for full list of values. |
| ISIN Code | char(12) | International Securities Identification Number |
| Market Identifier | char(4) | ISO Standard |
| Local Code | char(9) | The foreign domestic number used to identify the security |
| Assented Flag | char(1) | Indicates the security is involved in a stock situation, a number 1 indicates that an event (merger, takeover etc.) is happening |