Search Results igs_as_sc_atmpt_note




Overview
Explore in AI Chat

Overview

The IGS_AS_SC_ATMPT_NOTE table is a core data object within the Oracle E-Business Suite Student System (IGS). It functions as a mapping or junction table, establishing relationships between student program attempts and the system's generic notes. Its primary role is to associate specific notes, stored in the central IGS_GE_NOTE table, with individual student course attempts recorded in IGS_EN_STDNT_PS_ATT_ALL. This design enables the attachment of contextual notes—such as academic advisement, enrollment conditions, or administrative remarks—directly to a student's program enrollment record, providing a structured audit trail and reference within the academic lifecycle.

Key Information Stored

The table's structure is defined by its composite primary key and foreign key relationships. The key columns are PERSON_ID and COURSE_CD, which together uniquely identify a student's program attempt, and REFERENCE_NUMBER, which identifies the specific note being attached. The ENR_NOTE_TYPE column categorizes the note by linking it to a defined note type in the IGS_EN_NOTE_TYPE_ALL table. Therefore, the table does not store the note text itself but rather the critical linkages between the student attempt entity, the note entity, and the note type entity.

Common Use Cases and Queries

This table is central to reporting and processes that require a history of notes associated with a student's enrollment in a program. A common use case is generating a comprehensive student academic record that includes all administrative or advisor comments. Support staff may query it to review the history of notes attached to a student's program before making enrollment decisions. A typical SQL pattern involves joining to the student attempt and note tables:

  • SELECT s.person_id, s.course_cd, n.note_text, nt.note_type
    FROM igs_as_sc_atmpt_note a,
    igs_en_stdnt_ps_att_all s,
    igs_ge_note n,
    igs_en_note_type_all nt
    WHERE a.person_id = s.person_id
    AND a.course_cd = s.course_cd
    AND a.reference_number = n.reference_number
    AND a.enr_note_type = nt.note_type
    AND s.person_id = :student_id;

Related Objects

The table's integrity and meaning are derived entirely from its relationships with other key Student System tables, as documented in the provided metadata.

  • IGS_EN_STDNT_PS_ATT_ALL: This is the primary parent table. The PERSON_ID and COURSE_CD columns in IGS_AS_SC_ATMPT_NOTE form a foreign key to this table, linking each note mapping to a specific student program attempt.
  • IGS_GE_NOTE: The REFERENCE_NUMBER column is a foreign key to this central notes repository table, which contains the actual note text and creation metadata.
  • IGS_EN_NOTE_TYPE_ALL: The ENR_NOTE_TYPE column is a foreign key to this table, classifying the attached note (e.g., "Academic Warning", "Advisor Comment").