Search Results igs_as_unitass_item_all




Overview
Explore in AI Chat

Overview

The IGS_AS_UNITASS_ITEM_ALL table is a core data object within the Oracle E-Business Suite Student System (IGS) module, specifically for releases 12.1.1 and 12.2.2. It serves as the central repository for defining and managing assessment items that are allocated to a specific unit version offered within a particular teaching calendar instance. This table is fundamental to the academic assessment framework, enabling the configuration of exams, assignments, and other evaluative components for a course offering. Its design supports a multi-org structure, as indicated by the '_ALL' suffix, allowing data to be partitioned by operating unit. The table's primary role is to establish the link between a unit offering pattern, the assessment definition, and the logistical or grading rules applied to that assessment item.

Key Information Stored

The table stores metadata that defines an assessment item's context, configuration, and administration. Key columns include the surrogate primary key, UNIT_ASS_ITEM_ID, and the unique key combination that defines the item's business context: UNIT_CD, VERSION_NUMBER, CAL_TYPE, CI_SEQUENCE_NUMBER, ASS_ID, and SEQUENCE_NUMBER. This composite key ties the assessment item to a precise unit version and teaching calendar. Other significant columns govern the item's behavior and administration: GRADING_SCHEMA_CD and GS_VERSION_NUMBER link to the applicable grading scheme; EXAM_CAL_TYPE and EXAM_CI_SEQUENCE_NUMBER optionally link to a separate calendar for scheduling exams; LOCATION_CD specifies the assessment venue; and UNIT_ASS_ITEM_GROUP_ID associates the item with a logical grouping of assessments. The table also typically includes descriptive fields, weightings, duration, and status controls.

Common Use Cases and Queries

This table is central to numerous academic processes. Common use cases include generating examination timetables by joining to calendar instance tables, calculating final grades by aggregating weighted assessment items, and producing assessment schedules for students and faculty. A typical reporting query might retrieve all assessment items for a unit offering to validate configuration.

  • Listing Assessments for a Unit Offering: SELECT ass_id, sequence_number, grading_schema_cd FROM igs_as_unitass_item_all WHERE unit_cd = 'MATH101' AND cal_type = 'SEM1' AND ci_sequence_number = 202301;
  • Identifying Exam Assessments: Queries often join to IGS_CA_INST_ALL via EXAM_CAL_TYPE and EXAM_CI_SEQUENCE_NUMBER to fetch exam dates and details.
  • Data Validation: Checking for assessment items missing required grading schemas or linked to invalid unit offering patterns is a critical administrative task.

Related Objects

The IGS_AS_UNITASS_ITEM_ALL table maintains integral relationships with several other key tables in the Student System, as documented by its foreign key constraints.

  • IGS_PS_UNIT_OFR_PAT_ALL: Defines the parent unit offering pattern. Joined via UNIT_CD, VERSION_NUMBER, CAL_TYPE, and CI_SEQUENCE_NUMBER.
  • IGS_AS_UNIT_AI_GRP: Links to an assessment item grouping via UNIT_ASS_ITEM_GROUP_ID.
  • IGS_AS_GRD_SCHEMA: References the grading schema applied to this item via GRADING_SCHEMA_CD and GS_VERSION_NUMBER.
  • IGS_AD_LOCATION_ALL: Specifies the assessment location via LOCATION_CD.
  • IGS_CA_INST_ALL: Optionally links to a separate calendar instance for exam scheduling via EXAM_CAL_TYPE and EXAM_CI_SEQUENCE_NUMBER.
  • IGS_AS_UNT_PATRN_ITM: Serves as a child table, where specific pattern item details (like due dates for different attendance modes) are stored, linked via the unit offering and assessment key columns.