Search Results code_classes_id




Overview
Explore in AI Chat

Overview

The IGS_PE_CODE_CLASSES table is a core reference data repository within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the IGS (Oracle Higher Education) product family. It functions as a flexible, user-defined code lookup mechanism, centralizing the storage of various classification codes used across the Person (PE) entity. Its primary role is to provide a normalized, maintainable source for standardized values that describe attributes of a person, such as residency status, military service types, or disability support levels. By consolidating these codes into a single table keyed by CODE_CLASSES_ID, it enforces data integrity and simplifies application logic for code validation and display.

Key Information Stored

The table structure is designed to manage discrete code values organized into logical groups. The CODE_CLASSES_ID column serves as the unique, system-generated primary key for each record. The CLASS column defines the category or domain of the code (e.g., 'RELIGION', 'RESIDENCY_STATUS'), while the CODE column stores the specific value within that class. The DESCRIPTION provides the meaningful text for the code. A critical operational column is CLOSED_IND, which acts as an active/inactive flag, allowing administrators to retire codes without purging historical data. The table also includes standard Oracle EBS "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) for audit tracking.

Common Use Cases and Queries

This table is predominantly used for data validation, application drop-down list population, and reporting. A common operational query is to retrieve all active codes for a specific class to populate a form field. For example, to get a list of active residency statuses for use in a student admissions screen:

  • SELECT CODE, DESCRIPTION FROM IGS.IGS_PE_CODE_CLASSES WHERE CLASS = 'RESIDENCY_STATUS' AND CLOSED_IND = 'N' ORDER BY CODE;

Another frequent use case is in reporting joins, where transactional tables store only the CODE_CLASSES_ID foreign key. To generate a readable report on student disabilities with support level descriptions, a query would join IGS_PE_PERS_DISABLTY to IGS_PE_CODE_CLASSES on the SUPPORT_LEVEL_ID. Administrators may also run queries to audit code usage before marking a code as closed (CLOSED_IND = 'Y').

Related Objects

The IGS_PE_CODE_CLASSES table is a foundational reference point for numerous transactional tables, as evidenced by its foreign key relationships. Its primary key, CODE_CLASSES_ID, is referenced by columns in key person-related tables. Major relationships include:

These relationships demonstrate the table's integral role in standardizing person attribute data across the IGS modules.