Search Results inq_inq_id

Overview

The IGS_RC_IS_INQUIRY table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically in the now-obsolete IGS (Student System) module. Its primary function is to serve as a staging table for inquiry records submitted through the Self Service interface. This table acts as a temporary holding area for prospective student or applicant data before it is validated and processed into the main transactional tables of the system. Its role is critical in managing the flow of inbound inquiry information, ensuring data integrity during the initial capture phase.

Key Information Stored

While the provided ETRM metadata does not list individual columns beyond key fields, the structure is defined by its primary and foreign key relationships. The central identifier is the INQ_INQ_ID column, which serves as the unique primary key for each staged inquiry record. A crucial foreign key column is INQ_PERSON_ID, which links the inquiry to a corresponding staged person record in the IGS_RC_IS_PER_ALL table. This relationship establishes the connection between the inquiry event and the individual who submitted it. The table's purpose implies it likely stores additional contextual data such as inquiry source, date, status, and type, which are common attributes for staging prospective student interactions.

Common Use Cases and Queries

The primary use case involves data migration and integration processes where inquiry data from external sources or web forms is loaded into the EBS staging tables for subsequent processing. Common operational queries would focus on monitoring the staging queue. For instance, a query to list all pending inquiries awaiting processing would join IGS_RC_IS_INQUIRY with the person staging table. Reporting use cases include analyzing inquiry volumes by source or date to measure marketing campaign effectiveness. A typical SQL pattern would involve selecting from this table and joining to IGS_RC_IS_PER_ALL to get person details, often filtered by a creation date or a processing status flag.

Related Objects

The IGS_RC_IS_INQUIRY table exists within a network of related staging tables, as documented by its foreign key relationships.

• Referenced Table (Parent): IGS_RC_IS_PER_ALL. The inquiry record links to a staged person via the foreign key column IGS_RC_IS_INQUIRY.INQ_PERSON_ID.
• Referencing Tables (Children):
  • IGS_RC_IS_INFO_REQ: References IGS_RC_IS_INQUIRY via the column INQ_INQ_ID. This table likely holds additional information requests associated with the main inquiry.
  • IGS_RC_IS_I_LINES: References IGS_RC_IS_INQUIRY via the column INQ_INQ_ID. This table likely stores detailed line items related to the inquiry, such as questions or requested program details.

These relationships indicate that IGS_RC_IS_INQUIRY is the central header record for a staged inquiry, with detailed information stored in separate child tables.