Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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:
Y = Update
N = New Record
B = Both. Check for existing match. If found, update record; else insert.

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)