Versions Compared

Old Version 2

changes.mady.by.user Former user

Saved on

compared with

New Version 3

changes.mady.by.user Nancy Cohn

Saved on

Key

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

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.

Anchor
_Toc439930544
_Toc439930544
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.

Info

Note: 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.
     
PanelborderColor#9F9F9FtitleColor#F7F9F9titleBGColor#B48436borderStyledashedtitleContent on

On this page

:

Table of Contents
maxLevel2
indent2 px


Anchor
_Toc439930545
_Toc439930545
Query Warehouse Cash Activity Panel Options

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

OptionDescription
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 DateSpecifies the high date to include in cash activity query results.
Entity NameSpecifies the entity name to filter query results.
Entity IDSpecifies 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 IDSpecifies the asset identifier to filter query results. Available when Query Based On is set to Primary Asset ID.
Issue NameSpecifies the issue name to filter query results. Available when Query Based On is set to Issue Name.
Xref TypeSpecifies the security xreference type to use to filter query results. Available when Query Based On is set to Xref ID.
Xref IDSpecifies the security xreference for the Xref ID type to filter query results. Required when Query Based On is set to Xref ID.
Source NameSpecifies the data source to filter query results. For example, CUSTODY.
Max ItemsSpecifies the maximum number of result records that are returned for viewing. Default is 100 records.

Anchor
_Toc439930546
_Toc439930546
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.

Note

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.

Anchor
_Toc439930547
_Toc439930547
Query ESTAR Cash Transaction Panel Options

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

OptionDescription
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 DateSpecifies the low date to include in cash activity query results.
End DateSpecifies the high date to include in cash activity query results.
Entity IDSpecifies the entity ID to filter query results.
Base CurrencySpecifies 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 IDSpecifies the asset identifier to filter query results. Available when Query Based On is set to Primary Asset ID.
Issue NameSpecifies the issue name to filter query results. Available when Query Based On is set to Issue Name.
Xref TypeSpecifies the security xreference type to use to filter query results. Available when Query Based On is set to Xref ID.
Xref IDSpecifies the security xreference for the Xref ID type to filter query results. Required when Query Based On is set to Xref ID.
Max ItemsSpecifies 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.