Search Results igs_rc_is_acad

Overview

The IGS_RC_IS_ACAD table is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Student System (IGS) module. It functions as a staging table designed to hold academic interest data submitted by prospective students or applicants through self-service interfaces. Its primary role is to temporarily store this information before it is validated and processed into the main transactional tables of the student information system. This staging mechanism is critical for managing inbound data flows from web-based inquiry and application forms, ensuring data integrity before formal system integration.

Key Information Stored

Based on the provided ETRM metadata, the table's structure centers on a unique identifier for each academic interest record and a link to the corresponding person. The primary key column, INQ_ACAD_ID, uniquely identifies each staged academic interest entry. The foreign key column, INQ_PERSON_ID, is essential as it links the academic interest data to a specific person record staged in the related IGS_RC_IS_PER_ALL table. While the full column list is not detailed in the excerpt, a table of this nature would typically store data points such as the intended program of study (major, degree), start term, campus preference, and the source or creation date of the interest entry.

Common Use Cases and Queries

The primary use case for this table is supporting the "Request Information" or "Express Interest" functionalities in student recruitment portals. When a prospect submits their academic preferences online, that data lands here. Common operational and reporting queries involve extracting new interest submissions for follow-up by admissions counselors or analyzing trends in academic program popularity. A fundamental SQL pattern joins this table to the person staging table to build a complete prospect profile:

• SELECT per.inq_person_id, per.name, acad.inq_acad_id, acad.program_code FROM igs_rc_is_acad acad JOIN igs_rc_is_per_all per ON acad.inq_person_id = per.inq_person_id WHERE acad.creation_date > SYSDATE - 7;

This query would retrieve all academic interest submissions from the past week with associated person details for recruitment outreach.

Related Objects

The IGS_RC_IS_ACAD table has a documented, direct relationship with the person staging table, forming a key part of the inquiry staging schema. The established foreign key relationship is:

• IGS_RC_IS_PER_ALL: This table holds staged personal/demographic information for the inquirer. The IGS_RC_IS_ACAD table references it via the INQ_PERSON_ID column (IGS_RC_IS_ACAD.INQ_PERSON_ID → IGS_RC_IS_PER_ALL). This relationship ensures that every staged academic interest is associated with a valid staged person record.

As a staging table, its data is typically consumed by concurrent programs or APIs that validate and transfer records into the core student tables, such as those for applications (IGS_AD_APPL) or person records (PER_ALL_PEOPLE_F).