Data Table for Spin-Off FMV Rates

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

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

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 NONTAXSPINR

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 spin-off for From Security.

369 – From Post Action Price

Optional

NUMBER (28,12)

Price post spin-off 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 – defaults to D (round down)

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 – defaults to N

VARCHAR2 (3)

Only valid value is N.

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 spin-off for To Security.

1279 – FMV Rate

Required

NUMBER (28,12)

Cost allocation rate.

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.

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)



Â