Data Table for Cash Dividends

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

The following table describes the required and optional data fields for Cash Dividends.

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 message stream for identification of the event. Must be CASHDIV.	CHAR	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	Conditionally Required – required if loading dividend reinvestment records. Used to link reinvestment to dividend.	VARCHAR2 (50)	Client generated ID for the corporate action event.
1728 – Corporate Action Type	Required	VARCHAR2 (50)	Corporate Action Type, that is, Cash Dividend.
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.
1734 – Mandatory / Voluntary Indicator	Required	CHAR (2)	Defaults to M. Mandatory or Voluntary event indicator. Valid values: M = Mandatory V = Voluntary
1737 – Periodic Distribution Type	Optional	VARCHAR2 (30)	Defaults to D (Cash Dividend) if not supplied. Valid values: 5 = 5 Year Capital Gain Distribution I = Fund Income Distribution LT = LT Capital Gain Distribution ST = ST Capital Gain Distribution denotes not QDI eligible for these options
1259 – Dividend Amount	Required	NUMBER (28,12)	Amount of dividend.
1197 – Sweep Date	Optional	DATE	Ability to override message stream logic for setting a date.
1740 – Corporate Action Notes	Optional	VARCHAR2 (255)
3898 – QDI Percent	Optional	NUMBER (38)	Qualified dividend income (QDI) percentage.
3944 – QDI Percent Effective Date	Optional	DATE	Effective date for the QDI percentage.
3962 – Cash Currency	Optional	CHAR (3)	Currency cash to be paid in. By default, populates with From Security currency. Can be changed by sending in tag.