Search Results igs_as_us_ai_group




Overview
Explore in AI Chat

Overview

The IGS_AS_US_AI_GROUP table is a core data object within the Oracle E-Business Suite Student System (IGS) module. It serves as the master definition table for assessment item groups at the unit section level. In the academic structure of Oracle EBS, a unit section (UOO) is a specific offering of a unit. This table allows administrators to logically group multiple assessment items (e.g., exams, quizzes, projects) that are associated with a particular unit section. Its primary role is to establish a reusable grouping mechanism for assessments, which can then be linked to student unit attempts for grading and tracking purposes, thereby centralizing assessment management and ensuring consistency across student enrollments.

Key Information Stored

The table's central identifier is the US_ASS_ITEM_GROUP_ID, which is the primary key for the record. The most critical foreign key column is UOO_ID, which links the assessment item group to a specific unit offering option in the IGS_PS_UNIT_OFR_OPT_ALL table. This establishes the academic context for the group. While the provided metadata does not list all columns, typical columns in such a structure would include a group name or code, a description, effective dates, creation and last update details, and potentially a sequence number for ordering. The data stored fundamentally defines the relationship between a unit section and a collection of its assessment components.

Common Use Cases and Queries

A primary use case is the setup and maintenance of assessment structures for a course delivery. Administrators create groups here before associating individual assessment items. This table is frequently queried for academic reporting, such as listing all assessment groups for a unit section, or for operational processes like generating grade books. A common SQL pattern involves joining to the unit section and assessment item tables to get a complete view.

  • To find all assessment item groups for a specific unit section: SELECT * FROM igs.igs_as_us_ai_group WHERE uoo_id = <UOO_ID>;
  • To list groups with their associated unit section details: SELECT grp.us_ass_item_group_id, grp.uoo_id, uoo.unit_cd, uoo.version_number FROM igs.igs_as_us_ai_group grp JOIN igs.igs_ps_unit_ofr_opt_all uoo ON grp.uoo_id = uoo.uoo_id;

Related Objects

The IGS_AS_US_AI_GROUP table maintains defined relationships with several other key tables in the Student System, as per the provided foreign key metadata.

  • IGS_PS_UNIT_OFR_OPT_ALL: The parent table. The UOO_ID column in IGS_AS_US_AI_GROUP references this table to tie the assessment group to a specific unit offering.
  • IGS_AS_SUA_AI_GROUP: A key child table. It references IGS_AS_US_AI_GROUP via US_ASS_ITEM_GROUP_ID, linking the master assessment group definition to individual student unit attempt (SUA) assessment groups for grading.
  • IGS_PS_UNITASS_ITEM: Another child table. It references IGS_AS_US_AI_GROUP via US_ASS_ITEM_GROUP_ID, allowing individual assessment items (e.g., "Midterm Exam," "Final Paper") to be assigned to a logical group.