Search Results igs_en_spa_terms

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.

• IGS_EN_STDNT_PS_ATT_ALL: The parent student program attempt table. Joined via PERSON_ID and PROGRAM_CD.
• IGS_CA_INST_ALL: The calendar instance table. Joined via TERM_CAL_TYPE and TERM_SEQUENCE_NUMBER to define the academic term.
• IGS_PS_OFR_OPT_ALL: The course offering options table. Joined via COO_ID.
• IGS_FI_FEE_CAT_ALL: The fee category table. Joined via FEE_CAT.
• IGS_PR_CLASS_STD: The class standing table. Joined via CLASS_STANDING_ID.

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