Search Results igs_as_su_atmpt_itm




Overview
Explore in AI Chat

Overview

The IGS_AS_SU_ATMPT_ITM table is a core data object within the Oracle E-Business Suite Student System (IGS) for versions 12.1.1 and 12.2.2. It serves as the central repository for linking individual assessment items to specific student unit attempts. This table records which assessment items—such as exams, assignments, or projects—are allocated to a student for a particular unit enrollment. Allocations can occur either manually by an administrator or automatically via the unit's default assessment pattern. The table is fundamental to the assessment lifecycle, enabling the tracking, grading, and reporting of student performance at the granular level of each assessment component.

Key Information Stored

The table's structure is defined by its composite primary and unique keys, which enforce data integrity for the complex relationships it manages. The primary data points stored include identifiers for the student, their course, the specific unit offering (UOO_ID), and the assessment item (ASS_ID). A critical column is CREATION_DT, which is part of the primary key, allowing for historical tracking of multiple allocations of the same assessment item. Other significant columns reference related entities: SUA_ASS_ITEM_GROUP_ID links to assessment item groups, TRACKING_ID connects to tracking items, ASS_PATTERN_ID ties to the assessment pattern, and a set of columns (GRADING_SCHEMA_CD, GS_VERSION_NUMBER, GRADE) links to the grading schema to record or derive the final result for that item.

Common Use Cases and Queries

A primary use case is generating a student's assessment schedule or transcript, detailing all graded components for their enrolled units. Administrators use this table to manage special considerations, such as applying for extensions or alternative assessments, which are recorded against a specific assessment item attempt. Reporting on assessment workload or grade distributions also relies on this table. Common SQL queries involve joining to student (IGS_EN_SU_ATTEMPT_ALL) and assessment definition (IGS_AS_ASSESSMNT_ITM_ALL) tables. For example, to list all assessment items for a student in a given unit offering:

  • SELECT * FROM igs_as_su_atmpt_itm sai
  • JOIN igs_en_su_attempt_all sua ON sai.person_id = sua.person_id AND sai.course_cd = sua.course_cd AND sai.uoo_id = sua.uoo_id
  • JOIN igs_as_assessmnt_itm_all ai ON sai.ass_id = ai.ass_id
  • WHERE sai.person_id = [STUDENT_ID] AND sai.uoo_id = [UOO_ID];

Related Objects

The table maintains extensive relationships with other key entities in the Student System, as evidenced by its foreign key constraints. It is a child table to IGS_EN_SU_ATTEMPT_ALL (the student unit attempt) and IGS_AS_ASSESSMNT_ITM_ALL (the master definition of an assessment item). It is also a parent table to several transactional and historical entities, including IGS_AS_SPL_CONS_APPL (for special consideration applications) and IGS_AS_STD_EXM_INSTN_ALL (for standard exam instructions). The relationships with IGS_AS_SUA_AI_GROUP, IGS_TR_ITEM_ALL, IGS_AS_UNTAS_PATTERN_ALL, and IGS_AS_GRD_SCH_GRADE further integrate it with assessment grouping, student tracking, assessment patterns, and the grading system, respectively.