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 |
---|---|---|---|
1076 – Update Indicator | Required | CHAR | Y/N indicator used within message stream process. Valid values: |
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: |
3960 – Share Taxability | Required – defaults to N | VARCHAR2 (3) | Only valid value is N. |
54 – Corporate Action Status | Required | VARCHAR2 (2) | Valid values: |
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: |
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) |
Â