Data Table for Factors
- Natalie Gesin (Deactivated)
- Kinga Huszno
- Former user (Deleted)
Factor corporate action messages require Event Type (tag 55) set to ADDFACTOR for message routing to the correct XML processing rule.
The following table describes the required and optional data fields for Corporate Action Factor.
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: |
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: |
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. |
Â