Search Results igs_tr_group_note_pk

Overview

The IGS_TR_GROUP_NOTE table is a core data object within the Oracle E-Business Suite Student System (IGS) for releases 12.1.1 and 12.2.2. It functions as a junction or association table, designed to store references linking textual notes to specific tracking groups. A tracking group is a logical collection of items or records being monitored within the student lifecycle. This table does not store the note text itself; instead, it maintains the relationships between a tracking group, the note's content stored elsewhere, and the note's classification type. Its primary role is to enable the attachment and categorization of multiple notes to a single tracking group, supporting audit trails, communication logs, and process documentation essential for student administration and support services.

Key Information Stored

The table's structure is defined by a composite primary key and several foreign key columns that enforce data integrity. The most critical columns are the components of the primary key: TRACKING_GROUP_ID, which identifies the specific tracking group, and REFERENCE_NUMBER, which is a foreign key to the actual note text in the generic notes table (IGS_GE_NOTE). A third significant column is TRK_NOTE_TYPE, which classifies the note (e.g., internal comment, student communication, system-generated alert) by referencing the IGS_TR_NOTE_TYPE table. This structure ensures that for any given tracking group, each note reference is unique and properly typed.

Common Use Cases and Queries

This table is central to reporting and inquiry forms that display notes history for a student case or tracking item. A common operational use case is retrieving all notes attached to a particular tracking group for review by an advisor. For reporting, analysts may join this table to group and count notes by type to analyze support interactions. A typical SQL query to fetch note details for a tracking group would join IGS_TR_GROUP_NOTE to IGS_GE_NOTE for the text and IGS_TR_NOTE_TYPE for the type description.

• Sample Query Pattern:
  SELECT n.reference_number, nt.note_type_name, ge.note_text
  FROM igs_tr_group_note n,
  igs_ge_note ge,
  igs_tr_note_type nt
  WHERE n.tracking_group_id = :p_group_id
  AND n.reference_number = ge.reference_number
  AND n.trk_note_type = nt.trk_note_type
  ORDER BY ge.creation_date DESC;

Related Objects

The IGS_TR_GROUP_NOTE table maintains strict referential integrity through documented foreign key relationships with three key tables in the IGS schema. These relationships are fundamental to its operation.

• IGS_TR_GROUP_ALL: Linked via the TRACKING_GROUP_ID column. This is the parent table for tracking group definitions.
• IGS_GE_NOTE: Linked via the REFERENCE_NUMBER column. This generic table stores the actual note text, creation date, and creator information.
• IGS_TR_NOTE_TYPE: Linked via the TRK_NOTE_TYPE column. This table provides the valid list and descriptions for classifying tracking notes.

The table's primary key, IGS_TR_GROUP_NOTE_PK, on (TRACKING_GROUP_ID, REFERENCE_NUMBER), ensures the uniqueness of each note reference per group.