...
The following table describes the required and optional data fields for the SECURITY_ANALYTICS_EQUITY table security analytics.
Tag | Table Name | Field Name | Required/ Optional | Data Type |
|---|---|---|---|---|
1076 | Update Indicator. Must be Y or N. | Required | Y/N indicator used within message stream process. Valid values: | |
55 | Event Type. Must be ADD_EQ_ANALYTICS. | Required | Used to route the message to the stored procedure that updates the SECURITY_ANALYTICS_ EQUITY table. | |
1234 | Xref type | Required | CHAR. Not stored with data. | |
1233 | SECURITY_ANALYTICS_EQUITY | SECURITY_ALIAS | Required | RESOLVED. From lookup on tag 1233 (xref-id). |
1109 | SECURITY_ANALYTICS_EQUITY | EFFECTIVE_DATE | Required | DATE. |
1102 | SECURITY_ANALYTICS_EQUITY | SRC_INTFC_INST | Required | RESOLVED. From lookup on tag 1102 (Source Name). |
8658 | SECURITY_ANALYTICS_EQUITY | BID | Optional | NUMBER (28,12) |
8659 | SECURITY_ANALYTICS_EQUITY | EPS_12MNTH | Optional | NUMBER (28,12) |
8660 | SECURITY_ANALYTICS_EQUITY | ASK | Optional | NUMBER (28,12) |
8661 | SECURITY_ANALYTICS_EQUITY | HIGH_52WEEK | Optional | NUMBER (28,12) |
8662 | SECURITY_ANALYTICS_EQUITY | LOW_52WEEK | Optional | NUMBER (28,12) |
8663 | SECURITY_ANALYTICS_EQUITY | HIGHDATE_52WEEK | Optional | DATE |
8664 | SECURITY_ANALYTICS_EQUITY | LOWDATE_52WEEK | Optional | DATE |
8665 | SECURITY_ANALYTICS_EQUITY | BETA | Optional | NUMBER (28,12) |
8666 | SECURITY_ANALYTICS_EQUITY | NET_YLD | Optional | NUMBER (28,12) |
8667 | SECURITY_ANALYTICS_EQUITY | EXCHANGE_CODE | Optional | CHAR (10), |
8668 | SECURITY_ANALYTICS_EQUITY | SHARES_OUTSTANDING | Optional | NUMBER (28,12) |
8669 | SECURITY_ANALYTICS_EQUITY | SALES | Optional | NUMBER (28,12) |
8670 | SECURITY_ANALYTICS_EQUITY | SALES_PER_SHARE | Optional | NUMBER (28,12) |
8671 | SECURITY_ANALYTICS_EQUITY | RETURN_EQTY | Optional | NUMBER (28,12) |
8672 | SECURITY_ANALYTICS_EQUITY | BOOKVALUE_PERSHARE | Optional | NUMBER (28,12) |
8673 | SECURITY_ANALYTICS_EQUITY | DIV_12MNTH_PER_SHARE | Optional | NUMBER (28,12) |
8674 | SECURITY_ANALYTICS_EQUITY | PE_RATIO | Optional | NUMBER (28,12) |
8675 | SECURITY_ANALYTICS_EQUITY | IND_DIV_YLD | Optional | NUMBER (28,12) |
8676 | SECURITY_ANALYTICS_EQUITY | YTD_TOTAL_RETURN | Optional | NUMBER (28,12) |
8677 | SECURITY_ANALYTICS_EQUITY | NET_INCOME | Optional | NUMBER (28,12) |
8678 | SECURITY_ANALYTICS_EQUITY | ANALYST_CODE | Optional | CHAR (8) |
8679 | SECURITY_ANALYTICS_EQUITY | BOOK_VAL_PER_SHR | Optional | NUMBER (28,12) |
8680 | SECURITY_ANALYTICS_EQUITY | BOOK_Y0 | Optional | NUMBER (28,12) |
8681 | SECURITY_ANALYTICS_EQUITY | BOOK_YM1 | Optional | NUMBER (28,12) |
8682 | SECURITY_ANALYTICS_EQUITY | BOOK_YM2 | Optional | NUMBER (28,12) |
8683 | SECURITY_ANALYTICS_EQUITY | CASH_FLOW_EST | Optional | NUMBER (28,12) |
8684 | SECURITY_ANALYTICS_EQUITY | CASH_FLOW_FREE_3Y | Optional | NUMBER (28,12) |
8685 | SECURITY_ANALYTICS_EQUITY | DEBT_CAP | Optional | NUMBER (28,12) |
8686 | SECURITY_ANALYTICS_EQUITY | DEBT_CAP_FN | Optional | NUMBER (28,12) |
8687 | SECURITY_ANALYTICS_EQUITY | DISC_PERCENT | Optional | NUMBER (28,12) |
8688 | SECURITY_ANALYTICS_EQUITY | DIV_GR_3Y_E | Optional | NUMBER (28,12) |
8689 | SECURITY_ANALYTICS_EQUITY | DIV_GR_5Y_H | Optional | NUMBER (28,12) |
8690 | SECURITY_ANALYTICS_EQUITY | DIV_INDIC | Optional | NUMBER (28,12) |
8691 | SECURITY_ANALYTICS_EQUITY | DIV_NORM | Optional | NUMBER (28,12) |
8692 | SECURITY_ANALYTICS_EQUITY | DIV_PO_S1 | Optional | NUMBER (28,12) |
8693 | SECURITY_ANALYTICS_EQUITY | DIV_PO_S1_FN | Optional | NUMBER (28,12) |
8694 | SECURITY_ANALYTICS_EQUITY | DIV_PO_S2 | Optional | NUMBER (28,12) |
8695 | SECURITY_ANALYTICS_EQUITY | DIV_PO_S4 | Optional | NUMBER (28,12) |
8696 | SECURITY_ANALYTICS_EQUITY | DIV_Y0_H | Optional | NUMBER (28,12) |
8697 | SECURITY_ANALYTICS_EQUITY | INDEX_LISTED | Optional | CHAR (50) |
8698 | SECURITY_ANALYTICS_EQUITY | FND_CHAR | Optional | CHAR (20) |
8699 | SECURITY_ANALYTICS_EQUITY | FND_CHAR_NUM | Optional | CHAR (20) |
8700 | SECURITY_ANALYTICS_EQUITY | FILE_DATE | Optional | DATE |
8701 | SECURITY_ANALYTICS_EQUITY | GAIN_PCT | Optional | NUMBER (28,12) |
8702 | SECURITY_ANALYTICS_EQUITY | SHARES_CUR | Optional | NUMBER (28,12) |
8703 | SECURITY_ANALYTICS_EQUITY | SHARES_AVG | Optional | NUMBER (28,12) |
8704 | SECURITY_ANALYTICS_EQUITY | MARKET_CAP | Optional | NUMBER (28,12) |
8705 | SECURITY_ANALYTICS_EQUITY | MONTH_FYE | Optional | NUMBER (28,12) |
8706 | SECURITY_ANALYTICS_EQUITY | NYSE_BETA | Optional | NUMBER (28,12) |
8707 | SECURITY_ANALYTICS_EQUITY | QUARTER_END | Optional | CHAR (20) |
8708 | SECURITY_ANALYTICS_EQUITY | RECOMMENDATION | Optional | CHAR (20) |
8709 | SECURITY_ANALYTICS_EQUITY | SHARES_AVG_YM2 | Optional | NUMBER (28,12) |
8710 | SECURITY_ANALYTICS_EQUITY | SHARES_Y0 | Optional | NUMBER (28,12) |
8711 | SECURITY_ANALYTICS_EQUITY | SHARES_YM2 | Optional | NUMBER (28,12) |
8712 | SECURITY_ANALYTICS_EQUITY | SPLIT_DATE | Optional | DATE |
8713 | SECURITY_ANALYTICS_EQUITY | SPLIT_FACTOR | Optional | NUMBER (28,12) |
8714 | SECURITY_ANALYTICS_EQUITY | DIV_PO_S1_X | Optional | NUMBER (28,12) |
8715 | SECURITY_ANALYTICS_EQUITY | DECLARED_DATE | Optional | DATE |
8716 | SECURITY_ANALYTICS_EQUITY | SPLIT_FACTOR_INFO | Optional | VARCHAR2 (12) |
8717 | SECURITY_ANALYTICS_EQUITY | DIV_EX_FLAG | Optional | VARCHAR2 (8) |
8718 | SECURITY_ANALYTICS_EQUITY | BASIS | Optional | NUMBER (28,12) |
8719 | SECURITY_ANALYTICS_EQUITY | SHS_USED_FOR_EARNINGS_COMP | Optional | NUMBER (28,12) |
8720 | SECURITY_ANALYTICS_EQUITY | SHS_USED_FOR_OWNERSHIP_COMP | Optional | NUMBER (28,12) |
8721 | SECURITY_ANALYTICS_EQUITY | RECORD_STATUS | Optional | CHAR (2) |
8722 | SECURITY_ANALYTICS_EQUITY | LAST_DIV_TYPE | Optional | CHAR (50) |
11743 | SECURITY_ANALYTICS_EQUITY | DVD_SH_12M_NET | Optional | NUMBER (28,12) |
11774 | SECURITY_ANALYTICS_EQUITY | DVD_SH_IND_NET | Optional | NUMBER (28,12) |
11775 | SECURITY_ANALYTICS_EQUITY | INDX_GENERAL_PE_RATIO | Optional | NUMBER (28,12) |
11776 | SECURITY_ANALYTICS_EQUITY | WEIGHTED_AVG_PX | Optional | NUMBER (28,12) |
11777 | SECURITY_ANALYTICS_EQUITY | PX_TO_BOOK_RATIO | Optional | NUMBER (28,12) |
11778 | SECURITY_ANALYTICS_EQUITY | ALPHA | Optional | NUMBER (28,12) |