Results for “igs_as_us_ai_group_pk”

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

Overview

The IGS_AS_US_AI_GROUP table belongs to the Oracle EBS IGS — Student System product family, which Oracle has designated as obsolete in releases 12.1.1 and 12.2.2. The object is documented as the Unit Section Assessment Item Group, meaning it serves as the grouping construct that binds individual assessment items (such as midterm and final exam components) to a specific unit offering option within the academic structure. In the legacy Oracle Student System data model, assessment item groups provided the bridge between enrollment-bearing unit offerings and the graded coursework items that roll up into a student's final result.

The table is not implemented in the current database according to the ETRM documentation, which is consistent with its obsolete status. Its schema and relationships are nevertheless retained for reference, migration, and historical reporting purposes. From a Data Vault modeling perspective, the heuristic classification for this object is hub-leaning. This suggests the table can be treated as a durable business key registry for assessment item groups, keyed on the surrogate identifier US_ASS_ITEM_GROUP_ID and qualified by the natural business key (UOO_ID, GROUP_NAME).

Key Information Stored

The documented physical schema contains fourteen columns. The most significant among them are:

• US_ASS_ITEM_GROUP_ID — the surrogate primary key, enforced by IGS_AS_US_AI_GROUP_PK. It uniquely identifies each assessment item group and is the foreign key target from child tables.
• UOO_ID — foreign key to IGS_PS_UNIT_OFR_OPT_ALL, anchoring the group to a unit offering option.
• GROUP_NAME — the descriptive business identifier for the group, and together with UOO_ID forms the unique business key IGS_AS_US_AI_GROUP_U1.
• MIDTERM_FORMULA_CODE and MIDTERM_FORMULA_QTY — the rule code and quantity governing how midterm items are aggregated.
• MIDTERM_WEIGHT_QTY — the weighting applied to the midterm component in the overall assessment.
• FINAL_FORMULA_CODE and FINAL_FORMULA_QTY — the equivalent rule code and quantity for final assessment items.
• FINAL_WEIGHT_QTY — the weighting applied to the final component.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard EBS audit columns recording who created and last modified each row and when.

The midterm and final formula/weight columns collectively define the calculation policy for a group, making this table the configuration record for how a unit offering's assessment items are combined and weighted.

Common Use Cases and Queries

Typical reporting scenarios include retrieving all assessment groups for a given unit offering option and inspecting their exam weighting configuration. A representative query joins the group to its parent offering option:

• SELECT g.US_ASS_ITEM_GROUP_ID, g.GROUP_NAME, g.MIDTERM_WEIGHT_QTY, g.FINAL_WEIGHT_QTY FROM IGS_AS_US_AI_GROUP g WHERE g.UOO_ID = :uooid;
• Drilling into the item-level detail via IGS_PS_UNITASS_ITEM using US_ASS_ITEM_GROUP_ID.
• Validating weight totals against expected assessment policy for institutional audits.
• Extracting data as part of a migration or archive effort, given the object's obsolete status.

Related Objects

The following objects are most significant in the reference and dependency network:

• IGS_PS_UNIT_OFR_OPT_ALL — parent of this table via UOO_ID, supplying the unit offering option context.
• IGS_AS_SUA_AI_GROUP — child table referencing US_ASS_ITEM_GROUP_ID.
• IGS_PS_UNITASS_ITEM — child table referencing US_ASS_ITEM_GROUP_ID, holding the individual assessment items assigned to each group.