| Anchor |
|---|
| _Toc439930487 |
|---|
| _Toc439930487 |
|---|
|
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.
| Anchor |
|---|
| _Toc439930488 |
|---|
| _Toc439930488 |
|---|
|
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.
| Anchor |
|---|
| _Toc439930489 |
|---|
| _Toc439930489 |
|---|
|
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.
| Anchor |
|---|
| _Toc439930490 |
|---|
| _Toc439930490 |
|---|
|
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
| Anchor |
|---|
| _Toc439930491 |
|---|
| _Toc439930491 |
|---|
|
Query Lot Balances Panel Options
The following are the key options on the Lot Balances panel.
| Option | Descripiton |
|---|
| 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.