Results for “unit_assessment_item_group_id”

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

Overview

The view IGSBV_AS_UNIT_ASS_ITEM_GROUPS is a read-only database object owned by the APPS schema within the Oracle E-Business Suite Student System (IGS) product family. It presents unit assessment item group definitions, which are the configuration records that govern how assessment components contribute to a student's final unit result. In ETRM 12.1.1 and 12.2.2 this object is documented as "Unit Assessment Item Group" and carries VALID status, indicating that it is a supported dictionary object available for reporting and integration.

The view primarily serves reporting and integration purposes. Institutions use it to expose weighting configuration for midterm and final assessment formulae without requiring consumers to understand the underlying normalization of the base configuration table. It is commonly joined to assessment item, assessment result, and student unit attempt views to reconstruct grading schemes.

Underlying Base Objects

The view is defined over a single base table, IGS_AS_UNIT_AI_GRP, aliased as UAIG, in the APPS schema. The view text applies a WITH READ ONLY clause, so no DML may be issued against it. The ETRM metadata records that no additional referenced base objects are documented, and the view performs no joins, unions, or aggregation; each row of the view corresponds one-to-one with a row in the underlying table. The name prefix "BV" indicates a business view intended for external consumption, and the projection effectively renames the base table columns to the more readable forms listed below.

Key Columns

• UNIT_ASSESSMENT_ITEM_GROUP_ID — surrogate primary key from UAIG.UNIT_ASS_ITEM_GROUP_ID, used to join to child assessment item records.
• UNIT_ASS_ITEM_GROUP_NAME — the descriptive group name (UAIG.GROUP_NAME), such as a named grading scheme for a teaching period.
• UNIT_CODE, UNIT_VERSION_NUMBER, CALENDAR_TYPE, CALENDAR_INST_SEQUENCE_NUMBER — the academic context identifying the unit offering to which the item group applies.
• MIDTERM_FORMULA_QUANTITY and FINAL_FORMULA_QUANTITY — the formula option quantities for the midterm and final components, taken from UAIG.MIDTERM_FORMULA_QTY and UAIG.FINAL_FORMULA_QTY.
• MIDTERM_WEIGHT_QUANTITY and FINAL_WEIGHT_QUANTITY — the weighting quantities applied to the midterm and final components. These are the columns most commonly referenced when users search on final_weight_quantity.
• "_LA:MIDTERM_FORMULA_CODE" and "_LA:FINAL_FORMULA_CODE" — pseudo-columns generated via the descriptive flexfield lookup convention, resolving formula codes against IGS_LOOKUP_VALUES with lookup type IGS_AS_AI_FORMULA_OPTIONS and returning the MEANING attribute. These expose the human-readable formula description rather than the code.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard WHO audit columns.

Common Use Cases and Queries

Typical uses include audit reporting on grading weightings, validating that final and midterm weights sum correctly, and extracting configuration for migration or integration into external student record systems.

A representative query listing all valid item group weightings for a given unit:

• SELECT unit_ass_item_group_name, unit_code, version_number, midterm_weight_quantity, final_weight_quantity FROM igsbv_as_unit_ass_item_groups WHERE unit_code = :unit_code AND calendar_type = :cal_type;

To locate rows where the final weighting is populated, directly addressing the searched term:

• SELECT unit_ass_item_group_name, final_weight_quantity, "_LA:FINAL_FORMULA_CODE" FROM igsbv_as_unit_ass_item_groups WHERE final_weight_quantity IS NOT NULL;

Because the view is a thin projection of IGS_AS_UNIT_AI_GRP, joins to assessment item tables should use UNIT_ASSESSMENT_ITEM_GROUP_ID as the foreign key, and to the unit attempt using UNIT_CODE, VERSION_NUMBER, and CALENDAR_INST_SEQUENCE_NUMBER. Consumers should note that the view is read-only and that the "_LA" columns depend on lookup configuration being present in IGS_LOOKUP_VALUES.