Search Results igs_uc_ref_codetyps

Overview

The IGS_UC_REF_CODETYPS table is a core reference data structure within the Oracle E-Business Suite (EBS) Student System (IGS). Its primary role is to define and maintain the distinct categories or types of reference codes used throughout the application. It acts as a master list, ensuring data integrity by controlling the valid code types that can be entered into the related IGS_UC_REF_CODES table, which holds the actual code values. This relationship is fundamental for implementing standardized, validated lookup values across student system modules. Critically, the official ETRM documentation explicitly marks this table as OBSOLETE, indicating it is no longer actively developed or recommended for new customizations in versions 12.1.1 and 12.2.2, though it may remain present for backward compatibility.

Key Information Stored

The table's structure is centered on the unique identification of code types. Based on its primary key definition, the central column is CODE_TYPE. This column stores the short, typically alphanumeric, identifier for a category of reference data. Examples could include code types for 'NATIONALITY', 'ETHNICITY', 'MARITAL_STATUS', or 'COUNTRY'. The table's purpose is to house the authoritative list of these type values. While the provided metadata does not list additional columns, such a table would commonly include descriptive fields (e.g., DESCRIPTION, ACTIVE_FLAG) and standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE) for auditing, though these are not confirmed in the excerpt.

Common Use Cases and Queries

The primary historical use case was to manage and query the universe of available reference code types for setup, validation, and reporting purposes. Common operational queries would involve joining this table with IGS_UC_REF_CODES to generate complete lists of valid values. For instance, an administrator might need a report of all active codes for a specific type. A typical SQL pattern would be:

• SELECT rct.code_type, rc.code, rc.description FROM igs_uc_ref_codetyps rct, igs_uc_ref_codes rc WHERE rct.code_type = rc.code_type AND rct.code_type = 'NATIONALITY' ORDER BY rc.code;

Given its obsolete status, direct interaction with this table for new developments is discouraged. Customizations should instead utilize the standard Oracle Applications lookup and reference code frameworks (e.g., FND_LOOKUP_TYPES). Queries against this table in a live environment are now most likely for data migration analysis, legacy support, or understanding historical data relationships.

Related Objects

The table has a direct, documented relationship with the IGS_UC_REF_CODES table, which is its main consumer. The relationship is enforced by a foreign key constraint.

• IGS_UC_REF_CODES: This child table references IGS_UC_REF_CODETYPS via its CODE_TYPE column. The foreign key (IGS_UC_REF_CODES.CODE_TYPE → IGS_UC_REF_CODETYPS.CODE_TYPE) ensures that every code in the IGS_UC_REF_CODES table is associated with a valid, pre-defined code type from the IGS_UC_REF_CODETYPS master table.

The primary key IGS_UC_REF_CODETYPS_PK on the CODE_TYPE column is the anchor for this relationship. No other tables are documented as having foreign keys referencing this obsolete object.