Search Results mark_capped_flag




Overview
Explore in AI Chat

Overview

IGS_AS_SUAO_V is a view owned by the APPS schema in the Oracle E-Business Suite Student System (IGS) product. Its name derives from "Student Unit Attempt Outcome," and the view is designed to describe the outcome of a student unit attempt in the form of a mark and, where applicable, a grade. An outcome record represents the formal result recorded against a student's attempt at a unit of study within a course, including the assessment mark achieved and the grade derived from the applicable grading schema.

The view is not a simple pass-through of a base table. It applies a filtering predicate that restricts the result set to the most recent non-midterm outcome for each student, course, and unit offering option combination. This makes IGS_AS_SUAO_V particularly suited to reporting scenarios in which the latest final outcome is required, such as academic history production, transcript generation, progression checking, and integration feeds that publish finalised results to downstream systems. The filter is expressed against OUTCOME_DT and the GRADING_PERIOD_CD column, excluding records whose grading period is 'MIDTERM'.

Underlying Base Objects

The view is defined over a single documented base table: IGS_AS_SU_STMPTOUT, aliased as SUAO. Two predicates are applied to that table.

  • GRADING_PERIOD_CD <> 'MIDTERM' — midterm outcomes are excluded from the view entirely.
  • OUTCOME_DT IN (SELECT MAX(OUTCOME_DT) FROM IGS_AS_SU_STMPTOUT WHERE PERSON_ID = SUAO.PERSON_ID AND COURSE_CD = SUAO.COURSE_CD AND UOO_ID = SUAO.UOO_ID AND GRADING_PERIOD_CD <> 'MIDTERM') — this correlated subquery selects the latest outcome date per student, course, and unit offering option, ensuring only the most recent non-midterm outcome row is returned for each combination.

No additional base objects are documented in the ETRM metadata for this view. The view therefore inherits the structure of IGS_AS_SU_STMPTOUT while removing historical and midterm rows. Because the underlying table carries audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN), the view exposes these as well, allowing change tracking in reports. The relationship to IGS_AS_SU_STMPTOUT is one of filtered projection: all columns exposed by the view originate from that table, with no joins documented to unit, course, person, or grading schema entities; any such descriptive attributes must be obtained by joining the view to the relevant IGS tables on the keys it exposes.

Key Columns

  • PERSON_ID — identifies the student to whom the outcome belongs.
  • COURSE_CD, UNIT_CD, CAL_TYPE, CI_SEQUENCE_NUMBER — identify the course, unit, calendar type, and calendar instance sequence for the attempt.
  • CI_START_DT, CI_END_DT — the start and end dates of the calendar instance associated with the attempt; CI_END_DT is frequently used to bound reporting periods to a teaching period or academic year.
  • OUTCOME_DT — the date the outcome was recorded; used by the view's MAX subquery to select the latest non-midterm outcome.
  • GRADING_SCHEMA_CD, VERSION_NUMBER, GRADE, MARK — the grading schema applied, its version, the resulting grade, and the numeric mark awarded.
  • S_GRADE_CREATION_METHOD_TYPE, MANUAL_OVERRIDE_FLAG, MARK_CAPPED_FLAG — indicate how the grade was produced, whether it was manually overridden, and whether the mark was capped.
  • FINALISED_OUTCOME_IND — indicates whether the outcome has been finalised, a common filter in reporting.
  • TRANSLATED_GRADING_SCHEMA_CD, TRANSLATED_VERSION_NUMBER, TRANSLATED_GRADE, TRANSLATED_DT — the translated or converted grading result, typically used when results are mapped between schemas or for external presentation.
  • UOO_ID — the unit offering option identifier, a key element of the view's MAX subquery grouping.
  • SHOW_ON_ACADEMIC_HISTRY_FLAG — controls whether the outcome is displayed on the student's academic history.
  • RELEASE_DATE — the date the result is released to the student.
  • NUMBER_TIMES_KEYED — count of times the outcome was keyed, useful for data-quality monitoring.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns.

Common Use Cases and Queries

The view is commonly used to report the latest final outcome per student unit attempt, to build academic history extracts, and to feed downstream grading or transcript systems. A basic query listing finalised outcomes for a student is shown below.

  • Student result enquiry: SELECT person_id, course_cd, unit_cd, ci_end_dt, grade, mark FROM igs_as_suao_v WHERE person_id = :p_person_id AND finalised_outcome_ind = 'Y' ORDER BY ci_end_dt;
  • Results within an academic period: SELECT person_id, unit_cd, grade, mark FROM igs_as_suao_v WHERE ci_end_dt BETWEEN :p_start AND :p_end AND show_on_academic_histry_flag = 'Y';
  • Data-quality check for capping or overrides: SELECT uoo_id, person_id, mark, mark_capped_flag, manual_override_flag FROM igs_as_suao_v WHERE mark_capped_flag = 'Y' OR manual_override_flag = 'Y';
  • Released results feed: SELECT person_id, course_cd, unit_cd, grade, release_date FROM igs_as_suao_v WHERE release_date IS NOT NULL AND finalised_outcome_ind = 'Y' ORDER BY release_date;

Because the view exposes only identifiers and outcome attributes, reports requiring student names, unit titles, or grading schema descriptions must join to the appropriate IGS tables, for example on PERSON_ID, COURSE_CD, UNIT_CD, and GRADING_SCHEMA_CD. Queries should account for the view's inherent filtering: midterm outcomes and all but the latest non-midterm outcome per student, course, and UOO_ID are excluded, so the view must not be used where the full outcome history is required.