Search Results s_reference_cd_type




Overview
Explore in AI Chat

Overview

The view IGS_GE_REF_CD_TYPE_V belongs to the Oracle E-Business Suite Student System (IGS) product family. It exposes reference code type definitions used by the general (GE) component of the Student System to categorize and govern the various reference codes that applicants and students may select during self-service enrolment and admissions activities. In EBS 12.1.1 and 12.2.2 the IGS product is treated as obsolete and, as the ETRM metadata records, the object is documented as "Not implemented in this database." Consequently the view is preserved for historical reference, migration analysis, and upgrade impact assessment rather than for use in active production reporting.

The view presents one row per reference code type, combining the descriptive attributes stored on the base type table with a decoded lookup meaning obtained from the IGS lookups view. Its principal role in the EBS integration layer is to provide a denormalized, business-friendly projection of reference code type metadata so that concurrent programs, enrolment APIs, and legacy reports can resolve codes to user-facing descriptions without additional joins.

Underlying Base Objects

The view is defined over two documented objects: the base table IGS_GE_REF_CD_TYPE (aliased RCT) and the lookups view IGS_LOOKUPS_VIEW (aliased ILV). The join is an inner equijoin on ILV.LOOKUP_CODE = RCT.S_REFERENCE_CD_TYPE with the constant predicate ILV.LOOKUP_TYPE = 'REFERENCE_CD_TYPE'. This means every row returned by the view has a matching seeded or user-defined lookup value in the REFERENCE_CD_TYPE lookup type; reference code types whose lookup code is absent from the lookups view are silently excluded.

The ETRM metadata documents no other referenced base objects, and the owner is not recorded. The ROW_ID column is derived from RCT.ROWID, indicating the row identifier of the underlying base table row rather than a surrogate key owned by the view.

Key Columns

Common Use Cases and Queries

Typical scenarios include auditing which reference code types remain open, validating that self-service enumerations are complete, and cross-checking legacy IGS configuration before migration to a successor student system.

SELECT reference_cd_type,
       dsp_meaning,
       description,
       closed_ind,
       self_service_flag
FROM   igs_ge_ref_cd_type_v
WHERE  closed_ind = 'N';

SELECT reference_cd_type,
       dsp_meaning,
       mandatory_flag,
       restricted_flag
FROM   igs_ge_ref_cd_type_v
WHERE  self_service_flag = 'Y'
ORDER  BY dsp_meaning;

Because the object is documented as not implemented, these queries should be treated as reference patterns for environments where the view is present. On EBS 12.2.2 installations the view text and column list remain consistent, supporting static analysis and comparison exercises during upgrade or decommissioning projects.