Search Results incomp_grading_schema_cd




Overview
Explore in AI Chat

Overview

IGS_AS_SUAOA_V is an APPS-owned database view within the Oracle E-Business Suite Student System (IGS) product family. Its name reflects its function: a "student unit attempt outcome aggregate" view that exposes the most recent outcome recorded against a student unit attempt, expressed as either a grade or a mark, across differing grading periods. In Oracle EBS 12.1.1 and 12.2.2, this view serves as a reporting and integration surface for academic outcome data, insulating downstream consumers from the row-proliferation that occurs in the underlying stamp/outcome table when multiple outcomes are recorded over time for the same unit attempt.

The view is particularly relevant to users reconciling grade history, academic transcript extraction, and outcome finalisation reporting, and it is the object queried by the manual_override_flag search term — a column used to distinguish outcomes that were entered manually by a user from those generated by standard grading or processing logic.

Underlying Base Objects

The view is defined over a single documented base table, IGS_AS_SU_STMPTOUT (aliased SUAO). Rather than a simple projection, the view applies a correlated subquery filter that restricts returned rows to those whose OUTCOME_DT equals the maximum OUTCOME_DT for the matching combination of PERSON_ID, COURSE_CD, UOO_ID, and GRADING_PERIOD_CD. This effectively returns the latest outcome per student, per unit offering option, per grading period.

The ETRM metadata for 12.2.2 documents no additional referenced base objects beyond this table, so all columns in the view originate from IGS_AS_SU_STMPTOUT. Because the view is a pure selection and projection with a correlated aggregate filter, no materialisation occurs; query cost is therefore governed by the indexing and volume of the base table.

Key Columns

Common Use Cases and Queries

Typical uses include identifying students whose latest outcome was manually overridden, validating finalised outcomes for transcript generation, and extracting current grade/mark data for a person, unit, and grading period.

SELECT person_id, unit_cd, grading_period_cd, grade, mark, manual_override_flag
FROM   apps.igs_as_suaoa_v
WHERE  manual_override_flag = 'Y'
AND    outcome_dt >= SYSDATE - 365;

A second common pattern retrieves the latest outcome for a specific student and unit offering:

SELECT person_id, course_cd, unit_cd, grade, mark, finalised_outcome_ind
FROM   apps.igs_as_suaoa_v
WHERE  person_id = :p_person_id
AND    uoo_id    = :p_uoo_id;

Because the view already resolves to the latest outcome per grading period, these queries avoid duplicate rows that the base table would otherwise produce, making it suitable for concurrent-program extracts and integration interfaces.