Search Results igs_ps_unit_ver_note




Overview
Explore in AI Chat

Overview

The IGS_PS_UNIT_VER_NOTE table is a core data entity within the Oracle E-Business Suite Student System (IGS) module. It functions as a junction or mapping table, establishing formal relationships between specific unit versions and their associated textual notes. Its primary role is to enable the structured attachment of descriptive, administrative, or instructional notes to academic unit definitions at a particular version level. This ensures that critical information pertaining to a unit's content, prerequisites, assessment, or administrative details is persistently linked to the correct academic offering, supporting core student lifecycle processes like course planning, enrollment, and academic advising.

Key Information Stored

The table's structure is designed to uniquely identify a note attached to a specific unit version. Its primary key is a composite of three columns, which together form the unique identifier IGS_PS_UNIT_VER_NOTE_PK. The UNIT_CD column stores the code identifying the academic unit. The VERSION_NUMBER column specifies the particular version of that unit. The REFERENCE_NUMBER column holds a foreign key that points to the actual note text stored in the generic notes table (IGS_GE_NOTE). A critical additional column is CRS_NOTE_TYPE, which classifies the note (e.g., administrative note, learning outcome, prerequisite information) by referencing a controlled list of note types defined in the IGS_PS_NOTE_TYPE_ALL table.

Common Use Cases and Queries

A primary use case is retrieving all notes for a given unit version to display in a student portal or administrative interface. For example, a report on unit 'MATH101' version '2' would join this table to the notes master. Another common scenario involves data validation or migration scripts to ensure all active unit versions have required note types attached. Sample SQL to fetch note text for a unit would typically involve joining the mapping table to both the unit version and the notes master table:

  • SELECT n.note_text, uv.unit_cd, uv.version_number FROM igs_ps_unit_ver_note uvn JOIN igs_ge_note n ON uvn.reference_number = n.reference_number JOIN igs_ps_unit_ver_all uv ON uvn.unit_cd = uv.unit_cd AND uvn.version_number = uv.version_number WHERE uv.unit_cd = 'MATH101' AND uv.version_number = 2;

Related Objects

The IGS_PS_UNIT_VER_NOTE table maintains documented foreign key relationships with three key entities in the Student System, as per the provided metadata:

  • IGS_PS_UNIT_VER_ALL: This is the master table for unit versions. The relationship is established via the UNIT_CD and VERSION_NUMBER columns, ensuring every note mapping corresponds to a valid, existing unit version.
  • IGS_GE_NOTE: This generic notes table stores the actual note text. The REFERENCE_NUMBER column in IGS_PS_UNIT_VER_NOTE points to the primary key of this table, linking the mapping to the descriptive content.
  • IGS_PS_NOTE_TYPE_ALL: This table defines the valid types of notes (e.g., 'PREREQ', 'ASSESS'). The CRS_NOTE_TYPE column in the mapping table references this to categorize the attached note.
  • Table: IGS_PS_UNIT_VER_NOTE 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_UNIT_VER_NOTE,  object_name:IGS_PS_UNIT_VER_NOTE,  status:VALID,  product: IGS - Student System ,  description: This entity describes mappings of notes to unit versions. ,  implementation_dba_data: IGS.IGS_PS_UNIT_VER_NOTE , 

  • Table: IGS_PS_NOTE_TYPE_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_NOTE_TYPE_ALL,  object_name:IGS_PS_NOTE_TYPE_ALL,  status:VALID,  product: IGS - Student System ,  description: This entity describes the available program note types. ,  implementation_dba_data: IGS.IGS_PS_NOTE_TYPE_ALL , 

  • Table: IGS_GE_NOTE 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_GE_NOTE,  object_name:IGS_GE_NOTE,  status:VALID,  product: IGS - Student System ,  description: This table is used to store notes that may be recorded against many major entities for example courses, units, persons. The note may be an OLE object like word document, excel spreadsheet, and so on. ,  implementation_dba_data: IGS.IGS_GE_NOTE , 

  • Table: IGS_PS_UNIT_VER_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_UNIT_VER_ALL,  object_name:IGS_PS_UNIT_VER_ALL,  status:VALID,  product: IGS - Student System ,  description: This entity describes a version of a unit, which is offered by the university. ,  implementation_dba_data: IGS.IGS_PS_UNIT_VER_ALL ,