Search Results midterm_formula_qty

Overview

The IGS.IGS_AS_UNIT_AI_GRP table is a Student Systems foundation table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments. It is owned by the IGS schema and stores the definition of Unit Assessment Item Groups. In the context of academic assessment, a Unit Assessment Item Group is a logical collection of assessment items that carry a specific weight toward a student's final unit grade. This table enables institutions to define grouping rules such as "Best 3" or "At least 2" for assessment items within the group, and to apply derivation formulas that calculate a student's outcome marks for a given grading period.

From a data modeling perspective, the heuristic Data Vault classification for this object is hub-leaning. This classification represents a modeling suggestion rather than a mandatory construct: the table functions as a central list of unique business entities (Unit Assessment Item Groups) identified by a surrogate key, with a natural business key defined by a unique index. Association tables referencing it via foreign keys behave like link tables in a Data Vault context.

Key Information Stored

The table contains 17 documented columns. The most significant are:

• UNIT_ASS_ITEM_GROUP_ID — System-generated numeric surrogate primary key (NUMBER(15)) that uniquely identifies the group of unit assessment items.
• UNIT_CD — VARCHAR2(10) institution-defined unique identifier of the unit of study.
• VERSION_NUMBER — Version of the unit to which the group is linked. Students are normally enrolled in the current version.
• CAL_TYPE — Calendar type of the unit offering (e.g., ACAD-YR) to which the group applies.
• CI_SEQUENCE_NUMBER — Calendar instance sequence number, uniquely identifying the calendar instance.
• GROUP_NAME — VARCHAR2(30) descriptive name of the group (e.g., Quizzes, Homework).
• MIDTERM_FORMULA_CODE — VARCHAR2(30) definition of the derivation formula applied to the Midterm grading period: Weighted Average, Best N, At least N, or Null.
• MIDTERM_FORMULA_QTY — Numeric quantity used by the Midterm formula (e.g., N in "Best N").
• MIDTERM_WEIGHT_QTY — Numeric weight assigned to the Midterm group in the overall grade calculation.
• FINAL_FORMULA_CODE, FINAL_FORMULA_QTY, FINAL_WEIGHT_QTY — Equivalent formula, quantity, and weight values for the Final grading period.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Oracle EBS auditing columns.

Two unique indexes exist: IGS_AS_UNIT_AI_GRP_PK on UNIT_ASS_ITEM_GROUP_ID (surrogate key), and IGS_AS_UNIT_AI_GRP_U1 on UNIT_CD, VERSION_NUMBER, CAL_TYPE, CI_SEQUENCE_NUMBER, GROUP_NAME (the business key candidate).

Common Use Cases and Queries

Typical scenarios include retrieving the formula configuration for a specific unit offering or reporting on weighting rules used across a calendar instance.

• Identify the midterm formula for a group: SELECT GROUP_NAME, MIDTERM_FORMULA_CODE, MIDTERM_FORMULA_QTY FROM IGS.IGS_AS_UNIT_AI_GRP WHERE UNIT_CD = :p_unit AND CAL_TYPE = :p_cal_type;
• List all groups using a weighted-average midterm formula: SELECT * FROM IGS.IGS_AS_UNIT_AI_GRP WHERE MIDTERM_FORMULA_CODE = 'WEIGHTED';
• Report assessment weightings by unit and version to validate grade configuration.
• Join to assessment item associations to compute derived outcome marks.

Related Objects

The following objects reference or depend on this table through foreign-key relationships:

• IGS_AS_SUA_AI_GROUP — References UNIT_ASS_ITEM_GROUP_ID; links student unit attempts to assessment item groups.
• IGS_AS_UNITASS_ITEM_ALL — References UNIT_ASS_ITEM_GROUP_ID; stores the actual assessment items belonging to each group.
• IGS_AS_UNIT_AI_GRP_PK and IGS_AS_UNIT_AI_GRP_U1 — Unique indexes enforcing primary and business key integrity.
• Assessment and grading APIs that consume UNIT_ASS_ITEM_GROUP_ID when computing unit attempt outcomes.

Queries should join through UNIT_ASS_ITEM_GROUP_ID, as it is the stable surrogate key used by all dependent objects regardless of unit versioning changes.