Results for “finalised_outcome_indicator”

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

Overview

The view IGS_AS_UGAI_ADI_V belongs to the IGS – Student System product family within Oracle E-Business Suite. Its name expands conceptually to "Unit Grading / Assessment Item WebADI View," and it is designed to expose unit grading and assessment outcome data in a shape suitable for consumption by Oracle's WebADI (Web Applications Desktop Integrator) desktop integration framework. In practice, this means the view flattens the relationship between a student's unit attempt, the associated assessment outcome record, and the person identity details, then surfaces the result as a spreadsheet-friendly row set that can be uploaded or downloaded by administrative users through Excel.

The ETRM documentation classifies this object as part of the Obsolete Student System component set, and explicitly notes that it is "Not implemented in this database" for the 12.1.1 / 12.2.2 delivery examined. Consequently, the view may be absent from a standard installation even though its definition is catalogued. Its role in reporting and integration is therefore historical and reference-oriented: it illustrates how grading data was prepared for bulk maintenance and WebADI-driven correction of assessment outcomes.

Underlying Base Objects

The ETRM metadata documents no referenced base objects, which is unusual and reflects the fact that the view was never deployed in the reference environment; dependency metadata was not captured. The view text itself reveals the primary sources, which are the student unit attempt table (aliased SUA) and the student unit attempt outcome table (aliased SUAO). The SUAO alias supplies the outcome-level attributes, while SUA contributes unit, course, calendar, and location context. A person table (aliased P) supplies PARTY_NUMBER, PERSON_LAST_NAME, PERSON_FIRST_NAME, and PERSON_MIDDLE_NAME.

The view also references the package IGS_AS_ANON_GRD_PKG, invoking functions CHK_ANON_GRADED and GET_ANON_ID. These calls support anonymous grading controls, returning null for identifying fields when a grade is anonymous and supplying an anonymous identifier otherwise. The join is effectively a student unit attempt to its outcome, enriched with person and anonymity logic.

Key Columns

• PERSON_ID, PERSON_NUMBER, PERSON_NAME – student identity; number and name are suppressed (set null) when anonymous grading applies.
• COURSE_CD, UNIT_CD, SUA_VERSION_NUMBER, CAL_TYPE, CI_SEQUENCE_NUMBER, CI_START_DT, CI_END_DT – teaching period and unit version context from the unit attempt.
• UOO_ID – identifier of the unit attempt outcome, the key link to SUAO.
• SUAO_VERSION_NUMBER, OUTCOME_DT, GRADING_SCHEMA_CD, GRADE, MARK, MARK_CAPPED_FLAG – the outcome grade and mark details.
• S_GRADE_CREATION_METHOD_TYPE, FINALISED_OUTCOME_INDICATOR, NUMBER_TIMES_KEYED, MANUAL_OVERRIDE_FLAG – provenance and status of the grade.
• TRANSLATED_* and INCOMP_* columns – translated grade equivalents and incomplete-grade handling, including deadlines and default marks/grades.
• RELEASE_DATE, SHOW_ON_ACADEMIC_HISTRY_FLAG, GRADING_PERIOD_CD, COMMENTS – release and reporting attributes.
• ORG_ID – multi-org operating unit discriminator.

Common Use Cases and Queries

Typical usage centres on exporting grading data to Excel for bulk review or correction. A basic query selecting core grading columns is:

SELECT person_number, person_name, course_cd, unit_cd, sua_version_number, grade, mark, finalised_outcome_indicator FROM igs_as_ugai_adi_v WHERE org_id = :p_org_id;

Because suao_version_number is a frequently searched column, filtering on it isolates a specific outcome version:

SELECT uoo_id, sua_version_number, suao_version_number, grade FROM igs_as_ugai_adi_v WHERE suao_version_number = :p_version;

Administrators may also filter by grading_schema_cd or grading_period_cd to scope a download to a single assessment cycle. Where the view is not implemented, equivalent reporting must be constructed directly against the underlying unit attempt and outcome tables.