Results for “igs_as_unitass_item_all”

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

Overview

IGS_AS_UNITASS_ITEM_ALL is a Student System table in the Oracle E-Business Suite that describes assessment items allocated to a unit version within a nominated teaching calendar instance. In the assessment lifecycle, it acts as the bridge between a teachable unit offering pattern (a unit version delivered in a particular calendar instance) and the individual assessment items, grading schemes, venues, and weighting rules that apply to that delivery. The table stores one row per allocated assessment item, including scheduling, due dates, mandatory flags, and weight quantities, and it carries the standard EBS WHO columns plus an ORG_ID for multi-org security. The metadata marks the product as obsolete in the ETRM documentation set, and the table is documented as not implemented in the reference database, but its schema remains part of the 12.1.1 physical model and persists in 12.2.2.

From a Data Vault modeling perspective, the metadata's heuristic classification is satellite-leaning. This is a modeling suggestion rather than a statement of design intent: the table depends on business keys drawn from unit offering and assessment item context, and its payload columns (dates, weights, flags, descriptions) read as descriptive attributes surrounding that key rather than as an independent hub of identifiable entities.

Key Information Stored

The surrogate primary key is UNIT_ASS_ITEM_ID, enforced by IGS_AS_UNITASS_ITEM_ALL_PK. The business-key candidate is the composite unique index IGS_AS_UNITASS_ITEM_U1, comprising UNIT_CD, VERSION_NUMBER, CAL_TYPE, CI_SEQUENCE_NUMBER, ASS_ID, and SEQUENCE_NUMBER. Together these identify an assessment item placed against a unit version in a calendar instance, with SEQUENCE_NUMBER ordering multiple allocations of the same item.

• UNIT_CD, VERSION_NUMBER, CAL_TYPE, CI_SEQUENCE_NUMBER — the unit version and teaching calendar instance context.
• ASS_ID — the underlying assessment item referenced from IGS_AS_ASSESSMNT_ITM_ALL.
• SEQUENCE_NUMBER — ordering of the allocation within the unit/calendar combination.
• CI_START_DT, CI_END_DT, DUE_DT, RELEASE_DATE — delivery, due, and release timing for the assessment.
• UNIT_CLASS, UNIT_MODE, LOCATION_CD — teaching and delivery attributes, with LOCATION_CD resolving to IGS_AD_LOCATION_ALL.
• EXAM_CAL_TYPE, EXAM_CI_SEQUENCE_NUMBER — examination calendar instance where the assessment is examined.
• GRADING_SCHEMA_CD, GS_VERSION_NUMBER — the grading schema applied to the item.
• UNIT_ASS_ITEM_GROUP_ID — the assessment group to which the allocation belongs.
• MIDTERM_WEIGHT_QTY, FINAL_WEIGHT_QTY, MIDTERM_MANDATORY_TYPE_CODE, FINAL_MANDATORY_TYPE_CODE — weighting and mandatory rules for midterm and final components.
• DFLT_ITEM_IND, LOGICAL_DELETE_DT, ACTION_DT, DESCRIPTION — default flag, logical deletion, action dating, and free text.

Common Use Cases and Queries

Typical reporting covers assessment schedules and due-date calendars per unit version, weight analysis for midterm and final components, and grading-schema assignment audits. A practical query lists allocated items with their unit and due date:

• SELECT unit_cd, version_number, cal_type, ci_sequence_number, ass_id, due_dt, dflt_item_ind FROM igs_as_unitass_item_all WHERE logical_delete_dt IS NULL;
• Join to IGS_AS_ASSESSMNT_ITM_ALL on ASS_ID to obtain assessment item names and types.
• Join to IGS_AS_GRD_SCHEMA on GRADING_SCHEMA_CD and GS_VERSION_NUMBER to verify grading-schema assignment.
• Aggregate MIDTERM_WEIGHT_QTY and FINAL_WEIGHT_QTY by unit version to confirm weights sum correctly.
• Join to IGS_CA_INST_ALL on EXAM_CAL_TYPE and EXAM_CI_SEQUENCE_NUMBER to reconcile examination timetabling.

Related Objects

The most significant dependencies flow through the documented foreign keys and inbound references:

• IGS_PS_UNIT_OFR_PAT_ALL — referenced via UNIT_CD, VERSION_NUMBER, CAL_TYPE, CI_SEQUENCE_NUMBER for the unit offering pattern.
• IGS_AS_ASSESSMNT_ITM_ALL — referenced via ASS_ID, defining the assessment item itself.
• IGS_AS_GRD_SCHEMA — referenced via GRADING_SCHEMA_CD and GS_VERSION_NUMBER.
• IGS_CA_INST_ALL — referenced via EXAM_CAL_TYPE and EXAM_CI_SEQUENCE_NUMBER.
• IGS_AD_LOCATION_ALL — referenced via LOCATION_CD for delivery venue.
• IGS_AS_UNIT_AI_GRP — referenced via UNIT_ASS_ITEM_GROUP_ID.
• IGS_AS_UNT_PATRN_ITM — references this table through the unit/calendar/assessment key columns.
• IGS_AS_SU_ATMPT_ITM — references this table via UNIT_ASS_ITEM_ID, linking student attempts to allocated items.