Results for “closed_ind”

50+ results




Overview
Explore in AI Chat

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

Overview

IGS_PS_GOVT_SPL_TYPE is a reference (lookup) table within the Oracle E-Business Suite Student System (IGS) product family, historically used to catalog the government-defined set of special program types associated with academic programs. Its stated purpose in the ETRM documentation is to describe the government classification of special program types, which are used to tag academic program versions for regulatory, funding, or compliance reporting against government-defined categories. The object is documented as obsolete and the metadata explicitly states "Not implemented in this database," indicating that in Oracle EBS 12.1.1 and 12.2.2 deployments the table is typically absent or present only as a legacy residue of earlier Student System releases.

From a Data Vault modeling perspective, the metadata's heuristic classification is hub-leaning. This means the table behaves primarily as a hub: it anchors a distinct business concept—the government special course type—through a stable, unique business key (GOVT_SPECIAL_COURSE_TYPE). Its descriptive attributes (such as DESCRIPTION and CLOSED_IND) would ordinarily be modeled as a satellite on that hub, while its usage from other entities forms a link relationship.

Key Information Stored

The table's documented physical schema for ETRM 12.1.1 comprises eight columns, owned by the IGS schema. The most significant columns are:

  • GOVT_SPECIAL_COURSE_TYPE — The unique business identifier for each government special course type. It serves as both the primary key (IGS_PS_GOVT_SPL_TYPE_PK) and the sole business-key candidate defined by the unique index IGS_PS_GOVT_SPL_TYPE_U1.
  • DESCRIPTION — The human-readable label or long description of the government special course type, used for display and reporting.
  • CLOSED_IND — A status flag indicating whether a given government special course type is closed to new use, allowing historical values to be retained while preventing selection for new program versions.
  • CREATED_BY, CREATION_DATE — Standard EBS audit columns capturing the creating user and timestamp.
  • LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns capturing the last modification user, timestamp, and session login.

Notably, no separately generated surrogate key is documented; the business key GOVT_SPECIAL_COURSE_TYPE itself functions as the primary key, which simplifies joins but couples the identifier to business semantics.

Common Use Cases and Queries

Because the table is obsolete and not implemented in current databases, its practical uses are confined to legacy migration analysis, historical reporting, and archaeology of older Student System data models. Typical patterns include retrieving the full active lookup set, verifying closure status, and joining to program versions:

  • Listing active government special types: SELECT govt_special_course_type, description FROM igs_ps_govt_spl_type WHERE closed_ind = 'N';
  • Resolving program versions to their government type: join IGS_PS_VER_ALL to this table on GOVT_SPECIAL_COURSE_TYPE.
  • Auditing changes over time using LAST_UPDATE_DATE and LAST_UPDATED_BY.

Related Objects

The documented foreign-key relationship identifies the key dependent object:

  • IGS_PS_VER_ALL — The program version base table, which carries the foreign key column GOVT_SPECIAL_COURSE_TYPE referencing IGS_PS_GOVT_SPL_TYPE. This is the primary consumer of the government special type values. Join condition: IGS_PS_VER_ALL.GOVT_SPECIAL_COURSE_TYPE = IGS_PS_GOVT_SPL_TYPE.GOVT_SPECIAL_COURSE_TYPE.

No other tables, views, or APIs are documented as referencing this object. Related program-version views and the IGS program versioning APIs inherit the dependency transitively through IGS_PS_VER_ALL.