Search Results full_grade_name




Overview
Explore in AI Chat

Overview

IGSFV_UC_QUAL_DETAILS is a reporting and integration view owned by the APPS schema in Oracle E-Business Suite, residing in the Oracle Student System / Enterprise Talent Management (ETRM) product family. It exposes University and College Admissions Service (UCAS) qualification detail records — the individual examination results, predicted grades, approved grades, and claimed grades that an applicant holds — joined to their descriptive grade names, person names, awarding body names, award titles, and subject descriptions. Rather than forcing report authors and integrators to resolve multiple lookup joins manually, the view presents a denormalized, human-readable projection of the UCAS qualification data. Search terms such as full_grade_name map directly to the view's exposed columns, where the grade code stored in the base table is replaced by the descriptive grade name drawn from the grading schema grade table. This makes the view particularly valuable for applicant-facing reports, admissions extracts, and interfaces feeding UCAS return files, where grade codes alone would be insufficient.

Underlying Base Objects

The view is defined over eight base objects. The driving table is IGS_UC_QUAL_DETS (aliased QU), which holds the raw UCAS qualification detail rows keyed by QUAL_DETS_ID. Four of the joins are outer joins to grading schema grades: IGS_AS_GRD_SCH_GRADE is aliased three times — FT4 for the approved result, FT5 for the predicted result, and FT6 for the claimed result — each joined on GRADING_SCHEMA_CD, VERSION_NUMBER, and the respective grade value. HZ_PARTIES is joined twice: FT1 supplies the person or party details (PARTY_NUMBER, PARTY_NAME) via PERSON_ID, and FT7 supplies the awarding body name via IGS_PE_HZ_PARTIES and OSS_ORG_UNIT_CD. IGS_PS_AWD (FT2) resolves the EXAM_LEVEL code to an AWARD_TITLE, while IGS_PS_FLD_OF_STUDY_ALL (FT3) resolves SUBJECT_CODE to a field-of-study DESCRIPTION. All joins except the driving table are marked with the (+) outer-join operator, ensuring qualification rows are retained even when descriptive reference data is missing.

Key Columns

Common Use Cases and Queries

Typical scenarios include extracting applicant qualifications for admissions review, validating grade values against the grading schema, and producing UCAS tariff summaries. A representative query selecting the descriptive grade names is:

SELECT oss_person_number, oss_person_name, exam_level_title, subject_code_desc, year, sitting, approved_result_description, approved_result_score, predicted_result_description, claimed_result_description, ucas_tariff FROM apps.igsfv_uc_qual_details WHERE oss_person_number = :p_party_number ORDER BY year, sitting;

To list all qualifications for a grading schema, filter on grading_schema_code. Because the underlying joins are outer joins, reports should anticipate null values in description columns where reference data has not yet been defined; use NVL or COALESCE to fall back to the raw code columns such as approved_result or predicted_result.