Search Results ass_pattern_id




Overview
Explore in AI Chat

Overview

The IGS_AS_UNTAS_PATTERN_ALL 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) or related educational modules under the IGS (iGrants or Institutional Grants) schema. This table functions as a master repository for assessment patterns linked to specific unit offerings. An assessment pattern defines the schedule, type, and configuration of evaluations (e.g., exams, assignments) for a unit version delivered in a particular academic calendar instance. The table's ALL suffix indicates it is a multi-org enabled table, storing data partitioned by the ORG_ID column for multiple operating units. It is important to note that the provided ETRM metadata explicitly marks all columns as "Obsolete," suggesting this table may be part of a legacy or deprecated data model in the referenced EBS versions, though it remains integral for historical data and referential integrity.

Key Information Stored

The table stores the relationship between a unit offering and its defined assessment pattern. Key columns include the composite business key (UNIT_CD, VERSION_NUMBER, CAL_TYPE, CI_SEQUENCE_NUMBER) identifying the specific unit offering, and the ASS_PATTERN_ID, which is the system-generated primary key. The ASS_PATTERN_CD and DESCRIPTION provide the code and name for the assessment pattern. Additional attributes define the context of the pattern, such as LOCATION_CD, UNIT_CLASS, and UNIT_MODE. The DFLT_PATTERN_IND flags a default pattern, while LOGICAL_DELETE_DT and ACTION_DT support lifecycle management. Standard EBS audit columns (CREATED_BY, CREATION_DATE, etc.) and multi-org column (ORG_ID) are also present.

Common Use Cases and Queries

Primary use cases involve retrieving the assessment pattern configured for a unit offering or identifying all unit offerings using a specific pattern. This is essential for generating assessment schedules, validating student assessment attempts, and academic reporting. A common query retrieves the pattern details for a specific unit offering:

  • SELECT ass_pattern_cd, description FROM igs.igs_as_untas_pattern_all WHERE unit_cd = :p_unit_cd AND version_number = :p_ver AND cal_type = :p_cal_type AND ci_sequence_number = :p_ci_seq;

Another frequent pattern is joining to child tables to analyze assessment attempts. Given the obsolete status of columns, queries often involve historical data reconciliation or supporting integrations with downstream systems that have not migrated to a newer data model.

Related Objects

The table sits at the center of several key relationships, primarily via the ASS_PATTERN_ID column. It is referenced by child tables that record student assessment data, enforcing critical business rules.

  • Primary Key: The unique identifier API_UK is defined on the ASS_PATTERN_ID column.
  • Foreign Keys (Referencing this table):
  • Foreign Keys (This table references): The table has foreign key relationships to lookup or validation tables for LOCATION_CD and UNIT_CD, though the specific parent tables are not fully named in the provided metadata.

The unique indexes, particularly IGS_AS_UNTAS_PATTERN_U1 (on the business key) and IGS_AS_UNTAS_PATTERN_U2 (on ASS_PATTERN_ID), are critical for enforcing data integrity and optimizing query performance.