Results for “course_status”

50+ results




Overview
Explore in AI Chat

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

Overview

IGS_PS_STAT is a reference (lookup) table within the Oracle E-Business Suite Student System (IGS) product family. Its documented purpose is to describe user-defined program statuses that map back onto the system program statuses, allowing institutions to maintain a much larger set of institution-specific statuses while still tying each one to the underlying system functionality. In Oracle EBS 12.1.1 and 12.2.2, IGS falls under the Student System module, which Oracle has classified as obsolete; the table is documented in the ETRM repository but is explicitly noted as "Not implemented in this database," meaning it may not exist in every environment and should be confirmed before being referenced in custom code.

From a dimensional modeling perspective, the mined Data Vault classification places this entity as hub-leaning. The table functions as a hub because it holds a stable, unique business key (COURSE_STATUS) that is referenced by other tables through foreign keys, rather than acting as a transactional link or a descriptive satellite. This classification should be treated as a modeling suggestion rather than a functional guarantee.

Key Information Stored

The table is documented with nine columns in ETRM 12.1.1. The most significant are:

  • COURSE_STATUS — the primary key column (surrogate/business key) and the value referenced by foreign keys elsewhere; also the column named in the unique index IGS_PS_STAT_U1.
  • DESCRIPTION — the user-facing, institution-defined label for the program status.
  • S_COURSE_STATUS — the system-defined status to which the user-defined status maps, providing the link back to delivered system functionality.
  • CLOSED_IND — indicator of whether the status represents a closed state.
  • CREATED_BY, CREATION_DATE — standard audit columns recording who created the record and when.
  • LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns capturing the most recent change and its source session.

The primary key is defined by IGS_PS_STAT_PK on COURSE_STATUS. A second unique index, IGS_PS_STAT_U1, also exists on COURSE_STATUS, confirming that column as the sole business-key candidate. The remaining columns are descriptive or audit-related and are not part of any documented unique constraint.

Common Use Cases and Queries

Typical uses include validating program status codes, resolving user-defined statuses to their system equivalents, and building reporting lookups. A basic retrieval joins the status table to the version table to translate codes into descriptions:

SELECT v.COURSE_STATUS, s.DESCRIPTION, s.S_COURSE_STATUS
FROM IGS_PS_VER_ALL v, IGS_PS_STAT s
WHERE v.COURSE_STATUS = s.COURSE_STATUS;

Reporting queries may filter by CLOSED_IND to separate active from closed statuses, or use S_COURSE_STATUS to aggregate institution-specific statuses into system-standard groupings. Because the table is documented as not implemented in all databases, extraction scripts should first verify existence in ALL_TABLES before referencing it.

Related Objects

The documented foreign-key relationship identifies IGS_PS_VER_ALL as the primary dependent table:

  • IGS_PS_VER_ALL — references IGS_PS_STAT through the COURSE_STATUS column (IGS_PS_VER_ALL.COURSE_STATUS → IGS_PS_STAT.COURSE_STATUS). It records program version data and is the main consumer of this lookup.
  • IGS_PS_STAT_PK — the primary key constraint enforcing uniqueness on COURSE_STATUS.
  • IGS_PS_STAT_U1 — the unique index on COURSE_STATUS, supporting both constraint enforcement and lookups.

Other IGS_PS_* base tables and their _ALL/_TL variants that carry a status code may also reference this table indirectly, but only the IGS_PS_VER_ALL relationship is confirmed in the supplied metadata.