Search Results igs_ad_imp_near_mtch_all




Overview
Explore in AI Chat

Overview

The table IGS_AD_IMP_NEAR_MTCH_ALL is a data repository within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically belonging to the now-obsolete IGS (Student System) product family. Its primary function is to log and manage records of "near matches" identified during data import processes. When importing external data, such as prospective student information, the system compares it against existing records in the database. This table holds the results of those comparisons where the imported data is similar but not identical to an existing record, facilitating manual review and resolution of potential duplicates or data conflicts. It is a critical component for ensuring data integrity during high-volume import operations.

Key Information Stored

While the full column list is not provided in the metadata, the documented foreign key relationships define several critical data points stored in this table. The primary key, NEAR_MTCH_ID, uniquely identifies each near-match event. The table stores references to the matched entities: PERSON_ID links to the HZ_PARTIES table to identify the existing person or organization, and PARTY_SITE_ID links to HZ_PARTY_SITES for associated address information. To define the matching criteria used, MATCH_SET_ID references a configuration in IGS_PE_MATCH_SETS_ALL. Furthermore, PERSON_ID_TYPE references IGS_PE_PERSON_ID_TYP, indicating the type of identifier used for the person in the matching process. Collectively, these columns store the relationship between an imported data record and its closest existing counterpart in the system.

Common Use Cases and Queries

The primary use case for this table is supporting data stewardship activities following a batch import. Administrators would query this table to generate a list of all potential duplicate records requiring human intervention. A typical query would join to the HZ_PARTIES table to retrieve the names and details of the existing records flagged as near matches. For example, a report to list all near matches for a specific import batch or date range would be common. The table's data is also instrumental in audit trails, providing a historical record of matching decisions. Since the metadata indicates the object is "Not implemented in this database," direct queries in a given instance may not be possible, indicating its functionality may have been superseded or consolidated in later implementations of the Student System.

Related Objects

The table IGS_AD_IMP_NEAR_MTCH_ALL is centrally connected to several core EBS entities, as defined by its foreign key constraints. Its relationships are as follows:

  • HZ_PARTIES: Linked via the PERSON_ID column. This is the foundational Trading Community Architecture (TCA) table storing all persons and organizations.
  • IGS_PE_MATCH_SETS_ALL: Linked via the MATCH_SET_ID column. This table defines the rule sets and thresholds used to determine a "near match."
  • IGS_PE_PERSON_ID_TYP: Linked via the PERSON_ID_TYPE column. This reference table classifies the type of person identifier used in the matching logic.
  • HZ_PARTY_SITES: Linked via the PARTY_SITE_ID column. This TCA table stores address information for parties, indicating the match may have involved location data.

These relationships position the table as an intermediary, connecting imported data analysis results (near matches) to the master data definitions in TCA and the matching rules configuration within the Student System.