Note
The following table describes the required and optional data fields for Stock Splits.
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 | CHAR | Defaults on panel. Used by message stream for identification of the event. Must be SPLIT. Used for STAR processing. |
1432 – XReference ID Type | Required | CHAR (30) | Security identifier type (CUSIP, ISIN, SEDOL) – Code Value. |
14 – 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 – Pre Action Price | Optional | NUMBER (28,12) | Price pre stock split. |
319 – Post Action Price | Optional | NUMBER (28,12) | Price post stock split. |
1728 – Corporate Action Type | Required | VARCHAR2 (50) | Reverse Split, Stock Split. |
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: |
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: |
1710 – From Shares | Required – either tags 1710 and 1723 sent or tag 1001 | NUMBER (28,12) | Used to derive ratio for corporate action. |
1723 – To Shares | Required – either tags 1710 and 1723 sent or tag 1001 | NUMBER (28,12) | Used to derive ratio for corporate action. |
1001 – Split Ratio | Required – either tags 1710 and 1723 sent or tag 1001 | NUMBER (28,12) | Rate of corporate action. |
1197 – Sweep Date | Optional | DATE | Ability to override message stream logic for setting a date. |
1740 – Corporate Action Notes | Optional | VARCHAR2 (255) |
|
0 Comments