Search Results igs_as_assessmnt_itm_all




Overview
Explore in AI Chat

Overview

The IGS_AS_ASSESSMNT_ITM_ALL table is a core data structure within the Oracle E-Business Suite Student System (IGS) for versions 12.1.1 and 12.2.2. It serves as the master definition table for assessment items, which are the discrete units of work or evaluation for which a student's performance is measured and recorded. An assessment item can represent an examination, a coursework assignment, a practical test, or any other evaluative component within an academic course. Its primary role is to establish the fundamental characteristics and administrative rules for each assessable item, providing a central reference point that is linked to student attempts, grading, and exam scheduling throughout the assessment lifecycle.

Key Information Stored

While the provided metadata does not list specific columns, the table's primary key is documented as ASS_ID, a unique identifier for each assessment item record. Based on its description and relational context, the table typically stores descriptive and control attributes for an assessment item. Common columns in such a structure include the item's name, code, and detailed description. It also holds critical configuration data such as the assessment item type, its status, associated grading schema, maximum possible marks or grade, and weighting within a larger assessment model. The 'ALL' suffix indicates the table supports multi-organization architecture, meaning it likely includes an ORG_ID column to partition data by operating unit.

Common Use Cases and Queries

This table is central to queries supporting assessment setup, student result entry, and academic reporting. A common administrative use case is generating a list of all active assessment items for a term or course, which can be achieved by querying this table and joining to related course tables. For student-facing systems, a query might retrieve the details of items for which a specific student is enrolled. During grade processing, the table is referenced to validate grades against the defined grading schema and to calculate weighted scores. A typical reporting pattern involves joining IGS_AS_ASSESSMNT_ITM_ALL to student attempt tables to analyze performance across different assessment types.

  • Sample Query Pattern: SELECT ass_id, item_code, item_name, max_mark FROM igs_as_assessmnt_itm_all WHERE org_id = :p_org_id AND status = 'ACTIVE';

Related Objects

The IGS_AS_ASSESSMNT_ITM_ALL table has a foundational relationship with several key transactional and setup tables in the Student System, as evidenced by its foreign key constraints. The primary key (ASS_ID) is referenced by the IGS_AS_SU_ATMPT_ITM table, which records individual student attempts on these items. It is linked to IGS_AS_EXAM_INSTANCE_ALL for scheduling specific sittings of exam-type items. Setup relationships include IGS_AS_COURSE_TYPE_ALL for course-level assessment rules and IGS_AS_ITEM_ASSESSOR for assigning markers. The connection to IGS_AS_ITM_EXAM_MTRL manages associated examination materials. These relationships underscore its role as the source of truth for assessment item definitions.