Search Results igs_ps_unit_ofr_note




Overview
Explore in AI Chat

Overview

The IGS_PS_UNIT_OFR_NOTE table is a core data structure within the Oracle E-Business Suite Student System (IGS). It functions as a junction table that establishes and manages the relationship between a specific unit offering and its associated descriptive or administrative notes. A unit offering represents an instance of a unit (or course) scheduled for a particular academic period (calendar type). This table's primary role is to link a unit offering to one or more free-text notes stored in the generic notes repository (IGS_GE_NOTE), while also categorizing each note via a defined note type. It is essential for storing contextual information, instructions, or announcements pertinent to a specific offering of a unit, which is critical for academic administration and student communication.

Key Information Stored

The table's structure is defined by a composite primary key that uniquely identifies each note assignment. The key columns are UNIT_CD, VERSION_NUMBER, and CAL_TYPE, which together identify the specific unit offering by linking to the IGS_PS_UNIT_OFR table. The fourth key column, REFERENCE_NUMBER, is a foreign key to the IGS_GE_NOTE table, which holds the actual note text. A crucial descriptive column is CRS_NOTE_TYPE, which is a foreign key to IGS_PS_NOTE_TYPE_ALL. This column classifies the note (e.g., 'Prerequisites', 'Assessment Details', 'Special Requirements'), enabling structured reporting and conditional display of notes based on their type within the application.

Common Use Cases and Queries

A primary use case is the retrieval of all notes for a unit offering to display on a student's class schedule or in a course catalog. Administrators may also query this table to audit or update notes for a batch of offerings. Common SQL patterns include joining to the unit offering and note text tables. For example, to fetch all note text for a specific offering:

  • SELECT n.note_text, nt.note_type_name FROM igs_ps_unit_ofr_note uon JOIN igs_ge_note n ON uon.reference_number = n.reference_number JOIN igs_ps_note_type_all nt ON uon.crs_note_type = nt.note_type WHERE uon.unit_cd = 'MATH101' AND uon.cal_type = 'SEM1';

Another frequent reporting need is to list all unit offerings that have a specific type of note attached, such as all offerings with a 'Lab Safety' note, which requires filtering on the CRS_NOTE_TYPE column.

Related Objects

The IGS_PS_UNIT_OFR_NOTE table has defined foreign key relationships with several key tables in the Student System, as documented in the ETRM metadata:

  • IGS_PS_UNIT_OFR: This is the parent table for the unit offering itself. The relationship is on the columns UNIT_CD, VERSION_NUMBER, and CAL_TYPE. This ensures a note cannot exist without a valid unit offering.
  • IGS_GE_NOTE: This generic notes table stores the actual note text. The relationship is on the REFERENCE_NUMBER column. This design centralizes note text storage for reuse across the application.
  • IGS_PS_NOTE_TYPE_ALL: This table defines the valid note types. The relationship on the CRS_NOTE_TYPE column provides a lookup for the note's classification, enforcing data integrity.
  • Table: IGS_PS_UNIT_OFR_NOTE 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_UNIT_OFR_NOTE,  object_name:IGS_PS_UNIT_OFR_NOTE,  status:VALID,  product: IGS - Student System ,  description: This table describes the notes associated with a unit offering. ,  implementation_dba_data: IGS.IGS_PS_UNIT_OFR_NOTE , 

  • Table: IGS_PS_UNIT_OFR 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_UNIT_OFR,  object_name:IGS_PS_UNIT_OFR,  status:VALID,  product: IGS - Student System ,  description: This entity describes an offering of a unit within a calendar type. ,  implementation_dba_data: IGS.IGS_PS_UNIT_OFR , 

  • 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 ,