Search Results sitting_desc

Overview

The IGS_UC_QUAL_DETS_V view is a reporting object within the Oracle E-Business Suite (EBS) IGS Student System product. It exposes the qualifications that have been awarded to applicants, presenting a denormalized, human-readable representation of qualification data that would otherwise require complex joins across several base tables in the student records and trading community schemas. The view is owned by the APPS schema and carries a status of VALID. Because it consolidates applicant qualification records with descriptive translations — for example, converting coded values into their corresponding award titles, lookup meanings, and party names — the view is well suited to operational reporting, data extracts, and integration interfaces where qualification information must be delivered in a consumable form. A user searching for the SITTING_DESC column will find it exposed directly by this view, meaning the qualification sitting (such as a specific examination session) is resolved to its descriptive meaning without the caller needing to join to the lookup table manually.

Underlying Base Objects

The view is defined over a set of base tables joined through both inner and outer (outer-join) relationships. The principal driving table is IGS_UC_QUAL_DETS (aliased QD), which stores the applicant qualification detail records. Descriptive and reference data are sourced from several supporting objects:

• IGS_PS_AWD (PA) — joined on QD.EXAM_LEVEL = PA.AWARD_CD to supply the exam level award title.
• IGS_PS_FLD_OF_STUDY_ALL (FS) — outer-joined on subject code to provide the field-of-study description.
• IGS_LOOKUP_VALUES (LV) — outer-joined on lookup type 'IGS_UC_SITTING' and sitting code to translate the sitting value.
• IGS_PE_HZ_PARTIES (IHP) and HZ_PARTIES (HP) — outer-joined to resolve the awarding body organisation unit to a party name.
• IGS_AS_GRD_SCH_GRADE (AGSG) — outer-joined on grading schema, version, and grade to derive the UCAS tariff rank.

The joins are predominantly outer joins, ensuring that qualification detail rows are retained even where descriptive reference data is absent.

Key Columns

• ROW_ID, QUAL_DETS_ID, PERSON_ID — unique row identifier, primary key of the qualification detail, and the applicant's person identifier.
• EXAM_LEVEL, EXAM_LEVEL_DESC — the qualification examination level code and its award title description.
• SUBJECT_CODE, SUBJECT_CODE_DESC — the subject code and its field-of-study description.
• PREDICTED_RESULT, APPROVED_RESULT, CLAIMED_RESULT — the results recorded against the qualification.
• SITTING, SITTING_DESC — the sitting code and its meaning from the IGS_UC_SITTING lookup; SITTING_DESC is the descriptive value most commonly requested by report authors.
• AWARDING_BODY, AWARDING_BODY_DESC — the awarding body code and corresponding party name.
• UCAS_TARIFF — the tariff rank derived from the grading schema grade.
• YEAR, GRADING_SCHEMA_CD, VERSION_NUMBER — supporting attributes for the qualification record.
• IMPORTED_FLAG, IMPORTED_DATE — indicate whether the record was imported and when.
• Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical uses include applicant qualification reporting, UCAS tariff extraction, and data migration or interface validation. The following query retrieves qualification details for a given applicant, resolving the sitting description:

• SELECT person_id, exam_level_desc, subject_code_desc, year, sitting_desc, approved_result, awarding_body_desc, ucas_tariff
• FROM apps.igs_uc_qual_dets_v
• WHERE person_id = :p_person_id
• ORDER BY year DESC, exam_level_desc;

Because the view already performs the joins to lookup values and award titles, report authors and integration developers can consume SITTING_DESC and its companion descriptive columns directly, avoiding the need to reconstruct those joins against IGS_LOOKUP_VALUES or IGS_PS_AWD at query time.