Search Results igs_ps_unitass_item




Overview
Explore in AI Chat

Overview

The IGS_PS_UNITASS_ITEM table is a core data object within the Oracle E-Business Suite Student System (IGS) for releases 12.1.1 and 12.2.2. It functions as the master table for storing detailed definitions of individual assessment items associated with a specific unit section offering. This entity is fundamental to the academic assessment framework, enabling the configuration, tracking, and grading of various evaluative components—such as exams, assignments, or projects—that collectively determine a student's final result in a unit section. Its role is to establish the formal assessment structure for a course offering, linking assessment criteria to the administrative unit section record.

Key Information Stored

The table's primary identifier is the UNIT_SECTION_ASS_ITEM_ID, a system-generated unique key. The central relational column is UOO_ID, which ties each assessment item to its parent unit section offering in the IGS_PS_UNIT_OFR_OPT_ALL table. Critical assessment definition columns include GRADING_SCHEMA_CD and GS_VERSION_NUMBER, which together reference the specific grading schema and its version from the IGS_AS_GRD_SCHEMA table used to evaluate the item. The US_ASS_ITEM_GROUP_ID column optionally links an assessment item to a logical grouping defined in the IGS_AS_US_AI_GROUP table. Additional columns typically store metadata such as the assessment item name, description, weighting, due date, and active status, forming a complete assessment profile.

Common Use Cases and Queries

Primary use cases involve the setup and reporting of academic assessments. Administrators use this table to define the assessment regime for a unit section. Common reporting requirements include generating a summary of all assessment items for a given unit offering, calculating cumulative assessment weights, and listing items that use a specific grading schema. A typical query retrieves assessment details for a section:

  • SELECT unit_section_ass_item_id, assessment_item_name, weighting FROM igs_ps_unitass_item WHERE uoo_id = :p_uoo_id ORDER BY due_date;

Another frequent pattern joins to the grading schema table to validate or report on assessment grading rules, ensuring data integrity during grade entry and final result calculation processes.

Related Objects

The IGS_PS_UNITASS_ITEM table maintains defined foreign key relationships with several key entities in the Student System, as documented in the ETRM metadata:

  • IGS_PS_UNIT_OFR_OPT_ALL: The foundational relationship via the UOO_ID column, linking each assessment item to its specific unit offering option (section).
  • IGS_AS_GRD_SCHEMA: A composite foreign key relationship using the columns GRADING_SCHEMA_CD and GS_VERSION_NUMBER, which defines the grading scale applicable to the assessment item.
  • IGS_AS_US_AI_GROUP: A relationship via the US_ASS_ITEM_GROUP_ID column, allowing assessment items to be categorized into logical groups for administrative or marking purposes.

These relationships ensure referential integrity and facilitate complex joins for comprehensive academic reporting and transactional processing within the module.