| key |
id |
string* |
= |
Unique identifier |
|
acquirerName |
string |
|
Name of the acquiring company in a
merger/acquisition (M&A), as of the EFFECTIVE
DATE. Provided on a best effort basis. |
|
actionGroup |
string |
|
Index, country/region or stock event action group.
Please refer to section SDE Action Groups within
this chapter for further information. |
|
actionType |
string |
|
Index, country/region or stock event action type,
including index holidays and rebalancing dates.
Please refer to section SDE Action Types within this
chapter for further information. |
|
announcedDate |
date |
|
The date the event was first announced and
appears in the file. |
|
announcementId |
long(-9223372036854775807,9223372036854775806) |
|
Unique corporate actions identifier. (Not applicable
for all event types, refer to SDE Action Types
section for additional details) |
|
audCreatedDate |
dateTime |
|
Timestamp of the record created in DataBase |
| link |
batch |
Batch* |
= |
The Batch for which this BatchRun is an instance. |
| link |
batchRun |
BatchRun* |
= |
The BatchRun in which the data is calculated. |
|
cashAmount |
decimal |
|
Cash consideration for mergers/acquisitions
(M&A). |
|
closeOfBusinessDate |
date |
|
The previous business day, taking into account
holidays. |
|
comments |
string |
|
Descriptive commentary associated with the event |
|
currentAlternateClassificationCode |
string |
|
Constituents current alternate classification code.
This field is reserved for alternate, product-specific
classification schemes associated with the
constituent. |
|
currentAwf |
decimal |
|
The current Additional Weight Factor (AWF) of the
stock as required for certain methodologies. For
methodologies not using AWF, the value will be 1. |
|
currentBloombergTicker |
string |
|
Constituents current Bloomberg Ticker, provided
on a best effort basis. |
|
currentCapRange |
string |
|
Indicates constituent stocks current capitalization
range. Available for index families with breakdown
by a market cap bracket. For example, a stock that
is classified as having a capitalization of over $25
billion will have the code RO25B. |
|
currentCompanyName |
string |
|
The current name of the constituent. |
|
currentCountryOfDomicile |
string |
|
ISO country/region code that is
associated with the constituents current
country/region of domicile. |
|
currentCountryOfListing |
string |
|
ISO country/region code that is
associated with the constituents current
country/region of exchange. |
|
currentCurrencyCode |
string |
|
The current ISO currency code in
which the closing price of the stock is stated. |
|
currentCusip |
string |
|
Constituents current CUSIP identifier,
provided on a best effort basis. |
|
currentDjiIndustryCode |
string |
|
Constituents current Dow Jones Indexes'
proprietary industry classification code. |
|
currentGicsCode |
string |
|
Constituents current Global Industry Classification
Standard code |
|
currentGvKey |
string |
|
Constituents current Compustat permanent
company identifier, provided on a best effort basis. |
|
currentIndexShares |
decimal |
|
The constituents current index shares. Index
shares represents the total number of shares
determined and used by the index calculation
methodology (i.e. SHARES OUSTANDING * IWF *
AWF). |
|
currentIsin |
string |
|
Constituents current ISIN identifier,
provided on a best effort basis. |
|
currentIwf |
decimal |
|
The current Investible Weight Factor (IWF) of the
stock. A value of 1 = 100% Free Float. |
|
currentMic |
string |
|
Constituents current Market Identification Code,
representing the ISO code of the
exchange the constituent is traded on. |
|
currentPrice |
decimal |
|
Latest available price prior to the EFFECTIVE
DATE adjusted for all corporate actions. |
|
currentRegion |
string |
|
Constituents current region. Available for the
Global BMI family and indicates if the stock is
considered part of a developed or emerging
market. Currently not being used in files |
|
currentRic |
string |
|
Constituents current Reuters Instrument Code,
provided on a best effort basis. |
|
currentSedol |
string |
|
Constituents current SEDOL, provided
on a best effort basis. |
|
currentSharesOutstanding |
decimal{26,0} |
|
The constituents current number of shares outstanding. |
|
currentShariah |
string |
|
Current status
regarding Shariah compliance. |
|
currentSize |
string |
|
Constituents current size. Indicates if the stock is
classified as a large, mid or small cap stock within
the methodology of the index. A stock may be
classified as large in one index family, and mid in
another. Value is left blank for indices not providing
size breakdown. |
|
currentStockAttributes |
string |
|
Currently not populated. Will be used for future
enhancement to changes in stock attributes. |
|
currentTaxRate |
decimal |
|
Current tax rate. |
|
currentTicker |
string |
|
Constituents current stock ticker, associated with
the exchange the constituent is traded on.
Provided on a best effort basis. |
|
dividend |
decimal |
|
Dividend amount as reported, as of the
EFFECTIVE DATE. Dividend amount will be
translated to stock currency if dividend currency
differs from stock currency. If the action type is
Dividend Adjustment (primarily applicable for
Japanese and Korean companies), the dividend
amount will be the difference between the
confirmed dividend and any amount recognized on
the original ex-date. |
|
dividendCurrency |
string |
|
The ISO currency code for the
currency the dividend is paid in. |
|
effectiveDate |
date |
|
Indicative of when the corporate actions data is
applicable. Also known as the ex-date. |
|
fileDate |
date |
|
Date on which the file is distributed |
|
frankingRate |
decimal |
|
Franking rate for Australian dividends. |
|
fxRate |
decimal |
|
Foreign exchange rate as of the EFFECTIVE
DATE. |
|
growth |
decimal |
|
The growth weight factor associated with the stock,
as of the EFFECTIVE DATE. |
|
indexCode |
string |
|
Defines the index code that this stock is related to. |
|
indexCurrency |
string |
|
The ISO currency code for the currency
in which the index level data is being reported in. |
|
indexKey |
string |
|
Defines the index key that this stock is related to.
See chapter Index Keys for more information. |
|
indexName |
string |
|
Defines the index name that this stock is related to. |
|
indexSharesPostEvents |
decimal |
|
The constituents final index shares post all events
with the same effective date. |
|
indexSharesPriorEvents |
decimal |
|
The constituents index shares as of close of
business the day prior to the effective date. |
|
issuanceFee |
decimal |
|
Dividend issuance fee. |
|
lastUpdatedDate |
date |
|
The date when the last change was made to this
record. For adds/drops this states the last update
date of all compositions of an index. |
|
netDividend |
decimal |
|
Net dividend amount, as of the EFFECTIVE DATE
(after subtracting taxes and franking). Tax and
franking rates used are as of ex-date. Dividend
amount will be translated to stock currency if
dividend currency differs from stock currency. If
the action type is Dividend Adjustment (primarily
applicable for Japanese and Korean companies),
the net dividend amount will be the after tax
amount of the difference between the confirmed
dividend and any amount recognized on the
original ex-date |
|
newAlternateClassificationCode |
string |
|
Constituents new alternate classification code as
of the EFFECTIVE DATE. This field is reserved for
alternate, product-specific classification schemes
associated with the constituent. |
|
newAwf |
decimal |
|
The new Additional Weight Factor (AWF) of the
stock as required for certain methodologies, as of
the EFFECTIVE DATE. For methodologies not
using AWF, the value will be 1. |
|
newBloombergTicker |
string |
|
Constituents new Bloomberg Ticker as of the
EFFECTIVE DATE, provided on a best effort
basis. |
|
newCapRange |
string |
|
Indicates constituent stocks new capitalization
range as of the EFFECTIVE DATE. Available for
index families with breakdown by a market cap
bracket. For example, a stock that is classified as
having a capitalization of over $25 billion will have
the code RO25B. |
|
newCompanyName |
string |
|
The new name of the constituent as of the
EFFECTIVE DATE. |
|
newCountryOfDomicile |
string |
|
ISO country/region code that is
associated with the constituents new
country/region of domicile as of the EFFECTIVE
DATE. |
|
newCountryOfListing |
string |
|
ISO country/region code that is
associated with the constituents new
country/region of exchange as of the EFFECTIVE
DATE. |
|
newCurrencyCode |
string |
|
The new ISO currency code in which
the closing price of the stock is stated as of the
EFFECTIVE DATE. |
|
newCusip |
string |
|
Constituents CUSIP identifier as
of the EFFECTIVE DATE, provided on a best effort
basis. |
|
newDjiIndustryCode |
string |
|
Constituents new Dow Jones Indexes' proprietary
industry classification code,
as of the EFFECTIVE DATE. |
|
newGicsCode |
string |
|
Constituents new Global Industry Classification
Standard code, as of the
EFFECTIVE DATE. |
|
newGvKey |
string |
|
Constituents new Compustat permanent company
identifier as of the EFFECTIVE DATE, provided on
a best effort basis. |
|
newIndexProfile |
string |
|
The new index name, new index code or new index
key. |
|
newIndexShares |
decimal |
|
The constituents new index shares as of the
EFFECTIVE DATE. Index shares represents the
total number of shares determined and used by the
index calculation methodology adjusted for
corporate actions (i.e. SHARES OUSTANDING *
IWF * AWF). |
|
newIsin |
string |
|
Constituents new ISIN identifier as of
the EFFECTIVE DATE, provided on a best effort
basis. |
|
newIwf |
decimal |
|
The new Investible Weight Factor (IWF) of the
stock as of the EFFECTIVE DATE. A value of 1 =
100% Free Float. |
|
newMic |
string |
|
Constituents new Market Identification Code,
representing the ISO code of the
exchange the constituent is traded on, as of the
EFFECTIVE DATE. |
|
newPrice |
decimal |
|
Closing price adjusted for corporate actions as of
the EFFECTIVE DATE. |
|
newRegion |
string |
|
Constituents new region as of the EFFECTIVE
DATE. Available for the Global BMI family and
indicates if the stock is considered part of a
developed or emerging market. Currently not being
used in files |
|
newRic |
string |
|
Constituents new Reuters Instrument Code as of
the EFFECTIVE DATE, provided on a best effort
basis. |
|
newSedol |
string |
|
Constituents new SEDOL identifier as
of the EFFECTIVE DATE, provided on a best effort
basis. |
|
newSharesOutstanding |
decimal{26,0} |
|
The constituents new number of shares outstanding as of the EFFECTIVE DATE. |
|
newShariah |
string |
|
New status
regarding Shariah compliance as of the
EFFECTIVE DATE. |
|
newSize |
string |
|
Constituents new size as of the EFFECTIVE
DATE.
Indicates if the stock is classified as a large, mid or
small cap stock within the methodology of the
index. A stock may be classified as large in one
index family, and mid in another. Value is left blank
for indices not providing size breakdown. |
|
newStockAttributes |
string |
|
Currently not populated. Will be used for future
enhancement to changes in stock attributes. |
|
newTaxRate |
decimal |
|
New tax rate as of the EFFECTIVE DATE. |
|
newTicker |
string |
|
Constituents new stock ticker, associated with the
exchange the constituent is traded on, as of the
EFFECTIVE DATE. Provided on a best effort
basis. |
|
priceAdjustment |
decimal |
|
Amount of price adjustment. |
|
ratioHeld |
decimal |
|
For stock splits or rights offerings, this represents
the ratio of the shares held. For example, in a 3-for-1 stock split, the ratio held would be 1. For a
0.1-for-1 rights offering, the ratio held would be 1. |
|
ratioReceived |
decimal |
|
For stock splits or rights offerings, this represents
the ratio of the shares received. For example, in a
3-for-1 stock split, the ratio received would be 3.
For a 0.1-for- 1 rights offering, the ratio received
would be 0.1. |
|
referenceDate |
date |
|
The date of the next index rebalance or stock
replacement. If the action type is Dividend
Adjustment (primarily applicable for Japanese and
Korean companies), the REFERENCE DATE will
show the original ex-date of the dividend. |
|
replacementStockKey |
long(0,9223372036854775806) |
|
When a constituent stock is dropped from an
index, it is sometimes replaced by another stock
constituent at a predefined weight, depending on
the index methodology. In such instances, this field
represents the STOCK KEY of the replacement
stock constituent which will be added to the index
at that predefined weight. |
|
sequenceNo |
long(0,9223372036854775806) |
|
Sequence number for multiple actions on a single
stock on the same date. |
|
spinTargetIsIndexCo |
string |
|
Field used to identify if the M&A target
stock is also a current index constituent. |
|
spinTargetMic |
string |
|
The Market Identification Code representing the ISO Code of the exchange the M&A
target company is trading on, as of the
EFFECTIVE DATE. |
|
spinTargetName |
string |
|
Name of the M&A target company, as of the
EFFECTIVE DATE. Provided on a best effort
basis. |
|
spinTargetStockKey |
long(0,9223372036854775806) |
|
S&P Dow Jones Indices Stock Key of the M&A
target company, as of the EFFECTIVE DATE. A
stock key is a unique S&P Dow Jones Indices
identifier assigned to every stock. This key will be
persistent regardless of profile changes to the
stock. |
|
spinTargetTicker |
string |
|
Stock ticker associated with the exchange the
M&A target company is traded on, as of the
EFFECTIVE DATE. Provided on a best effort
basis. |
|
status |
string |
|
States whether the entry is finalized, estimate,
pending or cancelled. |
|
stockKey |
long(0,9223372036854775806) |
|
Unique S&P Dow Jones Indices identifier. This key
will be persistent regardless of other identifier
changes. |
|
subscriptionPrice |
decimal |
|
Subscription price for rights offerings. |
|
value |
decimal |
|
The value weight factor associated with the stock,
as of the EFFECTIVE DATE. |