This feed files can be regarded as a fixed format for all events if the generic definition is used. The Dates 1 to 12 and Rates and Ratio, section vary from event to event in content, but not in datatype The section Field 1 to 24 can vary in content and data type. All variable fields have a descriptive tag. All are varchar 255, but the real underlying datatype is given in this specification. Fields marked with <$> indicate a meaning they will always be populated Primary key combo within any one file: EventCD + EventID + OptionID + SerialID + ScexhID Option and Serial IDs are not always applicable, but will then always be populated with 1 by default. Global Industry Classification Standard Generic definition - Element Name DataType Format Max Width Lookup TypeGroup Field Description <$> EventCD VarChar Char String 10 EVENT Event type code <$> EventID Integer 32 bit 10 Unique global Event Identifier combined with Event type code <$> OptionID Integer 32 bit 10 Mulitple Payment Option ID - Groups together multiple elements that comprise a complete payment option e.g. Part Cash, part Stock <$> SerialID Integer 32 bit 10 Mulpile Payment Serial ID - Enumerates each element of an option from a multiple payment so the the combination of OptionID and SerialID <$> ScexhID Integer 32 bit 10 Unique global level Listing ID <$> Actflag Char Char String 1 ACTION Event Level Action Status <$> Changed Date yyyy/mm/dd hh:mm:ss 19 Date event updated. <$> Created Date yyyy/mm/dd 10 Date event first entered <$> SecID Integer 32 bit 10 Unique global level Security ID (can be used to link all multiple listings together <$> IssID Integer 32 bit 10 Unique global level Issuer ID (can be used to link all securities of a company togther) ISIN Char Char String 12 ISIN code (global level identifier) USCode Char Char String 9 USCode (global level identifier) <$> IssuerName VarChar Char String 70 Name of Issuer CntryofIncorp Char Char String 2 CNTRY ISO Country of Incorporation of Issuer SIC VarChar Char String 10 Standard Industrial Classification Code CIK VarChar Char String 10 Central Index Key IndusID Integer 32 bit 10 INDUS Proprietary Industry Sector Code <$> SectyCD Char Char String 3 SECTYPE Type of Equity Instrument <$> SecurityDesc VarChar Char String 70 Security Description ParValue Float 20 Security Parvalue PVCurrency Char Char String 3 CUREN Security Parvalue Currency <$> StatusFlag Char Char String 1 SECSTATUS Inactive at the global level else security is active. Not to be confused with delisted which is inactive at the exchange level PrimaryExchgCD Char Char String 6 EXCHANGE Exchange code for the primary listing (empty if unknown) StructCD VarChar Char String 10 <$> ExchgCntry Char Char String 2 CNTRY Country of Exchange where listed <$> ExchgCD Char Char String 6 EXCHANGE Maintained Exchange code. Equivalent to the MIC code but necessary as MIC might not be available in a timely fashion. Mic Char Char String 4 MICCODE ISO standard Market Identification Code Micseg Char Char String 4 MICCODE ISO standard Market Identification Code LocalCode VarChar Char String 50 Local code unique at Market level - a ticker or number <$> ListStatus Char Char String 1 LISTSTAT Indicates whether a security is Listed on an Exchange or Unlisted Indicates Exchange Listing Status Date1Type VarChar Char String 20 Type of calendar date Date1 Date yyyy/mm/dd 10 Calendar date Date2Type VarChar Char String 20 Type of calendar date Date2 Date yyyy/mm/dd 10 Calendar date Date3Type VarChar Char String 20 Type of calendar date Date3 Date yyyy/mm/dd 10 Calendar date Date4Type VarChar Char String 20 Type of calendar date Date4 Date yyyy/mm/dd 10 Calendar date Date5Type VarChar Char String 20 Type of calendar date Date5 Date yyyy/mm/dd 10 Calendar date Date6Type VarChar Char String 20 Type of calendar date Date6 Date yyyy/mm/dd 10 Calendar date Date7Type VarChar Char String 20 Type of calendar date Date7 Date yyyy/mm/dd 10 Calendar date Date8Type VarChar Char String 20 Type of calendar date Date8 Date yyyy/mm/dd 10 Calendar date Date9Type VarChar Char String 20 Type of calendar date Date9 Date yyyy/mm/dd 10 Calendar date Date10Type VarChar Char String 20 Type of calendar date Date10 Date yyyy/mm/dd 10 Calendar date Date11Type VarChar Char String 20 Type of calendar date Date11 Date yyyy/mm/dd 10 Calendar date Date12Type VarChar Char String 20 Type of calendar date Date12 Date yyyy/mm/dd 10 Calendar date Paytype Char Char String 1 PAYTYPE Paytype flag RDID Integer 32 bit 10 Record Date ID. Useful to link to other records sharing the same record date Priority Integer 8 bit 2 Indicates order of events where record date is shared <$> DefaultOpt Boolean Char String 1 BOOLEAN Default Option flag OutturnSecID Integer 32 bit 10 Security ID for an outturn security if any. Where sucessor the outturn SecID will be the same as the parent SecID OutturnIsin Char Char String 12 ISIN code outturn. These can be resultant OR successor codes. RatioOld Float 20 Number of old shares. Number of New Securities the shareholder receives as a proportion of Old Securities surrendered RatioNew Float 20 Number of new shares Fractions Char Char String 1 FRACTIONS Fractions Currency Char Char String 3 CUREN ISO Currency Code Rate1Type VarChar Char String 20 Type of of pay rate Rate1 Float 20 Rate2Type VarChar Char String 20 Type of of pay rate Rate2 Float 20 Pay rate Field1Name VarChar Char String 20 Name of Event specific Field Field1 VarChar Char String 255 Event Specific Field Content Field2Name VarChar Char String 20 Name of Event specific Field Field2 VarChar Char String 255 Event Specific Field Content Field3Name VarChar Char String 20 Name of Event specific Field Field3 VarChar Char String 255 Event Specific Field Content Field4Name VarChar Char String 20 Name of Event specific Field Field4 VarChar Char String 255 Event Specific Field Content Field5Name VarChar Char String 20 Name of Event specific Field Field5 VarChar Char String 255 Event Specific Field Content Field6Name VarChar Char String 20 Name of Event specific Field Field6 VarChar Char String 255 Event Specific Field Content Field7Name VarChar Char String 20 Name of Event specific Field Field7 VarChar Char String 255 Event Specific Field Content Field8Name VarChar Char String 20 Name of Event specific Field Field8 VarChar Char String 255 Event Specific Field Content Field9Name VarChar Char String 20 Name of Event specific Field Field9 VarChar Char String 255 Event Specific Field Content Field10Name VarChar Char String 20 Name of Event specific Field Field10 VarChar Char String 255 Event Specific Field Content Field11Name VarChar Char String 20 Name of Event specific Field Field11 VarChar Char String 255 Event Specific Field Content Field12Name VarChar Char String 20 Name of Event specific Field Field12 VarChar Char String 255 Event Specific Field Content Field13Name VarChar Char String 20 Name of Event specific Field Field13 VarChar Char String 255 Event Specific Field Content Field14Name VarChar Char String 20 Name of Event specific Field Field14 VarChar Char String 255 Event Specific Field Content Field15Name VarChar Char String 20 Name of Event specific Field Field15 VarChar Char String 255 Event Specific Field Content Field16Name VarChar Char String 20 Name of Event specific Field Field16 VarChar Char String 255 Event Specific Field Content Field17Name VarChar Char String 20 Name of Event specific Field Field17 VarChar Char String 255 Event Specific Field Content Field18Name VarChar Char String 20 Name of Event specific Field Field18 VarChar Char String 255 Event Specific Field Content Field19Name VarChar Char String 20 Name of Event specific Field Field19 VarChar Char String 255 Event Specific Field Content Field20Name VarChar Char String 20 Name of Event specific Field Field20 VarChar Char String 255 Event Specific Field Content Field21Name VarChar Char String 20 Name of Event specific Field Field21 VarChar Char String 255 Event Specific Field Content Field22Name VarChar Char String 20 Name of Event specific Field Field22 VarChar Char String 255 Event Specific Field Content Field23Name VarChar Char String 20 Name of Event specific Field Field23 VarChar Char String 255 Event Specific Field Content Field24Name VarChar Char String 20 Name of Event specific Field Field24 VarChar Char String 255 Event Specific Field Content Event specific variations. Announcement - (ANN) Date 1 - NotificationDate Option and Serial ID : Dummies Outurns: None Ratios: None Rates: None Priority: Not Applicable Extra Fields : None Arrangement - (ARR) Date 1 - Exdate Date 2 - Recdate Date 3 - Paydate Option and Serial ID : Dummies Outurns: Successor code Ratios: None Rates: None Priority: Applicable Extra Fields : None Assimilation - (ASSM) Date 1 - AssimilationDate Option and Serial ID : Dummy 1's Outurns: Resultant code Ratios: None Rates: None Priority: Not Applicable Extra Fields : None Buy Back - (BB) Date 1 - Start date Date 2 - End date Date 2 - Recdate Date 3 - Paydate Date 5 - Withdrawal fromdate Date 6 - Withdrawal Todate Option and Serial ID : Real but usually only one Option and Serial ID Outurns: Resultant code Ratios: Yes Rates: Minprice, Maxprice Floats as above in general spec Priority: Applicable Extra Fields : Yes Element Name DataType Format Max Width Lookup TypeGroup Field Description 1 OnOffFlag Char Char String 1 ONOFFFLAG The mechanism adopted by the company for buying back the shares. 2 WithdrawalRights Char Char String 1 BOOLEAN The mechanism adopted by the company for buying back the shares. 3 DutchAuction Char Char String 1 BOOLEAN Bankruptcy - (BKRP) Date 1 - Notification date Date 2 - Filing date Option and Serial ID : Dummies Outurns: None Ratios: None Rates: None Priority: Not Applicable Extra Fields : None Bonus Issue - (BON) Date 1 - Exdate Date 2 - Recdate Date 3 - Paydate Option and Serial ID : Dummies Outurns: None Ratios: Yes Floats as above in general spec Rates: None Priority: Applicable Extra Fields : Yes Element Name DataType Format Max Width Lookup TypeGroup Field Description 1 ResSectyCD Char Char String 3 SECTYPE Resultant Security Type 2 LapsedPremium Float 20 This field is populated for ADR holders only. If the underlying security is having Bonus issue and company decides ADR shares will not have bonus. The company will sell the share on behalf of ADR holders in the market and return the money to ADR holders. So there is no ratio. Bonus Rights - (BR) Date 1 - StartSubscription Date 2 - EndSubscription Date 3 - SplitDate Date 4 - StartTrade Date 5 - EndTrade Date 6 - ExDate Date 7 - RecDate Date 8 - PayDate Option and Serial ID : Dummies Outurns: Resultant (Note also Trading and Poison Pill in extra fields section) Ratios: Yes Rates: IssuePrice Floats as above in general spec Priority: Applicable Extra Fields : Yes Element Name DataType Format Max Width Lookup TypeGroup Field Description 1 TraSecID Integer 32 bit 10 Security Code of the security that may be created for Trading purposes. 2 TraIsin Char Char String 12 Trading ISIN if applicable/available 3 OverSubscription Char Char String 1 BOOLEAN 4 ResSectyCD Char Char String 3 SECTYPE Resultant Security Type Call - (CALL) Date 1 - DueDate Date 2 - RecDate Option and Serial ID : Dummies Outurns: None Ratios: None Rates: None Priority: Applicable Extra Fields : Yes Element Name DataType Format Max Width Lookup TypeGroup Field Description 1 CallNumber Integer 32 bit 10 Number of the call which the company has made on the security. Eg. 1st Call, 2nd Call, 3rd Call 2 CurenCD Char Char String 3 CUREN ISO Currency Code 3 ToFacevalue Float 20 Out of the total call amount the amount that will be apportioned to the Face Value of the security i.e. companys equity capital. 4 ToPremium Float 20 Out of the total call amount the amount that will be apportioned to the share premium account. Capital Reduction - (CAPRD) Date 1 - Effective date Date 2 - Recdate Date 3 - Paydate Option and Serial ID : Dummies Outurns: Successor code Ratios: Yes Floats as above in general spec Rates: None Priority: Applicable Extra Fields : Yes Element Name DataType Format Max Width Lookup TypeGroup Field Description 1 OldParValue Float 20 Par Value may change in Capital Reduction. Both are provided for reference. 2 NewParValue Float 20 Par Value may change in Capital Reduction. Both are provided for reference. Company Meeting - (AGM) Date 1 - AGMDate Date 2 - FYEDate Date 3 - RecDate Option and Serial ID : Dummies Outurns: None Ratios: None Rates: None Priority: Not Applicable Extra Fields : Yes Element Name DataType Format Max Width Lookup TypeGroup Field Description 1 AGMEGM Char Char String 3 AGMEGM Type of meeting 2 AGMNo Char Char String 10 Company meeting number 3 AGMTime VarChar Char String 12 4 Add1 VarChar Char String 50 Address Line 1 5 Add2 VarChar Char String 50 Address Line 2 6 Add3 VarChar Char String 50 Address Line 3 7 Add4 VarChar Char String 50 Address Line 4 8 Add5 VarChar Char String 50 Address Line 5 9 Add6 VarChar Char String 50 Address Line 6 10 City VarChar Char String 50 City 11 CntryCD Char Char String 2 CNTRY ISO Country Consolidation (AKA Reverse stock split) - (CONSD) Date 1 - Exdate Date 2 - Recdate Date 3 - Paydate Option and Serial ID : Dummies Outurns: Successor code Ratios: Yes Floats as above in general spec Rates: None Priority: Applicable Extra Fields : Yes Element Name DataType Format Max Width Lookup TypeGroup Field Description 1 OldParValue Float 20 Par Value may change in Consolidation. Both are provided for reference. 2 NewParValue Float 20 Par Value may change in Consolidation. Both are provided for reference. 3 CurenCD Char Char String 3 CUREN ISO Currency Code Conversion - (CONV) Date 1 - FromDate Date 2 - ToDate Date 3 - RecDate Option and Serial ID : Dummies Outurns: Resultant code Ratios: Yes Rates: Price Floats as above in general spec Priority: Not Applicable Extra Fields : Yes Element Name DataType Format Max Width Lookup TypeGroup Field Description 1 MandOptFlag Char Char String 1 MANDOPT Is the conversion for this period Mandatory or Optional to the shareholder. Generally there could be several conversion periods within the life of the Preference share. The Last one is Mandatory and all the interim ones would be optional. 2 FXrate Float 20 Foreign Exchange Rate 3 PartFinalFlag Char Char String 1 PARTFINAL 4 ResSectyCD Char Char String 3 SECTYPE Resultant Security Type 5 ConvType VarChar Char String 10 CONVTYPE 6 PriceAsPercent Float 20 Certificate Exchange - (CTX) Date 1 - Start date Date 2 - End date Option and Serial ID : Dummies Outurns: Resultant code Ratios: None Rates: None Priority: Not Applicable Extra Fields : Yes Element Name DataType Format Max Width Lookup TypeGroup Field Description 1 RelEvent VarChar Char String 10 TABLENAME Event related to or causing the current event. e.g. Subdivision could be the the related event of a Sedol Change Event 2 ResSectyCD Char Char String 3 SECTYPE Resultant Security Type Currency Redenomination - (CURRD) Date 1 - EffectiveDate Option and Serial ID : Dummies Outurns: None Ratios: None Rates: None Priority: Not Applicable Extra Fields : Yes Element Name DataType Format Max Width Lookup TypeGroup Field Description 1 EventType VarChar Char String 10 EVENT Event type code 2 OldCurenCD Char Char String 3 CUREN ISO Old Currency Code 3 NewCurenCD Char Char String 3 CUREN ISO New Currency Code 4 OldParValue Float 20 Par Value may change in Currency Redenomination. Both are provided for reference. 5 NewParValue Float 20 Par Value may change in Currency Redenomination. Both are provided for reference. Distribution - (DIST) Date 1 - Exdate Date 2 - Recdate Date 3 - Paydate Date 4 - WithdrawalFromdate Date 5 - WithdrawalTodate Date 6 - OptionElectionDate Option and Serial ID : OptionID real, Serial ID real Outurns: Resultant code Ratios: Yes Rates: MinPrice, MaxPrice Floats as above in general spec Priority: Applicable Extra Fields : Yes Element Name DataType Format Max Width Lookup TypeGroup Field Description 1 WithdrawalRights Char Char String 1 BOOLEAN True or False Dividend - (DIV) Date 1 - Exdate Date 2 - RecDate Date 3 - Paydate Date 4 - PayDate2 Date 5 - FYEDate Date 6 - PeriodEndDate Date 7 - OptElectionDate Date 8 - ToDate Date 9 - RegistrationDate Date 10 - DeclarationDate Date 11 - ExDate2 Date 12 - FXDate Option and Serial ID : OptionID real, Serial ID real Outurns: Resultant code Ratios: Yes Floats as above in general spec Rates: Gross and Net Dividend GrossDividend Float 20 Total Dividend amount NetDividend Float 20 Dividend net of taxes (if any) to the shareholder Priority: Applicable Extra Fields : Yes Element Name DataType Format Max Width Lookup TypeGroup Field Description 1 Marker Char Char String 3 MARKER Dividend Marker 2 Frequency Char Char String 3 FREQ Dividend Frequency 3 Tbaflag Char Char String 1 BOOLEAN The company intends to pay a dividend but the details are yet to be announced 4 NilDividend Char Char String 1 BOOLEAN Real Dividend event but of zero payrate. 5 DivRescind Char Char String 1 BOOLEAN Real Dividend event but of zero payrate. 6 RecindCashDiv Char Char String 1 BOOLEAN Cash Dividend Cancelled. 7 RecindStockDiv Char Char String 1 BOOLEAN Stock Dividend Cancelled. 8 Approxflag Char Char String 1 BOOLEAN If dividend is temporarily an approximate value. Expect an update. 9 TaxRate Float 20 Domestic withholding tax rate 10 Depfees Float 20 Depositary fees - Applies only to DR dividends 11 Coupon VarChar Char String 25 In countries where coupons are to be submitted to obtain a benefit this field is useful 12 Dapflag Char Char String 1 YNBLANK Divdend Access Plan Available (GB only) 13 InstallmentPayDate Date yyyy/mm/dd 10 14 DeclCurenCD Char Char String 3 CUREN Declared Currency Code 15 DeclGrossAmt Varchar Char String 20 Declared Gross Amount Demerger - (DMRGR) Date 1 - Exdate Date 2 - Recdate Date 3 - Paydate Date 4 - WithdrawalFromdate Date 5 - WithdrawalTodate Date 6 - OptionElectionDate Date 7 - EffectiveDate Option and Serial ID : Yes Outurns: Resultant code Ratios: Yes Rates: MinPrice, MaxPrice Floats as above in general spec Priority: Applicable Extra Fields : Yes Element Name DataType Format Max Width Lookup TypeGroup Field Description 1 WithdrawalRights Char Char String 1 BOOLEAN True or False Dividend Reinvestment Plan - (DRIP) Date 1 - DripLastdate Date 2 - DripPaydate Date 3 - CrestDate Date 4 - ExDate Option and Serial ID : No Outurns: No Ratios: No Rates: No Priority: Applicable Extra Fields : Yes Element Name DataType Format Max Width Lookup TypeGroup Field Description 1 DripReinvPrice Float 20 Drip reinvestment price 2 CntryCD Char Char String 2 CNTRY ISO Country Divestment - (DVST) Date 1 - Exdate Date 2 - Recdate Date 3 - Paydate Date 4 - StartSubscription Date 5 - EndSubscription Option and Serial ID : None Outurns: Resultant code Ratios: Yes Rates: MinPrice, MaxPrice Floats as above in general spec Priority: Applicable Extra Fields : Yes Element Name DataType Format Max Width Lookup TypeGroup Field Description 1 ResSectyCD Char Char String 3 SECTYPE Resultant Security Type 2 MaxQlyQty Integer 64 bit 11 If the quantity held by shareholder is within this range then he qualifies for taking part in the event. 3 MaxAcpQty Integer 64 bit 11 The TOTAL Quantity the company will accept from all the shareholders tendering their shares in the event for the event to be binding on the offeror. 4 TraSecID Integer 32 bit 10 Security Code of the security that may be created for Trading purposes. 5 TraIsin Char Char String 12 Trading ISIN if applicable/available Entitlements - (ENT) Date 1 - Exdate Date 2 - Recdate Date 3 - Paydate Date 4 - StartSubscription Date 5 - EndSubscription Option and Serial ID : Dummies Outurns: Successor code Ratios: Yes Rates: IssuePrice Floats as above in general spec Priority: Applicable Extra Fields : Yes Element Name DataType Format Max Width Lookup TypeGroup Field Description 1 ResSectyCD Char Char String 3 SECTYPE Resultant Security Type 2 OverSubscription Char Char String 1 BOOLEAN Franking - (FRANK) Date 1 - Exdate Date 2 - Recdate Date 3 - Paydate Option and Serial ID : Dummies Outurns: No Ratios: No Rates: No Priority: Applicable Extra Fields : Yes Element Name DataType Format Max Width Lookup TypeGroup Field Description 1 Frankflag Char Char String 1 FRANKFLAG Franking type. 2 FrankDiv Float 20 Franked amount if partially franked 3 UnFrankDiv Float 20 Unfranked amount if partially franked Financial Transaction Tax - (FTT) Date 1 - FTTStartDate Date 2 - FTTEndDate Option and Serial ID : Dummies Outurns: No Ratios: No Rates: No Priority: Not Applicable Extra Fields : None Financial Year Change - (FYCHG) Date 1 - NotificationDate Date 2 - OldFYStartDate Date 3 - OldFYEndDate Date 4 - NewFYStartDate Date 5 - NewFYEndDate Option and Serial ID : Dummies Outurns: None Ratios: None Rates: None Priority: Not Applicable Extra Fields : Yes Element Name DataType Format Max Width Lookup TypeGroup Field Description 1 RelEvent VarChar Char String 10 TABLENAME Event related to or causing the current event. e.g. Subdivision could be the the related event of a Sedol Change Event International Code Change - (ICC) Date 1 - EffectiveDate Option and Serial ID : Dummies Outurns: None Ratios: None Rates: None Priority: Not Applicable Extra Fields : Yes Element Name DataType Format Max Width Lookup TypeGroup Field Description EventType VarChar Char String 10 EVENT Event type code 1 OldISIN Char Char String 12 Old Isin 2 NewISIN Char Char String 12 New Isin 3 OldUSCode Char Char String 9 Old US code 4 NewUSCode Char Char String 9 New US code 5 RelEventID Integer 32 bit 10 Link to related event if available Incorporation Change - (INCHG) Date 1 - EffectiveDate Option and Serial ID : Dummies Outurns: None Ratios: None Rates: None Priority: Not Applicable Extra Fields : Yes Element Name DataType Format Max Width Lookup TypeGroup Field Description 1 EventType VarChar Char String 10 EVENT Event type code 2 OldCntryCD Char Char String 2 CNTRY Old ISO Country 3 NewCntryCD Char Char String 2 CNTRY New ISO Country Issuer Name Change - (ISCHG) Date 1 - EffectiveDate Option and Serial ID : Dummies Outurns: None Ratios: None Rates: None Priority: Not Applicable Extra Fields : Yes Element Name DataType Format Max Width Lookup TypeGroup Field Description 1 EventType VarChar Char String 10 EVENT Event type code 2 IssOldName VarChar Char String 70 Old Issuer Name 3 IssNewName VarChar Char String 70 New Issuer Name 4 LegalName Char Char String 1 BOOLEAN Flagged if IssNewName is the legal name 5 MeetingDateFlag Char Char String 1 BOOLEAN Lawsuit - (LAWST) Date 1 - EffectiveDate Date 2 - Regdate Option and Serial ID : Dummies Outurns: None Ratios: None Rates: None Priority: Not Applicable Extra Fields : Yes Element Name DataType Format Max Width Lookup TypeGroup Field Description 1 LAType Char Char String 10 Indicates if the Lawsuit is a class action Local Code Change - (LCC) Date 1 - EffectiveDate Option and Serial ID : Dummies Outurns: None Ratios: None Rates: None Priority: Not Applicable Extra Fields : Yes Element Name DataType Format Max Width Lookup TypeGroup Field Description 1 EventType VarChar Char String 10 EVENT Event type code 2 OldLocalCode VarChar Char String 50 3 NewLocalCode VarChar Char String 50 4 RelEventID Integer 32 bit 10 Link to related event if available Liquidation - (LIQ) Date 1 - Recdate Date 2 - Paydate Date 3 - Option Election Date Option and Serial ID : Real Outurns: Resultant code Ratios: Yes Rates: MinPrice, MaxPrice Floats as above in general spec Priority: Not Applicable Extra Fields : Yes Element Name DataType Format Max Width Lookup TypeGroup Field Description 1 ResSectyCD Char Char String 3 SECTYPE Resultant Security Type 2 Liquidator VarChar Char String 50 Name of the agency appointed for liquidating the assets of the company. 3 LiqAdd1 VarChar Char String 50 Address Line 1 4 LiqAdd2 VarChar Char String 50 Address Line 2 5 LiqAdd3 VarChar Char String 50 Address Line 3 6 LiqAdd4 VarChar Char String 50 Address Line 4 7 LiqAdd5 VarChar Char String 50 Address Line 5 8 LiqAdd6 VarChar Char String 50 Address Line 6 9 LiqCity VarChar Char String 50 City 10 LiqCntryCD Char Char String 2 CNTRY ISO Country 11 LiqTel VarChar Char String 50 Phone 12 LiqFax VarChar Char String 50 Fax 13 LiqEmail VarChar Char String 50 Email Listing Status Change - (LSTAT) Date 1 - EffectiveDate Date 2 - NotificationDate Option and Serial ID : Dummies Outurns: None Ratios: None Rates: None Priority: Not Applicable Extra Fields : Yes Element Name DataType Format Max Width Lookup TypeGroup Field Description 1 EventType VarChar Char String 10 EVENT Event type code 2 OldLStatStatus Char Char String 1 LISTSTAT Old Listing Status 3 LStatStatus Char Char String 1 LISTSTAT New Listing Status Lot Change - (LTCHG) Date 1 - EffectiveDate Option and Serial ID : Dummies Outurns: None Ratios: None Rates: None Priority: Not Applicable Extra Fields : Yes Element Name DataType Format Max Width Lookup TypeGroup Field Description 1 EventType VarChar Char String 10 EVENT Event type code 2 OldLot Integer 32 bit 10 Old lot size 3 OldMinTrdQty Integer 32 bit 10 Old Minimum Trading Quantity 4 NewLot Integer 32 bit 10 New lot size 5 NewMinTrdgQty Integer 32 bit 10 New Minimum Trading Quantity Market Segment Change - (MKCHG) Date 1 - EffectiveDate Option and Serial ID : Dummies Outurns: None Ratios: None Rates: No Priority: Not Applicable Extra Fields : Yes Element Name DataType Format Max Width Lookup TypeGroup Field Description 1 EventType VarChar Char String 10 EVENT Event type code 2 OldMIC Char Char String 6 3 NewMIC Char Char String 6 4 OldMktsegment Int 32 bit 11 5 NewMktsegment Int 32 bit 11 Merger - (MRGR) Date 1 - Exdate Date 2 - Recdate Date 3 - Paydate Date 4 - AppointedDate Date 5 - EffectiveDate Date 6 - WithdrawalFromdate Date 7 - WithdrawalTodate Date 8 - OptionElectionDate Option and Serial ID : Real Outurns: Resultant code Ratios: Yes Rates: MinPrice, MaxPrice Floats as above in general spec Priority: Applicable Extra Fields : Yes Element Name DataType Format Max Width Lookup TypeGroup Field Description 1 MrgrStatus Char Char String 1 MRGRSTAT Progress of the Merger 2 WithdrawalRights Char Char String 1 BOOLEAN True or False New Listing - (NLIST) Date 1 - EffectiveDate Option and Serial ID : Dummies Outurns: None Ratios: None Rates: None Priority: Not Applicable Extra Fields : None Odd Lot Offer - (ODDLT) Date 1 - StartDate Date 2 - EndDate Date 3 - Recdate Date 4 - Paydate Date 5 - Withdrawalfromdate Date 6 - Withdrawaltodate Date 7 - OptElectionDate Option and Serial ID : OptionID real, Serial ID real Outurns: Resultant code Ratios: Yes Rates: MinPrice, MaxPrice Floats as above in general spec Priority: Applicable Extra Fields : Yes Element Name DataType Format Max Width Lookup TypeGroup Field Description 1 MinQlyQty Integer 64 bit 11 If the quantity held by shareholder is within this range then he qualifies for taking part in the event. 2 MaxQlyQty Integer 64 bit 11 If the quantity held by shareholder is within this range then he qualifies for taking part in the event. 3 WithdrawalRights Char Char String 1 BOOLEAN True or False 4 MinOfrQty Integer 64 bit 11 The Quantity range within which the Shareholder can offer from his total holding in the event. 5 MaxOfrQty Integer 64 bit 11 The Quantity range within which the Shareholder can offer from his total holding in the event. 6 MinAcpQty Integer 64 bit 11 The TOTAL Quantity the company will accept from all the shareholders tendering their shares in the event for the event to be binding on the offeror. 7 MaxAcpQty Integer 64 bit 11 The TOTAL Quantity the company will accept from all the shareholders tendering their shares in the event for the event to be binding on the offeror. 8 BuyIn Char Char String 1 9 BuyInCurenCD Char Char String 3 10 BuyInPrice Varchar Char String 20 Property Income Distribution - (PID) Date 1 - Exdate Date 2 - Recdate Date 3 - Paydate Option and Serial ID : Dummies Outurns: No Ratios: No Rates: No Priority: Applicable Extra Fields : Yes Element Name DataType Format Max Width Lookup TypeGroup Field Description 1 NonPID Float 20 Indicates the portion of the dividend that is not Property Income Distribution 2 PID Float 20 Indicates the portion of the dividend that is Property Income Distribution Purchase Offer - (PO) Date 1 - Exdate Date 2 - Recdate Date 3 - Paydate Date 4 - Offer Opens date Date 5 - Offer Closes date Option and Serial ID : Dummies Outurns: None Ratios: None Rates: MinPrice, MaxPrice Floats as above in general spec Priority: Applicable Extra Fields : Yes Element Name DataType Format Max Width Lookup TypeGroup Field Description 1 POMinPercent Float 20 TOTAL Percentage of the shares outstanding that the purchaser will buy from the shareholders. 2 POMaxPercent Float 20 TOTAL Percentage of the shares outstanding that the purchaser will buy from the shareholders. 3 MinOfrQty Integer 64 bit 11 The Quantity range within which the Shareholder can offer from his total holding in the event. 4 MaxOfrQty Integer 64 bit 11 The Quantity range within which the Shareholder can offer from his total holding in the event. 5 TndrStrkPrice Float 20 If the event is via a Tender process it is the cut off price at which all the bids are accepted. 6 TndrPriceStep Float 20 If the event is via a Tender then there is a price step in which one can put in the bids. Eg. If the price step specified is 10p then one has to make bids in steps of 10p i.e. GBP 1.10, GBP 1.20, GBP 1.30. 7 MinQlyQty Integer 64 bit 11 If the quantity held by shareholder is within this range then he qualifies for taking part in the event. 8 MaxQlyQty Integer 64 bit 11 If the quantity held by shareholder is within this range then he qualifies for taking part in the event. 9 MinAcpQty Integer 64 bit 11 The TOTAL Quantity the company will accept from all the shareholders tendering their shares in the event for the event to be binding on the offeror. 10 MaxAcpQty Integer 64 bit 11 The TOTAL Quantity the company will accept from all the shareholders tendering their shares in the event for the event to be binding on the offeror. 11 SealedBid Char Char String 1 BOOLEAN True if Sealed Bid Primary Exchange Change - (PRCHG) Date 1 - EffectiveDate Option and Serial ID : Dummies Ratios: None Rates: None Priority: Not Applicable Extra Fields : Yes Element Name DataType Format Max Width Lookup TypeGroup Field Description 1 EventType VarChar Char String 10 EVENT Event type code 2 OldExchgCD VarChar Char String 6 EXCHANGE Old Primary Exchange Code 3 NewExchgCD VarChar Char String 6 EXCHANGE New Primary Exchange Code Preferential Offer - (PRF) Date 1 - Exdate Date 2 - Recdate Date 3 - Paydate Date 4 - Start Subscription Date 5 - End Subscription Option and Serial ID : Dummies Outurns: Resultant code Ratios: Yes Rates: MinPrice, MaxPrice Floats as above in general spec Priority: Applicable Extra Fields : Yes Element Name DataType Format Max Width Lookup TypeGroup Field Description 1 ResSectyCD Char Char String 3 SECTYPE Resultant Security Type 2 OffereeIssID Integer 32 bit 10 Offeree Issuer ID 3 OffereeName VarChar Char String 70 Name of the issuer making the offer but the issuer is not available on in the feed. 4 TndrStrkPrice Float 20 If the event is via a Tender process it is the cut off price at which all the bids are accepted. 5 TndrPriceStep Float 20 If the event is via a Tender then there is a price step in which one can put in the bids. Eg. If the price step specified is 10p then one has to make bids in steps of 10p i.e. GBP 1.10, GBP 1.20, GBP 1.30. 6 MinPrice Float 20 Price range within which the event would take place. 7 MaxPrice Float 20 Price range within which the event would take place. 8 MinQlyQty Integer 64 bit 11 If the quantity held by shareholder is within this range then he qualifies for taking part in the event. 9 MaxQlyQty Integer 64 bit 11 If the quantity held by shareholder is within this range then he qualifies for taking part in the event. 10 MinAcpQty Integer 64 bit 11 The TOTAL Quantity the company will accept from all the shareholders tendering their shares in the event for the event to be binding on the offeror. 11 MaxAcpQty Integer 64 bit 11 The TOTAL Quantity the company will accept from all the shareholders tendering their shares in the event for the event to be binding on the offeror. Parvalue Redenomination - (PVRD) Date 1 - EffectiveDate Option and Serial ID : Dummies Outurns: None Ratios: No Rates: No Priority: Not Applicable Extra Fields : Yes Element Name DataType Format Max Width Lookup TypeGroup Field Description 1 RelEvent VarChar Char String 10 TABLENAME Event related to or causing the current event. e.g. Subdivision could be the the related event of a Sedol Change Event 2 PVCurrency Char Char String 3 CUREN Security Parvalue Currency 3 OldParValue Float 20 Par Value may change in Currency Redenomination. Both are provided for reference. 4 NewParValue Float 20 Par Value may change in Currency Redenomination. Both are provided for reference. Return of Capital - (RCAP) Date 1 - Effective date Date 2 - Recdate Date 3 - Paydate Option and Serial ID : Dummies Outurns: Successor code Ratios: None Rates: CashBak Floats as above in general spec Priority: Applicable Extra Fields : None Preference Redemeption - (REDEM) Date 1 - Redemption date Option and Serial ID : Dummies Outurns: None Ratios: None Rates: RedemPrice Priority: Not Applicable Extra Fields : Yes Element Name DataType Format Max Width Lookup TypeGroup Field Description 1 MandOptFlag Char Char String 1 MANDOPT Is the redemption for this date Mandatory or Optional to the bond holder. Some securities can have several redemption dates (eg. Preference share) during the life of the security while others may just have one (eg. Bonds). 2 PartFinal VarChar Char String 1 PARTFINAL Is the redemption for this date Part or Final. Part redemptions may be mandatory. 3 RedemType Char Char String 10 REDEMTYPE A lookup table indicating the variety of redemptions possible. Eg. Amortisation, Sinking fund, bullet etc. 4 AmountRedeemed Float 20 5 RedemPremium Float 20 6 PriceAsPercent Float 20 7 PremiumAsPercent Float 20 8 RedemPercent Float 20 Redemption in %. To allow for Redemption of security which is only on % basis. 9 PoolFactor Float 20 The outstanding principal balance divided by the original principal balance with the result expressed as a Float. Useful in calculating redemption and outstanding par value. Introduced to capture this figure whenever its available. Rights - (RTS) Date 1 - Exdate Date 2 - Recdate Date 3 - Paydate Date 4 - StartSubscription Date 5 - EndSubscription Date 6 - StartTrade Date 7 - EndTrade Date 8 - Splitdate Rights Split Date: Split date concept in rights is known in asian countries where the lot size is more than 1. If the shareholder is suppose to receive 100 shares because of rights and the lost size is 50 then he will receive 2 physical certificates. Split date is only for shares in physical form. If the share holders wants 10 certificates for 100 shares companies can do it and the split date is the date when this shares are split by the company. Option and Serial ID : Dummies Outurns: Resultant (Note also Trading and Poison Pill in extra fields section) Ratios: Yes Rates: IssuePrice, LapsedPremium Floats as above in general spec Priority: Applicable Extra Fields : Yes Element Name DataType Format Max Width Lookup TypeGroup Field Description 1 TraSecID Integer 32 bit 10 Security Code of the security that may be created for Trading purposes. 2 TraIsin Char Char String 12 Trading ISIN if applicable/available 3 PPSecID Integer 32 bit 10 Poison Pill Rights: This rights behave same as normal rights but they do not trade at all. This rights are normally announced by the company to avoid hostile takeover. 4 PPIsin Char Char String 12 PP ISIN if applicable/available 5 OverSubscription Char Char String 1 BOOLEAN 6 ResSectyCD Char Char String 3 SECTYPE Resultant Security Type Security Description Change - (SCCHG) Date 1 - EffectiveDate Option and Serial ID : Dummies Outurns: None Ratios: None Rates: None Priority: Not Applicable Extra Fields : Yes Element Name DataType Format Max Width Lookup TypeGroup Field Description 1 EventType VarChar Char String 10 EVENT Event type code 2 SecOldName VarChar Char String 70 Previous Name 3 SecNewName VarChar Char String 70 New Name 4 OldSectyCD Char Char String 3 SECTYPE Old Security type code 5 NewSectyCD Char Char String 3 SECTYPE New Security type code 6 OldRegS144A Char Char String 10 REGS144A OldRegS144A Value 7 NewRegS144A Char Char String 10 REGS144A NewRegS144A Value Security Swap - (SCSWP) Date 1 - Exdate Date 2 - Recdate Date 3 - Paydate Option and Serial ID : Dummies Outurns: Resultant code Ratios: Yes Floats as above in general spec Rates: None Priority: Applicable Extra Fields : Yes Element Name DataType Format Max Width Lookup TypeGroup Field Description 1 ResSectyCD Char Char String 3 SECTYPE Resultant Security Type Subdivision (AKA - Forward Stock Split) - (SD) Date 1 - Exdate Date 2 - Recdate Date 3 - Paydate Option and Serial ID : Dummies Outurns: Successor code Ratios: Yes Floats as above in general spec Rates: None Priority: Applicable Extra Fields : Yes Element Name DataType Format Max Width Lookup TypeGroup Field Description 1 OldParValue Float 20 Par Value may change in Consolidation. Both are provided for reference. 2 NewParValue Float 20 Par Value may change in Consolidation. Both are provided for reference. 3 OldCurenCD Char Char String 3 CUREN ISO Old Currency Code 4 NewCurenCD Char Char String 3 CUREN ISO New Currency Code Security Reclassification - (SECRC) Date 1 - Effectivedate Option and Serial ID : Dummies Outurns: Resultant code Ratios: Yes Floats as above in general spec Rates: None Priority: Not Applicable Extra Fields : Yes Element Name DataType Format Max Width Lookup TypeGroup Field Description 1 RelEvent VarChar Char String 10 TABLENAME Event related to or causing the current event. e.g. Subdivision could be the the related event of a Sedol Change Event 2 ResSectyCD Char Char String 3 SECTYPE Resultant Security Type Takeover - (TKOVR) Date 1 - Opendate Date 2 - Closedate Date 3 - Recdate Date 4 - Cmacqdate Date 5 - Paydate Date 6 - Optelectiondate Date 7 - Withdrawalfromdate Date 8 - Withdrawaltodate Date 9 - UnconditionalDate Date 10 - ToDate Date 11 - RegistrationDate Option and Serial ID : Real Outurns: Resultant code Ratios: Yes Rates: MinPrice, MaxPrice Floats as above in general spec Priority: Applicable Extra Fields : Yes Element Name DataType Format Max Width Lookup TypeGroup Field Description 1 TkovrStatus Char Char String 1 TKOVRSTAT Takeover status 2 OfferorIssID Integer 32 bit 10 Internal IssID of the Offeror 3 OfferorName VarChar Char String 70 Name of the issuer making the offer but the issuer is not available on this feed. 4 Hostile Char Char String 1 BOOLEAN True if hostile takeover 5 MiniTkovr Char Char String 1 BOOLEAN True if Mini-Takeover. 6 ResSecType Char Char String 3 SECTYPE Resultant Security Type 7 TargetQuantity Integer 64 bit 11 Total Quantity of shares targeted for the Takeover by the offeror 8 TargetPercent Float 20 Percentage of the Company&s shares outstanding targeted by the Offeror. 9 MinAcpQty Integer 64 bit 11 The TOTAL Quantity the company will accept from all the shareholders tendering their shares in the event for the event to be binding on the offeror. 10 MaxAcpQty Integer 64 bit 11 The TOTAL Quantity the company will accept from all the shareholders tendering their shares in the event for the event to be binding on the offeror. 11 PreOfferQty Integer 64 bit 11 Number of shares held by the Offeror prior to making the Takeover offer 12 PreOfferPercent Float 20 Percentage of the Company&s shares outstanding that the Offeror held prior to making the Takeover offer 13 TndrStrkPrice Float 20 If the event is via a Tender process it is the cut off price at which all the bids are accepted. 14 TndrPriceStep Float 20 If the event is via a Tender then there is a price step in which one can put in the bids. Eg. If the price step specified is 10p then one has to make bids in steps of 10p i.e. GBP 1.10, GBP 1.20, GBP 1.30. 15 MinQlyQty Integer 64 bit 11 If the quantity held by shareholder is within this range then he qualifies for taking part in the event. 16 MaxQlyQty Integer 64 bit 11 If the quantity held by shareholder is within this range then he qualifies for taking part in the event. 17 MinOfrQty Integer 64 bit 11 The Quantity range within which the Shareholder can offer from his total holding in the event. 18 MaxOfrQty Integer 64 bit 11 The Quantity range within which the Shareholder can offer from his total holding in the event. 19 DutchAuction Char Char String 1 BOOLEAN 20 WithdrawalRights Char Char String 1 Preference Offer - (POFF) Date 1 - Listdate Date 2 - RedemptionDate Date 3 - RecordDate Date 4 - TenderOpenDate Date 5 - TenderCloseDate Option and Serial ID: Dummies Outurns: None Ratios: No Rates: Price Element Name DataType Format Max Width Lookup TYPEGROUP Field Description Price Numeric v14.5 14 Priority: Not Applicable Extra Fields : Yes Element Name DataType Format Max Width Lookup TypeGroup Field Description OfferType Char Char String 10 REDEMTYPE OfferAmount Numeric v14.5 14 The total value of all the bonds redeemed i.e. in Millions. Mutually exclusive from Redemption in %. PartFinal VarChar Char String 1 PARTFINAL Choice Char Char String 1 MANDOPT RedemtionPremium Numeric v14.5 14 Currency Premium paid on the original par value of the Bond at the time of redemption of the Bond. This is over and above the Redemption Amount. PriceAsPercent Numeric v14.9 14 Price expressed as a percentage PremiumAsPercent Numeric v14.9 14 Premium expressed as a percentage TenderOfferor VarChar Char String 70 Name of Offerer if it is different from the Issuer PoolFactor Numeric v13.9 13 Preference Exchange Offer - (PXOF) Date 1 - ListDate Date 2 - PeriodStartDate Date 3 - PeriodEndDate Date 4 - SettlementDate Date 5 - RecordDate Option and Serial ID : Dummies Outturns : Resultant code Ratios: No Rates: Price Element Name DataType Format Max Width Lookup TYPEGROUP Field Description Price Numeric v14.5 14 Priority: Not Applicable Extra Fields : Yes Element Name DataType Format Max Width Lookup TypeGroup Field Description OfferType Char Char String 10 CONVTYPE OfferAmount Numeric v14.5 14 OutturnSectyCD Char Char String 3 SECTYPE Resultant Security Type Choice Char Char String 1 MANDOPT PartFinal Char Char String 1 PARTFINAL Preference Conversion - (PCON) Date 1 - ListDate Date 2 - PeriodStartDate Date 3 - PeriodEndDate Date 4 - SettlementDate Date 5 - RecordDate Option and Serial ID : Dummies Outturns : Resultant code Ratios: Yes Rates: Price Element Name DataType Format Max Width Lookup TYPEGROUP Field Description Price Numeric v14.5 14 Priority: Not Applicable Extra Fields : Yes Element Name DataType Format Max Width Lookup TypeGroup Field Description OfferType Char Char String 10 CONVTYPE OfferAmount Numeric v14.5 14 OutturnSectyCD Char Char String 3 SECTYPE Resultant Security Type Choice Char Char String 1 MANDOPT PartFinal Char Char String 1 PARTFINAL Preference Redemption - (PRED) Date 1 - ListDate Date 2 - RedemptionDate Date 3 - RecordDate Option and Serial ID : Dummies Outurns: None Ratios: No Rates: Price Element Name DataType Format Max Width Lookup TYPEGROUP Field Description Price Numeric v14.5 14 Priority: Not Applicable Extra Fields : Yes Element Name DataType Format Max Width Lookup TypeGroup Field Description OfferType Char Char String 10 REDEMTYPE OfferAmount Numeric v14.5 14 The total value of all the bonds redeemed i.e. in Millions. Mutually exclusive from Redemption in %. PartFinal VarChar Char String 1 PARTFINAL Choice Char Char String 1 MANDOPT RedemtionPremium Numeric v14.5 14 Currency Premium paid on the original par value of the Bond at the time of redemption of the Bond. This is over and above the Redemption Amount. PriceAsPercent Numeric v14.9 14 Price expressed as a percentage PremiumAsPercent Numeric v14.9 14 Premium expressed as a percentage PoolFactor Numeric v13.9 13 Preference Amount Outstanding - (PAMO) Date 1 - EffectiveDate Date 2 - OldOutstandingDate Date 3 - NewOutstandingDate Option and Serial ID : Dummies Outurns: None Ratios: No Rates: None Priority: Not Applicable Extra Fields : Yes Element Name DataType Format Max Width Lookup TypeGroup Field Description Eventtype VarChar Char String 10 EVENT Event related to or causing the current event. e.g. Subdivision could be the the related event of a Sedol Change Event OldOutValue Numeric v18.5 18 Previous outstanding amount value NewOutValue Numeric v18.5 18 New outstanding amount value RelEventId Integer 32 bit 10 EventID of the linked record Interest Payment Dividend - (IDIV) Fields marked with * are blank in this event Date 1 - Exdate Date 2 - RecDate Date 3 - Paydate Date 4 - PayDate2 *Date 5 - FYEDate *Date 6 - PeriodEndDate Date 7 - OptElectionDate *Date 8 - ToDate *Date 9 - RegistrationDate *Date 10 - DeclarationDate Date 11 - ExDate2 *Date 12 - FXDate Option and Serial ID : OptionID real, Serial ID dummies Outurns: Resultant code Ratios: Yes Decimals as above in general spec Rates: Gross and Net Dividend GrossDividend Decimal 18.9 18 Total Dividend amount NetDividend Decimal 18.9 18 Dividend net of taxes (if any) to the shareholder Priority: Applicable Extra Fields : Yes Element Name DataType Format Max Width Lookup TypeGroup Field Description *Marker Char Char String 3 MARKER Dividend Marker Frequency Char Char String 3 FREQ Dividend Frequency *Tbaflag Char Char String 1 BOOLEAN The company intends to pay a dividend but the details are yet to be announced NilDividend Char Char String 1 BOOLEAN Real Dividend event but of zero payrate. DivRescind Char Char String 1 BOOLEAN Real Dividend event but of zero payrate. *RecindCashDiv Char Char String 1 BOOLEAN Cash Dividend Cancelled. RecindStockDiv Char Char String 1 BOOLEAN Stock Dividend Cancelled. *Approxflag Char Char String 1 BOOLEAN If dividend is temporarily an approximate value. Expect an update. TaxRate Decimal 14.5 14 Domestic withholding tax rate *Depfees Decimal 14.5 14 Depositary fees - Applies only to DR dividends Coupon VarChar Char String 25 In countries where coupons are to be submitted to obtain a benefit this field is useful *Dapflag Char Char String 1 YNBLANK Divdend Access Plan Available (GB only) *InstallmentPayDate Date yyyy/mm/dd 10 *DeclCurenCD Char Char String 3 CUREN Declared Currency Code *DeclGrossAmt Varchar Char String 20 Declared Gross Amount