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

1197 – Sweep Date

Optional

DATE

Ability to override message stream logic for setting a date. Valid values:
B = Both
G = Gain
L = Loss
N = None

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 action.

319 – Post Action Price/Subscription Price

Required

NUMBER (28,12)

Price post action/subscription price.

1728 – Corporate Action Type

Required

VARCHAR2 (50)

PAYMENT IN KIND PREFERRED, PIK.

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.

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.

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

1734 – Mandatory / Voluntary Indicator

Required

CHAR (2)

Defaults to M. Mandatory or Voluntary event indicator. Valid values:
M = Mandatory
V = Voluntary

1740 – Corporate Action Notes

Optional

VARCHAR2 (255)