Search Results igs_as_sua_ai_group




Overview
Explore in AI Chat

Overview

The IGS_AS_SUA_AI_GROUP 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 represents the linkage between a specific student's unit attempt and the defined groups of assessment items (like exams, assignments, or projects) that constitute the unit's evaluation. Its primary role is to manage and track which assessment item groups, defined at the unit offering or unit section level, are applicable to an individual student's enrollment. This table is essential for the accurate calculation of grades, as it connects the student's attempt record with the assessment structure against which they will be measured.

Key Information Stored

The table's structure centers on a unique identifier and key foreign key relationships. The primary key column, SUA_ASS_ITEM_GROUP_ID, uniquely identifies each record. The table's critical function is established through its foreign keys, which define its relationships to other core entities. The columns PERSON_ID, COURSE_CD, and UOO_ID together form a foreign key to IGS_EN_SU_ATTEMPT_ALL (the Student Unit Attempt table), anchoring the group assignment to a specific student's enrollment in a specific unit offering. The UNIT_ASS_ITEM_GROUP_ID links to IGS_AS_UNIT_AI_GRP, indicating the base assessment item group defined for the unit. The US_ASS_ITEM_GROUP_ID links to IGS_AS_US_AI_GROUP, which allows for assessment group variations at the unit section level, enabling different assessment structures for different classes of the same unit.

Common Use Cases and Queries

A primary use case is generating reports on the assessment workload for a cohort of students or validating assessment setup before finalizing grades. For instance, an administrator may need to list all assessment groups assigned to students in a particular unit offering. A typical query would join IGS_AS_SUA_AI_GROUP with IGS_EN_SU_ATTEMPT_ALL and the relevant unit or person tables. Another critical scenario is during grade processing, where the system references this table to determine which assessment items (via related child tables like IGS_AS_SU_ATMPT_ITM) belong to a student's attempt for aggregation into a final result. Troubleshooting often involves queries to find students missing an expected assessment group assignment, which would involve a NOT EXISTS check against this table.

Related Objects

  • IGS_EN_SU_ATTEMPT_ALL: The foundational student unit attempt record to which the assessment group is attached.
  • IGS_AS_UNIT_AI_GRP: The master definition of an assessment item group for a unit version.
  • IGS_AS_US_AI_GROUP: The section-specific override or instance of an assessment item group.
  • IGS_AS_SU_ATMPT_ITM (via foreign key): Stores the individual assessment item attempts (e.g., scores for specific exams) that roll up under this group for the student.
  • IGS_AS_SUAAI_OUHIST (via foreign key): Likely stores outcome or grading history related to the student's assessment item group.