Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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:
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 SPLIT. Used for STAR processing.

1432 – XReference ID Type

Required

CHAR (30)

Security identifier type (CUSIP, ISIN, SEDOL) – Code Value.

14 – 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 – Pre Action Price

Optional

NUMBER (28,12)

Price pre stock split.

319 – Post Action Price

Optional

NUMBER (28,12)

Price post stock split.

1728 – Corporate Action Type

Required

VARCHAR2 (50)

Reverse Split, Stock Split.

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

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

1710 – From Shares

Required – either tags 1710 and 1723 sent or tag 1001

NUMBER (28,12)

Used to derive ratio for corporate action.

1723 – To Shares

Required – either tags 1710 and 1723 sent or tag 1001

NUMBER (28,12)

Used to derive ratio for corporate action.

1001 – Split Ratio

Required – either tags 1710 and 1723 sent or tag 1001

NUMBER (28,12)

Rate of corporate action.

1197 – Sweep Date

Optional

DATE

Ability to override message stream logic for setting a date.

1740 – Corporate Action Notes

Optional

VARCHAR2 (255)