Results for “igs_uc_app_results”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_UC_APP_RESULTS is a transactional table in the IGS (Student System) product family of Oracle E-Business Suite, owned by the IGS schema. It stores applicant examination results captured through the Universities and Colleges Admissions Service (UCAS) interface that links external admissions data with the institution's internal applicant records. The table synchronizes with the UCAS external view ivStarPQR, which supplies predicted and qualification result data used during the admissions cycle. Rows are populated or refreshed by the UCAS import process and retain a timestamp column (IVSTARPQR_TIMESTAMP) reflecting when the source view supplied the data.

Within a Data Vault modeling heuristic, the foreign-key structure suggests this table should be classified as a link entity. It resolves relationships between an applicant (via APP_ID to IGS_UC_APPLICANTS) and a subject/award-body combination (via SUBJECT_ID to IGS_UC_COM_EBL_SUBJ), while also carrying descriptive measures such as predicted, claimed, and awarded results. This classification is a modeling suggestion derived from the FK topology rather than a formal EBS designation.

Key Information Stored

The table contains 21 documented columns in the ETRM 12.1.1 physical schema. The most significant columns are:

• APP_RESULT_ID — surrogate primary key; also the single-column unique index IGS_UC_APP_RESULTS_U1, making it the sole documented business-key candidate.
• APP_ID — foreign key to IGS_UC_APPLICANTS, identifying the applicant to whom the result belongs.
• APP_NO / ENQUIRY_NO — external UCAS application and enquiry identifiers used for reconciliation with the UCAS feed.
• SUBJECT_ID — foreign key to IGS_UC_COM_EBL_SUBJ, defining the subject or qualification area.
• EXAM_LEVEL — the level of qualification (e.g., A-level, AS-level, Scottish Highers).
• YEAR / SITTING — academic year and examination sitting associated with the result.
• AWARD_BODY — the awarding or examining body.
• PREDICTED_RESULT — the grade predicted by the referee or applicant.
• RESULT_IN_OFFER — the qualification result stipulated within the applicant's offer conditions.
• EBL_RESULT / EBL_AMENDED_RESULT — examination/board result and any subsequently amended value.
• CLAIMED_RESULT — the result self-reported by the applicant.
• IVSTARPQR_TIMESTAMP — timestamp of synchronization with the UCAS source view.
• IMPORTED — flag indicating whether the row originated from an import process.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns.

Common Use Cases and Queries

Typical reporting scenarios include verifying predicted versus achieved results for offer-making decisions, monitoring applicants whose results match or miss conditional offers, and auditing import runs. A representative join retrieves an applicant's results with their award-body descriptions:

SELECT a.app_no, r.exam_level, r.predicted_result, r.ebl_result, r.claimed_result
FROM igs.igs_uc_app_results r
JOIN igs.igs_uc_applicants a ON a.app_id = r.app_id
WHERE r.imported = 'Y'
ORDER BY a.app_no, r.year;

A second pattern identifies results recently refreshed by the UCAS feed, using IVSTARPQR_TIMESTAMP as the filter:

SELECT app_result_id, app_id, subject_id, ivstarpqr_timestamp
FROM igs.igs_uc_app_results
WHERE ivstarpqr_timestamp >= TRUNC(SYSDATE) - 1;

Analysts also aggregate by AWARD_BODY and EXAM_LEVEL to profile applicant qualifications across a recruitment cycle.

Related Objects

The following objects are most significant to IGS_UC_APP_RESULTS:

• IGS_UC_APPLICANTS — parent table referenced by APP_ID; supplies applicant identity and status.
• IGS_UC_COM_EBL_SUBJ — parent table referenced by SUBJECT_ID; defines subjects and award-body combinations.
• IGS_UC_APP_RESULTS_PK — primary key constraint on APP_RESULT_ID.
• IGS_UC_APP_RESULTS_U1 — unique index reinforcing APP_RESULT_ID as the business-key candidate.
• ivStarPQR — external UCAS view from which result data is synchronized.
• UCAS import concurrent programs and interfaces within the IGS Student System that populate and maintain these rows.