Search Results api_uk

Overview

The table IGS_AS_UNTAS_PATTERN_ALL is a core data object within the Oracle E-Business Suite's Student System (IGS) module. It is designated as obsolete in the provided ETRM documentation for versions 12.1.1 and 12.2.2, indicating its structure and data are maintained for backward compatibility but its active use in new development is deprecated. Historically, this table served as a master repository for defining assessment patterns linked to specific unit offerings. An assessment pattern dictates the schedule, types, and weightings of evaluations (e.g., exams, assignments) for a unit within a particular academic calendar instance. Its primary role was to establish a reusable template for assessment requirements, which could then be applied to individual student attempts.

Key Information Stored

The table's structure centers on uniquely identifying a unit offering and its associated assessment template. The primary key (IGS_AS_UNTAS_PATTERN_PK) is a composite key consisting of UNIT_CD, VERSION_NUMBER, CAL_TYPE, CI_SEQUENCE_NUMBER, and ASS_PATTERN_ID. This combination ensures a unique pattern for a specific unit version within a defined teaching calendar. The ASS_PATTERN_ID column is also defined as a unique key (API_UK) on its own, serving as a system-generated surrogate identifier for the pattern record. Other notable columns inferred from the foreign key relationships include LOCATION_CD, which would specify the campus or delivery location for the unit offering. The table's design supports the multi-org architecture of Oracle EBS, as indicated by the "_ALL" suffix.

Common Use Cases and Queries

While obsolete, typical historical use cases involved querying the defined assessment patterns for academic planning, auditing, and reporting. Common queries would retrieve patterns for a given unit or validate assessment structures. For instance, to list all assessment patterns for a specific unit code and version, a query might be: SELECT ass_pattern_id, cal_type, location_cd FROM igs_as_untas_pattern_all WHERE unit_cd = :p_unit_cd AND version_number = :p_ver_num;. Another critical use was to identify which student attempt records were based on a particular pattern, which involves joining to the related IGS_AS_SU_ATMPT_ITM and IGS_AS_SU_ATMPT_PAT tables via the ASS_PATTERN_ID.

Related Objects

The ETRM metadata clearly defines this table's integration within the Student System schema through primary and foreign key relationships. The table is referenced by two key transactional tables, linking the master pattern to individual student records:

• IGS_AS_SU_ATMPT_ITM: References IGS_AS_UNTAS_PATTERN_ALL via the column ASS_PATTERN_ID. This table typically stores details of individual assessment items for a student's unit attempt.
• IGS_AS_SU_ATMPT_PAT: References IGS_AS_UNTAS_PATTERN_ALL via the column ASS_PATTERN_ID. This table likely holds the overall assessment pattern applied to a specific student's unit attempt.

Additionally, the table has self-referencing foreign keys (likely for hierarchical data or default patterns) on columns UNIT_CD, VERSION_NUMBER, CAL_TYPE, CI_SEQUENCE_NUMBER, and LOCATION_CD, indicating it may reference other records within the same table to establish relationships or inheritance between patterns.