Search Results self_service_flag

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:

• IGS_GE_REF_CD_TYPE — the driving base table (aliased RCT) that stores each reference code type, its description, applicability flags, status, and audit columns. It supplies every column except the decoded lookup attributes, and also the ROWID exposed as ROW_ID.
• IGS_LOOKUPS_VIEW — the lookup view (aliased ILV) used to resolve the internal code in S_REFERENCE_CD_TYPE to a human-readable value. The join is constrained to ILV.LOOKUP_TYPE = 'REFERENCE_CD_TYPE' and ILV.LOOKUP_CODE = RCT.S_REFERENCE_CD_TYPE, producing the columns DSP_MEANING and DSP_CLOSED_IND.

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

• REFERENCE_CD_TYPE — the primary reference code type identifier.
• DESCRIPTION — the descriptive text for the code type.
• S_REFERENCE_CD_TYPE — the system reference code type used to join to lookups.
• UNIT_FLAG — indicates whether the reference code type is applicable to teaching units.
• PROGRAM_FLAG, PROGRAM_OFFERING_OPTION_FLAG, UNIT_SECTION_FLAG, UNIT_SECTION_OCCURRENCE_FLAG — entity applicability flags mirroring the same pattern across the other higher-education entities.
• SELF_SERVICE_FLAG — denotes whether the code type is exposed in self-service functions.
• MANDATORY_FLAG, RESTRICTED_FLAG — indicate whether usage is required or constrained.
• CLOSED_IND — whether the base record is closed; DSP_CLOSED_IND — the corresponding closed indicator from the lookup view.
• DSP_MEANING — decoded, report-friendly meaning of the system reference code type.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard auditing 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.