Create a data deduplication subscription

Use data deduplication subscriptions to identify duplicate HCP and HCO records in your Network instance.

Supported objects

The following objects are supported for data deduplication jobs:

  • HCPs and HCOs - Only active and valid records are considered.

    Both active and inactive sub-objects are considered in the match comparisons to help identify duplicate HCPs and HCOs.

Create a subscription

  1. In the Admin console, click System Interfaces > Data Maintenance Subscriptions.
  2. On the Data Maintenance page, click Add Subscription.
  3. In the Add Subscription dialog, select Data Deduplication and click OK.
  4. Type a Name and Description for this job that reflects the data that you are analyzing.
  5. New subscriptions are Enabled by default. For more information, see Disabling subscriptions.
  6. In the Settings section, there are several options to consider:
    • Job Action - Select how you want Network to process the job:
      • Stop and Don't Merge - Stop the job after the match stage and do not merge records. This is selected by default. Use this option to test the job and ensure that overmatching is not occurring before you apply the updates.
      • Apply Updates & Merge- ACTClosed A high confidence match between two records. ACT matches result in a merge without any human review. (strong) matches will be automatically processed. Use when you are confident that the job is matching appropriately.
      • Review Before Merge - Pause the job after the match stage and before the records are merged so that you can review the match log for changes. When you are satisfied with the outcome, you can resume the job so the records merge. When you select this option, an email is sent to you when the job pauses so you can review the results. You can resume the paused job from the Job Details page.
    • Job Error Log - Produce a job error log for this maintenance job. This should be used during the testing process only because it contributes to length of the job's run time.
    • Allow File Reprocessing - Enabled by default and cannot be changed. Data deduplication jobs can run the same file, from the FTP server, multiple times.
    • Allow in Matching - Select this option if you want to include records that have been previously rejected as a suspect match or have been unmerged in the past.

      This also includes records that are already in a pending suspect match task in the inbox.

      Note: For initial testing, do not select this option.

    • Export Match Analysis - Export match logs for HCOs and HCPs.

      This is helpful for analyzing the results while you are testing the effectiveness of the Data Deduplication job.

    • Result Type - Filter the exported match log by result type: ACT, ASK, or Unmatched results. Unmatched results is not selected by default because that information is not relevant for this job.
    • Export Data Group Analysis - Select to export data group logs for HCOs and HCPs.

      This is helpful for analyzing the results while you are testing the effectiveness of the Data Deduplication job.

  7. In the HCP Subset Options and HCO Subset Options sections, identify the records that you want to compare.
    • No Records - Use to indicate that no HCPs will be compared during the job.
    • FTP - Create a file with a list of Veeva IDs (VIDs) and add it to an FTP site. Specify the FTP directory where Network can retrieve the file.

      For information about accessing the files in your Network file system, see File Explorer.

      Requirements for the.csv file:

      • One column only that contains the list of Veeva IDs (VIDs)

      • Column header is optional and must not have any other characters around the text
      • VIDs must be listed in separate rows
      • Double quotation marks ("") around VIDs are permitted
      • No extra characters; for example, commas (,) after VIDs
      • File name must be exactly the same format as it is on the FTP site; capitalization matters (for example, VIDS.csv is not the same as VIDs.csv)

      • You can use one file to contain both HCOs and HCPs and identify it in either the HCP Subset Options or the HCO Subset Options section.
      • If you use separate files, the file names can be different, but the FTP path must be the same.

    • Use Filters - Use the filters in Basic Mode or create a SQL query in Advanced Mode to identify the records that you want to compare during the job. To use filters, Network Reporting must be available.

      An advanced SQL query must return a list of VIDs only. The SQL query can contain both HCP and HCO records. Note that even if No Records has been selected for HCPs or HCOs, if your query returns both HCO and HCP records, they will be included in the job.

      Note: If a filter defines a sub-object (Address, License, Parent HCO), the owning HCO or HCP is identified and that VID is used in the matching process. All fields and sub-objects on a record are used to identify possible duplicates.

      The reporting database identifies the records that are selected in Basic or Advanced queries. You might find a discrepancy between what reports or filters indicate versus the actual status of records in the instance. When you are analyzing the remaining duplicate records, take note of when the reporting database was last updated for your instance.

  8. In the Match Configuration section, define match rules and data groups by country and entity type for this job. If you have records for a country where match rules are not defined, the data deduplication process cannot match those records so the records are skipped.

    Data groups restrict the set of records to compare, while the match rules provide detailed rules to compare objects. Data groups should be generic enough to include all possible matches, but cannot include more than 1,000 records.

    Network provides default data groups and match rules that can be used or modified for your Network instance. These are the same defaults used by source subscriptions.

  9. In the Job Schedule & Triggers section, define the schedule for the job and any subsequent actions that will start when this job finishes.

    Job Schedule - Run the subscription manually or on a scheduled basis. If you select Manual, the subscription only runs when you click the Start Job button on the subscription page. During testing, select Manual; scheduled jobs should not be paused.

    Job Triggers - Trigger other actions to start after a job runs.

    Available triggers:

    • Send email - Specify users that should be notified for successful and unsuccessful job outcomes.
    • Start a job - Start a subsequent job when this job successfully completes.

    For more information, see Subscription job triggers.

  10. Save your changes.

Next steps

Run the job. If you set the Review Before Merge option, you can review the matches before records are merged. For more details, see Run and pause data deduplication jobs.