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 PIKBOND

CHAR

Used for STAR processing.

1432 – From XReference ID Type

Required

CHAR (30)

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

14 – From 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 – From Pre Action Price

Optional

NUMBER (28,12)

Price pre spin-off for From Security. Used In the Fair Market Value Report.

319 – From Post Action Price

Optional

NUMBER (28,12)

Price post spin-off for From Security. Used In the Fair Market Value Report

1728 – Corporate Action Type

Required

VARCHAR2 (50)

PIK BOND.

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

1197 – Sweep Date

Optional

DATE

Ability to override message stream logic for setting a date.

1740 – Corporate Action Notes

Optional

VARCHAR2 (255)

 


1001 – Baby Bond Rate

Optional

NUMBER (28,12)

Rate of Action. The  This rate to compare to the PIK bond coupon to determine the number of shares or par amount of the payment that is in bonds. The sum of the Cash Rate plus the Baby Bond Rate is equal to the Coupon Rate of the parent PIK bond. Otherwise, the panel displays a warning stating that the cash rate does not equal the coupon rate, that the baby bond rate does not equal the coupon rate, or that the cash rate and baby bond rate do not equal the coupon rate, as appropriateis used to determine the amount of baby bond shares the holder will receive.

8012 – Dividend Reclass

Optional

CHAR (10)

Valid Values:
Y = Cash Receivable
N or NULL = Reclass

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

1692 – Cash Rate

Optional

NUMBER (28,12)

Cash Rate. The rate to compare to the PIK bond coupon to determine the interest payment that is in cash.

1705 – Baby Bond Price

Optional

NUMBER (28,12)

If the Baby Bond Rate is not zero or null, this field is required for a Mandatory CA. The Baby Bond Price field should not be entered for a Voluntary CA.

...