Search Results igs_ps_unit_subtitle_u2

Overview

The IGS_PS_UNIT_SUBTITLE table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Student Management (OSM) product, as indicated by its IGS (iGrants) schema ownership. Its primary function is to manage alternative or secondary titles, known as subtitles, for academic units (courses or modules). This table enables institutions to maintain multiple descriptive titles for a single unit, which is essential for detailed cataloging, specialized program tracks, or compliance with different reporting requirements. The table's design ensures data integrity through unique constraints and standard EBS "Who" columns for auditing.

Key Information Stored

The table stores the relationship between a unit and its possible subtitles, along with administrative status flags. The critical columns are:

• SUBTITLE_ID: The primary key, a unique system-generated sequence number.
• UNIT_CD and VERSION_NUMBER: Together, these foreign key columns identify the specific unit (and its version) to which the subtitle is assigned. They form part of a unique constraint (IGS_PS_UNIT_SUBTITLE_U2) with the SUBTITLE column.
• SUBTITLE: Holds the alternative title text (up to 90 characters).
• APPROVED_IND and CLOSED_IND: Control flags indicating whether the subtitle is officially approved and whether it is available for active use, respectively.
• Standard Who Columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN): Provide full audit trail capabilities as per EBS conventions.

Common Use Cases and Queries

This table is central to queries involving unit catalog information and reporting. A common operational use case is retrieving all active, approved subtitles for a given unit to populate course selection interfaces or academic transcripts. For reporting, it is often joined to the main unit definition table (e.g., IGS_PS_UNIT_VER) to produce enriched course catalogs. A typical query pattern involves filtering on the status indicators and unit identifier:

SELECT unit_cd, version_number, subtitle
FROM igs.igs_ps_unit_subtitle
WHERE unit_cd = 'MATH101'
AND approved_ind = 'Y'
AND closed_ind = 'N';

Another critical administrative query identifies all subtitles that are not yet approved or are closed, supporting data cleanup and governance workflows. The unique constraint on UNIT_CD, VERSION_NUMBER, and SUBTITLE ensures that duplicate subtitle entries for the same unit version cannot be created.

Related Objects

While the provided metadata shows no outward dependencies from this table, it is referenced by objects within the APPS schema, indicating it is accessed via public synonyms and standard EBS application code. Its primary relationship is to the main unit version table (likely named IGS_PS_UNIT_VER), as indicated by the UNIT_CD and VERSION_NUMBER columns. The SUBTITLE_ID primary key is populated by the sequence IGS_PS_UNIT_SUBTITLE_S. For comprehensive reporting, this table is typically joined in queries with core academic structures to provide full context for unit subtitles.