Search Results unit_flag




Overview
Explore in AI Chat

Overview

APPS.IGS_GE_REF_CD_TYPE_V is a reporting view within the Oracle E-Business Suite (EBS) Student Systems / Student Information Management (formerly Oracle Student System, OSS) schema, owned by the IGS product family. Its name derives from "Reference Code Type" (REF_CD_TYPE) and it belongs to the general (GE) functional group. The view presents the set of configurable reference code types used to categorise and structure higher-education reference data, and it enriches the base transaction table with a decoded lookup meaning so that reporting and integration layers do not need to join to the lookup view themselves.

The primary role of this view is to expose reference code type configuration — including which business entities (programs, program offerings, unit offerings, unit sections, and unit section occurrences) each code type applies to — together with display-oriented fields such as the decoded meaning. The column UNIT_FLAG, which prompted the search, indicates whether a given reference code type is valid for use against unit (i.e. teaching unit / subject) records.

Underlying Base Objects

The view is defined over two objects joined in a single SELECT statement:

The ROW_ID pseudo-column supports views consumed by Oracle Forms / OA Framework for updatable query semantics, though the underlying data should generally be treated as configuration master data rather than transactional data.

Key Columns

Common Use Cases and Queries

Typical uses include validating configurations prior to data load, driving Flexfield or LOV behaviour, and feeding downstream reports that require the decoded meaning. The UNIT_FLAG column is frequently queried to determine which reference code types may legitimately be assigned to unit records.

  • List all code types valid for units: SELECT reference_cd_type, description, dsp_meaning FROM igs_ge_ref_cd_type_v WHERE unit_flag = 'Y';
  • Identify active, non-closed code types available for program offerings: SELECT reference_cd_type, description FROM igs_ge_ref_cd_type_v WHERE program_offering_option_flag = 'Y' AND closed_ind = 'N';
  • Audit recent configuration changes: SELECT reference_cd_type, last_updated_by, last_update_date FROM igs_ge_ref_cd_type_v ORDER BY last_update_date DESC;

Because the view already performs the lookup join, report queries against DSP_MEANING avoid a redundant lookup join and reduce execution complexity across EBS 12.1.1 and 12.2.2.