Search Results igs_en_spa_terms




Overview
Explore in AI Chat

Overview

The IGS_EN_SPA_TERMS table is a core data object within the Oracle E-Business Suite Student System (IGS) module. It functions as a term-level detail table for a student's program attempt, storing attributes that are specific to a particular academic term calendar. This table enables the system to manage and track student progression, enrollment status, and associated administrative data on a per-term basis, which is fundamental for academic planning, billing, and reporting. Its existence is critical for linking the high-level program enrollment (student program attempt) with the cyclical nature of term-based academic calendars.

Key Information Stored

The table's primary key is TERM_RECORD_ID, which uniquely identifies each term-specific record for a student's program. Key columns include identifiers for the student and program (PERSON_ID, PROGRAM_CD), the specific academic term (TERM_CAL_TYPE, TERM_SEQUENCE_NUMBER), and the corresponding course offering option (COO_ID). It also holds fields for financial and academic categorization, such as FEE_CAT for fee category and CLASS_STANDING_ID for academic class standing. These columns collectively create a granular record of a student's engagement with their program during each defined term period.

Common Use Cases and Queries

A primary use case is generating term-specific enrollment reports for academic departments or financial aid offices. For instance, an administrator may need to list all students actively enrolled in a specific program for a given term to manage class resources. A common reporting query would join this table to student and program master tables. Another critical use is in the fee assessment process, where the FEE_CAT value helps determine applicable tuition and fees for the term. Developers often query this table to validate a student's enrollment status in a term before allowing actions like grade submission or dropping courses.

  • Sample SQL to find term records for a student: SELECT * FROM igs.igs_en_spa_terms WHERE person_id = <student_id> ORDER BY term_cal_type, term_sequence_number;
  • Use case: Auditing a student's progression through their program by reviewing the sequence of term records.

Related Objects

The IGS_EN_SPA_TERMS table maintains integral relationships with several master and transactional tables via foreign key constraints, as documented in the ETRM metadata.

These relationships ensure data integrity and are essential for any joins performed in custom reports or interfaces that require comprehensive term enrollment data.