Import Process

When the Import Batch to TCA Registry program is submitted, this process follows:

  1. The batch de-duplication and address validation runs, if selected.

    Duplicates found through batch de-duplication are resolved as you specified in the Action to Take on Duplicates parameter, for example, to keep the records that are last updated.

    If you chose to run preimport processes only so that you can preview preimport results, then address validation includes all records. If not, then address validation includes only records that batch de-duplication determines as not duplicates.

  2. The data in the interface tables are matched against source system mappings to determine if imported records are inserted as new parties or to update existing parties. See: Matching Records with Source System Management.

  3. For performance reasons, the records are populated into staging tables for processing before loading into the TCA tables.

  4. If you have selected the optional Registry de-duplication, then duplicates are identified between the batch that you are importing and the TCA Registry. All parties are to be inserted as new parties, but then the duplicates are resolved as described in step 7.

  5. After any selected preimport processes finish, depending on your choice, either:

  6. Mandatory validations are performed on all data, and records that pass all validations are loaded into the TCA Registry. Records that fail are marked with error and not imported. See: Import Validations.

  7. If Registry de-duplication was run, then:

  8. Postimport processes automatically run. See: Postimport Processes.

  9. If you ran batch de-duplication, optionally run the Import Batch De-Duplication report for this batch. The report output provides the de-duplication results.

Related Topics