Search Results term_cal_type




Overview
Explore in AI Chat

Overview

The IGS_EN_SPA_TERMS table is a core data object within the Oracle E-Business Suite Student Administration module, specifically in the context of Oracle EBS 12.1.1 and 12.2.2. It functions as a detailed term-level transactional table that stores enrollment and program attempt attributes for a student, organized by academic term. The table's design is intrinsically linked to the institutional calendar structure, as indicated by the presence of the TERM_CAL_TYPE and TERM_SEQUENCE_NUMBER columns. It serves as a child table to the primary student program attempt record (IGS_EN_STDNT_PS_ATT_ALL), providing a granular breakdown of a student's academic progression, fee categorization, attendance mode, and other critical attributes for each specific term within their program of study.

Key Information Stored

The table stores a comprehensive set of attributes for each student-term record. The primary identifier is the TERM_RECORD_ID. Key columns defining the academic context include PERSON_ID, PROGRAM_CD, PROGRAM_VERSION, ACAD_CAL_TYPE, TERM_CAL_TYPE, and TERM_SEQUENCE_NUMBER, which together uniquely identify a specific term for a student's program attempt (as enforced by the IGS_EN_SPA_TERMS_U1 unique index). Operational data includes the KEY_PROGRAM_FLAG, LOCATION_CD, ATTENDANCE_MODE, and ATTENDANCE_TYPE. The table also holds important foreign keys for integration: FEE_CAT links to the fee category, COO_ID to the course offering option, and CLASS_STANDING_ID to a student's academic standing. Standard Oracle EBS columns for auditing (CREATED_BY, LAST_UPDATE_DATE), concurrent program tracking (REQUEST_ID, PROGRAM_ID), and Descriptive Flexfields (ATTRIBUTE_CATEGORY, ATTRIBUTE1-8) are also present.

Common Use Cases and Queries

A primary use case is generating term-specific enrollment reports or validating a student's status for a given academic period. The table is central to processes involving term-based fee assessment, attendance tracking, and academic standing updates. A common query pattern involves joining to the student program attempt and calendar tables to retrieve a student's complete term history. For example, to find all term records for a specific student and term calendar type (as indicated by the user's search for "term_cal_type"):

  • SELECT * FROM igs.igs_en_spa_terms WHERE person_id = :stu_id AND term_cal_type = :cal_type ORDER BY term_sequence_number;

Another critical use case is data validation, ensuring term records align with the parent program attempt. Reporting often leverages joins to related tables to include descriptive values for codes like FEE_CAT or LOCATION_CD.

Related Objects

IGS_EN_SPA_TERMS has defined foreign key relationships with several fundamental tables in the Student Administration and other modules, as documented in the provided metadata:

  • IGS_EN_STDNT_PS_ATT_ALL: The primary parent table. The PERSON_ID column in IGS_EN_SPA_TERMS references this table to link term details to the overarching student program attempt.
  • IGS_CA_INST_ALL: The TERM_CAL_TYPE column references this calendar instance table, enforcing referential integrity for the term calendar type.
  • IGS_PS_OFR_OPT_ALL: The COO_ID (Course Offering Option ID) column references this table, linking the term to specific program offering options.
  • IGS_FI_FEE_CAT_ALL: The FEE_CAT column references this table, associating the term record with a valid fee category for financial processing.
  • IGS_PR_CLASS_STD: The CLASS_STANDING_ID column references this table to maintain the student's academic class standing for the term.

These relationships position IGS_EN_SPA_TERMS as a pivotal junction table connecting student program data with calendar, financial, and progression entities.