Announce something here

edi_corporateactions_notes
Contact Sales Team

edi_corporateactions_notes by EDI

Dataset Name: edi_corporateactions_notes


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): 23:30 EST
Data Update Frequency: day

Corporate actions are an activity that brings material change to an organization and impacts its stakeholders, including shareholders, both common and preferred, as well as bondholders. These events are generally approved by the company's board of directors; shareholders may be permitted to vote on some events as well. Common corporate actions are dividends, splits, and consolidations.

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.
muts uint64 Microseconds Unix Timestamp. An integer representation of a timestamp with microsecond precision that can be compared directly to other timestamps.
symbol string Trading Symbol or Ticker
ntsactioncd string Record Action Status Code
ntsaction string Record Action Status
ntschangedt string Record Last Changed Date and Time
reflinkid int Reference Data Link ID. SecID for Security Level Events, IssID for Issuer Level Events
notestype string Underlying WCA Notes Fieldname. Usually only one per Event with the value of Notes, but where more than one, the value indicates the notes subject.
notestext string Event Narrative Text. Each time textual changes are made to the event narrative text, the text is first copied to the top of the memo, dated and changes made. This means earlier versions are preseved unchanged for reference purposes.
lstuniqueid int64 Unique Listing Record ID - Concatenation of a sequence number and the WCA ScexhID. The sequence number will usually be 1 unless additional listings exists for the same security in the same market, usually as a result of secondary trading currencies.
scexhid int Unique global level Listing ID
listsourceflag string Indicates if the listing level data in the record is (M)ain or (S)econdary.
listsource string List Source
globalstatuscd string Global Status Code. Indicates the global listing activity status of a security.
globalstatus string Global Status Value
issid int Unique global level Issuer ID (can be used to link all securities of a company togther)
issuername string Name of Issuer
secid int Unique global level Security ID (can be used to link all multiple listings together
securitydescription string Security Description
parvalue double Security Parvalue
parvaluecurencd string Parvalue Currency Code - ISO 4217
parvaluecuren string Parvalue Currency
isin string International Securities Identification Number. An international code which identifies a securities issue
uscode string USCode (global level identifier)
sectycd string Type of Equity Instrument
secty string Type of Equity Instrument
primaryexchgcd string Exchange code for the primary listing (empty if unknown)
primaryexchg string Primary Exchange
listcntrycd string Listing Country Code - ISO 3166-1
listcntry string Listing Country
registercntrycd string Register Country Code - ISO 3166-1
registercntry string Register Country
tradingcurencd string Trading Currency Code - ISO 4217
tradingcuren string Trading Currency
multicurenflag string Set to (T)rue if there is currently more than one listing in the market, otherwise set to (F)alse.
multicuren string Multi-Currency
bbgcompid string Bloomberg Composite Global ID
bbgcompticker string Bloomberg Composite Ticker
bbgcomptickerlup string Bloomberg Composite Ticker lookup value
figi string FIGI ID. The FIGI code (https://www.openfigi.com) that identifies the stock across related exchanges in the same country.
figiticker string FIGI ID. The FIGI code (https://www.openfigi.com) that identifies the stock across related exchanges in the same country.
sedol string Sedol for underlying constituent. Stock Exchange Daily Official List identifier assigned by the London Stock Exchange, requires SEDOL license
sedoldefunct string Indicates a defunct SEDOL
sedoldefunctlup string Defunct Sedol
sedolmic string Main Operational Market Identifier code indicated by the London Stock Exchange - ISO 10383 with a small number of non standard codes.
sedolmiclup string SEDOL Market
exchgcd string EDI maintained Exchange code. Equivalent to the MIC code but necessary as MIC might not be available in a timely fashion.
exchg string Exchange or Market place name
operationalmic string Operational Market Identification Code - ISO 10383
operationalmiclup string Operational Exchange
lotsize int Lot Size. Indicates the minimum number of shares that can be aquired in one transaction.
segmentmicname string Market Segment Name. Not the ISO 10383 MICSEG lookup name but used when no Segment MIC is available.
segmentmic string Market Identification Code - ISO 10383
segmentmiclup string Segment Market
localcode string Local Code. Usually unique at Market Level but there are exceptions to this rule. Either an alpha string, or a number.
localdot string Local Code but with Market formatting using dot separator. Only currently reformatted for NYSE, otherwise the LocalDot value equals the Localcode value.
localslash string Local Code but with Market formatting using a forward slash separator. Only currently reformatted for NYSE, otherwise LocalSlash value equals Localcode value.
localspace string Local Code but with Market formatting using space separator. Only currently reformatted for NYSE, otherwise LocalSpace value equals Localcode value.
liststatuscd string Listing Status Code. Indicates the listing activity status at market level
liststatus string Indicates whether a security is Listed on an Exchange or Unlisted Indicates Exchange Listing Status
listdt string Listing Date
delistdt string Delisting Date
evtuniqueid int64 Unique LST EVT Record Identifier when combined with LstUniqueID
evtactioncd string Record Action Status Code
evtaction string Record Action Status
evtchangedt string Record Last Changed Date and Time
eventcreatedt string Event Creation Date
eventcd string Event type code
eventid int Unique global Event Identifier combined with Event type code
eventsubtypecd string Event Subtype Code. This is only used for a limited number of events where the Event data supplied falls into distinct subgroupings.
eventsubtype string Event Subtype
relatedeventcd string Related Event Code
relatedeventid int Direct Link to another Event when combined with this ID and the Related Event Code.
mandvoluflag string Indicates Mandatory and/or Voluntary Event participation requirement. With a few Event types the flag change in the course of the corporate action lifecycle.
mandvolu string Mandatory or Voluntary Event
rdid int Record Date ID. Useful to link to other records sharing the same record date
rdpriority int The Priority Order Number sequence where populated is necessary to correctly calculate resultant cash and stock outcomes.
primarydtlabel string The main Calendar Date Name for the Event
primarydtvalue string The main Calendar Date Value for the Event in YYY/MM/DD format
effectivedt string Effective Date
exdt string Ex Date - Where the PaytypeCD of a Multiple Payment Event is flagged as a (B)oth, this Ex Date field will contain the Ex Date of the Cash component. The ExDate2 field in the Event Assignable Date section will carry the Stock component Ex Date.
recorddt string Record Date
paydt string Pay Date - Where the PaytypeCD of a Multiple Payment Event is flagged as a (B)oth, this Pay Date field will contain the Pay Date of the Cash component. The PayDate2 field in the Event Assignable Date section will carry the Stock component Pay Date.
duebillsredemdt string Due Bills Redemption Date
fromdt string From Date
todt string To Date
registrationdt string Registration Date
startdt string Start Date
enddt string End Date
opendt string Open Date
closedt string Close Date
startsubscriptiondt string Start Subscription Date
endsubscriptiondt string End Subscription Date
optionelectiondt string Option Election Date
wthdrlrtsfromdt string Withdrawal From Date
wthdrlrtstodt string Withdrawal To Date
notificationdt string Notification Date
financialyearenddt string Financial Year End Date
expcompletiondt string Expected Completion Date
datelabel01 string Event assignable Date Label 1
datevalue01 string Event assignable Date Value 1
datelabel02 string Event assignable Date Label 2
datevalue02 string Event assignable Date Value 2
datelabel03 string Event assignable Date Label 3
datevalue03 string Event assignable Date Value 3
datelabel04 string Event assignable Date Label 4
datevalue04 string Event assignable Date Value 4
datelabel05 string Event assignable Date Label 5
datevalue05 string Event assignable Date Value 5
datelabel06 string Event assignable Date Label 6
datevalue06 string Event assignable Date Value 6
datelabel07 string Event assignable Date Label 7
datevalue07 string Event assignable Date Value 7
datelabel08 string Event assignable Date Label 8
datevalue08 string Event assignable Date Value 8
paytypecd string WCA proprietary Payment Type Code
paytype string Paytype flag
optionid int Mulitple Payment Option ID - Groups together multiple elements that comprise a complete payment option e.g. Part Cash, part Stock
serialid int Mulpile Payment Serial ID - Enumerates each element of an option from a multiple payment so the the combination of OptionID and SerialID
defaultoptionflag string Flag indicating the benefit the shareholder would receive by default in case of several options being offered to them. The default is not always announced.
defaultoption string Default Option
ratecurencd string Payment Currency Code - ISO 4217
ratecuren string Payment Currency
ratelabel01 string Rate 1 Event SpecificPayment Fieldname
ratevalue01 double Rate 1 Event Specific Payment Value
ratelabel02 string Rate 2 Event Specific Payment Fieldname
ratevalue02 double Rate 2 Event Specific Payment Value
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
fractioncd string WCA proprietary code describing how Fractions are handled in Settlement calculations.
fraction string Fraction
outturnstylecd string WCA Code for style of Outturn Security
outturnstyle string Style of Outturn Security
outsectycd string EDI proprietary code for security asset type
outsecty string Security asset Type
outsecid int The internal EDI ID for the Outturn security
outisin string Outturn ISIN
outuscode string Outturn CUSIP
outlocalcode string Outturn Local Code
outsedol string Outturn SEDOL
outbbgcompid string Outturn Bloomberg Composite ID
outbbgcompticker string Outturn Bloomberg Composite Ticker
outfigi string Outturn FIGI - Bloomberg Exchange Level ID
outfigiticker string Outturn FIGI Ticker - Bloomberg Exchange Level Ticker
minofrqty int The Quantity range within which the Shareholder can offer from his total holding in the event.
maxofrqty int The Quantity range within which the Shareholder can offer from his total holding in the event.
minqlyqty int If the quantity held by shareholder is within this range then he qualifies for taking part in the event.
maxqlyqty int If the quantity held by shareholder is within this range then he qualifies for taking part in the event.
minacpqty int 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.
maxacpqty int 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.
tndrstrkprice double If the event is via a Tender process it is the cut off price at which all the bids are accepted.
tndrpricestep double 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.
wthdrlrtsflag string Withdrawal Rights Flag
wthdrlrts string Withdrawal Rights
oedexptime string Option Expiry Time
oedexptimezone string Option Expiry Timezone
wthdrlrtsexptime string Withdrawal Rights Expiry Time
wthdrlrtsexptimezone string Withdrawal Rights Expiry Timezone
exptime string Expiry Time
exptimezone string Expiry Time Zone
eventlabel01 string Event Label 1
eventvalue01 string Event Value 1
eventlabel02 string Event Label 2
eventvalue02 string Event Value 2
eventlabel03 string Event Label 3
eventvalue03 string Event Value 3
eventlabel04 string Event Label 4
eventvalue04 string Event Value 4
eventlabel05 string Event Label 5
eventvalue05 string Event Value 5
eventlabel06 string Event Label 6
eventvalue06 string Event Value 6
eventlabel07 string Event Label 7
eventvalue07 string Event Value 7
eventlabel08 string Event Label 8
eventvalue08 string Event Value 8
eventlabel09 string Event Label 9
eventvalue09 string Event Value 9
eventlabel10 string Event Label 10
eventvalue10 string Event Value 10
eventlabel11 string Event Label 11
eventvalue11 string Event Value 11
eventlabel12 string Event Label 12
eventvalue12 string Event Value 12
eventlabel13 string Event Label 13
eventvalue13 string Event Value 13
eventlabel14 string Event Label 14
eventvalue14 string Event Value 14
eventlabel15 string Event Label 15
eventvalue15 string Event Value 15
eventlabel16 string Event Label 16
eventvalue16 string Event Value 16
eventlabel17 string Event Label 17
eventvalue17 string Event Value 17
eventlabel18 string Event Label 18
eventvalue18 string Event Value 18
eventlabel19 string Event Label 19
eventvalue19 string Event Value 19
eventlabel20 string Event Label 20
eventvalue20 string Event Value 20
eventlabel21 string Event Label 21
eventvalue21 string Event Value 21
eventlabel22 string Event Label 22
eventvalue22 string Event Value 22
eventlabel23 string Event Label 23
eventvalue23 string Event Value 23
eventlabel24 string Event Label 24
eventvalue24 string Event Value 24


Important Dataset Notes

This dataset is not available for direct online purchase. Please contact sales directly at sales@CloudQuant.com. The data is available through our normal sales department who can provide you with current pricing and a quote for accessing this valuable dataset. This may be due to a number of reasons such as dataset intended use, size of the company (or investment fund) using the dataset, or for simple legal requirements that CloudQuant needs to ensure are in place prior to licensing the dataset to you.