Data Table for Spin-Off FMV Prices

Spin-Off FMV Price corporate action messages require Event Type (tag 55) set to NONTAXSPINP or TAXSPINP for message routing to the correct XML processing rule.

The following table describes the required and optional data fields for Spin-off FMV Prices.

Tag # – Tag Name	Required/Optional	Data Type	Value/Description of Field

Tag # – Tag Name	Required/Optional	Data Type	Value/Description of Field
1076 – Update Indicator	Required	CHAR	Y/N indicator used within message stream process. Valid values: Y = Update N = New Record B = Both. Check for existing match. If found, update record; else insert.
55 – Event Type	Required – defaults on panel. Used by message stream for identification of the event. Must be NONTAXSPINP or TAXSPINP.	CHAR	Used for STAR processing.
1432 – From XReference ID Type	Required	CHAR (30)	Security identifier type (CUSIP, ISIN, SEDOL) – Code Value.
14 – From XReference ID	Required	CHAR (100)	Security identifier.
4003 – Original Source	Optional	VARCHAR2 (15)	Original Source of the announcement.
1695 – Client Specific ID	Optional	VARCHAR2 (50)	Client generated ID for corporate action event.
1264 – From Pre Action Price	Optional	NUMBER (28,12)	Price pre spinoff for From Security.
369 – From Post Action Price	Optional	NUMBER (28,12)	Price post spinoff for From Security.
1728 – Corporate Action Type	Required	VARCHAR2 (50)	SPINOFF
65 – Ex Date	Required	DATE	Event ex date
1694 – Record Date	Optional	DATE	Record Date of the event.
1260 – Announcement Date	Optional	DATE	Announcement date of the event.
1275 – Pay Date	Required	DATE	Pay Date of the event.
3965 – Treatment of Fractional Shares	Required	VARCHAR2 (3)	How Fractional Shares are to be handled. Valid values: E = European N = Post Fractional Shares D = Round Down U = Round Up R = Round to Nearest Whole Share
3960 – Share Taxability	Required	VARCHAR2 (3)	Y/N value (if Y value for tag 55, must be TAXSPINP; if N value for tag 55, must be NONTAXSPINP).
54 – Corporate Action Status	Required	VARCHAR2 (2)	Valid values: RD = Released PD = Pending IC = Incomplete
3961 – Corporate Action Sub Priority	Required	INTEGER	Defaults to 1. Priority used if there are multiple events on the same day.
1734 – Mandatory / Voluntary Indicator	Required	CHAR (2)	Defaults to M. Mandatory or Voluntary event indicator. Valid values: M = Mandatory V = Voluntary.
1103 – To XReference ID Type	Required	CHAR (50)	Security identifier Type (CUSIP, ISIN, SEDOL) – Code Value.
1348 – To XReference ID	Required	CHAR (100)	Security identifier.
319 – To Post Action Price	Required	NUMBER (28,12)	Price post spinoff for To Security.
1710 – From Shares	Required (either tags 1710 and 1723 sent or tag 1001)	NUMBER (28,12)	Used to derive share ratio for corporate action.
1723 – To Shares	Required (either tags 1710 and 1723 sent or tag 1001)	NUMBER (28,12)	Used to derive share ratio for corporate action.
369 – From Post Action Price	Required	NUMBER (28,12)	Price post spin-off for From Security.
1197 – Sweep Date	Optional	DATE	Ability to override message stream logic for setting a date.
1740 – Corporate Action Notes	Optional	VARCHAR2 (255)
1001 – Split Ratio	Required – either tags 1710 and 1723 sent or tag 1001	NUMBER (28,12)