Search Results igs_uc_qual_dets




Overview
Explore in AI Chat

Overview

The IGS_UC_QUAL_DETS table is a core data structure within the now-obsolete Student System (IGS) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It was designed to serve as the central repository for storing detailed records of academic qualifications awarded to an applicant. Its primary role was to support admissions and student data management processes by maintaining a historical and current record of an applicant's educational achievements, which is critical for application assessment, eligibility determination, and credit transfer evaluations. Notably, the provided ETRM documentation explicitly states this table was "Not implemented in this database," indicating it may have been a planned component that was not deployed in standard installations or was superseded by other functionality.

Key Information Stored

The table's structure is designed to capture the precise details of a qualification. The unique combination of a specific applicant (PERSON_ID), an exam level (EXAM_LEVEL), a subject code (SUBJECT_CODE), a year (YEAR), a sitting (SITTING), an awarding body (AWARDING_BODY), and an approved result (APPROVED_RESULT) forms a unique key (IGS_UC_QUAL_DETS_UK). Key columns include QUAL_DETS_ID as the primary surrogate key, PERSON_ID linking to the party (HZ_PARTIES), and EXAM_LEVEL and SUBJECT_CODE linking to award and field of study definitions, respectively. Crucially, it stores multiple result types—APPROVED_RESULT, CLAIMED_RESULT, and PREDICTED_RESULT—each linked to the grading schema (IGS_AS_GRD_SCH_GRADE), allowing the system to track official, self-reported, and forecasted grades for a qualification.

Common Use Cases and Queries

In a functional implementation, this table would be central to applicant qualification reporting and validation. Common operational use cases would include generating summary transcripts for applicants, verifying that stated qualifications meet course entry requirements, and processing data for regulatory or accreditation reporting. A typical query might involve joining to HZ_PARTIES for applicant details and IGS_PS_AWD for the qualification name to list all qualifications for a specific person. Another critical pattern would be to compare CLAIMED_RESULT against APPROVED_RESULT for audit purposes to identify discrepancies between applicant-reported and officially verified grades. Reports for admissions committees would likely aggregate data from this table to analyze the academic profiles of applicant cohorts.

Related Objects

Based on the documented foreign key relationships, IGS_UC_QUAL_DETS is integrally connected to several foundational EBS tables. It references the following objects:

  • HZ_PARTIES via PERSON_ID to identify the applicant/student.
  • IGS_PS_AWD via EXAM_LEVEL to define the type of award or qualification level.
  • IGS_PS_FLD_OF_STUDY_ALL via SUBJECT_CODE to define the academic subject.
  • IGS_AS_GRD_SCH_GRADE via GRADING_SCHEMA_CD and VERSION_NUMBER for the APPROVED_RESULT, CLAIMED_RESULT, and PREDICTED_RESULT values, linking to the institutional grading scheme.
Furthermore, the table is referenced by:
  • IGS_AV_STND_UNIT_LVL_ALL via QUAL_DETS_ID, suggesting a relationship where standardized unit levels (potentially for credit transfer) are associated with a specific recorded qualification detail.
These relationships position IGS_UC_QUAL_DETS as a nexus between applicant personal data, the product catalog (awards and subjects), and the grading system.