Search Results midterm_formula_quantity




Overview
Explore in AI Chat

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

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.