Source: https://databento.com/docs/schemas/corporate-actions


# Corporate actions

**Corporate actions** includes coverage from 215+ exchanges worldwide, 310,000+ listed and delisted securities from 100,000+ companies, categorized as 60+ event types.
The dataset focuses on crucial events affecting global securities such as dividends, takeovers, mergers & acquisitions and rights issues.

> **See also**
>
> [Reference data enums](https://databento.com/docs/conventions/reference-data-enums.md) for a lookup table of possible enumeration field values.

### Fields

- Timestamps are strings in [ISO 8601](https://www.iso.org/iso-8601-date-and-time-format.html) format, expressed in UTC
- Dates are strings in YYYY-MM-DD [ISO 8601](https://www.iso.org/iso-8601-date-and-time-format.html) format, expressed in the local time of the listing `exchange`
- Enums are strings, with each value corresponding to a predefined set of options listed in the associated lookup table

| Field [//]: # (column: sortable) | Type [//]: # (column: sortable) | Description [//]: # (column: sortable) |
| `ts_record` | Timestamp | The timestamp (UTC) the record last changed. |
| `event_unique_id` | String | Unique corporate actions record identifier. Can be used to deduplicate records for the same event. |
| `event_id` | String | Event identifier unique at the event level. |
| `listing_id` | String | Unique listing numerical ID. Concatenation of a sequence number and the `listing_group_id`. 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. |
| `listing_group_id` | String | Groups all listings for the same security on a specific exchange, often in different trading currencies. |
| `security_id` | String | Security level numerical ID. Can be used to link all multiple listings together. |
| `issuer_id` | String | Issuer level numerical ID. Can be used to link all securities of a company together. |
| `event_action` | Enum | Record action status code. See [ACTION](https://databento.com/docs/conventions/reference-data-enums.md#action) enum. |
| `event` | Enum | Event type. The `event_id` where applicable links all payments rows of an event together to show all the payment options. Can be used as a short event name. See [Corporate actions events](https://databento.com/docs/conventions/corporate-actions-events.md). |
| `event_subtype` | Enum or null | Event subtype. This is only used for a limited number of events where the event data supplied falls into distinct sub-groupings. See [EVENTSUBTYPE](https://databento.com/docs/conventions/reference-data-enums.md#eventsubtype) enum and [Corporate actions events](https://databento.com/docs/conventions/corporate-actions-events.md). |
| `event_date_label` | String | The main calendar date name for the event. |
| `event_date` | Date | The primary date associated with the event, often marking when the event is scheduled to occur or take effect. |
| `event_created_date` | Date | The date on which the event was officially created or recorded in the system. |
| `ex_date` | Date or null | The ex-dividend date (ex-date), marking the first date on which the security trades without the entitlement to the upcoming dividend, distribution, or other corporate action benefit. Where the `payment_type` 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 `ex_date2` field in the `event_info` section will carry the stock component ex-date. |
| `effective_date` | Date or null | The date on which the event becomes effective or is executed, signifying when the changes or actions are officially recognized. |
| `record_date` | Date or null | The date on which a company reviews its records to determine the eligible shareholders entitled to receive dividends or participate in the event. The record date is one business day after the ex-date. |
| `record_date_id` | Date or null | Record date ID. This ID links all events for the same security that share the same record date. |
| `related_event` | Enum or null | Related event type. See [Corporate actions events](https://databento.com/docs/conventions/corporate-actions-events.md). |
| `related_event_id` | Date or null | Direct link to another event. |
| `global_status` | Enum | Global status code. Indicates the global listing activity status of a security. See [GLOBSTATUS](https://databento.com/docs/conventions/reference-data-enums.md#globstatus) enum. |
| `listing_status` | Enum | Listing status code. Indicates the listing activity status at market level. See [LISTSTAT](https://databento.com/docs/conventions/reference-data-enums.md#liststat) enum. |
| `listing_source` | Enum | Indicates if the listing level data in the record is (**M**)ain or (**S**)econdary. See [LISTSOURCE](https://databento.com/docs/conventions/reference-data-enums.md#listsource) enum. |
| `listing_date` | Date or null | The date when the security is officially listed on the exchange and becomes available for trading. |
| `delisting_date` | Date or null | The date when the security is officially removed from the exchange and ceases to be traded. |
| `issuer_name` | String | The issuer name. |
| `security_type` | Enum | The security type. See [SECTYPE](https://databento.com/docs/conventions/reference-data-enums.md#sectype) enum. |
| `security_description` | String | The security description. |
| `primary_exchange` | Enum or null | Exchange code for the primary security. Empty if unknown. See [EXCHANGE](https://databento.com/docs/conventions/reference-data-enums.md#exchange) enum. |
| `exchange` | Enum | Exchange code for the listing. Equivalent to the MIC but more stable as MIC might not be available in a timely fashion. Also note that the MIC can change but the `exchange` will remain the same. See [EXCHANGE](https://databento.com/docs/conventions/reference-data-enums.md#exchange) enum. |
| `operating_mic` | Enum or null | Market Identifier Code (MIC) as an ISO 10383 string. See [EXCHANGE](https://databento.com/docs/conventions/reference-data-enums.md#exchange) enum. |
| `symbol` | String or null | The query input symbol which matched the record. |
| `nasdaq_symbol` | String or null | The security's symbol in the Nasdaq convention (e.g. `BF.B`). See [Symbology](https://databento.com/docs/schemas/security-master.md#symbology) on the security master schema page for known limitations on `USNYSE` listings. |
| `local_code` | String or null | The listing exchange's native symbol form, as published by the upstream reference-data vendor. Convention varies by listing exchange. Either an alpha string, or a number. |
| `isin` | String or null | ISIN global level identifier as an ISO 6166 string. |
| `us_code` | String or null | US domestic CUSIP. |
| `bbg_comp_id` | String or null | Bloomberg composite global ID. |
| `bbg_comp_ticker` | String or null | Bloomberg composite ticker. |
| `figi` | String or null | Bloomberg FIGI, that is exchange level ID. |
| `figi_ticker` | String or null | Bloomberg exchange level ticker. |
| `listing_country` | Enum or null | Listing country as two letter ISO 3166-1 alpha-2 string. See [CNTRY](https://databento.com/docs/conventions/reference-data-enums.md#cntry) enum. |
| `register_country` | Enum or null | Register country as two letter ISO 3166-1 alpha-2 string. See [CNTRY](https://databento.com/docs/conventions/reference-data-enums.md#cntry) enum. |
| `trading_currency` | Enum or null | Trading currency as an ISO 4217 string. See [CUREN](https://databento.com/docs/conventions/reference-data-enums.md#curen) enum. |
| `multi_currency` | Boolean | True if there is currently more than one listing in the market, otherwise false. |
| `segment_mic_name` | String or null | Market Segment Name. Used when no Segment MIC is available (Not the ISO 10383 MICSEG lookup name). |
| `segment_mic` | Enum or null | Market Identifier Code (MIC) as an ISO 10383 string. See [MICSEG](https://databento.com/docs/conventions/reference-data-enums.md#micseg) enum. |
| `mand_volu_flag` | Enum | Indicates mandatory and/or voluntary event participation requirement. With a few event types the flag change in the course of the corporate action lifecycle. See [MANDVOLU](https://databento.com/docs/conventions/reference-data-enums.md#mandvolu) enum. |
| `rd_priority` | Number or null | The priority order number sequence where populated is necessary to correctly calculate resultant cash and stock outcomes. |
| `lot_size` | Number or null | Lot Size. Indicates the minimum number of shares that can be acquired in one transaction. |
| `par_value` | Number or null | Par value amount. |
| `par_value_currency` | Enum or null | Par value currency as an ISO 4217 string. See [CUREN](https://databento.com/docs/conventions/reference-data-enums.md#curen) enum. |
| `payment_date` | Date or null | The date on which the dividend or payment is made to eligible shareholders. Where the `payment_type` of a multiple payment event is flagged as a (**B**)oth, this payment date field will contain the payment date of the cash component. |
| `duebills_redemption_date` | Date or null | Due bills redemption date. |
| `from_date` | Date or null | The earliest date from which a specific corporate action or event is valid, active, or can be exercised. This date marks the beginning of the relevant event or process, such as when shareholders can start participating in a buyback, conversion, or rights issue. Applicable to a wide range of events. |
| `to_date` | Date or null | The final date by which the specific corporate action or event is valid, active, or must be completed. This date marks the conclusion of the relevant event or process, after which the associated rights, entitlements, or obligations may expire. Applicable to a wide range of events. |
| `registration_date` | Date or null | Registration date. |
| `start_date` | Date or null | The date on which the specific corporate action or event begins or becomes effective. This marks the commencement of the event's active period, such as the start of a buyback program, the beginning of a class action period, or the initiation of an odd-lot offer. Applicable to events like Class Actions (`CLSAC`), Certificate of Exchange (`CTX`), Buyback (`BB`), Odd-Lot Offer (`ODDLT`), and Financial Transaction Tax (`FTT`). |
| `end_date` | Date or null | The final date by which the corporate action or event is valid, active, or must be completed. This marks the conclusion of the event's active period, such as the end of a buyback program, the closing of a class action period, or the deadline for participating in an odd-lot offer. Applicable to events like Class Actions (`CLSAC`), Certificate of Exchange (`CTX`), Buyback (`BB`), Odd-Lot Offer (`ODDLT`), and Financial Transaction Tax (`FTT`). |
| `open_date` | Date or null | The date when the corporate action or event opens for participation or becomes available to stakeholders. This marks the beginning of the active period during which actions like tender offers, purchase offers, or redemptions can be initiated. Applicable to events like Takeovers (`TKOVR`), Purchase Offers (`PO`), and Redemptions (`REDEM`). |
| `close_date` | Date or null | The final date by which participation in the corporate action or event must be completed. This marks the end of the active period for actions like tender offers, purchase offers, or redemptions. Applicable to events like Takeovers (`TKOVR`), Purchase Offers (`PO`), and Redemptions (`REDEM`). |
| `start_subscription_date` | Date or null | The date when the subscription period for the event begins. |
| `end_subscription_date` | Date or null | The date when the subscription period for the event ends. |
| `option_election_date` | Date or null | The deadline by which participants must choose or elect an option related to the event. |
| `withdrawal_rights_from_date` | Date or null | The date from which withdrawal rights become effective, allowing participants to retract their election or participation. |
| `withdrawal_rights_to_date` | Date or null | The final date by which participants can exercise their withdrawal rights, retracting their election or participation. |
| `notification_date` | Date or null | The date on which the event notification is issued or made public. |
| `financial_year_end_date` | Date or null | The closing date of the company's financial year. |
| `exp_completion_date` | Date or null | The anticipated date when the event or related transaction is expected to be completed. |
| `payment_type` | Enum or null | Payment type. See [PAYTYPE](https://databento.com/docs/conventions/reference-data-enums.md#paytype) enum. |
| `option_id` | String or null | Option number of the event where applicable - options are ORs. |
| `serial_id` | String or null | Serial number of the event where applicable - serials are ANDs. |
| `default_option_flag` | Boolean or null | 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. |
| `rate_currency` | Enum or null | Payment currency as an ISO 4217 string. See [CUREN](https://databento.com/docs/conventions/reference-data-enums.md#curen) enum. |
| `ratio_old` | Number or null | Ratio Denominator is the existing holding. |
| `ratio_new` | Number or null | Ratio Numerator is the new holding (for `FSPLT`, `DIV` and `BON` events *includes* the existing holding). |
| `fraction` | Enum or null | Describes how fractions are handled in settlement calculations. See [FRACTIONS](https://databento.com/docs/conventions/reference-data-enums.md#fractions) enum. |
| `outturn_style` | Enum or null | Style of outturn security. See [OUTTURNSTYLE](https://databento.com/docs/conventions/reference-data-enums.md#outturnstyle) enum. |
| `outturn_security_type` | Enum or null | Security asset type. See [SECTYPE](https://databento.com/docs/conventions/reference-data-enums.md#sectype) enum. |
| `outturn_security_id` | String or null | Outturn security. |
| `outturn_isin` | String or null | Outturn ISIN. |
| `outturn_us_code` | String or null | Outturn CUSIP. |
| `outturn_local_code` | String or null | Outturn local code. |
| `outturn_bbg_comp_id` | String or null | Outturn Bloomberg composite ID. |
| `outturn_bbg_comp_ticker` | String or null | Outturn Bloomberg composite ticker. |
| `outturn_figi` | String or null | Outturn FIGI - Bloomberg exchange level ID. |
| `outturn_figi_ticker` | String or null | Outturn FIGI Ticker - Bloomberg exchange level ticker. |
| `min_offer_qty` | Number or null | The quantity range within which the shareholder can offer from their total holding in the event. |
| `max_offer_qty` | Number or null | The quantity range within which the shareholder can offer from their total holding in the event. |
| `min_qualify_qty` | Number or null | If the quantity held by shareholder is within this range then they qualify for taking part in the event. |
| `max_qualify_qty` | Number or null | If the quantity held by shareholder is within this range then they qualify for taking part in the event. |
| `min_accept_qty` | Number or null | 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. |
| `max_accept_qty` | Number or null | 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. |
| `tender_strike_price` | Number or null | If the event is via a tender process it is the cut off price at which all the bids are accepted. |
| `tender_price_step` | Number or null | If the event is via a tender then there is a price step in which one can put in the bids. E.g. 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. |
| `option_expiry_time` | String or null | Option expiry time. |
| `option_expiry_tz` | String or null | Option expiry time zone. |
| `withdrawal_rights_flag` | Boolean or null | Withdrawal rights flag. |
| `withdrawal_rights_expiry_time` | String or null | Withdrawal rights expiry time. |
| `withdrawal_rights_expiry_tz` | String or null | Withdrawal rights expiry time zone. |
| `expiry_time` | String or null | Expiry time. |
| `expiry_tz` | String or null | Expiry time zone. |
| `date_info` | JSON | Event-specific date information. |
| `rate_info` | JSON | Event-specific payment rate information. |
| `event_info` | JSON | Additional event-specific information. |
| `ts_created` | Timestamp | The timestamp (UTC) the record was added by Databento. |

### Identifiers

Identifiers for listing, security and issuer are grouped at the beginning of each record, which enables
clearer comparisons of where a single security is associated with many individual listings across
different exchanges. There is one `primary_exchange` for a security, and it may then be listed
on multiple secondary `exchange`s.

### Dynamic fields

The following dynamically-sized fields provide additional supplementary information as key-value pairs:

- `date_info`. Date specific information related to the event
- `rate_info`. Rate specific information related to the event
- `event_info`. Additional supplementary event information

> **Info**
> The content of these dynamic fields is contingent on the type of `event` and its `event_subtype`,
> allowing for flexible and detailed data representation.