Search Results marks_grade_change_comment




Overview
Explore in AI Chat

Overview

IGS_AS_SUAAI_OUTHIST_V is a dictionary view owned by the APPS schema in Oracle E-Business Suite, part of the Student System (IGS) product family associated with Oracle Student Information Management. The view exposes a consolidated history of student attempt item outcomes together with their change-comment context. Its defining characteristic is a UNION that combines the current attempt-item rows from IGS_AS_SU_ATMPT_ITM with their archived counterparts in IGS_AS_SUAAI_OUHIST, producing a single result set that spans both live and historical assessment outcomes.

The view carries special significance for users searching on "marks_grade_change_comment". Internally, the view calls the lookup-resolution function IGS_GE_GEN_004.genp_get_lookup with a lookup type of MARKS_GRADE_CHANGE_COMMENT, passing the stored OUTCOME_COMMENT_CODE and returning a decoded OUTCOME_COMMENT_MEANING. This means the view is the primary presentation layer for grade- or mark-change commentary recorded against an attempt item. In reporting and integration terms it serves as a stable, flattened read interface for outcome-history interrogation, shielding downstream consumers from the physical split between live and historical storage.

Underlying Base Objects

The ETRM metadata documents no referenced base objects, but the embedded view text is explicit. The view is defined over two tables:

  • IGS_AS_SU_ATMPT_ITM (alias suaai) — the current student attempt-item records.
  • IGS_AS_SUAAI_OUHIST (alias suaaih) — the corresponding outcome-history / archival table.

The first branch of the UNION selects from IGS_AS_SU_ATMPT_ITM, joined to IGS_AS_SUAAI_OUHIST on person_id, course_cd, creation_dt, ass_id, and uoo_id. The second branch selects the archived rows directly from IGS_AS_SUAAI_OUHIST. The join keys establish the relationship between a live attempt item and its historical lineage, ensuring that current and prior versions of the same outcome are correlated by person, course, assessment, and unit-offering occurrence.

An additional functional dependency exists on the lookup definition for MARKS_GRADE_CHANGE_COMMENT, accessed through the IGS_GE_GEN_004 package, which resolves the stored short code to a user-readable meaning.

Key Columns

The view projects identity, assessment, grading, and audit columns:

  • ROW_ID — the ROWID of the source row, used for row identification across the UNION.
  • person_id, course_cd, unit_cd, cal_type, ci_sequence_number — the student and academic context of the attempt.
  • ass_id, sua_ass_item_group_id, uoo_id — assessment, assessment item group, and unit-offering occurrence identifiers.
  • grade, mark, grading_schema_cd, gs_version_number, outcome_dt — the outcome values and the schema against which they were graded.
  • OUTCOME_COMMENT_CODE / OUTCOME_COMMENT_MEANING — the stored change-comment code and its decoded meaning via MARKS_GRADE_CHANGE_COMMENT.
  • midterm_mandatory_type_code, midterm_weight_qty, final_mandatory_type_code, final_weight_qty — weighting and mandatory rules for midterm and final components.
  • submitted_date, waived_flag, penalty_applied_flag — submission and exception indicators.
  • HIST_START_DT, HIST_END_DT, HIST_WHO, created_by, creation_date, last_updated_by, last_update_date, last_update_login — history and audit trail columns.

For rows sourced from the live table, HIST_START_DT is set to last_update_date and HIST_END_DT is a null TO_DATE placeholder; archived rows carry their own hist_start_dt and hist_end_dt values.

Common Use Cases and Queries

Typical uses include producing a complete mark/grade change audit trail for a student, and reporting on the reasons captured in MARKS_GRADE_CHANGE_COMMENT.

  • All change comments for a student: 
    SELECT person_id, course_cd, unit_cd, ass_id, grade, mark,
       OUTCOME_COMMENT_CODE, OUTCOME_COMMENT_MEANING
FROM   apps.IGS_AS_SUAAI_OUTHIST_V
WHERE  person_id = :person_id
ORDER BY HIST_START_DT;
  • Frequency of each change-comment reason: 
    SELECT OUTCOME_COMMENT_MEANING, COUNT(*)
FROM   apps.IGS_AS_SUAAI_OUTHIST_V
GROUP BY OUTCOME_COMMENT_MEANING;
  • Reconstructing outcome history for one assessment: 
    SELECT ass_id, grade, mark, HIST_START_DT, HIST_END_DT, HIST_WHO
FROM   apps.IGS_AS_SUAAI_OUTHIST_V
WHERE  person_id = :person_id AND ass_id = :ass_id;

Because the view already decodes the comment lookup and unifies live and archived rows, it is well suited to concurrent-program extracts, OBIEE/BIP reporting datasets, and integration feeds requiring a single source of outcome-history truth.