Search Results igs_ad_acad_interest




Overview
Explore in AI Chat

Overview

The IGS_AD_ACAD_INTEREST table is a core data object within the Oracle E-Business Suite (EBS) Student System (IGS) module. It serves as the primary repository for storing and managing an applicant's declared academic interests during the admissions process. This table is fundamental for capturing the specific programs, courses, or study areas a prospective student intends to pursue, enabling institutions to track applicant intent, align applications with academic offerings, and support enrollment planning. Its role is critical in the pre-admission workflow, linking applicant personal data directly to their academic aspirations.

Key Information Stored

The table's primary key is the system-generated ACAD_INTEREST_ID, which uniquely identifies each academic interest record. As indicated by its foreign key relationships, the table is intrinsically linked to the main applicant record via the PERSON_ID and ADMISSION_APPL_NUMBER columns. While the provided metadata does not list all columns, the table's purpose suggests it would typically store fields such as the academic program or course of interest code (e.g., PROGRAM_CD, MAJOR_CODE), the intended start term, a priority ranking if multiple interests are listed, and the status of the interest. It also contains standard Oracle EBS audit columns like CREATION_DATE and LAST_UPDATE_DATE.

Common Use Cases and Queries

This table is central to admissions reporting and applicant communication. Common use cases include generating lists of applicants interested in a specific academic program for targeted outreach, analyzing trends in academic interest over time for strategic planning, and verifying that an applicant's submitted materials align with their declared interests. A typical reporting query would join this table to the applicant master table (IGS_AD_APPL_ALL) and related descriptive flexfield or code tables to produce a readable list.

  • Sample Query: SELECT appl.PERSON_ID, appl.ADMISSION_APPL_NUMBER, int.PROGRAM_INTEREST_CODE FROM IGS_AD_ACAD_INTEREST int JOIN IGS_AD_APPL_ALL appl ON int.PERSON_ID = appl.PERSON_ID AND int.ADMISSION_APPL_NUMBER = appl.ADMISSION_APPL_NUMBER WHERE int.PROGRAM_INTEREST_CODE = '&PROG_CODE';

Related Objects

The IGS_AD_ACAD_INTEREST table has a direct and critical dependency on the primary applicant table, IGS_AD_APPL_ALL. The documented foreign key relationship ensures referential integrity, mandating that every academic interest record must be associated with a valid applicant. The join is performed on two columns: IGS_AD_ACAD_INTEREST.PERSON_ID and IGS_AD_ACAD_INTEREST.ADMISSION_APPL_NUMBER, which reference their counterparts in IGS_AD_APPL_ALL. This table is also likely referenced by various Student System forms, reports, and APIs that manage the applicant academic interest lifecycle.