Search Results igr_is_contact_pk

Overview

The table IGR_IS_CONTACT is a data object within the Oracle E-Business Suite (EBS) release 12.1.1 and 12.2.2. It belongs to the IGS (Student System) product family, which is documented as obsolete. The table's core function is to serve as a staging area for contact information, specifically holding "Self Service Staging Contact records." This indicates it was designed to temporarily store contact data submitted through a self-service interface, such as a prospective student inquiry portal, before that data is validated and processed into the main transactional tables of the student system. Its role is therefore integral to the data capture and initial processing workflow for external interactions.

Key Information Stored

Based on the provided ETRM metadata, the primary data elements stored in IGR_IS_CONTACT revolve around uniquely identifying contact records and linking them to a person. The definitive key column is INQ_CONTACT_ID, which serves as the primary key for the table (IGR_IS_CONTACT_PK). This column uniquely identifies each staged contact record. A second critical column is INQ_PERSON_ID, which acts as a foreign key. This column establishes a relationship from the contact record to a corresponding person record, presumably within a related staging or main person table, linking the contact details to an individual entity within the system.

Common Use Cases and Queries

The primary use case for this table is the management of inbound contact data from self-service applications. A typical operational query would involve selecting recently staged records for batch processing or validation. For instance, an administrator might run a report to see all pending contact records awaiting integration. A common SQL pattern would involve joining IGR_IS_CONTACT to its related person table using the INQ_PERSON_ID foreign key to create a comprehensive view of the staged data. Troubleshooting or auditing specific inquiries would leverage the primary key, as shown in the sample query below.

• Sample Query to Retrieve a Specific Staged Contact:
  SELECT * FROM IGR_IS_CONTACT WHERE INQ_CONTACT_ID = :inq_contact_id;
• Sample Query to Join with a Related Person Table:
  SELECT cont.*, person.* FROM IGR_IS_CONTACT cont, [Related_Person_Table] person WHERE cont.INQ_PERSON_ID = person.PERSON_ID;

Related Objects

The documented relationship data specifies one foreign key relationship originating from the IGR_IS_CONTACT table. This table references another object via the column INQ_PERSON_ID. The metadata indicates the foreign key references a column in a related table, though the specific target table name is partially obscured in the excerpt (noted as "%"). This confirms that IGR_IS_CONTACT is a child table in a relationship where INQ_PERSON_ID is dependent on a primary key in a parent table, most likely a person staging table such as IGR_IS_PERSON or a similar entity. The primary key constraint IGR_IS_CONTACT_PK on INQ_CONTACT_ID may be referenced by other objects, but no such dependencies are detailed in the provided excerpt.