Note
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 |
|---|---|---|---|
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 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: |
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: |
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 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) |
0 Comments