Search Results acad_intent_id




Overview
Explore in AI Chat

Overview

The IGS_PE_ACAD_INTENTS table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically in the Student System (i.e., Oracle Campus Solutions) under the IGS schema. It serves as the master repository for recording and managing a student's declared academic intent for a specific academic term or calendar instance. The table's primary role is to track a student's planned academic status—such as full-time, part-time, or withdrawn—within a given period, which is critical for enrollment reporting, financial aid eligibility, academic advising, and institutional planning. Its design enforces business logic, allowing only one active intent record per person per calendar term, as indicated by the ACTIVE_FLAG column.

Key Information Stored

The table stores the relationship between a student, an academic calendar period, and their declared intent. Key columns include:

  • ACAD_INTENT_ID: The system-generated primary key and unique identifier for each record.
  • PERSON_ID: References the unique identifier for the student (person), linking to the foundational party information (IGS_PE_HZ_PARTIES).
  • CAL_TYPE and SEQUENCE_NUMBER: Together, these identify the specific academic calendar instance (e.g., "TERM", "SEMESTER") and its sequence, forming a foreign key relationship to the calendar instance table.
  • ACAD_INTENT_CODE: A critical field holding the actual code representing the student's academic intent (e.g., 'FULL_TIME', 'PART_TIME'). This is the primary data point users search for when analyzing enrollment patterns.
  • ACTIVE_FLAG: A status indicator ('Y' or 'N') that ensures only one intent per term is active, maintaining data integrity for current status reporting.
  • Standard WHO Columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN): For auditing and tracking data changes.

Common Use Cases and Queries

This table is central to operational and analytical reporting on student enrollment status. A common use case is generating a list of all students with an active full-time intent for a current term for financial aid verification or census reporting. The following query pattern retrieves active intents for a specific academic intent code and calendar:

SELECT p.party_number, p.person_id, ai.acad_intent_code, ai.cal_type, ai.sequence_number
FROM igs.igs_pe_acad_intents ai,
     igs.igs_pe_hz_parties p
WHERE ai.person_id = p.person_id
  AND ai.acad_intent_code = 'FULL_TIME'
  AND ai.active_flag = 'Y'
  AND ai.cal_type = 'TERM'
  AND ai.sequence_number = 202410;

Another critical scenario is auditing intent history for a student across terms, which involves querying all records for a given PERSON_ID, ordered by calendar and sequence. Data from this table is often joined with person, enrollment, and financial aid tables in complex institutional reports.

Related Objects

Based on the provided metadata, IGS_PE_ACAD_INTENTS has defined foreign key relationships and dependencies that integrate it into the broader EBS data model.

  • Referenced Foreign Keys (This table references):
    • TABLE: IGS.IGS_CA_INST_ALL via columns CAL_TYPE and SEQUENCE_NUMBER. This links the academic intent to a specific instance of an academic calendar.
    • TABLE: IGS.IGS_PE_HZ_PARTIES via column PERSON_ID. This links the intent to the core person/student record.
  • Referencing Objects (Referenced by): The documentation states the table is referenced by the APPS synonym IGS_PE_ACAD_INTENTS. This indicates it is accessed by application code and other database objects within the EBS environment, though specific dependent tables or views are not listed in the excerpt.
  • Primary Key: IGS_PE_ACAD_INTENTS_PK on ACAD_INTENT_ID.
  • Index: IGS_PE_ACAD_INTENTS_N1 on (PERSON_ID, CAL_TYPE, SEQUENCE_NUMBER) for performance in queries filtering by student and term.