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

...