Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

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:

  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

Query Positions on the Data Warehouse Panel Options

The following are the key options on the Query Positions from the Warehouse panel.

OptionDescription
Query Based OnSpecifies the security qualification to use to filter query results. Options include Issue Name (Default) and Xref ID.
Issue NameSpecifies the issue name to filter query results. Available when the Query Based On option is set to Issue Name.
Xref TypeSpecifies the security xreference type used to filter query results. Available when the Query Based On field is set to Xref ID.
Xref IDSpecifies 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 IDSpecifies the Entity ID to filter query results.
DateSpecifies the position effective date to filter query results.
Max ItemsSpecifies 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:

  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.

Query Ledger Balances Panel Options

The following are the key options on the Query Ledger Balances panel.

OptionDescription
Query Based OnSpecifies the security qualification to use to filter query results. Options include Issue Name (Default) and Xref ID.
Issue NameSpecifies the issue name to filter query results. Available when the Query Based On option is set to Issue Name.
Xref TypeSpecifies the security xreference type used to filter query results. Available when the Query Based On field is set to Xref ID.
Xref IDSpecifies 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 IDSpecifies the Entity ID to filter query results.
DateSpecifies the effective date to filter query results.
Max ItemsSpecifies 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:

  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

Query Lot Balances Panel Options

The following are the key options on the Lot Balances panel.

OptionDescripiton
Query Based OnSpecifies the security qualification to use to filter query results. Options include Issue Name (Default) and Xref ID.
Issue NameSpecifies the issue name to filter query results. Available when the Query Based On option is set to Issue Name.
Xref TypeSpecifies the security xreference type used to filter query results. Available when the Query Based On field is set to Xref ID.
Xref IDSpecifies 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 IDSpecifies the Entity ID to filter query results.
DateSpecifies the lot position effective date to filter query results.
Max ItemsSpecifies 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.

  • No labels