Search Results enrolment_latest_yr

Overview

The IGS_AD_TER_EDU table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Student Management (OSM) product, under the IGS (iGrants) schema. Its primary function is to store detailed records of an applicant's or student's prior tertiary education from other institutions. This data is critical for two key institutional processes: the assessment of applicants for admission into academic programs and the evaluation of advanced standing or transfer credits. By maintaining a historical record of external educational achievements, the table enables informed decision-making on admissions and credit articulation.

Key Information Stored

The table is structured to capture comprehensive details about each prior educational engagement. Each record is uniquely identified by a combination of PERSON_ID and a system-generated SEQUENCE_NUMBER. Key descriptive columns include INSTITUTION_CD and INSTITUTION_NAME for identifying the awarding body, and ENROLMENT_FIRST_YR/ENROLMENT_LATEST_YR for defining the period of study. Academic details are stored in fields such as TERTIARY_EDU_LVL_COMP (completion status), TERTIARY_EDU_LVL_QUAL (qualification level), FIELD_OF_STUDY, and HONOURS_LEVEL. Notably, the table includes language-specific attributes like LANGUAGE_COMPONENT and LANGUAGE_OF_TUITION, which are indexed (IGS_AD_TER_EDU_N8 and N9) for efficient querying, aligning with the user's search context. The EXCLUSION_IND flag is a significant administrative marker indicating if a student was previously refused enrollment.

Common Use Cases and Queries

A primary use case is generating reports for admissions committees, which involve joining this table with person and application data. The indexed columns, particularly LANGUAGE_COMPONENT, are frequently used in filters for specialized program eligibility. Common SQL patterns include retrieving an applicant's full educational history or identifying all applicants with a specific qualification from a particular country or institution.

• To find applicants with prior education in a specific language component: SELECT * FROM IGS.IGS_AD_TER_EDU WHERE LANGUAGE_COMPONENT = '[Component_Code]';
• To list all tertiary education records for an applicant for assessment: SELECT * FROM IGS.IGS_AD_TER_EDU WHERE PERSON_ID = <id> ORDER BY SEQUENCE_NUMBER;
• To report on applicants from a specific country with completed qualifications: SELECT PERSON_ID, INSTITUTION_NAME, TERTIARY_EDU_LVL_QUAL FROM IGS.IGS_AD_TER_EDU WHERE COUNTRY_CD = '[Country_Code]' AND TERTIARY_EDU_LVL_COMP = 'COMPLETE';

Related Objects

Based on the provided metadata, the IGS_AD_TER_EDU table has defined relationships with other objects primarily through its indexes. The unique index (IGS_AD_TER_EDU_U1) on PERSON_ID and SEQUENCE_NUMBER suggests this composite key is the primary key, likely referenced by foreign keys in related detail or transactional tables. The numerous non-unique indexes (N2 through N9) indicate common join paths or filtering criteria for performance. These indexes imply relationships with lookup tables for values like FIELD_OF_STUDY, COUNTRY_CD, TERTIARY_EDU_LVL_QUAL, INSTITUTION_CD, and the language-related columns. The table is fundamentally linked to a core PERSON or PARTY table via the PERSON_ID column, which is mandatory and central to its function within the student information system.