Query Data Warehouse Cash Tables

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:

From the Cash Recon console, click Warehouse Cash in the left pane.
Click the Warehouse Cash tab.
You see the Query Warehouse Cash panel.
Complete the fields on the Query Warehouse Cash panel.
Click Search.
You see the Query Warehouse Cash Activity report.

On this page

1 Query Warehouse Cash Activity
2 Query Warehouse Cash Activity Panel Options
3 Query ESTAR Cash Transactions
4 Query ESTAR Cash Transaction Panel Options

Query Warehouse Cash Activity Panel Options

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

Option	Description

Option	Description
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:

From the Cash Recon console, click Query ESTAR Cash Transaction in the left pane.
Click the Query ESTAR Cash Transaction tab.
You see the ESTAR Cash Transaction panel.
Complete the fields on the Query ESTAR Cash Transaction panel.
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.

Option	Description

Option	Description
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.