Search Results action_dt




Overview
Explore in AI Chat

Overview

The APPS.IGS_AS_UNTAS_PATTERN view is a critical data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Student Management (OSM) or Campus Solutions modules. This view provides a filtered, multi-organization (Multi-Org) access layer over the underlying base table, IGS_AS_UNTAS_PATTERN_ALL. Its primary role is to manage and present the assignment patterns linked to specific academic units (courses/subjects). An assignment pattern defines the schedule, types, and potentially the weighting of assessments (e.g., exams, projects, quizzes) for a unit offering in a given academic calendar period. The view enforces data security by using a WHERE clause filter on ORG_ID, ensuring users only see data relevant to their operating unit context.

Key Information Stored

The view exposes columns essential for defining and tracking unit assessment patterns. The primary key columns (UNIT_CD, VERSION_NUMBER, CAL_TYPE, CI_SEQUENCE_NUMBER, ASS_PATTERN_ID) uniquely identify a pattern for a specific unit version and teaching calendar instance. The ASS_PATTERN_CD and DESCRIPTION columns store the code and name of the assessment pattern itself. Key contextual columns include LOCATION_CD, UNIT_CLASS, and UNIT_MODE, which can tailor a pattern to specific delivery modes or locations. The DFLT_PATTERN_IND flag indicates if this is the default pattern for the unit offering, while LOGICAL_DELETE_DT and ACTION_DT support lifecycle management. Standard EBS audit columns (CREATED_BY, CREATION_DATE, etc.) and processing 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 configuring assessment schedules during unit setup, generating academic calendars for students and faculty, and auditing assessment structures. A frequent query pattern involves retrieving all active assessment patterns for a unit to display in a course catalog or administration form. For example, to find the default assessment pattern for a specific unit offering, one might use: SELECT ass_pattern_cd, description FROM apps.igs_as_untas_pattern WHERE unit_cd = 'MATH101' AND version_number = 1 AND cal_type = 'SEMESTER' AND ci_sequence_number = 202301 AND dflt_pattern_ind = 'Y' AND logical_delete_dt IS NULL; Another common reporting need is to list all patterns across units for a given teaching calendar to ensure consistency, leveraging joins on calendar columns.

Related Objects

The view's structure indicates strong relationships with other core academic entities. Its primary key, IGS_AS_UNTAS_PATTERN_PK, is defined on UNIT_CD, VERSION_NUMBER, CAL_TYPE, CI_SEQUENCE_NUMBER, and ASS_PATTERN_ID. This suggests it is a child entity, likely referencing master tables for the Unit (IGS_PS_UNIT_VER), Calendar (IGS_CA_INST), and the Assessment Pattern definition itself (potentially IGS_AS_PATTERN). The provided foreign key metadata indicates that the UNIT_MODE column references another lookup table to validate the unit delivery mode. The view is built directly from the table IGS_AS_UNTAS_PATTERN_ALL, and any custom reporting or integration logic referencing unit assessment patterns would typically query this APPS view to respect Multi-Org security rules.