Search Results ass_id




Overview
Explore in AI Chat

Overview

The IGS_AS_UNT_PATRN_ITM table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Student Management (OSM) product, as indicated by the IGS schema. This table functions as a transactional junction table that maps individual assessment items (ASS_ID) to defined assessment patterns (ASS_PATTERN_ID) for specific unit offerings. Its primary role is to manage the composition of assessment patterns, which are templates or groupings of assessments (e.g., exams, assignments) required for a unit version within a particular academic calendar instance. The table's status is marked as "Obsolete" in the provided metadata, indicating it may be part of a legacy data model that has been superseded in later application versions, though it remains valid and in use within the specified EBS releases.

Key Information Stored

The table stores relational and transactional data linking assessments to patterns. Key columns include identifiers for the academic unit (UNIT_CD, VERSION_NUMBER), the calendar instance (CAL_TYPE, CI_SEQUENCE_NUMBER), and the core assessment entities (ASS_PATTERN_ID, ASS_ID). The UAI_SEQUENCE_NUMBER likely defines the order or sequence of the assessment item within the pattern. A critical functional column is APPORTIONMENT_PERCENTAGE, which dictates the weight or contribution of that specific assessment item towards the total grade for the unit pattern. Standard EBS audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, etc.) are also present to track data changes. All columns are annotated as obsolete, aligning with the table's overall status.

Common Use Cases and Queries

This table is central to queries involving the structure and weighting of assessments for academic units. A primary use case is generating reports or building logic to understand the complete assessment profile for a unit offering. For instance, an administrator might need to list all assessment items and their respective weights for a specific unit pattern. Given the user's search for "ass_id", a common query would involve joining this table to assessment master data to retrieve details for a specific assessment item across all patterns it belongs to.

  • Sample Query: Retrieve Assessment Pattern Details for a Unit:
    SELECT unit_cd, version_number, ass_pattern_id, ass_id, uai_sequence_number, apportionment_percentage
    FROM igs.igs_as_unt_patrn_itm
    WHERE unit_cd = 'MATH101'
    AND cal_type = 'SEMESTER'
    AND ci_sequence_number = 1
    ORDER BY ass_pattern_id, uai_sequence_number;
  • Sample Query: Find All Patterns Containing a Specific Assessment (ass_id):
    SELECT DISTINCT ass_pattern_id, unit_cd, version_number
    FROM igs.igs_as_unt_patrn_itm
    WHERE ass_id = <specific_assessment_id>;

Related Objects

As per the dependency information, the IGS_AS_UNT_PATRN_ITM table does not reference other objects but is itself referenced by an object within the APPS schema named IGS_AS_UNT_PATRN_ITM. This is most likely a public synonym or a view that provides an APPS-schema access point to the underlying IGS table, a standard EBS architecture practice for encapsulation. The table's indexes, IGS_AS_UNT_PATRN_ITM_U1 (unique) and IGS_AS_UNT_PATRN_ITM_N1 (non-unique), are built on the key identifier columns to enforce data integrity and optimize query performance, particularly for lookups involving the unit/calendar context and the ASS_ID.