Data Table for Dividend Reinvestments

Dividend Reinvestment corporate action messages require Event Type (tag 55) set to DIVREINVEST for message routing to the correct XML processing rule.

Dividend Reinvestment processing is dependent upon a Cash Dividend record being present.

Using the message stream process, the Cash Dividend record links to the Dividend Reinvestment through the Client Specific ID (tag 1695). The value sent for tag 1695 on the Dividend Reinvestment record must match an existing Cash Dividend tag 1695. All information for the Cash Dividend, including Dividend Rate, From CUSIP, and the Batch Identifier is retrieved and used based on this value. The remaining Dividend Reinvestment data record information must be related to the Reinvestment Announcement, not the Cash Dividend Announcement.

The following table describes the required and optional data fields for Dividend Reinvestments.

Tag # – Tag Name	Required/Optional	Data Type	Value/Description of Field

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