Search Results igs_en_nom_cmpl_prd




Overview
Explore in AI Chat

Overview

The table IGS_EN_NOM_CMPL_PRD is a configuration table within the Oracle E-Business Suite (EBS) Student System (IGS), which is noted as obsolete in the provided ETRM documentation for versions 12.1.1 and 12.2.2. It serves as the central repository for defining Nominated Completion Periods. These periods are likely administrative or academic timeframes used to manage and track student progression, potentially related to expected course or program completion timelines. Its role is to provide a standardized set of period codes that can be referenced by other transactional and setup entities within the Student System, ensuring data integrity and consistency across related processes.

Key Information Stored

Based on the provided metadata, the table's structure is centered on a primary key column that stores the unique identifier for a completion period. The most critical column is COMPLETION_PERD, which constitutes the table's primary key (IGS_EN_NOM_CMPL_PRD_PK). This column stores the unique code or identifier for each nominated completion period. While the ETRM excerpt does not list additional columns, typical setup tables in EBS often include descriptive fields (like a description or name), effective date ranges (START_DATE, END_DATE), and audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE). The core business data is the controlled list of valid period codes stored in the COMPLETION_PERD column.

Common Use Cases and Queries

The primary use case for this table is as a reference source for validating and describing completion periods used in other student lifecycle operations. Given its status as a setup table, common interactions would involve administrative maintenance and integration with reporting. A typical query would retrieve all active periods for use in a list of values (LOV) within a related form or interface. For example:

SELECT completion_perd FROM igs_en_nom_cmpl_prd ORDER BY completion_perd;

In a reporting context, it would be joined to transactional tables to translate period codes into meaningful descriptions for end-users. Since the metadata indicates the table is "Not implemented in this database," its practical use in a given instance may be limited or non-existent, and any custom reporting or integration would need to verify its population and status.

Related Objects

The ETRM relationship data specifies one documented foreign key relationship where IGS_EN_NOM_CMPL_PRD is referenced as a parent table. This defines a critical data dependency.

  • Table: IGS_GR_CRM_ROUND_PRD
    This table references IGS_EN_NOM_CMPL_PRD via the foreign key column IGS_GR_CRM_ROUND_PRD.COMPLETION_PERIOD. This relationship ensures that any completion period recorded in the IGS_GR_CRM_ROUND_PRD table (which likely manages rounds or cycles for processes like graduation) must be a valid value defined in the IGS_EN_NOM_CMPL_PRD setup table. The join condition for queries or data validation would be:
    IGS_GR_CRM_ROUND_PRD.COMPLETION_PERIOD = IGS_EN_NOM_CMPL_PRD.COMPLETION_PERD