Search Results igs_as_untas_pattern_pk

Overview

The table IGS_AS_UNTAS_PATTERN is a core data entity within the Oracle E-Business Suite's now-obsolete Student System (IGS) module. It serves a fundamental role in defining the academic assessment structure for a unit of study. Specifically, it describes the distinct assessment patterns that collectively constitute the complete assessment requirement for a given unit offering. This table acts as a junction, linking a unit version offered in a specific academic calendar to one or more defined assessment patterns. It is critical for managing how student performance is evaluated across different unit delivery modes and sessions.

Key Information Stored

The table's composite primary key defines the unique combination of attributes required to identify a specific assessment pattern for a unit offering. The key columns are: UNIT_CD (the unit code), VERSION_NUMBER (the version of the unit), CAL_TYPE (the calendar type, e.g., 'SEMESTER'), CI_SEQUENCE_NUMBER (the sequence number identifying the calendar instance), and ASS_PATTERN_ID (the identifier for the assessment pattern itself). According to the provided metadata, the table also contains a column, UNIT_MODE, which is documented as a foreign key, indicating the mode of study (e.g., on-campus, distance) for which the assessment pattern applies. The table's status as "Not implemented in this database" in the excerpt suggests it may be a legacy definition or part of a non-deployed schema in some instances.

Common Use Cases and Queries

This table is central to queries that retrieve or validate the assessment components for a student's enrolled unit. A typical use case involves generating a student's assessment schedule or verifying the assessment rules applied to a specific unit offering. A common reporting query would join this table to the unit details and assessment pattern master tables to list all assessment patterns for units in a given academic period. For example:

• Identifying all assessment patterns for a unit in the current semester to configure a learning management system.
• Auditing assessment requirements across different unit versions or delivery modes.
• Supporting administrative processes for calculating final grades based on aggregated pattern results.

A sample SQL pattern would select from IGS_AS_UNTAS_PATTERN, filtering on CAL_TYPE and CI_SEQUENCE_NUMBER for a specific teaching period, and joining to related unit and pattern definition tables.

Related Objects

The primary and foreign key relationships define this table's integration within the Student System schema. Its primary key, IGS_AS_UNTAS_PATTERN_PK, is referenced by other tables that store data dependent on a specific unit assessment pattern. The documented foreign key shows that the UNIT_MODE column in IGS_AS_UNTAS_PATTERN references another table, though the specific target table name is partially obscured in the metadata (noted as referencing "IGS_AS_UNTAS_PATTERN.UNIT_MODE → %"). This implies a relationship to a lookup table for unit modes. Furthermore, the table itself is a likely parent to entities storing detailed assessment items (e.g., exams, assignments) that roll up into the broader pattern defined here.