Query Data Warehouse Positions Tables
- Copy Page Tree (Unlicensed)
- Nancy Cohn (Deactivated)
- Former user (Deleted)
You can use the Position Recon console to directly query the Eagle data warehouse tables to display the source data used during the position, ledger balance, and lot level reconciliations.
Query Positions on the Data Warehouse
You can query the Eagle data warehouse to display positions for a given data source and position effective date.
To query Positions on the data warehouse:
From the Position Recon console, double click Warehouse Positions in the left pane.
Click the Query Positions from the Warehouse tab.
You see the Query Positions from the Warehouse panel.Complete the options on the Query Positions from the Warehouse panel.
Click Search.
You see the Query Positions query results.
Query Positions on the Data Warehouse Panel Options
The following are the key options on the Query Positions from the Warehouse panel.
Option | Description |
|---|---|
Query Based On | Specifies the security qualification to use to filter query results. Options include Issue Name (Default) and Xref ID. |
Issue Name | Specifies the issue name to filter query results. Available when the Query Based On option is set to Issue Name. |
Xref Type | Specifies the security xreference type used to filter query results. Available when the Query Based On field is set to Xref ID. |
Xref ID | Specifies the security xreference for the Xref ID type to filter query results. Required when the Query Based On option is set to Xref ID. |
Entity ID | Specifies the Entity ID to filter query results. |
Date | Specifies the position effective date to filter query results. |
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 entity name, entity list, primary asset id, source name, and long/short indicator.
Query Ledger Balances on the Data Warehouse
You can query the Eagle data warehouse to display ledger balances for a given data source and account effective date.
To query Ledger Balances on the data warehouse:
From the Position Recon console, click Ledger Balances in the left pane.
Click the Ledger Balances tab.
You see the Ledger Balances panel.Complete the options on the Ledger Balances panel.
Click Search.
You see the Ledger Balances query results.
Query Ledger Balances Panel Options
The following are the key options on the Query Ledger Balances panel.
Option | Description |
|---|---|
Query Based On | Specifies the security qualification to use to filter query results. Options include Issue Name (Default) and Xref ID. |
Issue Name | Specifies the issue name to filter query results. Available when the Query Based On option is set to Issue Name. |
Xref Type | Specifies the security xreference type used to filter query results. Available when the Query Based On field is set to Xref ID. |
Xref ID | Specifies the security xreference for the Xref ID type to filter query results. Required when the Query Based On option is set to Xref ID. |
Entity ID | Specifies the Entity ID to filter query results. |
Date | Specifies the effective date to filter query results. |
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 entity name, entity currency, account basis, issue symbol, and primary asset id.
Query Lot Balances on the Data Warehouse
You can query the Eagle data warehouse to display open position lots for a given data source and lot effective date.
To query Lot Balances on the data warehouse:
From the Position Recon console, click Lot Balances in the left pane.
Click the Lot Balances tab.
You see the Lot Balances panel.Complete the options on the Lot Balances panel.
Click Search.
You see Lot Balances query results
Query Lot Balances Panel Options
The following are the key options on the Lot Balances panel.
Option | Description |
|---|---|
Query Based On | Specifies the security qualification to use to filter query results. Options include Issue Name (Default) and Xref ID. |
Issue Name | Specifies the issue name to filter query results. Available when the Query Based On option is set to Issue Name. |
Xref Type | Specifies the security xreference type used to filter query results. Available when the Query Based On field is set to Xref ID. |
Xref ID | Specifies the security xreference for the Xref ID type to filter query results. Required when the Query Based On option is set to Xref ID. |
Entity ID | Specifies the Entity ID to filter query results. |
Date | Specifies the lot position effective date to filter query results. |
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 entity name, entity currency, account basis, issue symbol, and primary asset id.