Anchor
_Toc439930578 _Toc439930578

Query Total Trade Summary Panel Options

The following describes the key options on the Query Total Trade Summary panel.

• Entity Query Based On. Specifies the Entity list to filter query results. Or, you can select by composite entity ID to roll up all entities in the composite to the security level.

• Select by Effective Date. Specifies whether an exact date or date range is used to filter query results.
  

• Options include:
  –  Exact Value (Default)
  –  Range

• Effective Date. Specifies the effective date to exactly match to query results. To use this option, you must select Exact Value as your effective date selection.

• Start Effective Date. Specifies the low effective date in a date range to include in query results. To use this option, you must select Range as your effective date selection.

• End Effective Date. Specifies the high effective date in a date range to include in query results. To use this option, you must select Range as your effective date selection.

• Right Source Name. Specifies the custodian data source to filter query results. This is the right side of the mathematical match.

• Left Source Name. Specifies the second data source to filter query results. This is the left side of the mathematical match.

• Query Based On. Specifies additional filter to use for query results. Options include Primary Asset ID, Issue Name, and Xref ID.

• Max Items. Specifies the maximum number of result records that are returned for viewing. Default is 100 records.

Anchor
_Toc439930579 _Toc439930579

Create the Trade Recon Exceptions Report

You can use the Trade Recon console to review trade exceptions and identify data warehouse breaks on trade records from different sets of data sources, such as Eagle Accounting and custodians.

To review trade recon exceptions:

1. From the Trade Recon console, double click Trade Recon Exceptions in the left pane.

1. Click the Trade Recon Exceptions tab.
   

1. You see the Trade Recon Exceptions panel.

1. Complete the fields on the Trade Recon Exceptions panel.

1. Click Search.
   

1. You see the Trade Recon Exceptions report.
   You can correct breaks by entering new trades, cancel and rebooking old trades, processing corrected trade records from external custodian sources, and then resubmitting the Recon Trade Event panel to reconcile the additional information.

Anchor
_Toc439930580 _Toc439930580

Trade Recon Exceptions Panel Options

The following describes the key options on the Trade Recon Exceptions panel.

• Status. Specifies the status of the trade activity match to filter query results.
  

• Options include:
  –  Matched
  –  Matched With Tolerance
  –  Manual Recon
  –  Out-of-Balance
  –  Error
  –  Unmatched

• Start Date. Specifies the low date to include in trade activity query results.

• End Date. Specifies the high date to include in trade activity query results.

• Entity Query Based On. Specifies the entity qualification to use to filter query results.
  

• Options include:
  –  Entity ID/Entity Composite ID
  –  Process Center
  –  Entity List
  –  All Entities

• Entity ID. Specifies the Entity ID to filter query results. Available when Entity Query Based On is set to Entity ID.

• Query Based On. Specifies the security qualification to use to filter query results.Options include:
  –  Primary Asset ID
  –  Issue Name (Default)
  –  Xref ID

• Primary Asset ID. Specifies the asset identifier to filter query results. Available when Query Based On is set to Primary Asset ID.

• Issue Name. Specifies the issue name to filter query results. Available when Query Based On is set to Issue Name.

• Xref Type. Specifies the security xreference type to use to filter query results. Available when Query Based On is set to Xref ID.

• Xref ID. Specifies the security xreference for the Xref ID type to filter query results. Required when Query Based On is set to Xref ID.

• Assigned to User. Specifies the assigned user ID to filter query results.

• Assigned to Group. Specifies the assigned user group to filter query results.

• Has comments. Indicates whether the exception record has comments to filter query results.

• Left source. Specifies the left data source to filter query results.

• Right source. Specifies the right data source to filter query results.

• Category. Specifies the comments category to filter query results.

• Sub category. Specifies the comments sub category to filter query results.

• Max Rows. Specifies the maximum number of result records that are returned for viewing. Default is 100 records.
  You can also qualify report results by transaction code, is approved (yes/no), and custom xref type.