Search Results igs_ad_ter_edu




Overview
Explore in AI Chat

Overview

The IGS_AD_TER_EDU table is a core data structure within the Oracle E-Business Suite Student System (IGS). It functions as the primary repository for storing a student's historical tertiary education details obtained from institutions other than the current one. This table is critical for the admissions and academic records processes, enabling institutions to evaluate prior qualifications, manage transfer credits, and maintain a comprehensive academic history for each person. Its design, featuring foreign key relationships to master tables for countries, languages, and academic levels, ensures data integrity and supports standardized reporting on applicant and student educational backgrounds across modules like Admissions and Student Records.

Key Information Stored

The table is structured around a composite primary key of PERSON_ID and SEQUENCE_NUMBER, allowing for multiple prior education records per individual. Key columns store detailed information about each prior educational experience. This includes identifiers for the awarding institution and country (COUNTRY_CD), specific qualification details such as the TERTIARY_EDU_LVL_QUAL (qualification level) and TERTIARY_EDU_LVL_COMP (completion level), and academic specifics like the FIELD_OF_STUDY and HONOURS_LEVEL. Additionally, it captures contextual data such as the LANGUAGE_OF_TUITION and LANGUAGE_COMPONENT, which are essential for international qualification assessments. The table effectively provides a normalized model for complex prior learning data.

Common Use Cases and Queries

This table is central to operations involving applicant evaluation and academic history reporting. A common use case is generating a report of all applicants with prior tertiary education in a specific field of study for cohort analysis. The corresponding query would join to person and code tables for descriptive information. Another critical scenario is the validation of transfer credits, where data from IGS_AD_TER_EDU is assessed against the institution's own course catalog. A typical operational query might retrieve a specific student's complete prior education history to support an academic audit or advising session, often joining to related tables like IGS_AD_TER_ED_UNI_AT for attendance details.

  • Sample Query (Prior Education Summary): SELECT p.party_name, tte.country_cd, tte.tertiary_edu_lvl_qual, tte.field_of_study FROM igs_ad_ter_edu tte JOIN hz_parties p ON tte.person_id = p.party_id WHERE tte.person_id = :person_id ORDER BY tte.sequence_number;

Related Objects

The IGS_AD_TER_EDU table maintains integral relationships with numerous master and transactional tables within the IGS schema, as documented by its foreign key constraints. Its primary key is referenced by the IGS_AD_TER_ED_UNI_AT (Tertiary Education University Attendance) table. Key foreign key dependencies link to foundational code tables: IGS_PE_COUNTRY_CD for country codes, IGS_PE_LANGUAGE_CD for language codes (used for both LANGUAGE_COMPONENT and LANGUAGE_OF_TUITION), IGS_PS_FLD_OF_STUDY_ALL for the field of study, and IGS_GR_HONOURS_LEVEL_ALL for honours level classification. Crucially, it links to the core person entity, HZ_PARTIES, via PERSON_ID, and to qualification framework tables IGS_AD_TER_ED_LVL_QF and IGS_AD_TER_ED_LV_COM for standardizing education levels.

  • IGS_AD_TER_ED_UNI_AT: Linked via PERSON_ID and TE_SEQUENCE_NUMBER (details attendance periods).
  • HZ_PARTIES: Linked via PERSON_ID (core person/entity record).
  • IGS_PE_COUNTRY_CD: Linked via COUNTRY_CD.
  • IGS_PS_FLD_OF_STUDY_ALL: Linked via FIELD_OF_STUDY.
  • IGS_GR_HONOURS_LEVEL_ALL: Linked via HONOURS_LEVEL.