...
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 NONTAXMERGP or TAXMERGP. Used for STAR processing. | |
1197 – Sweep Date | Optional | DATE | Ability to override message stream logic for setting date | |
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 merger for From Security. | |
369 – From Post Action Price | Required | NUMBER (28,12) | Price post merger for From Security. | |
1728 – Corporate Action Type | Required | VARCHAR2 (50) | MERGER. | |
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 = EuropeanN = Post Fractional SharesD = Round DownU = Round UpR = Round to Nearest Whole Share | |
3960 – Share Taxability | Required | VARCHAR2 (3) | Share Taxability indicator. Valid values:Y = Yes, N = No | |
1715 – Cost/Proceed Flag | Required | CHAR (2) | Cost/Proceed indicator. Valid values: | |
1692 – Rate of Action Cash | Optional | NUMBER (28,12) | Cash rate. | |
3963 – Cash Taxability | Conditionally Required – required if value sent in for tag 1692 | VARCHAR2 (3) | Cash Taxability Indicator. Valid values:Y = Yes, N = No | |
3962 – Cash Currency | Conditionally Required – optional if value sent in for tag 1692 | CHAR (3) | Currency cash to be paid in. By default, populates with From Security currency. Can be changed by sending in tag. | |
8779 – Treatment of Cash Gain/Loss | Conditionally Required – required if value sent in for tag 1692 | VARCHAR2 (1) | Indicator to recognize currency gain/loss for foreign currency. Valid values:Y = Yes, N = No | |
54 – Corporate Action Status | Required | VARCHAR2 (2) | RD = Released, PD = Pending,IC = Incomplete | |
3961 – Corporate Action Sub Priority | Required | INTEGER | Deafults to 1. Priority used if there are multiple events on the same day. | |
1734 – Mandatory / Voluntary Indicator | Required | CHAR (2) | Mandatory or Voluntary event indicator. Defaulted to M for Mandatory. 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 merger for To Security. | |
1710 – From Shares | Required – either tags 1710 and 1723 sent in or tag 1001. | NUMBER (28,12) | Used to derive share ratio for corporate action. | |
1723 – To Shares | Required – either tags 1710 and 1723 sent in or tag 1001 | NUMBER (28,12) | Used to derive share ratio for corporate action. | |
8553 – Limit Gain Loss Indicator | Optional | VARCHAR2 (1) | Applies to Taxable Mergers where both cash and shares are taxable. Valid values: | |
8011 – Effective Date on Consent | Optional | DATE | Cut–off date for consent elections | |
8010 – Rate of Action Consent | Optional | NUMBER (22,12) |
| |
1001 – Rate of Action Shares | Required if 1710 and 1723 null | NUMBER (28,12) | Used to calculate resulting shares | |
1740 – Corporate Action Notes | Conditionally Required – tag 8011 is not null | VARCHAR2 (255) |