Results for “crs_note_type”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_PS_UNIT_VER_NOTE is a table within the Oracle E-Business Suite IGS – Student System product family, a module that Oracle has designated as obsolete in the ETRM documentation for releases 12.1.1 and 12.2.2. The entity describes mappings of notes to unit versions — each row associates a free-text note (or note reference) with a specific version of an academic unit. Notes in the Student System are typically administrative, regulatory, or descriptive annotations that accompany curriculum structures so that admissions staff, faculty, and administrators can understand contextual information about a unit offering.

The ETRM metadata records this object as "Not implemented in this database," confirming that the table was not physically deployed in the reference environment; the documented physical schema nonetheless lists the owner as IGS with nine columns. The supplied Data Vault classification is a heuristic derived from the foreign-key structure and describes the entity as a link. This is a modeling suggestion rather than a physical implementation detail: the table resolves a many-to-many relationship between unit versions and notes, and as such behaves like a link table that connects two hubs (unit version and note) rather than functioning as a standalone hub or a purely descriptive satellite.

Key Information Stored

The documented columns capture the identity of the unit version, the note being attached, and standard audit fields. The most significant attributes are:

• UNIT_CD — the code identifying the academic unit; part of the primary key and a foreign key to IGS_PS_UNIT_VER_ALL.
• VERSION_NUMBER — the version of the unit; also part of the primary key and joined with UNIT_CD to identify the unit version.
• REFERENCE_NUMBER — the identifier of the referenced note; third primary key column and a foreign key to IGS_GE_NOTE.
• CRS_NOTE_TYPE — the note type classification; a foreign key to IGS_PS_NOTE_TYPE_ALL that categorises the purpose of the note.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Oracle audit columns capturing who created and last maintained the mapping.

The surrogate-style composite primary key IGS_PS_UNIT_VER_NOTE_PK is defined over (UNIT_CD, VERSION_NUMBER, REFERENCE_NUMBER). The unique index IGS_PS_UNIT_VER_NOTE_U1 carries the same three columns, making this triple the business-key candidate: no two rows may map the same note to the same unit version twice. Because all three key columns are also foreign keys, the table is effectively an associative entity.

Common Use Cases and Queries

Typical usage centres on retrieving the notes attached to a unit version for curriculum review, catalog publication, or regulatory reporting. A representative query joins the note table to retrieve descriptive text:

• SELECT n.unit_cd, n.version_number, n.reference_number, g.note_text
  FROM igs_ps_unit_ver_note n, igs_ge_note g
  WHERE n.reference_number = g.reference_number
  AND n.unit_cd = :unit_code;
• Filtering by note type, using CRS_NOTE_TYPE, to isolate, for example, only admission-related notes for a given version.
• Audit and change-tracking reports using LAST_UPDATED_BY and LAST_UPDATE_DATE to identify recently modified note mappings.
• Referential-integrity and orphan checks confirming every REFERENCE_NUMBER exists in IGS_GE_NOTE and every unit version exists in IGS_PS_UNIT_VER_ALL.

Because the object is obsolete and not implemented, these patterns are relevant primarily for historical data migration or for administrators working with legacy IGS installations.

Related Objects

The FK metadata identifies the principal related tables, all of which participate in the note-mapping relationship:

• IGS_PS_UNIT_VER_ALL — provides the unit version (UNIT_CD, VERSION_NUMBER); the primary parent of this link.
• IGS_GE_NOTE — supplies the note identified by REFERENCE_NUMBER.
• IGS_PS_NOTE_TYPE_ALL — defines the note type referenced by CRS_NOTE_TYPE.
• IGS_PS_UNIT_VER_NOTE_PK and IGS_PS_UNIT_VER_NOTE_U1 — the primary key constraint and unique index enforcing row uniqueness.

Together these objects form the note-to-unit-version mapping structure that the IGS Student System used to enrich curriculum definitions with contextual annotations.