Search Results ass_pattern_cd

Overview

The IGS_AS_UNTAS_PATTERN view is a critical data object within the Oracle E-Business Suite (EBS) Student System (IGS) module, specifically for releases 12.1.1 and 12.2.2. It provides a multi-organization (Multi-Org) enabled perspective on the assessment patterns that constitute the assessment requirements for an academic unit. The view filters the underlying base table data (IGS_AS_UNTAS_PATTERN_ALL) based on the current operating unit context derived from the user's session, ensuring data security and isolation. Its primary role is to define and manage the specific assessment structures—such as exams, assignments, and projects—that students must complete for a unit offering within a given academic calendar.

Key Information Stored

The view consolidates key identifiers and descriptive attributes for unit assessment patterns. Essential columns include UNIT_CD, VERSION_NUMBER, CAL_TYPE, and CI_SEQUENCE_NUMBER, which together identify the specific unit offering. The ASS_PATTERN_ID and ASS_PATTERN_CD uniquely identify the assessment pattern itself. Operational flags and dates govern the pattern's lifecycle: DFLT_PATTERN_IND specifies a default pattern, LOGICAL_DELETE_DT supports soft deletion, and the ACTION_DT column, noted in the user's search, is a significant date field typically recording when a key action (like pattern activation or a status change) was taken. Standard EBS audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE) and program context columns (REQUEST_ID, PROGRAM_ID) are also present.

Common Use Cases and Queries

This view is central to academic operations and reporting. Common use cases include generating unit assessment outlines, validating student assessment loads, and auditing changes to assessment requirements. A typical query might retrieve all active assessment patterns for a unit to display in a course catalog, often filtering out logically deleted records. For example, to find patterns for a specific unit where an action occurred after a certain date, one might use:

• SELECT UNIT_CD, ASS_PATTERN_CD, DESCRIPTION, ACTION_DT FROM APPS.IGS_AS_UNTAS_PATTERN WHERE UNIT_CD = 'MATH101' AND LOGICAL_DELETE_DT IS NULL AND ACTION_DT > '01-JAN-2023';

Reporting often involves joining this view with related calendar and unit definition tables to produce comprehensive assessment schedules.

Related Objects

IGS_AS_UNTAS_PATTERN is part of a tightly integrated schema within the Student System. Its primary key, IGS_AS_UNTAS_PATTERN_PK, is defined on the columns UNIT_CD, VERSION_NUMBER, CAL_TYPE, CI_SEQUENCE_NUMBER, and ASS_PATTERN_ID. This key is frequently referenced by foreign keys in child tables that store detailed assessment items or student results. The provided metadata indicates a foreign key relationship from the view's UNIT_MODE column, though the specific referenced table is not fully detailed in the excerpt. The view's source is the ALL table (IGS_AS_UNTAS_PATTERN_ALL), and it is inherently related to core IGS tables defining units (IGS_PS_UNIT_VER), calendars (IGS_CA_INST), and assessment components.