Query Data Warehouse Cash Tables

Owned by Tom Fahey (Unlicensed)
Last updated: Sept 27, 2016 by Former user (Deleted)
3 min read

You can use the Cash Recon console to directly query the Eagle data warehouse tables to display the source data used during the cash activity reconciliation.

Query Warehouse Cash Activity

You can query the Eagle data warehouse to display cash activity on the data warehouse for a given data source and effective date. Results are based on the  CASH_ACTIVITY table in the CASH database.

You must set DataSetOption=2 in the MSGSERVICE.INI file to view the Warehouse Cash report option.

To create the Warehouse Cash Activity report:

  1. From the Cash Recon console, click Warehouse Cash in the left pane.
  2. Click the Warehouse Cash tab.
    You see the Query Warehouse Cash panel.
  3. Complete the fields on the Query Warehouse Cash panel.
  4. Click Search.
    You see the Query Warehouse Cash Activity report.
     
Content on this page:

Query Warehouse Cash Activity Panel Options

The following table describes the key options on the Warehouse Cash panel.

  • Query Date Type. Specifies the type of date range to filter cash activity query results.
    Options include:
    –  Accounting Date
    –  Post Date
    –  Settlement Date
    –  Trade Date
  • Start Date. Specifies the low date to include in cash activity query results.
  • End Date. Specifies the high date to include in cash activity query results.
  • Entity Name. Specifies the entity name to filter query results.
  • Entity ID. Specifies the entity ID to filter query results.
  • Query Based On. Specifies the security qualification to use to filter query results.
    Options include:
    –  Primary Asset ID
    –  Issue Name (Default)
    –  Xref ID
  • Primary Asset ID. Specifies the asset identifier to filter query results. Available when Query Based On is set to Primary Asset ID.
  • Issue Name. Specifies the issue name to filter query results. Available when Query Based On is set to Issue Name.
  • Xref Type. Specifies the security xreference type to use to filter query results. Available when Query Based On is set to Xref ID.
  • Xref ID. Specifies the security xreference for the Xref ID type to filter query results. Required when Query Based On is set to Xref ID.
  • Source Name. Specifies the data source to filter query results. For example, CUSTODY.
  • Max Items. Specifies the maximum number of result records that are returned for viewing. Default is 100 records.

Query ESTAR Cash Transactions

You can query the Eagle data warehouse to display ESTAR cash activity for a given data source and effective date. Results are based on the ESTAR_TRADED_CASH_ACTIVITY and the ESTAR_SETTLED_CASH_ACTIVITY tables in the ESTAR database.

You must set DataSetOption=3 or DataSetOption=4 in the MSGSERVICE.INI file to view the ESTAR report option.

To create the ESTAR Cash Transaction report:

  1. From the Cash Recon console, click Query ESTAR Cash Transaction in the left pane.
  2. Click the Query ESTAR Cash Transaction tab.
    You see the ESTAR Cash Transaction panel.
  3. Complete the fields on the Query ESTAR Cash Transaction panel.
  4. Click Search.
    You see the ESTAR Cash Transaction report.

Query ESTAR Cash Transaction Panel Options

The following table describes the required options on the ESTAR Cash Transaction panel.

  • Query Date Type. Specifies the type of date range to filter cash activity query results.
    Options include:
    –  Accounting Date
    –  Month End Date
    –  Post Date
    –  Settlement Date
    –  Trade Date
  • Start Date. Specifies the low date to include in cash activity query results.
  • End Date. Specifies the high date to include in cash activity query results.
  • Entity ID. Specifies the entity ID to filter query results.
  • Base Currency. Specifies the base currency to filter query results.
  • Transaction Status. Specifies the transaction status to filter query results.
    Options include:
    –  Traded
    –  Settled
  • Query Based On. Specifies the security qualification to use to filter query results.
    Options include:
    –  Primary Asset ID
    –  Issue Name (Default)
    –  Xref ID
  • Primary Asset ID. Specifies the asset identifier to filter query results. Available when Query Based On is set to Primary Asset ID.
  • Issue Name. Specifies the issue name to filter query results. Available when Query Based On is set to Issue Name.
  • Xref Type. Specifies the security xreference type to use to filter query results. Available when Query Based On is set to Xref ID.
  • Xref ID. Specifies the security xreference for the Xref ID type to filter query results. Required when Query Based On is set to Xref ID.
  • Max Items. Specifies the maximum number of result records that are returned for viewing. Default is 100 records.

You can optionally qualify report results by security type, share class, transaction type, flow type, cash category, processing security type, accounting basis, ticker, and investment type.