Data Table for Exchange Offers
Exchange Offer corporate action messages require Event Type (tag 55) set to EXCHANGE for message routing to the correct XML processing rule.
The following table describes the required and optional data fields for Exchange Offers.
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 EXCHANGE. Used for STAR processing. |
1197 – Sweep Date | Optional | DATE | Ability to override message stream logic for setting a date. Valid values: |
1432 – From XReferenceID 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 exchange offer for From Security. |
369 – From Post Action Price | Required | NUMBER (28,12) | Price post exchange offer for From Security. |
1728 – Corporate Action Type | Required | VARCHAR2 (50) | EXCHANGE OFFER. |
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: |
1709 – Treatment Of Interest Indicator | Optional | CHAR (2) | For interest bearing securities, how the interest must be handled. Valid values: |
3960 – Share Taxability | Required | VARCHAR2 (3) | Share Taxability indicator. Valid values: |
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: |
3962 – Cash Currency | Conditionally Required – optional if value sent in for tag 1692 | CHAR (3) | Currency in which cash is to be paid. 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: |
54 – Corporate Action Status | Required | VARCHAR2 (2) | Valid values: |
3961 – Corporate Action Sub Priority | Required | INTEGER | Defaults to 1. Can be overridden by sending in tag/value. 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 exchange offer for To Security. |
1710 – From Shares | Required – either tags 1710 and 1723 sent in or tag 1001 | NUMBER (28,12) | Used to derive Rate of Action. |
1723 – To Shares | Required – either tags 1710 and 1723 sent in or tag 1001 | NUMBER (28,12) | Used to derive Rate of Action. |
1001 – Rate of Action | Required – either tags 1710 and 1723 sent in or tag 1001 | NUMBER (28,12) | |
1740 – Corporate Action Notes | Optional | VARCHAR2 (255) | |
8011 – Effective Date On Consent | Optional | DATE | |
8010 – Consent Rate of Action | Conditionally Required – tag 8011 is not null | NUMBER (22,12) |
Â