Search Results inq_contact_id




Overview
Explore in AI Chat

Overview

The IGS_SS_INQ_CONTACT table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the IGS (Oracle Student Management) product family. Its primary role is to hold contact information, such as phone numbers and email addresses, for prospective students or inquirers within the Self Service Staging layer. This staging area typically manages data submitted via web-based inquiry forms before it is formally processed and integrated into the main transactional student system. The metadata explicitly notes the table's status as "Obsolete," indicating it is part of a legacy data model that may be superseded in newer implementations or future releases, though it remains present and valid in the specified EBS versions.

Key Information Stored

The table is structured to capture detailed contact records linked to an inquiry. The primary and most critical column is INQ_CONTACT_ID, a mandatory numeric unique identifier for each contact record. Each record is tied to a specific inquirer via the foreign key INQ_PERSON_ID. The core contact data is stored across several columns: PHONE_COUNTRY_CODE, PHONE_AREA_CODE, PHONE_NUMBER, PHONE_EXTENSION, and PHONE_LINE_TYPE, which together provide a decomposed and standardized format for telephone information. The EMAIL_ADDRESS column can store addresses up to 2000 characters. A STATUS column tracks the record's condition, and the table includes a full suite of Standard Who Columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, etc.) for auditing and concurrent program tracking.

Common Use Cases and Queries

This table is central to reporting and data validation processes for prospective student inquiries. A common use case involves extracting all contact information for a specific inquirer or a batch of inquiries for communication purposes or data quality checks. Administrators might query this table to identify duplicate contact entries or to audit the source of inquiry data. A typical reporting query would join this table to the related person staging table to create a comprehensive contact list.

Sample Query: Retrieving all phone and email contacts for a specific inquiry person.

SELECT ic.INQ_CONTACT_ID,
       ic.PHONE_LINE_TYPE,
       ic.PHONE_COUNTRY_CODE,
       ic.PHONE_AREA_CODE,
       ic.PHONE_NUMBER,
       ic.EMAIL_ADDRESS,
       ic.STATUS
FROM IGS.IGS_SS_INQ_CONTACT ic
WHERE ic.INQ_PERSON_ID = :p_inq_person_id
ORDER BY ic.INQ_CONTACT_ID;

Related Objects

The IGS_SS_INQ_CONTACT table has defined relationships with other key staging tables, forming part of the inquiry data model.

  • Primary Key: The table is uniquely identified by its primary key constraint, IGS_SS_INQ_CONTACT_PK, on the column INQ_CONTACT_ID.
  • Foreign Key Relationship: The table references the main inquiry person staging table via a foreign key. The column INQ_PERSON_ID in IGS_SS_INQ_CONTACT references the IGS_SS_INQ_PERSON_ALL table. This relationship ensures every contact record is associated with a valid prospective student record in the staging area.