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