Search Results igs_ps_note_type_pk

Overview

The IGS_PS_NOTE_TYPE_ALL table is a foundational data dictionary table within the Oracle E-Business Suite Student System (IGS). It functions as the master reference entity that defines and controls the types of notes or annotations that can be attached to various academic program structures. Its primary role is to enforce data integrity and standardization across the complex hierarchy of program offerings, versions, units, and their associated patterns and options. By providing a centralized list of valid note types, this table enables institutions to categorize descriptive text consistently for administrative, advisory, or informational purposes throughout the student lifecycle management system.

Key Information Stored

While the provided ETRM metadata does not list specific column names beyond the primary key, the structure and relationships define its core data model. The central column is CRS_NOTE_TYPE, which serves as the unique primary key (IGS_PS_NOTE_TYPE_PK). This column stores the short code or identifier for each distinct note type. Typical implementations would include additional descriptive columns, such as a description field, an active/inactive indicator, and possibly attributes controlling data entry rules or display context. The table supports multi-organization architecture, as indicated by the "_ALL" suffix, meaning it stores data for multiple operating units with an implied ORG_ID column.

Common Use Cases and Queries

This table is primarily used in two contexts: setup/maintenance and transactional validation. Administrators use the table to define the institution-specific note types available during data entry, such as "ADMISSION_REQS," "ACCREDITATION," or "INTERNAL_REVIEW." The system then uses this reference data to validate entries in all related note tables. Common reporting and query scenarios involve joining this table to its numerous child tables to translate note type codes into meaningful descriptions for reports. A fundamental query pattern is retrieving all active note types or listing notes for a specific program entity with their descriptions.

SELECT nt.crs_note_type, pn.note_text
FROM igs_ps_note_type_all nt,
     igs_ps_ver_note pn
WHERE nt.crs_note_type = pn.crs_note_type
  AND pn.course_cd = 'MATH101';

Related Objects

The IGS_PS_NOTE_TYPE_ALL table is a critical parent table referenced by a wide array of transactional note tables across the Student System. As documented in the foreign key relationships, its primary key (CRS_NOTE_TYPE) is referenced by the following entities, forming the core of the program annotation framework:

• IGS_EN_UNIT_SET_NOTE via CRS_NOTE_TYPE
• IGS_PS_OFR_NOTE via CRS_NOTE_TYPE
• IGS_PS_OFR_OPT_NOTE via CRS_NOTE_TYPE
• IGS_PS_OFR_PAT_NOTE via CRS_NOTE_TYPE
• IGS_PS_VER_NOTE via CRS_NOTE_TYPE
• IGS_PS_UNIT_OFR_NOTE via CRS_NOTE_TYPE
• IGS_PS_UNT_OFR_OPT_N via CRS_NOTE_TYPE
• IGS_PS_UNT_OFR_PAT_N via CRS_NOTE_TYPE
• IGS_PS_UNIT_VER_NOTE via CRS_NOTE_TYPE

This extensive relationship network confirms its central role in categorizing notes attached to course versions (VER), course offerings (OFR), unit sets, and their respective patterns and options.