Ability to Save a Group of Reconciliation Exception Records to a Watchlist

You are viewing documentation for Data Trust v7.6 (latest).
Looking for the previous version? View v2024.06 documentation →

Data Trust › Scenario Studio › Scenario Builder

Save Reconciliation Exception Records to a Watchlist

Select and save a group of exception records to a watchlist for ongoing tracking.

Overview

This guide walks through the Save Reconciliation Exception Records to a Watchlist scenario in Data Trust Scenario Studio. Follow the numbered steps below to configure, execute, and review the results of this scenario type.

Note: Ensure all required connection profiles are configured in the Administration module before building this scenario.

Prerequisites

• You are logged in to Data Trust with a Pro-User or Admin Pro-User role.
• The relevant connection profiles have been configured in the Administration module.

Steps

Path: Data Trust › Scenario Studio › Scenario Builder › Save Reconciliation Exception Records to a Watchlist

Figure 1: Scenario Execution Summary Page

The Scenario Execution Summary Page page presents the full outcome of the scenario execution including record counts, match rates, and any detected exceptions. Drill into exception records to inspect individual mismatches and use the Export to CSV option to share results with stakeholders.

Figure 2: Exception Records with Maching Keys

The Exception Records with Maching Keys page presents the full outcome of the scenario execution including record counts, match rates, and any detected exceptions. Drill into exception records to inspect individual mismatches and use the Export to CSV option to share results with stakeholders.

Figure 3: Watchlist Popup

The Watchlist Popup dialog exposes all available configuration options for this step. Review each field carefully and fill in the required values before clicking Save or OK to apply the configuration.

Figure 4: Click on Save Watchlist

Click the Save button to persist the current widget or scenario configuration. A confirmation indicator appears on the canvas once the save is successful, and the widget thumbnail updates to reflect the configured state.

Figure 5: Watchlist Saved Successfully

Click the Save button to persist the current widget or scenario configuration. A confirmation indicator appears on the canvas once the save is successful, and the widget thumbnail updates to reflect the configured state.

Figure 6: Watchlist Count in the Result Summary page

The Watchlist Count in the Result Summary page page presents the full outcome of the scenario execution including record counts, match rates, and any detected exceptions. Drill into exception records to inspect individual mismatches and use the Export to CSV option to share results with stakeholders.

Figure 7: Edit Watchlist

The Edit Watchlist feature allows you to flag and track specific exception records across multiple execution cycles. Saving records to a watchlist ensures that known outstanding issues are visible in subsequent runs until they are resolved.

Figure 8: Watchlist History

The Watchlist History feature allows you to flag and track specific exception records across multiple execution cycles. Saving records to a watchlist ensures that known outstanding issues are visible in subsequent runs until they are resolved.

Figure 9: Watchlist Filter

The Watchlist Filter panel allows you to define criteria that limit which records are included in the comparison. Filters reduce data volume and processing time by excluding records that are out of scope for this reconciliation or validation run.

Figure 10: Show Watchlist Records filter

The Show Watchlist Records filter panel allows you to define criteria that limit which records are included in the comparison. Filters reduce data volume and processing time by excluding records that are out of scope for this reconciliation or validation run.