Results for “approved_ind”

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

Overview

IGS_PS_UNIT_SUBTITLE is a table within the IGS (Student System) product schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores alternate or secondary descriptive titles — subtitles — associated with units of study offered by an institution. A unit is the fundamental academic offering within the Student System, and this table allows one unit to carry additional presentation titles beyond its primary title, typically for variants such as short titles, language translations, transcript-specific wording, or marketing-oriented naming.

In ETRM the object is documented as VALID with the schema owner IGS and a physical column count of eleven in the 12.1.1 reference release. Under the heuristic Data Vault classification mined from its foreign key structure, IGS_PS_UNIT_SUBTITLE is characterized as hub-leaning. In Data Vault terms this suggests the table behaves as a stable, subject-oriented entity keyed by a surrogate identifier, forming a durable integration point to which descriptive detail and contextual references can attach. Whether implemented as a formal hub or as a business entity preserving historical attributes, its role is consistent: it provides the canonical identity for subtitles that other Student System components reference.

Key Information Stored

SUBTITLE_ID is the surrogate primary key (IGS_PS_UNIT_SUBTITLE_PK) and uniquely identifies each subtitle row. It is also enforced by the unique index IGS_PS_UNIT_SUBTITLE_U1 and serves as the target of foreign key references from other tables, establishing it as the durable identifier for the entity.

The business-key candidate is defined by the unique index IGS_PS_UNIT_SUBTITLE_U2, comprising UNIT_CD, VERSION_NUMBER, and SUBTITLE. Together these describe which unit version carries a given subtitle text and guarantee that the same subtitle is not duplicated within a unit version.

• SUBTITLE_ID — surrogate primary key; referenced by dependent tables.
• UNIT_CD — code of the unit of study to which the subtitle belongs.
• VERSION_NUMBER — version of the unit, enabling subtitle maintenance across unit versions.
• SUBTITLE — the actual subtitle text applied to the unit.
• APPROVED_IND — indicates whether the subtitle record has been approved for use.
• CLOSED_IND — indicates the record is closed and should no longer be applied.
• CREATED_BY, CREATION_DATE — standard WHO audit columns recording row creation.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns recording the most recent change and session.

Common Use Cases and Queries

Typical usage centers on retrieving the alternate titles for a unit version and on joining subtitle information to unit definition records. A representative query filters active subtitles for a unit:

• Select UNIT_CD, VERSION_NUMBER, SUBTITLE from IGS_PS_UNIT_SUBTITLE where UNIT_CD = :unit_cd and VERSION_NUMBER = :version_number.
• Restrict to approved and open rows using APPROVED_IND = 'Y' and CLOSED_IND = 'N' for catalog, transcript, or web display purposes.
• Join to IGS_PS_UNIT_VER_ALL on UNIT_CD and VERSION_NUMBER to reconcile the subtitle with the owning unit version record.
• Resolve downstream references by joining SUBTITLE_ID to IGS_PS_USEC_REF or IGS_PS_UNIT_VER_ALL, where SUBTITLE_ID is carried as a foreign key.
• Audit reporting on LAST_UPDATED_BY and LAST_UPDATE_DATE to trace who modified subtitle data and when.

Related Objects

The following objects are significant because of documented foreign key relationships with IGS_PS_UNIT_SUBTITLE:

• IGS_PS_UNIT_VER_ALL — referenced by IGS_PS_UNIT_SUBTITLE on UNIT_CD and VERSION_NUMBER; this table also carries SUBTITLE_ID back to IGS_PS_UNIT_SUBTITLE, tying the subtitle to the unit version.
• IGS_PS_USEC_REF — references IGS_PS_UNIT_SUBTITLE through SUBTITLE_ID, using the subtitle as a referenceable entity in usec (unit section) contexts.
• IGS_PS_UNIT_VER_HIST_ALL — historical unit version table that also references IGS_PS_UNIT_SUBTITLE.SUBTITLE_ID, preserving subtitle associations across history.
• IGS_PS_UNIT_SUBTITLE_PK — primary key constraint on SUBTITLE_ID.
• IGS_PS_UNIT_SUBTITLE_U1 / IGS_PS_UNIT_SUBTITLE_U2 — unique indexes enforcing the surrogate and business-key uniqueness described above.