Search Results intermission_type




Overview
Explore in AI Chat

Overview

IGS.IGS_EN_INTM_TYPES is a reference (lookup) table in the Oracle E-Business Suite student information model, owned by the IGS (Student Systems) schema. It stores the valid catalogue of intermission types available to the institution, together with descriptive text and control flags that determine how each intermission type behaves during processing. Intermission in this context refers to an approved break in a student's programme of study, and the type recorded against a student determines whether approval workflow is triggered and whether the intermission is taken in order to study at another institution.

The table is registered as FND Design Data under the identifier IGS.IGS_EN_INTM_TYPES and holds a VALID status in the ETRM 12.1.1 / 12.2.2 object inventory. Physically it resides in the APPS_TS_TX_DATA tablespace with PCTFREE 10, and its unique index IGS_EN_INTM_TYPES_U1 is stored separately in APPS_TS_TX_IDX. The object carries no foreign key dependencies of its own, which is characteristic of a reference table that constrains rather than consumes data.

From a dimensional or Data Vault modelling perspective, the mined relationship structure classifies this object as hub-leaning. It is therefore best treated as a hub candidate, with INTERMISSION_TYPE as the natural business key, and the descriptive and flag attributes carried either on the hub or on a companion satellite depending on historisation requirements.

Key Information Stored

The table contains ten documented columns. The business-key candidate is INTERMISSION_TYPE, a mandatory VARCHAR2(25) column enforced by the unique index IGS_EN_INTM_TYPES_U1 and identified in the relationship metadata as the primary key IGS_EN_INTM_TYPES_UK. There is no separate surrogate key column in the documented schema; application code and foreign keys refer to the type by this code value.

  • INTERMISSION_TYPE — the user-defined code identifying the intermission type; the unique business key of the table.
  • DESCRIPTION — VARCHAR2(90) free-text description of the intermission type, typically surfaced in list of values and enquiry screens.
  • APPR_REQD_IND — indicates whether approval is required before an intermission of this type can be granted.
  • STUDY_ANTR_INST_IND — indicates whether the intermission is taken in order to study at another institution.
  • CLOSED_IND — indicates whether the intermission type is still valid for new use or has been closed to further selection.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard WHO audit columns recording insert and update context.

The three indicator columns are the principal behavioural controls: they allow the institution to define, for example, an intermission type that requires committee approval, a type that permits study elsewhere, and a type that has been retired from active use without deleting historical student records.

Common Use Cases and Queries

The most frequent use is populating a validation list of active intermission types for entry against a student's programme record, filtering on CLOSED_IND so that obsolete codes are not offered:

  • SELECT INTERMISSION_TYPE, DESCRIPTION FROM IGS.IGS_EN_INTM_TYPES WHERE NVL(CLOSED_IND,'N') = 'N' ORDER BY INTERMISSION_TYPE;
  • Identifying types that require approval: SELECT INTERMISSION_TYPE, DESCRIPTION FROM IGS.IGS_EN_INTM_TYPES WHERE APPR_REQD_IND = 'Y';
  • Identifying types associated with study at another institution: SELECT INTERMISSION_TYPE, DESCRIPTION FROM IGS.IGS_EN_INTM_TYPES WHERE STUDY_ANTR_INST_IND = 'Y';
  • Extract and audit patterns joining the type to student records: SELECT i.INTERMISSION_TYPE, t.DESCRIPTION, i.STUDENT_PERSON_NUMBER FROM IGS.IGS_EN_STDNT_PS_INTM i, IGS.IGS_EN_INTM_TYPES t WHERE i.INTERMISSION_TYPE = t.INTERMISSION_TYPE;

Reporting use cases include counting intermissions by type for a given academic period, reconciling approval-required intermissions against pending workflow items, and validating that no active student record references a CLOSED_IND type.

Related Objects

The documented dependency data identifies a single consuming object, but the table should be considered together with the following:

  • IGS.IGS_EN_STDNT_PS_INTM — the student intermission record table; its INTERMISSION_TYPE column is a foreign key referencing IGS_EN_INTM_TYPES.
  • IGS_EN_INTM_TYPES_U1 — the unique index on INTERMISSION_TYPE in APPS_TS_TX_IDX, enforcing the business key.
  • APPS.IGS_EN_INTM_TYPES — the APPS synonym through which the table is normally queried by forms, concurrent programs, and reports.

Because the object neither references nor is referenced by any other database object beyond the student intermission table, changes to its contents should be coordinated primarily with IGS_EN_STDNT_PS_INTM and with the intermission setup forms that maintain the type list.