Data Table for Equity Security Analytics
- Natalie Gesin (Deactivated)
- Kinga Huszno
- Former user (Deleted)
This section describes the Security Analytics data fields for loading the SECURITY_ANALYTICS_EQUITY table. You can load any security type to this table if you assign meaningful definitions to the table field attributes to use for that security type.
To review the results of processing in the database, use the List Security Analytics Equity query or Issue Viewer under the Reference category in Eagle Accounting.
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) |