Page Comparison

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 – defaults on panel. Used by message stream for identification of the event. Must be NONTAXSPINR

CHAR

Used for STAR processing.

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 spin-off for From Security.

369 – From Post Action Price

Optional

NUMBER (28,12)

Price post spin-off for From Security.

1728 – Corporate Action Type

Required

VARCHAR2 (50)

SPINOFF.

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:
E = European
N = Post Fractional Shares
D = Round Down
U = Round Up
R = Round to Nearest Whole Share

3960 – Share Taxability

Required – defaults to N

VARCHAR2 (3)

Only valid value is N.

54 – Corporate Action Status

Required

VARCHAR2 (2)

Valid values:
RD = Released
PD = Pending
IC = Incomplete

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:
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 spin-off for To Security.

1279 – FMV Rate

Required

NUMBER (28,12)

Cost allocation rate.

1710 – From Shares

Required (either tags 1710 and 1723 sent or tag 1001)

NUMBER (28,12)

Used to derive share ratio for corporate action.

1723 – To Shares

Required (either tags 1710 and 1723 sent or tag 1001)

NUMBER (28,12)

Used to derive share ratio for corporate action.

1197 – Sweep Date

Optional

DATE

Ability to override message stream logic for setting a date.

1740 – Corporate Action Notes

Optional

VARCHAR2 (255)

1001 – Split Ratio

Required – either tags 1710 and 1723 sent or tag 1001

NUMBER (28,12)