| Anchor | ||||
|---|---|---|---|---|
|
| Info | ||
|---|---|---|
| ||
Merger FMV Rate corporate action messages require Event Type (tag 55) set to NONTAXMERGR for message routing to the correct XML processing rule. |
The following table describes the required and optional data fields for Merger 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 | CHAR | Defaults on panel. Used by message stream for identification of the event. Must be NONTAXMERGR. Used for STAR processing. |
1197 – Sweep Date | Optional | DATE | Ability to override message stream logic for setting a 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 | Optional | 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: |
3960 – Share Taxability | Required | VARCHAR2 (3) | Share Taxability indicator. Valid value is 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 1692 | VARCHAR2 (3) | Cash Taxability indicator. Valid values: |
3962 – Cash Currency | Conditionally Required – optional if value sent 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 CashGain/Loss | Conditionally Required – required if value sent 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 | 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 XReferenceID | Required | CHAR (100) | Security identifier. |
319 – To Post Action Price | Optional | 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 | Conditionally Required – tag 8011 is not null | NUMBER (22,12) | |
1001 – Rate of Action Shares | Required if 1710 and 1723 are null | NUMBER (28,12) | Used to calculate resulting shares |
1740 – Corporate Action Notes | Optional | VARCHAR2 (255) |