Results for “subtitle_id”

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

Overview

IGS_PS_UNIT_SUBTITLE_V is a read-only view in the APPS schema belonging to the IGS (Student System) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. As its ETRM description states, the view "displays the subtitles for units." Within the Oracle Student System data model, a unit is the fundamental academic offering (a module or course component), and units may carry one or more descriptive subtitles across their lifecycle. This view provides a stable, denormalized read surface over the IGS_PS_UNIT_SUBTITLE entity, exposing subtitle records together with their approval and closure status flags. Because it is a view rather than a table, it carries no independent storage and inherits the row-level security and grants applied to its underlying base object. It is primarily consumed by reporting extracts, concurrent programs, and integration interfaces that need to present unit subtitles without navigating the full unit hierarchy directly.

Underlying Base Objects

The documented ETRM metadata records no referenced base objects, but the view text establishes its single source: IGS_PS_UNIT_SUBTITLE USUB. The view is defined as a straightforward projection with no joins, unions, or aggregations, selecting the base table's ROWID alongside its business and audit columns. Consequently, the view is fully updateable in principle (the ROWID supports DML targeting), although in practice it is used for query and reporting access. The base table IGS_PS_UNIT_SUBTITLE stores subtitle definitions keyed by SUBTITLE_ID and linked to a unit via UNIT_CD and VERSION_NUMBER, reflecting Oracle Student System's versioning convention in which unit attributes are tracked across successive versions rather than overwritten in place.

Key Columns

• ROW_ID — the physical row identifier of the base table row, exposed as USUB.ROWID.
• SUBTITLE_ID — unique identifier for the subtitle record; the primary key of the underlying table.
• UNIT_CD — the unit code identifying the parent academic unit.
• VERSION_NUMBER — the unit version to which the subtitle applies, supporting historical and versioned reporting.
• SUBTITLE — the descriptive subtitle text itself.
• APPROVED_IND — a Y/N indicator of whether the subtitle has been approved. This is the column most relevant to the user's search term "approved_ind," and it is the principal filter in most queries against this view.
• CLOSED_IND — a Y/N indicator of whether the subtitle record has been closed or retired.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle EBS audit columns capturing who created and last modified the record and when.

Common Use Cases and Queries

The most frequent scenario is retrieving currently active, approved subtitles for a unit and version, which requires filtering on both indicator columns. A typical query is:

SELECT subtitle_id, unit_cd, version_number, subtitle
FROM apps.igs_ps_unit_subtitle_v
WHERE unit_cd = :unit_cd
AND version_number = :version_number
AND approved_ind = 'Y'
AND closed_ind = 'N';

A second common pattern is an audit or data-quality check that lists all unapproved subtitles pending review:

SELECT unit_cd, version_number, subtitle, created_by, creation_date
FROM apps.igs_ps_unit_subtitle_v
WHERE approved_ind = 'N'
AND closed_ind = 'N'
ORDER BY creation_date;

A third use is traceability reporting, joining the subtitle to the unit and versioning tables to produce a complete catalogue of approved unit descriptions for prospectus or transcript feeds. Because the view exposes no joins and relies on UNIT_CD and VERSION_NUMBER as its linkage keys, consumers should always qualify queries by both to avoid cross-version contamination. All queries should be issued against the APPS schema (or a synonym) with the caller's EBS responsibility providing the necessary read privileges.