Results for “igs_as_sua_ai_group”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The IGS_AS_SUA_AI_GROUP table, owned by the IGS schema within the Oracle E-Business Suite Student System product, stores Student Unit Attempt Assessment Item Groups. Each row defines a named grouping of assessment items associated with a student's attempt at a unit, together with the weighting and formula attributes that govern how the constituent assessment items contribute to the student's overall assessment outcome. The object therefore sits at the intersection of assessment definition (institutional assessment structure) and assessment delivery (a specific student's unit attempt), allowing the Student System to maintain per-student, per-attempt assessment groupings rather than relying on a single global definition.

From a dimensional modeling perspective, the metadata's heuristic Data Vault classification is satellite-leaning. This classification should be treated as a modeling suggestion: the table's natural role is to hold descriptive, time-variant attributes attached to a parent assessment/unit-attempt business key, rather than to act as an independent hub of business entities or as a pure many-to-many link. The presence of audit columns and a LOGICAL_DELETE_DATE column reinforces the satellite interpretation, since satellites typically carry soft-delete and change-tracking attributes.

Key Information Stored

The table is documented with 19 columns in the ETRM 12.1.1 physical schema. The most significant are:

• SUA_ASS_ITEM_GROUP_ID — the surrogate primary key, enforced by the IGS_AS_SUA_AI_GROUP_PK unique index. This is the column referenced by downstream child tables and the identifier most often searched as sua_ass_item_group_id.
• PERSON_ID, COURSE_CD, UOO_ID, GROUP_NAME — the business-key candidate columns, enforced together by the unique index IGS_AS_SUA_AI_GROUP_U1. Together they identify a group by student, course, unit offering option, and group name.
• UNIT_ASS_ITEM_GROUP_ID — the foreign key to IGS_AS_UNIT_AI_GRP, linking the student-level group to the unit-level assessment item group definition.
• US_ASS_ITEM_GROUP_ID — the foreign key to IGS_AS_US_AI_GROUP, tying the record to the unit-set assessment item group from which it derives.
• MIDTERM_FORMULA_CODE, MIDTERM_FORMULA_QTY, MIDTERM_WEIGHT_QTY — the formula and weighting attributes applied to the midterm component of the group.
• FINAL_FORMULA_CODE, FINAL_FORMULA_QTY, FINAL_WEIGHT_QTY — the corresponding formula and weighting attributes for the final component.
• LOGICAL_DELETE_DATE — supports soft deletion, allowing rows to be logically retired while preserving history.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard EBS audit trail columns.

Common Use Cases and Queries

Typical use cases include assessment result reporting, weighting audits, and reconciliation between institution-level assessment definitions and student-level applied groups. A common query joins the business key of the parent unit attempt to the group rows:

• Retrieve all assessment item groups for a student attempt: SELECT sua_ass_item_group_id, person_id, course_cd, uoo_id, group_name FROM igs.igs_as_sua_ai_group WHERE person_id = :person_id AND course_cd = :course_cd AND logical_delete_date IS NULL;
• Resolve a group to its unit-level definition: join UNIT_ASS_ITEM_GROUP_ID to IGS_AS_UNIT_AI_GRP.
• Find all assessment items belonging to a group: query IGS_AS_SU_ATMPT_ITM by SUA_ASS_ITEM_GROUP_ID.
• Audit weighting configuration by inspecting MIDTERM_WEIGHT_QTY, FINAL_WEIGHT_QTY and their associated formula codes.

Related Objects

The table participates in several documented foreign key relationships:

• IGS_EN_SU_ATTEMPT_ALL — referenced via PERSON_ID, COURSE_CD, and UOO_ID; the parent student unit attempt.
• IGS_AS_UNIT_AI_GRP — referenced via UNIT_ASS_ITEM_GROUP_ID.
• IGS_AS_US_AI_GROUP — referenced via US_ASS_ITEM_GROUP_ID.
• IGS_AS_SUAAI_OUHIST — references this table via SUA_ASS_ITEM_GROUP_ID, holding organizational unit history.
• IGS_AS_SU_ATMPT_ITM — references this table via SUA_ASS_ITEM_GROUP_ID, storing the individual assessment attempt items.

Together these objects constitute the assessment grouping layer of the Student System, with IGS_AS_SUA_AI_GROUP acting as the student-attempt satellite bridging institutional assessment definitions and recorded student assessment items.