Search Results igs_as_unt_patrn_itm

Overview

The table IGS_AS_UNT_PATRN_ITM is a historical data object from the Oracle E-Business Suite Student System (IGS) module. As explicitly noted in the official ETRM documentation, this table is marked as "Obsolete" and was "Not implemented in this database" for the referenced Oracle EBS releases 12.1.1 and 12.2.2. Its intended functional role was to manage the relationship between unit assessment patterns and specific assessment items. The table served as a junction entity, linking a defined assessment pattern for a unit offering to the individual assessment components (items) that comprised it, thereby defining the structure of assessment for a unit in a given academic period.

Key Information Stored

The table's composite primary key defines the precise context and identity of a linked assessment item within a pattern. The key columns are UNIT_CD, VERSION_NUMBER, CAL_TYPE, and CI_SEQUENCE_NUMBER, which together identify a specific unit offering. The ASS_PATTERN_ID identifies the assessment pattern applied. The ASS_ID and UAI_SEQUENCE_NUMBER are the critical columns for identifying the specific assessment item. The UAI_SEQUENCE_NUMBER, which was the user's search term, is a numeric identifier that denotes the order or sequence of an assessment item within the broader context of a unit assessment. This sequence was crucial for structuring the assessment timeline and reporting.

Common Use Cases and Queries

Given the table's obsolete status, direct operational use in Oracle EBS 12.1.1/12.2.2 is non-existent. Historically, its use cases would have involved configuring and reporting on unit assessment structures. Analytical queries would have joined this table to unit and assessment master tables to list all assessment items for a unit's pattern or to validate assessment configuration. A typical historical query pattern might have been:

• SELECT * FROM IGS_AS_UNT_PATRN_ITM WHERE unit_cd = :p_unit_cd AND cal_type = :p_cal_type AND ass_pattern_id = :p_pattern_id ORDER BY uai_sequence_number;

This would retrieve all assessment items in their defined sequence for a specific unit and pattern. For reporting, it would have been a central table for generating assessment schedules or workload summaries per unit offering.

Related Objects

Based on the provided foreign key metadata, the primary related object is the table IGS_AS_UNITASS_ITEM_ALL. The foreign key relationship indicates that IGS_AS_UNT_PATRN_ITM referenced this table to validate and retrieve details about the specific assessment item (ASS_ID). The join was performed using a combination of columns: UNIT_CD, VERSION_NUMBER, CAL_TYPE, CI_SEQUENCE_NUMBER, ASS_ID, and UAI_SEQUENCE_NUMBER. This relationship was fundamental, ensuring that any assessment item linked to a pattern was a valid, existing assessment item defined for that unit offering. No other foreign key relationships are documented in the provided metadata.