Search Results igs_uc_sitting

Overview

The view APPS.IGS_UC_QUAL_DETS_V is a reporting and integration object within the Oracle E-Business Suite student system (the IGS product family), designed to expose University and Colleges Admissions Service (UCAS) qualification detail records in a denormalised, user-friendly form. Its purpose is to resolve the raw foreign-key identifiers held on the underlying qualification detail entity into their descriptive equivalents, so that downstream reports, interfaces, and enquiry screens can present examination results, sittings, awarding bodies, subjects, and tariff values without additional joins.

In the context of a search for "igs_uc_sitting", the view is significant because it is the principal object through which the SITTING attribute of a UCAS qualification record is exposed. The lookup type IGS_UC_SITTING governs the sitting codes, and the view translates the stored code into its meaning through the SITTING_DESC column. This makes the view the natural access point for any requirement that reports or reconciles UCAS sittings against predicted, claimed, and approved results.

The view supports both EBS 12.1.1 and 12.2.2, and because it is defined within the APPS schema it is available to standard EBS responsibilities through the usual synonym and grant mechanisms.

Underlying Base Objects

The view is defined over six base objects using Oracle's outer-join (+) syntax, reflecting an older join convention retained in the ETRM definition:

• IGS_UC_QUAL_DETS qd — the driving table, holding one row per qualification detail record (the "qual dets" entity).
• IGS_PS_AWD pa — award definitions, joined on exam_level = award_cd, supplying the award title used as EXAM_LEVEL_DESC.
• IGS_PS_FLD_OF_STUDY_ALL fs — the field-of-study lookup, outer-joined on subject_code = field_of_study, supplying SUBJECT_CODE_DESC.
• IGS_LOOKUP_VALUES lv — outer-joined on lookup type IGS_UC_SITTING and sitting = lookup_code, supplying SITTING_DESC.
• HZ_PARTIES hp via IGS_PE_HZ_PARTIES ihp — outer-joined to resolve the awarding body organisation unit into a party name, giving AWARDING_BODY_DESC.
• IGS_AS_GRD_SCH_GRADE agsg — outer-joined on grading schema code, version number, and approved result grade, supplying the UCAS tariff RANK value.

Because the lookup, subject, awarding body, and tariff joins are all outer joins, a qualification detail row is still returned even when any of the descriptive sources are absent.

Key Columns

• QUAL_DETS_ID and ROW_ID — the primary key and physical row identifier of the underlying qualification detail record.
• PERSON_ID — identifies the student to whom the qualification detail belongs.
• EXAM_LEVEL / EXAM_LEVEL_DESC — the examination level code and its award title.
• SUBJECT_CODE / SUBJECT_CODE_DESC — the subject studied and its description.
• SITTING / SITTING_DESC — the UCAS sitting code and the meaning resolved from lookup type IGS_UC_SITTING.
• PREDICTED_RESULT, APPROVED_RESULT, CLAIMED_RESULT — the three result perspectives captured for the qualification.
• GRADING_SCHEMA_CD, VERSION_NUMBER, UCAS_TARIFF — the grading framework and the derived tariff points.
• AWARDING_BODY / AWARDING_BODY_DESC — the awarding organisation code and party name.
• IMPORTED_FLAG, IMPORTED_DATE — provenance indicators for records loaded from UCAS.
• Standard WHO audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

A frequent requirement is reporting all qualification details for a student with sitting descriptions resolved:

SELECT qual_dets_id, exam_level_desc, subject_code_desc,
       sitting_desc, predicted_result, approved_result,
       ucas_tariff, awarding_body_desc
FROM   apps.igs_uc_qual_dets_v
WHERE  person_id = :p_person_id;

To review records by sitting type, the resolved description allows filtering on meaningful values rather than codes:

SELECT sitting, sitting_desc, COUNT(*)
FROM   apps.igs_uc_qual_dets_v
GROUP BY sitting, sitting_desc;

For UCAS import reconciliation, the provenance columns are typically combined with the tariff value:

SELECT person_id, year, sitting_desc, approved_result, ucas_tariff
FROM   apps.igs_uc_qual_dets_v
WHERE  imported_flag = 'Y'
AND    imported_date >= :p_from_date;

Because the tariff join depends on both the grading schema version and the approved result grade, tariff output should be treated as informational; where an exact tariff is unavailable the outer join returns a null UCAS_TARIFF, which calling code must handle gracefully.