Search Results qual_dets_id




Overview
Explore in AI Chat

Overview

The IGS_UC_QUAL_DETS table is a core data repository within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the IGS (presumably an institution-specific or industry module like Higher Education) product family. Its primary function is to store detailed records of academic qualifications awarded to applicants. This table serves as a critical component for managing applicant profiles, supporting admissions processes, and interfacing with external systems like UCAS (Universities and Colleges Admissions Service in the UK). The presence of the IMPORTED_FLAG and IMPORTED_DATE columns explicitly indicates its role in data integration workflows, where qualification records are received from and synchronized with external admissions services.

Key Information Stored

The table's columns are designed to capture the complete lifecycle and details of an applicant's qualifications. The QUAL_DETS_ID serves as the unique primary key for each record. Key subject and qualification attributes include PERSON_ID (linking to the applicant), EXAM_LEVEL, SUBJECT_CODE, AWARDING_BODY, YEAR, and SITTING (Summer or Winter). The table tracks multiple result types—PREDICTED_RESULT, APPROVED_RESULT, and CLAIMED_RESULT—which are essential for assessing applicant eligibility. The GRADING_SCHEMA_CD and VERSION_NUMBER allow for precise interpretation of result values. The UCAS_TARIFF column stores the standardized points score, which is fundamental for automated admissions scoring. Standard WHO columns (CREATED_BY, LAST_UPDATE_DATE, etc.) provide full auditability for all data changes.

Common Use Cases and Queries

This table is central to applicant qualification reporting and verification. Common operational and reporting scenarios include generating a summary of all qualifications for a specific applicant, validating imported UCAS data, and calculating aggregate tariff points for admission thresholds. A typical query to retrieve a comprehensive qualification history for an applicant would be:

SELECT exam_level, subject_code, year, approved_result, ucas_tariff
FROM igs.igs_uc_qual_dets
WHERE person_id = :person_id
ORDER BY year DESC, exam_level;

Another critical use case is auditing data integration, often executed with a query such as:

SELECT COUNT(*), imported_flag, TRUNC(imported_date)
FROM igs.igs_uc_qual_dets
WHERE imported_date > SYSDATE - 30
GROUP BY imported_flag, TRUNC(imported_date);

Furthermore, the table supports eligibility checks by joining result data with grading schema tables to interpret and compare results against course entry requirements.

Related Objects

Based on the provided metadata, the table's structure indicates relationships with other key entities in the schema. The unique index IGS_UC_QUAL_DETS_U2 on PERSON_ID, EXAM_LEVEL, SUBJECT_CODE, YEAR, SITTING, AWARDING_BODY, and APPROVED_RESULT suggests a likely foreign key relationship where PERSON_ID references a central person or applicant table (e.g., IGS_PE_PERSON). While explicit foreign key constraints are not listed in the excerpt, the GRADING_SCHEMA_CD and VERSION_NUMBER columns are designed to join with a grading schema definition table to decode result values. The table is also a probable parent to other detail tables or is referenced by views that consolidate applicant academic data for presentation layers and reporting interfaces within the EBS application.