Search Results igs_as_unit_ai_grp_pk

Overview

IGS_AS_UNIT_AI_GRP (Unit Assessment Item Group) is a configuration table within the Oracle E-Business Suite IGS — Student System product family, historically associated with the Oracle Student System (OSS) academic assessment module. Its documented role is to define assessment item groups at the unit level, providing the grouping construct into which individual assessment items and their weighting or formula rules are assembled for grading purposes. In the ETRM 12.1.1 physical schema the table is owned by the IGS schema and contains seventeen columns, organized around a surrogate identifier and a composite business key.

Oracle classifies this product as obsolete in the current EBS release line, and the ETRM metadata explicitly notes that the object is "Not implemented in this database." Practitioners should therefore treat IGS_AS_UNIT_AI_GRP as a legacy or reference-only artifact on 12.1.1 and 12.2.2, and should not expect runtime dependencies unless the Oracle Student System was separately licensed and installed.

Using a heuristic Data Vault classification derived from its foreign-key structure, this object is best modeled as hub-leaning: it carries a stable surrogate key (UNIT_ASS_ITEM_GROUP_ID) referenced by multiple downstream tables, with descriptive attributes (GROUP_NAME, formula codes, weight quantities) behaving as satellite-style payload on that hub. This is a modeling suggestion rather than a documented Oracle classification.

Key Information Stored

The surrogate primary key is UNIT_ASS_ITEM_GROUP_ID, enforced by the index IGS_AS_UNIT_AI_GRP_PK. All foreign-key relationships from dependent tables point to this column, making it the durable integration key for the entity.

A second unique index, IGS_AS_UNIT_AI_GRP_U1, defines the natural or business key: the composite of UNIT_CD (unit code), VERSION_NUMBER, CAL_TYPE (calendar type), CI_SEQUENCE_NUMBER (calendar instance sequence), and GROUP_NAME (the group name). Together these columns identify a specific assessment item group for a given unit offering in a given academic calendar instance.

The remaining documented columns are assessment rule attributes. MIDTERM_FORMULA_CODE, MIDTERM_FORMULA_QTY, and MIDTERM_WEIGHT_QTY describe the formula and weighting applied to midterm items within the group; FINAL_FORMULA_CODE, FINAL_FORMULA_QTY, and FINAL_WEIGHT_QTY perform the equivalent role for final assessment items. Standard EBS audit columns complete the structure: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical usage centers on reporting and data migration rather than transactional processing. A recurring query pattern joins the group header to its member assessment items through the shared group identifier:

• Assessment structure reporting: retrieve GROUP_NAME and weighting attributes for a given UNIT_CD and VERSION_NUMBER to document how a unit's marks are composed.
• Formula auditing: select MIDTERM_FORMULA_CODE and FINAL_FORMULA_CODE to verify that weighting rules are consistent across versions of a unit.
• Migration and reconciliation: use the composite business key (UNIT_CD, VERSION_NUMBER, CAL_TYPE, CI_SEQUENCE_NUMBER, GROUP_NAME) to match legacy OSS extracts against EBS staging tables.
• Referential integrity checks: count child rows in IGS_AS_SUA_AI_GROUP and IGS_AS_UNITASS_ITEM_ALL grouped by UNIT_ASS_ITEM_GROUP_ID to identify orphaned or unused group definitions.

A representative pattern is SELECT g.GROUP_NAME, g.MIDTERM_WEIGHT_QTY, g.FINAL_WEIGHT_QTY FROM IGS_AS_UNIT_AI_GRP g WHERE g.UNIT_CD = :unit_cd AND g.VERSION_NUMBER = :version.

Related Objects

Two foreign keys are documented, both referencing IGS_AS_UNIT_AI_GRP.UNIT_ASS_ITEM_GROUP_ID from the child table:

• IGS_AS_SUA_AI_GROUP.UNIT_ASS_ITEM_GROUP_ID → IGS_AS_UNIT_AI_GRP — a child grouping association linking assessment groups to unit attempts.
• IGS_AS_UNITASS_ITEM_ALL.UNIT_ASS_ITEM_GROUP_ID → IGS_AS_UNIT_AI_GRP — the item-level detail table holding individual assessment items belonging to the group.

These two objects constitute the principal dependents of the group header. Reporting or extracting the complete assessment item group structure therefore requires joining IGS_AS_UNIT_AI_GRP to IGS_AS_UNITASS_ITEM_ALL on UNIT_ASS_ITEM_GROUP_ID, and optionally to IGS_AS_SUA_AI_GROUP for student unit attempt context. Because the object is obsolete and unimplemented in current databases, no supported public APIs are documented against it.