Results for “subject_identifier”
9 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IGSBV_UC_APPLICANT_RESULTS is a read-only base view owned by the APPS schema within the IGS (Student System) product family of Oracle E-Business Suite. In both release 12.1.1 and 12.2.2 the view is registered as VALID and is documented in the E-Business Suite Technical Reference Manual (ETRM) under the title "View: IGSBV_UC_APPLICANT_RESULTS", described as the "Base View for Applicant Examination Results". Its purpose is to expose examination results recorded against UCAS applicants in a denormalised, business-friendly form suitable for inquiry, reporting, and outbound integration.
The view sits in the admissions data flow. UCAS applicant and result data is staged in the underlying UCAS tables, converted by concurrent programs, and subsequently surfaced through base views such as this one. Because the view supplies descriptive and identifier columns for exam level, sitting, awarding body, and result values, it is a natural source for applicant result extracts, admissions dashboards, and reconciliation reports. It is equally relevant to the search term ebl_amended_result, since that column is one of the explicitly projected result fields in the view definition.
Underlying Base Objects
The view is defined over a single base table, IGS_UC_APP_RESULTS (aliased AP), and is created WITH READ ONLY, so no DML may be performed through it. No additional referenced base objects are documented in the ETRM metadata. The view performs no joins; every column is a direct projection of a column in IGS_UC_APP_RESULTS, with the sole exception of the descriptive sitting attribute, which is derived at runtime from the Descriptive Flexfield / lookup mechanism. Column aliases are introduced to give the underlying attributes more explicit business names, for example APP_NO becomes UCAS_APPLICANT_NUMBER and APP_RESULT_ID becomes APPLICANT_RESULT_IDENTIFIER.
One derived attribute is present: '_LA:AP.SITTING:IGS_LOOKUP_VALUES:IGS_UC_SITTING:MEANING' "_LA:SITTING_DESC". This is an Oracle Application Object Library descriptive flexfield reference that resolves the sitting code stored in AP.SITTING against the lookup type IGS_UC_SITTING, returning the corresponding meaning as SITTING_DESC. Because the view wraps the base table one-for-one, the row cardinality and key structure of IGS_UC_APP_RESULTS are preserved.
Key Columns
- APPLICANT_RESULT_IDENTIFIER — Primary key of the underlying result record (APP_RESULT_ID).
- UCAS_APPLICANT_NUMBER — The UCAS applicant number (APP_NO), the principal admissions identifier.
- ENQUIRY_NUMBER — UCAS enquiry reference associated with the applicant.
- EXAM_LEVEL — Qualification or examination level of the result.
- EXAM_YEAR and SITTING — Year of the examination and the sitting code; SITTING_DESC supplies the decoded lookup meaning.
- AWARDING_BODY — Examination board or awarding organisation.
- PREDICTED_RESULT — Grade predicted by the applicant or referee.
- RESULT_IN_OFFER — Result stipulated as a condition of the offer.
- EBL_RESULT, EBL_AMENDED_RESULT, CLAIMED_RESULT — The externally board-loaded result, its amended value, and the result claimed by the applicant respectively. EBL_AMENDED_RESULT is the field most commonly targeted by users searching this object.
- IMPORTED_FLAG — Indicates whether the result record arrived through import processing.
- APPLICANT_IDENTIFIER and SUBJECT_IDENTIFIER — Foreign keys to the applicant and subject entities.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — Standard WHO audit columns.
Common Use Cases and Queries
Typical scenarios include UCAS result verification, comparisons between predicted, offered, and confirmed grades, and identifying records whose externally loaded result has been amended. The amended-result analysis is a frequent requirement in clearing and confirmation workflows.
- Reconcile board-loaded results against amended values:
SELECT ucas_applicant_number,
exam_year,
exam_level,
ebl_result,
ebl_amended_result
FROM apps.igsbv_uc_applicant_results
WHERE ebl_amended_result IS NOT NULL
AND ebl_result <> ebl_amended_result;
- Compare predicted, offered, and claimed outcomes for a given applicant:
SELECT ucas_applicant_number,
subject_identifier,
predicted_result,
result_in_offer,
claimed_result,
ebl_result
FROM apps.igsbv_uc_applicant_results
WHERE exam_year = :p_year
ORDER BY ucas_applicant_number;
- Identify imported records for audit purposes using imported_flag combined with the WHO audit columns.
- Join to the applicant entity on applicant_identifier to enrich reports with applicant names and choices.
Because the view is read-only and directly reflects IGS_UC_APP_RESULTS, it is safe for concurrent reporting use and requires no additional privilege beyond SELECT on the APPS view.
-
Base View for Applicant Examination Results
APPS.IGSBV_UC_APPLICANT_RESULTS·↳ IGS_UC_APP_RESULTS·Explore IGS module →
-
Full View for Applicant Examination Results
APPS.IGSFV_UC_APPLICANT_RESULTS·↳ HZ_PARTIES·↳ IGS_UC_APPLICANTS·↳ IGS_UC_APP_RESULTS·Explore IGS module →
-
Base View for Applicant Examination Results
Not implemented in this database·Explore IGS module →
-
Full View for Applicant Examination Results
Not implemented in this database·Explore IGS module →
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.