Data Table for Merger FMV Prices

1076 – Update Indicator

Required

CHAR

Y/N indicator used within message stream process. Valid values:
Y = Update
N = New Record
B = Both. Check for existing match. If found, update record; else insert.

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
Valid values:
B = Both
G = Gain
L = Loss
N = None

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:
C = Cost
P = Proceed

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:
M = Mandatory
V = Voluntary

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:
B – Both, G – Gain Only. L – Loss Only.
N – None

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)