Announce something here

edi_corporate_actions

edi_corporate_actions by EDI

Regular price
$4,200.00 USD
Sale price
$4,200.00 USD
Regular price
Sold out
Unit price
per 






Dataset Name: edi_corporate_actions


Group: reference_data
Vendor: EDI
Data Starts at: 2020-08-17 00:00:00
Symbol Set: Global Equities
Asset Class: Equity
Data Update Time(s): 21:45 EST
Data Update Frequency: day

A cost-effective solution which allows clients to manage corporate action information.

Data Contained in this Dataset

Column Type Description
_seq uint Internal sequence number used to keep data rows in order
timestamp string Timestamp of the Data - America/New York Time.
eventcd string Event type code
eventid uint Unique global Event Identifier combined with Event type code
optionid uint Mulitple Payment Option ID - Groups together multiple elements that comprise a complete payment option e.g. Part Cash, part Stock
serialid uint Mulpile Payment Serial ID - Enumerates each element of an option from a multiple payment so the the combination of OptionID and SerialID
scexhid uint Unique global level Listing ID
bbcid uint EDI Internal unique ID for Bloomberg Composite Codes
bbeid uint EDI Internal unique ID for Bloomberg Exchange Codes
actflag string Event Level Action Status
muts uint64 Microseconds Unix Timestamp. An integer representation of a timestamp with microsecond precision that can be compared directly to other timestamps.
created string Date event first entered
secid uint Unique global level Security ID (can be used to link all multiple listings together
issid uint Unique global level Issuer ID (can be used to link all securities of a company togther)
isin string International Securities Identification Number. An international code which identifies a securities issue
uscode string USCode (global level identifier)
issuername string Name of Issuer
cntryofincorp string ISO Country of Incorporation of Issuer
sic string Standard Industrial Classification Code
cik string Central Index Key
indusid uint EDI Proprietary Industry Sector Code
sectycd string Type of Equity Instrument
securitydesc string Security Description
parvalue double Security Parvalue
pvcurrency string Security Parvalue Currency
statusflag string Inactive at the global level else security is active. Not to be confused with delisted which is inactive at the exchange level
primaryexchgcd string Exchange code for the primary listing (empty if unknown)
bbgcurrency string Bloomberg Trading Currency
bbgcompositeglobalid string Bloomberg composite global ID
bbgcompositeticker string Bloomberg composite ticker
bbgglobalid string Bloomberg global ID
bbgexchangeticker string Bloomberg exchange ticker
structcd string Structured Certificate of Deposit (eg CEF, REIT, MLP, ETF, VCT, SCT, BT, ARF, ETC, CCI, ROYTRT, ETN, ET, PWR&PIPE, ISF)
exchgcntry string Country of Exchange where listed
exchgcd string EDI maintained Exchange code. Equivalent to the MIC code but necessary as MIC might not be available in a timely fashion.
mic string ISO Market Identifier Code for the Exchange. ISO 10383, ISO 20022
micseg string ISO Market Identifier Code for the Exchange. ISO 10383, ISO 20022
liststatus string Indicates whether a security is Listed on an Exchange or Unlisted Indicates Exchange Listing Status
date1type string Type of calendar date
date1 string Calendar date
date2type string Type of calendar date
date2 string Calendar date
date3type string Type of calendar date
date3 string Calendar date
date4type string Type of calendar date
date4 string Calendar date
date5type string Type of calendar date
date5 string Calendar date
date6type string Type of calendar date
date6 string Calendar date
date7type string Type of calendar date
date7 string Calendar date
date8type string Type of calendar date
date8 string Calendar date
date9type string Type of calendar date
date9 string Calendar date
date10type string Type of calendar date
date10 string Calendar date
date11type string Type of calendar date
date11 string Calendar date
date12type string Type of calendar date
date12 string Calendar date
paytype string Paytype flag
rdid uint Record Date ID. Useful to link to other records sharing the same record date
priority uint Indicates order of events where record date is shared
defaultopt string Paytype flag
outturnsecid uint EDI Security ID for an outturn security if any. Where sucessor the outturn SecID will be the same as the parent SecID
outturnisin string ISIN code outturn. These can be resultant OR successor codes.
ratioold double Number of old shares. Number of New Securities the shareholder receives as a proportion of Old Securities surrendered
rationew double Number of new shares
fractions string Fractions
currency string ISO Currency Code
rate1type string Type of of pay rate
rate1 double Pay rate
rate2type string Type of of pay rate
rate2 double Pay rate
field1name string Name of Event specific Field
field1 string Event Specific Field Content
field2name string Name of Event specific Field
field2 string Event Specific Field Content
field3name string Name of Event specific Field
field3 string Event Specific Field Content
field4name string Name of Event specific Field
field4 string Event Specific Field Content
field5name string Name of Event specific Field
field5 string Event Specific Field Content
field6name string Name of Event specific Field
field6 string Event Specific Field Content
field7name string Name of Event specific Field
field7 string Event Specific Field Content
field8name string Name of Event specific Field
field8 string Event Specific Field Content
field9name string Name of Event specific Field
field9 string Event Specific Field Content
field10name string Name of Event specific Field
field10 string Event Specific Field Content
field11name string Name of Event specific Field
field11 string Event Specific Field Content
field12name string Name of Event specific Field
field12 string Event Specific Field Content
field13name string Name of Event specific Field
field13 string Event Specific Field Content
field14name string Name of Event specific Field
field14 string Event Specific Field Content
field15name string Name of Event specific Field
field15 string Event Specific Field Content
field16name string Name of Event specific Field
field16 string Event Specific Field Content
field17name string Name of Event specific Field
field17 string Event Specific Field Content
field18name string Name of Event specific Field
field18 string Event Specific Field Content
field19name string Name of Event specific Field
field19 string Event Specific Field Content
field20name string Name of Event specific Field
field20 string Event Specific Field Content
field21name string Name of Event specific Field
field21 string Event Specific Field Content
field22name string Name of Event specific Field
field22 string Event Specific Field Content
field23name string Name of Event specific Field
field23 string Event Specific Field Content
field24name string Name of Event specific Field
field24 string Event Specific Field Content
symbol string Trading Symbol or Ticker