The run results screen provides the match results as well as useful metrics about a specific process run, with an option to navigate to the same information for historic runs. *
* Please note that this screen will look slightly different if the Exception Workflow is switched on.
When you first access the run screen you will defaulted to the Overview sub-screen.
The left side of the screen shows the results buckets for each result category:
|Unmatched||Where there either weren't corresponding items in the submitted files, or because items were not found to be sufficiently similar to qualify as Partial matches.|
|Partially matched||Where items have been found to be 50%+ similar but not 100%*|
|Accepted||Items that Duco initially reported as partially matched or unmatched and that a user manually set to "Accepted".|
|Filtered||Items that have been filtered out by the filter rules. This bucket is not visible if the filter rules are not used or if you choose not to report them in Results control page.|
|Errors||Items that have not been included for matching consideration owing to an issue with the submitted file.|
The buckets show the number of results in each category. An auto-match or partial-match result item consists of a pair of records, for example two trades.
Figures greater than 1,000 are shown rounded in the navigation bar to keep them easy to read. For example, if the number of partially matched is 1,236, the navigation bar shows 1.2k. The balance sheet box (see below for further information) gives all the results figures in detail.
Filtering and sorting results
Clicking on a specific bucket will navigate you to that category of run results, where you will be able to see each individual line item. You can then use sorting and filtering to browse through the data
The filtering and sorting works much like in Microsoft Excel. So if you are familiar with Excel, you should be able to filter and browse the results in Duco in a similar manner.
There are filters applicable for all the data types and some are data-specific.
All the results can either be sorted ascending or descending. Additionally, you can also sort items by the absolute value. This is useful in different scenarios, in particular for cash reconciliations when you look for transactions to be manually matched.
Filtering can be performed not only by specific values, but also by ranges.
You can also filter by values. Do not forget to click on 'Select none' before searching.
It is also possible to filter to see all items where a break is occurring or not occurring on a specific field.
For numeric fields, Duco supports the following:
- Less than
- Less than or equal to
- Greater than
- Great than or equal to
- Is equal to
- Is not equal to
- Is between amounts
- Is not between amounts
For date fields, the following are supported:
- Before a particular date
- After a date
- Between two dates
- On a specific date
For text fields, the following are supported:
- Does not contain
Bookmarking and sharing your filters
With our dynamically generating URLs you can bookmark particular result filters to reuse them or share them with your team members. Simply go to your current latest run, apply your filters and bookmark the URL in order to access your pre-filtered results quickly.
Please note that the usual data access permissions will apply.
Note: Internet Explorer has a technical limit for URL length, meaning that this feature will not work properly on IE in rare scenarios when you have a very complex set of filters. Duco recommends Chrome.
When browsing the matching results, you can
- Enter a page number in the "Page" text box to any page of the results.
- Select a different "Page size" to show more results in a single page.
There is a display limit of 100 items per page.
Sometimes our informational columns can obscure relevant information such as your business data.
Users have the ability to hide these columns, allowing them to view only the more relevant columns.
To adjust the view, first select View.
This will then display a drop-down where you can select Column settings.
This will return a pop-up screen where you are able to select which columns are displayed by having them either checked or unchecked.
Fields can additionally be resequenced in alignment with your preferences, simply by clicking on a field and using grab & drop to change the ordering.
Click on Apply settings for the change to take effect.
Fullscreen mode to see more data
In case you do not have access to a full-size work station and monitor when working from home, hence it’s more challenging to analyse large amounts of data. With a fullscreen mode, you can perform analysis with less scrolling.
It is also possible to 'pin' one or more result items in place at the top of the display, in order help you to focus on specific issues or collect potential candidates when you are manually matching items. As you move through different pages of results, pinned items stay with you at the top of each page.
You can find the Pin button by selecting an exception and then going to the Actions menu.
Multiple items can be pinned at the same time.
To unpin items, simply check the box next to the items you wish to remove and this will enable an Unpin button.
For some processes, you may struggle to identify a good combination of fields that can be used as a record tracking key (e.g. you may have limited data from a counterparty). As a result, there may be many items identified as duplicates in after a run, which may in fact be individual items that need to be reconciled and investigated.
It is possible to mark these items as not duplicates. These will then be included in the run and become exceptions. Such items will be carried-over to next run if remain unresolved, and will not be treated as duplicates again in subsequent runs if new records matching the same tracking keys are submitted.
To mark an item as not being a duplicate, go to the Actions menu and then select Not duplicate.