Data Table for Factors

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 event. Must be ADDFACTOR.

CHAR

Used for STAR processing

1234 – XReference ID Type

Required – mapped to tag 1432

CHAR (30)

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

1233 – XReference ID

Required – mapped to tag 14

CHAR (100)

Security identifier.

1168 – Original Source

Optional – mapped to tag 4003

INTEGER

Original Source of the announcement.

1728 – Reason

Required

VARCHAR2 (50)

FACTOR.

65 – Ex Date

Required

DATE

Event ex-date.

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.

1696 – Factor Rate

Required

NUMBER (28,12)

2926 – Principal Loss Factor

Optional

DEC

Principal loss factor.

1197 – Sweep Date

Optional

DATE

Ability to override message stream logic for setting date.

1740 – Corporate Action Notes

Optional

VARCHAR2 (255)

Notes field.

7052 – CUSIP Xref – ID

Optional

CHAR

Additional security identifier used to resolve security alias if tag 10 is null. Uses next tag to control xref ID type.

7053 – Xref – ID Type for 7052

Optional

CHAR

Xref ID type associated with tag 7052; defaults to CUSIP.

7055 – ISIN Xref – ID

Optional

CHAR

Additional security identifier used to resolve security alias if tag 10 is null. Uses next tag to control xref ID type.

7056 – Xref – ID Type for 7055

Optional

CHAR

Xref ID type associated with tag 7055; defaults to ISIN.

7058 – SEDOL Xref – ID

Optional

CHAR

Additional security identifier used to resolve security alias if tag 10 is null. Uses next tag to control xref ID type.

7059 – Xref – ID Type for 7058

Optional

CHAR

Xref ID type associated with tag 7058; defaults to SEDOL.

7061 – REUTERS Xref – ID

Optional

CHAR

Additional security identifier used to resolve security alias if tag 10 is null. Uses next tag to control xref ID type.

7062 – Xref – ID Type for 7061

Optional

CHAR

Xref ID type associated with tag 7061; defaults to RIC.

7064 – BLOOMBERG Xref – ID

Optional

CHAR

Additional security identifier used to resolve security alias if tag 10 is null. Uses next tag to control xref ID type.

7065 – Xref – ID Type for 7064

Optional

CHAR

Xref ID type associated with tag 7064; defaults to BBID.

7067 – SICOVM Xref – ID

Optional

CHAR

Additional security identifier used to resolve security alias if tag 10 is null. Uses next tag to control xref ID type.

7068 – Xref – ID Type for 7067

Optional

CHAR

Xref ID type associated with tag 7067; defaults to SICOVM.

7070 – VALOREN Xref – ID

Optional

CHAR

Additional security identifier used to resolve security alias if tag 10 is null. Uses next tag to control xref ID type.

7071 – Xref – ID Type for 7070

Optional

CHAR

Xref ID type associated with tag 7070; defaults to VALOREN.

7073 – CEDEL Xref – ID

Optional

CHAR

Additional security identifier used to resolve security alias if tag 10 is null. Uses next tag to control xref ID type.

7074 – Xref – ID Type for 7073

Optional

CHAR

Xref ID type associated with tag 7073; defaults to CEDEL.

7076 – INTERNAL Xref – ID

Optional

CHAR

Additional security identifier used to resolve security alias if tag 10 is null. Uses next tag to control xref ID type.

7077 – Xref – ID Type for 7076

Optional

CHAR

Xref ID type associated with tag 7076; defaults to INTERNAL.

7079 – CINS Xref – ID

Optional

CHAR

Additional security identifier used to resolve security alias if tag 10 is null. Uses next tag to control xref ID type.

7080 – Xref – ID Type for 7079

Optional

CHAR

Xref ID type associated with tag 7079; defaults to CINS.

38 – Maturity Date

Optional

DATE

Date on which the security matures. Used by the Xref ID lookup to qualify security resolution.

11043 – Inactive flag

Optional

VARCHAR2 (255)

Valid values are Y = Yes or N = No. Used by the Xref ID lookup to qualify security resolution.

85 – Asset Currency

Optional

CHAR (30)

3 character currency code – Code Value. Used by the Xref ID lookup to qualify security resolution.

1981 –Xref Exchange

Optional

CHAR (8)

Used by the Xref ID lookup to further qualify the security resolution.

17 – Primary Exchange Code

Optional

CHAR (8)

Exchange on which the security is listed – Code Value.

1275 – Pay Date

Optional

DATE

Pay Date

3962 – Cash Currency

Optional

CHAR (3)

Currency in which the event is paid.