Search Results inq_college_id

Overview

The IGS_SS_INQ_COLLEGE table is a legacy data object within the Oracle E-Business Suite (EBS) Student System (IGS). As explicitly noted in the ETRM documentation, its purpose was to hold staging data for college-related information within the Self Service module. This table is designated as obsolete, indicating its functional logic has been superseded or retired in the application's architecture. Critically, the provided metadata states it was "Not implemented in this database," which strongly suggests that while the table definition exists in the data dictionary, it was never populated or actively used in standard deployments of EBS 12.1.1 or 12.2.2. Its role was transitional, likely intended to temporarily store data during online transactions before validation and posting to permanent master tables.

Key Information Stored

Based on the provided metadata, the table's structure centers on a unique identifier and a foreign key relationship. The primary column is INQ_COLLEGE_ID, which serves as the primary key (IGS_SS_INQ_COLLEGE_PK) to uniquely identify each staged college record. The other documented column is INQ_PERSON_ID, a foreign key that links the staged college data to a corresponding inquiry person record in the IGS_SS_INQ_PERSON_ALL table. This relationship implies the table was designed to store college preferences or affiliations associated with specific prospective student inquiries. The absence of other documented columns in the excerpt reinforces its limited and staging-specific purpose.

Common Use Cases and Queries

Given its obsolete status and noted non-implementation, there are no active use cases for this table in production EBS environments. It would not be used for operational reporting or processes. Historically, if it had been used, its function would have been internal to the Self Service application flow. A typical query to inspect any residual data (though none is expected) would join to the related person staging table:

SELECT coll.inq_college_id, coll.inq_person_id, person.inquiry_details
FROM igs_ss_inq_college coll,
igs_ss_inq_person_all person
WHERE coll.inq_person_id = person.inq_person_id(+);

Database administrators or consultants might query the table's existence or definition during system analysis or cleanup of obsolete objects, but it holds no business data.

Related Objects

The table has a defined relationship with one other object in the Student System, as per the foreign key metadata:

• IGS_SS_INQ_PERSON_ALL: This is the primary related table. The foreign key in IGS_SS_INQ_COLLEGE (INQ_PERSON_ID) references a record in IGS_SS_INQ_PERSON_ALL. This establishes that a staged college record was intended to be a child of a staged prospective student (inquirer) record.

No other foreign keys or dependencies are documented, which is consistent with a simple, single-purpose staging table that feeds into or from a more central person staging entity.