Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.

Anchor
_Toc439930486
_Toc439930486
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:

  1. From the Position Recon console, double click Warehouse Positions in the left pane.

  2. Click the Query Positions from the Warehouse tab.
    You see the Query Positions from the Warehouse panel.

  3. Complete the options on the Query Positions from the Warehouse panel.

  4. Click Search.
    You see the Query Positions query results.

On this page

Table of Contents
maxLevel2
indent2 px


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:

  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.

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:

  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.

Option

Descripiton

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.