Search Results igs_as_su_atmpt_pat




Overview
Explore in AI Chat

Overview

The table IGS_AS_SU_ATMPT_PAT is a historical data object within the Oracle E-Business Suite, specifically belonging to the now-obsolete IGS (Student System) product family. Based on the provided ETRM metadata, this table is explicitly marked as "Obsolete" and was "Not implemented in this database" for the documented releases, including versions 12.1.1 and 12.2.2. Its intended role was to manage the relationship between student unit attempts and assessment patterns. It served as a junction table, linking a student's enrollment attempt for a specific unit offering to a defined assessment pattern that outlined the required evaluations for that unit.

Key Information Stored

The table's composite primary key defines the unique combination of identifiers required to locate a specific record. The key columns indicate the granular level of data it was designed to store, tying together student, course, unit, and assessment details. The primary columns include:

Common Use Cases and Queries

Given its obsolete status and non-implementation, this table is not used in active Oracle EBS 12.1.1 or 12.2.2 environments for transactional processing or reporting. In historical contexts where legacy data migration was required, its purpose would have been to answer queries such as: "Which assessment pattern is assigned to a specific student for a particular unit attempt?" or "List all students assigned a specific assessment pattern for a given unit offering." A sample join query to retrieve this information, based on its documented foreign keys, would have resembled:

SELECT suap.*, sua.unit_cd, pat.ass_pattern_name
FROM igs_as_su_atmpt_pat suap
JOIN igs_en_su_attempt_all sua
  ON suap.person_id = sua.person_id
 AND suap.course_cd = sua.course_cd
 AND suap.unit_cd = sua.unit_cd
 AND suap.cal_type = sua.cal_type
 AND suap.ci_sequence_number = sua.ci_sequence_number
JOIN igs_as_untas_pattern_all pat
  ON suap.ass_pattern_id = pat.ass_pattern_id;

Practitioners should note that this structure and logic may have been superseded by other tables in the active Student Management module.

Related Objects

The ETRM documentation specifies two key foreign key relationships for this table, which define its dependencies within the obsolete schema:

  • IGS_EN_SU_ATTEMPT_ALL: This table is referenced via a composite foreign key on columns PERSON_ID, COURSE_CD, UNIT_CD, CAL_TYPE, and CI_SEQUENCE_NUMBER. It stores the core record of a student's attempt at a unit within a course.
  • IGS_AS_UNTAS_PATTERN_ALL: This table is referenced via the ASS_PATTERN_ID column. It holds the master definitions of assessment patterns that could be assigned to unit attempts.

These relationships confirm the table's role as a mapping entity between a student's specific enrollment instance and a template for assessment requirements.