Search Results completion_perd

Overview

The IGS_EN_NOM_CMPL_PRD table is a setup and reference data table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the IGS (Oracle Student Management) product family. It serves as the master repository for defining Nominated Completion Periods. These periods are critical timeframes used to manage and track academic progression, particularly in processes related to graduation, certification, or course completion. The table's role is to provide a validated list of period codes that can be associated with student records and related academic workflows, ensuring data integrity and consistency across the student lifecycle.

Key Information Stored

The table stores the core definition for each completion period. The primary and most critical column is COMPLETION_PERD, a mandatory 30-character code that uniquely identifies the period. The DESCRIPTION column provides an 80-character explanatory name for the code. A key functional column is CLOSED_IND, which acts as a status flag to indicate whether the period is active or closed for further transactions or assignments, a common control mechanism in EBS. The table also includes standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) for audit purposes, tracking the user and timestamp of record creation and modification.

Common Use Cases and Queries

A primary use case is the maintenance of valid completion periods via an administration screen, where users can add new periods or close existing ones. This table is frequently referenced in student graduation processing, where a student's expected or actual completion term is validated against this list. Common reporting needs include listing all active periods or auditing setup changes. Sample queries include fetching all periods for a lookup list or checking the status of a specific period.

• Retrieve all active (non-closed) completion periods: SELECT COMPLETION_PERD, DESCRIPTION FROM IGS.IGS_EN_NOM_CMPL_PRD WHERE NVL(CLOSED_IND, 'N') = 'N';
• Find the description and status for a specific period code: SELECT DESCRIPTION, CLOSED_IND FROM IGS.IGS_EN_NOM_CMPL_PRD WHERE COMPLETION_PERD = '&PERIOD_CODE';

Related Objects

The table's integrity is enforced by a primary key constraint, IGS_EN_NOM_CMPL_PRD_PK, on the COMPLETION_PERD column. It is referenced as a foreign key by other transactional tables in the schema, creating a key data relationship. The documented foreign key relationship shows that the IGS_GR_CRM_ROUND_PRD table references IGS_EN_NOM_CMPL_PRD via its COMPLETION_PERIOD column. This indicates that nominated completion periods are used to define rounds or periods within the Graduation (GR) Ceremony (CRM) module, linking completion timelines to specific graduation events.