Search Results s_course_status




Overview
Explore in AI Chat

Overview

IGS_PS_VER_TITLE_V is a database view belonging to the IGS — Student System product family in Oracle E-Business Suite (available in both 12.1.1 and 12.2.2). Its documented description is simply "Manually created," indicating that the object is a custom or ad hoc construct rather than a seeded Oracle-delivered view registered through standard implementation scripts. The ETRM metadata explicitly records it as "Not implemented in this database," and no referenced base objects are formally documented.

Functionally, the view presents a flattened result set combining course version records with a decoded course status value. It exposes the course code, version number, course status, title, and short title from the course version entity, alongside a second status representation (S_COURSE_STATUS) sourced from the status lookup table. The view thus serves as a lightweight reporting and integration surface for presenting course version data with human-readable status labels.

Underlying Base Objects

The view text defines a two-table join over the following IGS base tables:

The join condition is CS.COURSE_STATUS = CRV.COURSE_STATUS, an equijoin on the numeric status code shared by both tables. Because the join is written as a plain inner join, only course versions whose status code exists in IGS_PS_STAT will be returned. This relationship effectively decodes the stored status code from the version row into a descriptive value, which is the principal purpose of the view.

Key Columns

  • COURSE_CD — the unique code identifying the course.
  • VERSION_NUMBER — the version of the course record, allowing multiple historical or draft versions per course.
  • COURSE_STATUS — the raw numeric status code held on the course version row.
  • TITLE and SHORT_TITLE — the full and abbreviated descriptive titles of the course version.
  • S_COURSE_STATUS — the decoded/descriptive status value sourced from IGS_PS_STAT, joined on the matching status code. This column is directly relevant to searches referencing "s_course_status".
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle WHO audit columns, inherited from the course version table.

Common Use Cases and Queries

The view is typically used to report course versions together with their descriptive status, supporting catalog review, publishing checks, and integration extracts. A representative query filtering on the decoded status column is shown below:

  • SELECT course_cd, version_number, s_course_status, title, short_title FROM igs_ps_ver_title_v WHERE s_course_status = :status;
  • SELECT course_cd, version_number, title FROM igs_ps_ver_title_v WHERE course_status = :code ORDER BY course_cd, version_number;
  • SELECT s_course_status, COUNT(*) FROM igs_ps_ver_title_v GROUP BY s_course_status;

Because the metadata records the view as not implemented and manually created, availability should be verified in the target instance before use. Where the view is absent, equivalent results can be produced by joining IGS_PS_VER and IGS_PS_STAT directly on COURSE_STATUS.