About the Analytics Default Message Stream

Owned by Natalie Gesin (Deactivated)
Last updated: Jan 31, 2024 by Kinga Huszno
1 min read

The Analytics default message stream is used to load security analytics to specific tables in the SECURITY database, under the control of event field (tag 55), which determines the routing of each message to the appropriate database update stored procedure.

Tables loaded include:

  • SECURITY_ANALYTICS table, for event type = ADD_SEC_ANALYTICS.

  • SECURITY_ANALYTICS_EQUITY table, for event type = ADD_EQ_ANALYTICS.

  • SECURITY_ANALYTICS_FI table, for event type = ADD_FI_ANALYTICS.

Security analytics are loaded to the SECURITY_ANALYTICS table using the following streams:

  • eagle_default_in_csv_analytic

  • eagle_default_in_star_analytic

The following data tables are described for Analytics:

  • Security Analytics data table

  • Equity Security Analytics data table

  • Fixed Income Security Analytics data table

Panels, binds, and stored procedures for the Analytics stream are also described in the following pages.