Results for “igs_as_sc_atmpt_note”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The IGS_AS_SC_ATMPT_NOTE table is a core component of the Oracle EBS Student System (IGS) module, specifically within the Student Records and Academic Standing functional area. This table describes the mappings of notes to student program attempts, serving as the associative entity that connects free-text or coded notes to a student's recorded attempt at a course or program. In the context of Oracle EBS 12.1.1 and 12.2.2, this table acts as a bridge between the note repository (IGS_GE_NOTE), note type definitions (IGS_EN_NOTE_TYPE_ALL), and the student program attempt records (IGS_EN_STDNT_PS_ATT_ALL). It allows institutions to attach administrative, academic, or advising notes to a specific student's course attempt without duplicating note content.

The relationship data classifies this table heuristically as a link entity in Data Vault modeling terms. This classification is a modeling suggestion rather than an enforced constraint; it reflects the table's role in resolving a many-to-many relationship between student program attempts and notes. The primary key, IGS_AS_SC_ATMPT_NOTE_PK, is defined on the composite of PERSON_ID, COURSE_CD, and REFERENCE_NUMBER, ensuring that a given note can be associated only once with a specific student-course attempt combination.

Key Information Stored

The table contains nine documented columns in the ETRM 12.1.1 schema. The most significant columns are described below, distinguishing the composite primary key from business-key candidates.

• PERSON_ID — Part of the composite primary key and a foreign key to IGS_EN_STDNT_PS_ATT_ALL. Identifies the student whose program attempt is being annotated.
• COURSE_CD — Part of the composite primary key and a foreign key to IGS_EN_STDNT_PS_ATT_ALL. Identifies the course associated with the student's attempt.
• REFERENCE_NUMBER — Part of the composite primary key and a foreign key to IGS_GE_NOTE. Points to the underlying note record holding the actual note text or content.
• ENR_NOTE_TYPE — A foreign key to IGS_EN_NOTE_TYPE_ALL that classifies the note (for example, advising, academic standing, or administrative note types).

The composite primary key (PERSON_ID, COURSE_CD, REFERENCE_NUMBER) is also exposed as a unique index, IGS_AS_SC_ATMPT_NOTE_U1, making it the documented business-key candidate. The remaining columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — are standard Oracle EBS audit columns that record who created and last modified each row and when. There is no separate surrogate single-column primary key; the surrogate role is fulfilled by the composite natural key.

Common Use Cases and Queries

Typical use cases include reporting all notes attached to a student's course attempt, retrieving notes by their enrollment note type, and auditing who introduced or changed a note mapping. A common query pattern joins the link table to its parent attempt and note tables:

• SELECT n.PERSON_ID, n.COURSE_CD, n.REFERENCE_NUMBER, n.ENR_NOTE_TYPE FROM IGS_AS_SC_ATMPT_NOTE n WHERE n.PERSON_ID = :person_id;
• Join to IGS_GE_NOTE on REFERENCE_NUMBER to retrieve the actual note text, and to IGS_EN_NOTE_TYPE_ALL on ENR_NOTE_TYPE to obtain the note type description.
• Join to IGS_EN_STDNT_PS_ATT_ALL on PERSON_ID and COURSE_CD to display the associated student program attempt details.
• Aggregate counts of notes per note type (ENR_NOTE_TYPE) for administrative dashboards and compliance reporting.
• Audit queries filtering on CREATION_DATE or LAST_UPDATE_DATE to identify recently added or modified note mappings.

Related Objects

The following objects are the most significant to reference or join with IGS_AS_SC_ATMPT_NOTE, based on the documented foreign key and primary key relationships.

• IGS_GE_NOTE — Referenced via REFERENCE_NUMBER; holds the note content linked to each mapping.
• IGS_EN_NOTE_TYPE_ALL — Referenced via ENR_NOTE_TYPE; provides the note type definition.
• IGS_EN_STDNT_PS_ATT_ALL — Referenced via PERSON_ID and COURSE_CD; the parent student program attempt record.
• IGS_AS_SC_ATMPT_NOTE_PK — The primary key constraint enforcing uniqueness on PERSON_ID, COURSE_CD, and REFERENCE_NUMBER.
• IGS_AS_SC_ATMPT_NOTE_U1 — The unique index mirroring the primary key and serving as the business-key candidate.