Search Results igs_en_intm_types




Overview
Explore in AI Chat

Overview

IGS_EN_INTM_TYPES is a reference (lookup) table in the IGS – Student System product of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It stores the institution-defined intermission types and their descriptions. An intermission, in the Oracle Student System model, is an approved interruption in a student's programme of study — for example, a medical, compassionate, or personal leave of absence. The table therefore supplies the controlled vocabulary that qualifies how and why a student's registration is suspended for a period, and it drives the associated rules governing whether approval is required and whether study at another institution may be counted.

The documented structure is deliberately narrow: a single business attribute, INTERMISSION_TYPE, is qualified by a description and a small number of indicator flags. From a data-modelling perspective, the ETRM metadata classifies this object as hub-leaning. Taken as a suggestion rather than a directive, this means IGS_EN_INTM_TYPES behaves as a stable list of business keys — each intermission type is a durable concept that is referenced rather than updated, making it a suitable hub candidate in a Data Vault model, with the descriptive columns and audit attributes forming sat-ellite-like content around it.

Key Information Stored

The table is documented with ten columns. The most significant are:

  • INTERMISSION_TYPE — the business key and the column on which the unique index IGS_EN_INTM_TYPES_U1 (and the primary key constraint IGS_EN_INTM_TYPES_UK) is defined. It holds the short code identifying the intermission category.
  • DESCRIPTION — the human-readable name or explanation presented to users, typically rendered in lists of values and on student records.
  • APPR_REQD_IND — a flag indicating whether an approval workflow or authorisation step is mandatory before the intermission can be granted.
  • STUDY_ANTR_INST_IND — a flag indicating whether study undertaken at another institution during the intermission is permitted or recognised.
  • CLOSED_IND — an end-dating or availability flag; when set, the type is retired from active selection while remaining valid for historical records.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Oracle Applications audit columns recording row creation and last modification.

No separate surrogate primary key column is documented; the primary key is the natural business key INTERMISSION_TYPE, which makes the table compact and easily joined.

Common Use Cases and Queries

The primary use case is populating the intermission type list of values on the student intermission entry form, and validating the value selected against the reference table. A typical validation or lookup query is:

  • SELECT intermission_type, description FROM igs_en_intm_types WHERE NVL(closed_ind,'N') = 'N' ORDER BY description;
  • Reporting the distribution of intermissions by type, joining to the transactional table: SELECT t.description, COUNT(*) FROM igs_en_stdnt_ps_intm i, igs_en_intm_types t WHERE i.intermission_type = t.intermission_type GROUP BY t.description;
  • Identifying types requiring authorisation: SELECT intermission_type, description FROM igs_en_intm_types WHERE appr_reqd_ind = 'Y';
  • Data-quality checks for orphaned or retired types still in use: SELECT i.intermission_type FROM igs_en_stdnt_ps_intm i WHERE NOT EXISTS (SELECT 1 FROM igs_en_intm_types t WHERE t.intermission_type = i.intermission_type);

Because the table is small and static, it is commonly extracted into reporting and warehouse layers as a dimension for student progression and retention analysis.

Related Objects

The documented foreign-key relationship identifies one dependent transactional table:

  • IGS_EN_STDNT_PS_INTM — the student programme-of-study intermission table, joined on IGS_EN_STDNT_PS_INTM.INTERMISSION_TYPE = IGS_EN_INTM_TYPES.INTERMISSION_TYPE. This is the principal consumer of the reference data and the source of intermission records attached to a student's programme attempt.

In practice, the reference values are surfaced through the Student System intermission setup and maintenance forms and their associated list-of-values definitions, and through any customer-built concurrent programs or reports that aggregate intermission activity. Administrators maintain the contents of IGS_EN_INTM_TYPES during implementation, and typically set CLOSED_IND rather than deleting rows so that historical intermission records remain referentially intact.