Search Results outcome_comment_code

Overview

IGS_AS_SUAAI_OUTHIST_V is a Student System (IGS) view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It presents a consolidated history of student assessment item outcomes, allowing institutions to track how an individual's assessment attempt results have evolved over time. The view is implemented as a UNION of two sources: the live attempt item table IGS_AS_SU_ATMPT_ITM and its corresponding history table IGS_AS_SUAAI_OUHIST. This design exposes both current and prior versions of an assessment outcome in a single, unified result set.

The view plays a reporting and integration role. It is typically consumed by gradebook, transcripts, and outcome-audit reports, and can be joined to lookup-driven dimension queries. Because it surfaces the outcome comment code alongside a decoded meaning, it supports reporting on grade-change justifications without requiring the report author to resolve IGS lookup values manually.

Underlying Base Objects

Two base objects are referenced in the view definition:

• IGS_AS_SU_ATMPT_ITM (alias SUAAI) — the primary assessment attempt item table holding the current outcome record.
• IGS_AS_SUAAI_OUHIST (alias SUAAIH) — the history table that retains superseded outcome rows.

The join keys linking the two sources are PERSON_ID, COURSE_CD, CREATION_DT, ASS_ID, and UOO_ID. The first branch of the UNION selects from IGS_AS_SU_ATMPT_ITM joined to IGS_AS_SUAAI_OUHIST; the second branch selects directly from IGS_AS_SUAAI_OUHIST. For the live record, HIST_START_DT is derived from LAST_UPDATE_DATE and HIST_END_DT is set to a NULL date. For historical records, HIST_START_DT, HIST_END_DT, and HIST_WHO come from the history table's own columns.

Key Columns

• PERSON_ID, COURSE_CD, UNIT_CD, CAL_TYPE, CI_SEQUENCE_NUMBER — the student and academic context identifying the assessment event.
• ASS_ID, UOO_ID, SUA_ASS_ITEM_GROUP_ID — identifiers for the assessment, unit offering option, and item group.
• GRADE, GS_VERSION_NUMBER, GRADING_SCHEMA_CD, MARK — the outcome value and the grading schema used to derive it.
• OUTCOME_DT, SUBMITTED_DATE — the date the outcome was recorded and the item was submitted.
• OUTCOME_COMMENT_CODE — the raw lookup code describing the reason for a mark or grade change.
• OUTCOME_COMMENT_MEANING — the decoded description of OUTCOME_COMMENT_CODE. This is produced by IGS_GE_GEN_004.GENP_GET_LOOKUP('MARKS_GRADE_CHANGE_COMMENT', OUTCOME_COMMENT_CODE), with a special case that returns NULL where the lookup value is 'ALL'. This column is the primary target for users searching on "outcome_comment_meaning".
• HIST_START_DT, HIST_END_DT, HIST_WHO — the effective date range and actor for each historical row, enabling temporal (flashback-style) analysis.
• WAIVED_FLAG, PENALTY_APPLIED_FLAG, MIDTERM_WEIGHT_QTY, FINAL_WEIGHT_QTY — assessment handling attributes including weightings and penalty or waiver status.

Common Use Cases and Queries

Typical scenarios include auditing grade changes, explaining mark adjustments in student-facing reports, and reconciling the current outcome against its history. The following query returns all outcome history for a given student and course, ordered chronologically:

SELECT person_id, course_cd, ass_id, grade, mark, outcome_dt,
      outcome_comment_meaning, hist_start_dt, hist_end_dt, hist_who
FROM  apps.igs_as_suaai_outhist_v
WHERE  person_id = :p_person_id
AND    course_cd = :p_course_cd
ORDER BY hist_start_dt;

To isolate records where a change comment was supplied, filter on the decoded meaning:

SELECT person_id, course_cd, ass_id, grade, mark, outcome_comment_meaning
FROM  apps.igs_as_suaai_outhist_v
WHERE  outcome_comment_meaning IS NOT NULL;

Because the view already performs the IGS lookup translation, report authors do not need to join to IGS_LOOKUP_VALUES for the MARKS_GRADE_CHANGE_COMMENT lookup type, simplifying both ad-hoc queries and concurrent program data sources.