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.

• 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:

1. From the Position Recon console, click Ledger Balances in the left pane.
2. Click the Ledger Balances tab.
   You see the Ledger Balances panel.
3. Complete the options on the Ledger Balances panel.
4. 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.

• 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:

1. From the Position Recon console, click Lot Balances in the left pane.
2. Click the Lot Balances tab.
   You see the Lot Balances panel.
3. Complete the options on the Lot Balances panel.
4. 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.

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