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 MC for identification of event. Must be DIVREINVEST.

CHAR

Used for STAR processing.

1103 – To Xreference Asset ID Type

Required

CHAR (50)

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

1348 – To Asset Xreference ID

Required

CHAR (100)

Security identifier for reinvestment security.

4003 – Original Source

Optional

VARCHAR2 (15)

Original source of the announcement. If not populated, defaults to that of Cash Dividend record.

1695 – Client Specific ID

Required – must be the same as Cash Dividend Record. Used to retrieve Div info.

VARCHAR2 (50)

Client generated ID for corporate action event.

1728 – Corporate Action Type

Required

VARCHAR2 (50)

Dividend Reinvestment.

65 – Ex Date

Required

DATE

Event ex date.

1109 – Effective Date

Required

DATE

Trade date for reinvestment record.

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)

RELEASED or PENDING. Valid Values:
RD = Released
PD = Pending
IC = Incomplete

3961 – Corporate Action Sub Priority

Required

INTEGER

Defaults at panel level to 2. Can be overridden. Priority used if there are multiple events on the same day.

1734 – Mandatory / Voluntary Indicator

Required

CHAR (2)

Defaults to V. Mandatory or Voluntary event indicator. Only Voluntary events are supported.

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

8009 – Cost Amount Method

Required

VARCHAR2 (1)

Valid values:
G = Gross
N = Net
R = Recoverable

7249 – Reinvestment Based on

Required

CHAR

Valid values:
P = Reinvest Price
R = Reinvest Ratio

1705 – Reinvestment Price

Conditionally Required – required if tag 7249 sent in as P

NUMBER (28,12)

1710 – From Share Ratio

Conditionally Required – required if tag 7249 sent in as R

NUMBER (28,12)

From shares

1723 – To Share Ratio

Conditionally Required – required if tag 7249 sent in as R

NUMBER (28,12)

To shares

1001 – Reinvestment Ratio

Conditionally Required – required if tag 7249 sent in as R

NUMBER (28,12)

Ratio. Greater than zero.

1197 – Sweep Date

Optional

DATE

Ability to override MC logic for setting a date.

1740 – Corporate Action Notes

Optional

VARCHAR2 (255)

Notes field.