Search Results final_formula_code

Overview

The IGS.IGS_AS_US_AI_GROUP table is a core configuration object within the Oracle E-Business Suite Student Systems (IGS) module. It defines assessment item groups for unit sections, allowing academic institutions to organize assessment items such as quizzes, homework, and exams into logical groupings that carry a defined weight toward a student's final unit grade. Each group is associated with a unit section offering option and carries grading-period-specific formula definitions for both midterm and final grading periods. This enables flexible academic grading rules, including weighted averages, "Best N" and "At least N" derivations.

Based on the heuristic Data Vault classification mined from the foreign key structure, this table is hub-leaning. In Data Vault modeling terms, it behaves primarily as a hub, since it holds the durable business key (US_ASS_ITEM_GROUP_ID) and descriptive attributes that identify and qualify an assessment item group, with foreign keys radiating outward rather than serving as a transactional link. Analysts building a Data Vault layer might model US_ASS_ITEM_GROUP_ID as a hub key, with UOO_ID acting as a link to the unit section offering option.

Key Information Stored

The table carries fourteen documented columns. The most significant include:

• US_ASS_ITEM_GROUP_ID — Surrogate primary key (NUMBER(15)); system-generated identifier uniquely identifying a group of unit section assessment items.
• UOO_ID — Unique identifier for the unit section; foreign key to IGS_PS_UNIT_OFR_OPT_ALL.
• GROUP_NAME — VARCHAR2(30) describing the group, such as "Quizzes" or "Homework".
• MIDTERM_FORMULA_CODE — VARCHAR2(30) formula derivation for the Midterm grading period (Weighted Average, Best N, At least N, or Null).
• MIDTERM_FORMULA_QTY — Number of assessment items used when the midterm formula is Best N or At least N.
• MIDTERM_WEIGHT_QTY — Relative weight of the group for the Midterm grading period.
• FINAL_FORMULA_CODE — VARCHAR2(30) formula derivation for the Final grading period; this is the column most frequently searched by users.
• FINAL_FORMULA_QTY — Corresponding quantity for the final formula.
• FINAL_WEIGHT_QTY — Relative weight of the group for the Final grading period.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATED_DATE, LAST_UPDATE_LOGIN — Standard EBS who-columns for audit and concurrency tracking.

Two indexes are documented. The unique index IGS_AS_US_AI_GROUP_U1 on (UOO_ID, GROUP_NAME) is the business-key candidate that enforces a group name is unique within a unit section. The primary key index IGS_AS_US_AI_GROUP_PK is a non-unique NORMAL index on US_ASS_ITEM_GROUP_ID, which is atypical but documented.

Common Use Cases and Queries

This table is queried primarily for grading configuration reporting and validation. Common scenarios include listing all assessment groups for a given unit section offering, verifying formula assignment for the final grading period, and reconciling group weights across grading periods.

A representative query for locating groups by the searched column:

• SELECT us_ass_item_group_id, group_name, final_formula_code, final_formula_qty, final_weight_qty FROM igs.igs_as_us_ai_group WHERE final_formula_code IS NOT NULL;
• SELECT g.group_name, g.final_formula_code, g.final_weight_qty FROM igs.igs_as_us_ai_group g, igs.igs_ps_unit_ofr_opt_all o WHERE g.uoO_id = o.unit_ofr_opt_id AND g.uoO_id = :uoO_id;

Reporting use cases include generating grade-weight summaries per unit section, auditing groups that use "Best N" or "At least N" formulas, and validating that group weights across a unit section sum appropriately. Because the object is described as a supplementary view used to simplify forms coding, Oracle recommends not querying it directly for transactional updates.

Related Objects

The table participates in several key relationships:

• IGS_PS_UNIT_OFR_OPT_ALL — Referenced via UOO_ID; the parent unit section offering option.
• IGS_AS_SUA_AI_GROUP — References this table through US_ASS_ITEM_GROUP_ID; links student unit attempt assessment items to groups.
• IGS_PS_UNITASS_ITEM — References this table through US_ASS_ITEM_GROUP_ID; the individual assessment items belonging to the group.
• IGS_AS_US_AI_GROUP_U1 and IGS_AS_US_AI_GROUP_PK — Indexes supporting lookup and uniqueness enforcement.

Together these objects form the assessment grouping and grading derivation framework within Oracle Student Systems, with FINAL_FORMULA_CODE serving as the pivotal attribute for final grading period calculations.