CorpActionDefinitionV3

V8 Message Definiton

THE FUNDAMENTAL EVENT, once: a 3:2 split is ONE row here and thousands of KeyTransform edges. Machine-coded AND legal/textual. Carries the lifecycle - announced, REVISED, effective, cancelled - under a STABLE actionKey: revisions change terms, never identity (the occurrence-identity lesson)

METADATA

Attribute	Value
Topic	9100-product-def-core
MLink Token	EquityDefinition
Product	SRReference
accessType	SELECT
MLink Endpoint	MLink-Live

Table Definition

Field	Type	Key	Default Value	Comment
actionKey	VARCHAR(16)	PRI	''	SRminted stable across revisions CA26004417
actionType	enum - CorpActionType		'None'	Split ReverseSplit SpinOff Merger CashMerger Exchange Redemption Call Tender RightsIssue Novation Succession Rename SeasoningMerge Fork IsinChange CashDividend ReturnOfCapital Distribution Rekey a SpiderRock symbology change no issuer event
kind	enum - CorpActionKind		'None'	Scheduled Announced scheduled transits DERIVE their transforms LINEAGEMODEL 42 announced ones store them
status	enum - CorpActionStatus		'None'	Announced Revised Effective Cancelled the lifecycle
subjectKey_at	enum - AssetType		'None'	the primary subject the equity the reference entity the full blast radius is the transform edges empty on a Rekey that moves many keys
subjectKey_ts	enum - TickerSrc		'None'	the primary subject the equity the reference entity the full blast radius is the transform edges empty on a Rekey that moves many keys
subjectKey_tk	VARCHAR(12)		''	the primary subject the equity the reference entity the full blast radius is the transform edges empty on a Rekey that moves many keys
exDate	DATE		'1900-01-01'	THE TRANSIT BOUNDARY transforms mint here looking back
effectiveTime	INT		0	ms since midnight venue tz RECORDED here APPLIED at the boundary 24x7 markets the boundary is a convention we impose LINEAGEMODEL 44
announceDate	DATE		'1900-01-01'	date the action was announced which can be well before the effective date
shareRatioNum	INT		0	32 split 3 2
shareRatioDen	INT		0	denominator of the share ratio a 32 split is 3 over 2
basisAllocPct	DOUBLE		0	NOT the share ratio LINEAGEMODEL 43 basis follows relative fair values
cashPerUnit	DOUBLE		0	dividends returns of capital distributions redemptions cash mergers cashinlieu
electionType	enum - ElectionType		'None'	None CashOrStock Tender Exercise Convert
electionDeadline	DATE		'1900-01-01'	last date a holder may elect empty where the action carries no election
defaultElectionNote	TINYTEXT		''	what happens to a holder who does not elect
legalText	TEXT		''	the documents language beside the codes never instead of them
eventSeriesKey	VARCHAR(24)		''	the MaterialEvent this action announced through
sourceNote	TINYTEXT		''	vendor filing citation
pendingDelete	enum - YesNo		'None'	Yes queued for removal stop resolving against this row
v3Source	enum - V3Source		'None'	Bridge projected from a legacy record Loader written natively None reads as Loader
timestamp	DATETIME(6)		'1900-01-01 00:00:00.000000'	when this row was last written
oldIsin	VARCHAR(12)		''	the ISIN the subject carried before the action
newIsin	VARCHAR(12)		''	the ISIN it carries after empty where the ISIN does not change

PRIMARY KEY DEFINITION (Unique)

Field	Sequence
actionKey	1

SELECT TABLE EXAMPLE QUERY

SELECT *
FROM `SRReference`.`MsgCorpActionDefinitionV3`
WHERE 
    /* Replace with a VARCHAR(16) */ 
    `actionKey` = 'Example_actionKey';

Doc Columns Query

SELECT * FROM SRReference.doccolumns WHERE TABLE_NAME='CorpActionDefinitionV3' ORDER BY ordinal_position ASC;