Search Results igs_ad_ter_ed_uni_at

Overview

The IGS_AD_TER_ED_UNI_AT table is a core data object within the Oracle E-Business Suite's now-obsolete Student System (IGS) module. It was designed to store detailed transactional records of specific unit or course attempts undertaken by an applicant during their prior tertiary education. Its primary role was to support the admissions and advanced standing (credit transfer) evaluation processes. By maintaining a granular history of an applicant's academic unit attempts, the table enabled institutions to assess eligibility, calculate grade point averages, and determine applicable credit transfers against their own academic programs. The metadata explicitly notes this table was "Not implemented in this database," indicating it may have been part of a data model that was not fully deployed in certain instances of Oracle EBS 12.1.1 or 12.2.2.

Key Information Stored

The table's structure centers on uniquely identifying a unit attempt within the context of an applicant's broader tertiary education history. Its four-column composite primary key underscores this relationship: PERSON_ID links to the applicant; TE_SEQUENCE_NUMBER sequences multiple tertiary education records for that person; UNIT_CD identifies the specific unit attempted; and SEQUENCE_NUMBER sequences multiple attempts at the same unit. Beyond these identifiers, the table would typically store assessment data for the attempt, such as a final grade, result status, credit points awarded, and the academic period in which the attempt occurred. The documented foreign key to IGS_PS_DSCP_ALL via the DISCIPLINE_GROUP_CD column suggests it also classified the unit within a broader academic discipline framework for evaluation purposes.

Common Use Cases and Queries

The primary use case was generating detailed transcripts of prior learning for admission committees. A typical query would join this table to the applicant's main tertiary education record (IGS_AD_TER_EDU) and discipline tables to produce a comprehensive academic history report. For advanced standing, analysts would query unit attempts matching specific grades or credit points to map against internal course requirements. A sample SQL pattern for retrieving an applicant's unit attempt history would be:

• SELECT ateu.unit_cd, ateu.sequence_number, ateu.final_grade, dscp.discipline_group_name FROM igs_ad_ter_ed_uni_at ateu JOIN igs_ad_ter_edu ate ON (ateu.person_id = ate.person_id AND ateu.te_sequence_number = ate.sequence_number) LEFT JOIN igs_ps_dscp_all dscp ON (ateu.discipline_group_cd = dscp.discipline_group_cd) WHERE ate.person_id = :p_person_id ORDER BY ateu.unit_cd, ateu.sequence_number;

Related Objects

This table sits within a specific hierarchy of the obsolete Student System's data model. Its relationships are strictly defined by the documented foreign keys:

• IGS_AD_TER_EDU: This is the parent table. Each unit attempt record must belong to a summarized tertiary education entry for an applicant. The join uses the composite key of PERSON_ID and TE_SEQUENCE_NUMBER.
• IGS_PS_DSCP_ALL: This table provides the discipline group classification for a unit attempt. The IGS_AD_TER_ED_UNI_AT.DISCIPLINE_GROUP_CD column references IGS_PS_DSCP_ALL.DISCIPLINE_GROUP_CD, allowing units to be grouped and evaluated by academic discipline.

As a child of IGS_AD_TER_EDU, this table would also be indirectly related to the core person (IGS_PE_PERSON) and application (IGS_AD_APPL) tables through that parent's relationships.