Versions Compared

Key

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

You can use the Trade Recon console to create a total summary and detail report of trade match exceptions and drill down to the activity detail within a security. Results are based on the TRADE_EXCEPTION table in the MSGCENTER database.

Anchor
_Toc439930577
_Toc439930577
Create the Total Trade Summary Report

You can use the Trade Summary report to total trade recon exceptions by date range, entity, and data source.

To create the Total Trade Summary report:

  1. From the Trade Recon console, double click Total Trade Summary in the left pane.
  2. Click the Total Trade Summary tab.
    You see the Total Trade Summary panel.
  3. Complete the fields on the Total Trade Summary panel.
  4. Click Search.
    You see the Total Trade Summary report.


Panel
borderColor#9F9F9F
titleColor#F7F9F9
titleBGColor#B48436
borderStyledashed
titleContent on this page:

Table of Contents
maxLevel2
indent2 px


Anchor
_Toc439930578
_Toc439930578
Query Total Trade Summary Panel Options

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

OptionDescription
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
  • Exact Value (Default)
–  Range
  • 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.
  2. Click the Trade Recon Exceptions tab.
    You see the Trade Recon Exceptions panel.
  3. Complete the fields on the Trade Recon Exceptions panel.
  4. Click Search.
    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.
Noteinfo

Note: You can automatically close/delete comments by selecting the Close Comments option on the Run Assignment Rule dialog box.

Anchor
_Toc439930580
_Toc439930580
Trade Recon Exceptions Panel Options

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

OptionDescription
Status
.

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


Options include:

–  Matched
  • Matched
–  Matched
  • Matched With Tolerance
–  Manual
  • Manual Recon
–  Out
  • Out-of-Balance
–  Error
  • Error
–  Unmatched
  • 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
  • Entity ID/Entity Composite ID
–  Process
  • Process Center
–  Entity
  • Entity List
–  All
  • All Entities
Entity ID
.
Specifies the Entity ID to filter query results. Available when Entity Query Based On is set
to Entity
to Entity ID.
Query Based On
.

Specifies the security qualification to use to filter query results. Options include:

–  Primary
  • Primary Asset ID
–  Issue
  • Issue Name (Default)
–  Xref
  • Xref ID
Primary Asset ID
.
Specifies the asset identifier to filter query results. Available when Query Based On is set
to Primary
to Primary Asset ID.
Issue Name
.
Specifies the issue name to filter query results. Available when Query Based On is set
to Issue
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
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
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.