Data Table for SMF Indexes
- Natalie Gesin (Deactivated)
- Kinga Huszno
- Former user (Deleted)
The SMF Index stream currently supports the INXXXX processing security type.
The following table describes the required and optional data fields for SMF Indexes.
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 – must be ADDSECMASTER | CHAR | Used by STAR processing. |
1257 – Transaction Type | Optional | CHAR (30) | Switch used restrict database updates. Options include: |
961 – Issue Name | Required | VARCHAR2 (255) | Security name. |
962 – Issue Description | Optional | VARCHAR2 (255) | Security description. |
13 – Ticker | Optional | CHAR (100) | Security ticker. |
1257 – History Only Flag | Optional | CHAR (30) | If set to HISTORY_ONLY, places a record in the history tables only, and updates specific key fields on the composite. |
1293 – Journaling | Optional | CHAR | If set to EXCLUDE_JOURNAL, field level journaling does not occur. |
1432 – Primary Asset ID Type | Required | CHAR (30) | Security Identifier Type (CUSIP, ISIN, SEDOL) – Code Value. |
14 – Primary Asset ID | Required | CHAR (100) | Security identifier. |
11 – Investment Type | Required – defaults at panel level to INDX | CHAR (4) | INDX |
3931 – Processing Security Type | Required | VARCHAR2 (15) | Code Value used by STAR processing. Set to INXXXX |
82 – Security Type | Optional | CHAR (15) | Used for reporting – Code Value. |
1464 – Sub Security Type | Optional | CHAR (15) | Used for reporting – Code Value. |
12 – Quantity Type | Required – defaults at panel level to PAR. | CHAR (12) | |
18 – Price Multiplier | Required – defaults at panel level to .01. Can be overridden by sending tag/value. | NUMBER (28,12) | |
19 – Quantity Scale | Required – defaults at panel level to 1. Can be overridden by sending tag/value. | NUMBER (28,12) | |
10536 – Country of Risk Code | Optional | VARCHAR2 (4) | ISO Country Code of Country of Risk – Code Value. |
85 – Asset Currency | Required | CHAR (30) | 3–character Currency Code – Code Value. |
1545 – US Federal Tax Indicator | Optional | CHAR (2) | Valid Value: Y– Yes, N – No |
12023 – Essential Flag | Optional | CHAR (12) | Valid Value: Y– Yes, N – No |
12024 – Synthetic Flag | Optional | CHAR (12) | Valid Value: Y– Yes, N – No |
1343 – State Code | Optional | CHAR (2) | |
7250 – Spoke Check | Optional | INTEGER | If set to a number greater than 0, the procedure performs the spoke check. (Valid for Hub and Spoke clients only.) |
11043 – Inactive Flag | Optional | VARCHAR2 (255) | Valid value is Y = Yes. |
1102 – Source Name | Required – defaults on panel to EAGLE PACE. Can be overridden by sending tag/value. | CHAR (15) | Source of SMF record. Used in history tables. |
1109 – Effective Date | Optional – defaults to current date on panel. Can be overridden. | DATE | Date SMF was created/changed. Effective date of change. Used on SMF history tables. |
989 – Compare Incoming Data | Optional | CHAR | If Y, the stored procedure compares the current record to the previous record for that source in the history tables, and inserts a new record only if data changed. |
990 – Update Master Tables | Optional | CHAR | If tag 1257 = HISTORY_ONLY, specify a list of tags (separated by commas) that must be updated in the master tables. |
1084 – Exchange Mode Flag | Optional | CHAR | If set EXCHANGE, the interface will attempt to resolve on the primary asset ID (tag 14) plus the value in exchange (tag 17). If it is not equal to EXCHANGE then it will resolve on primary asset ID only. |
1085 – Vendor Mode Flag | Optional | CHAR | If set to VENDOR_MODE, it is assumed that the data is sourced from a vendor and that only data on the file should be stored. The interface will resolve security alias only, it will not perform the detail lookup which is used to retrieve the current security detail. |
2817 – Cost Basis Rule Type | Optional | VARCHAR2(20) | Used by STAR processing. |
3998 – Maturity Delay Days Type | Optional | VARCHAR2 (1) | Maturity Delay Days Type |
3999 – Coupon Delay Days Type | Optional | VARCHAR2 (1) | Coupon Delay Days Type |
5076 – Last Trade Date | Optional | DATE | Last Trade Date |
5089 – Legal Entity Indicator (LEI) | Optional | VARCHAR2 (20) | Alphameric LEI assignment for this security. |
Â