Search Results igs_as_unit_ai_grp




Overview
Explore in AI Chat

Overview

The IGS_AS_UNIT_AI_GRP table is a core data object within the Oracle E-Business Suite (EBS) Student System (IGS), specifically designed for managing academic assessment structures. As indicated by its description, "Unit Assessment Item Group," this table serves as a master definition table for grouping individual assessment items (such as exams, assignments, or projects) within a specific unit offering. Its primary role is to establish a logical container that allows for the collective management, weighting, and application of rules to a set of assessment components. This functionality is critical for calculating final grades and enforcing assessment policies. It is important to note that the provided ETRM metadata explicitly labels the IGS product line as "Obsolete," indicating this table is part of a legacy Student System that may have been superseded in later Oracle Campus Solutions implementations.

Key Information Stored

The table stores the defining attributes of an assessment item group. Its structure reveals two primary keys: a surrogate key and a natural composite key. The surrogate key, UNIT_ASS_ITEM_GROUP_ID, provides a unique system identifier for each group. The composite key (IGS_AS_UNIT_AI_GRP_U1) precisely ties the group to a specific unit offering, consisting of UNIT_CD (unit code), VERSION_NUMBER, CAL_TYPE (calendar type), and CI_SEQUENCE_NUMBER (teaching calendar sequence). The GROUP_NAME column stores the descriptive name of the assessment group. This design ensures that group names can be unique within the context of a single unit offering, preventing ambiguity.

Common Use Cases and Queries

This table is central to operations involving the configuration and reporting of unit assessments. A common administrative use case is querying all assessment groups defined for a unit in a given academic period to validate assessment weightings or to generate a syllabus. For reporting, the table is joined to student assessment results to analyze performance across grouped items. Sample SQL to list groups for a unit would leverage the natural key columns:

  • SELECT group_name, unit_ass_item_group_id FROM igs_as_unit_ai_grp WHERE unit_cd = 'MATH101' AND version_number = 1 AND cal_type = 'SEMESTER' AND ci_sequence_number = 202301;

Another critical use case is ensuring referential integrity when deleting or archiving unit offerings, as the system must check for dependent student assessment records linked through the group identifier.

Related Objects

The IGS_AS_UNIT_AI_GRP table sits at the center of the assessment data model, with defined relationships to key transactional tables. As per the foreign key metadata, it is referenced by two primary objects:

  • IGS_AS_SUA_AI_GROUP: This table likely links student unit attempt records to assessment groups, connecting the group definition to individual student enrollments and their results.
  • IGS_AS_UNITASS_ITEM_ALL: This is the master table for individual assessment items. The foreign key from this table to IGS_AS_UNIT_AI_GRP (via UNIT_ASS_ITEM_GROUP_ID) is the fundamental relationship that populates a group with its constituent assessment components.

These relationships form a hierarchy: Unit Offering -> Assessment Item Group (IGS_AS_UNIT_AI_GRP) -> Assessment Items (IGS_AS_UNITASS_ITEM_ALL) -> Student Attempt Results (via IGS_AS_SUA_AI_GROUP).