Search Results program_offering_option_flag

Overview

IGS_GE_REF_CD_TYPE is a reporting and integration view owned by the APPS schema within the IGS - Student System product family of Oracle E-Business Suite. In EBS 12.1.1 and 12.2.2, the view exposes the reference code type definitions used by the student system to categorize and control the reference codes that drive admission, enrollment, and program structure processing. Reference code types act as the master groupings under which individual reference codes (for example, fee statuses, applicant categories, or program attributes) are organized and made available to functional flows.

The view presents a filtered, security-aware projection of its underlying table. Rather than returning all rows unconditionally, it applies an ORG_ID (operating unit) predicate driven by the session's CLIENT_INFO value, ensuring that a querying session only sees reference code type rows that belong to the current operating unit context. This makes the view suitable for embedded use in forms, concurrent programs, and integration extracts where multi-org isolation is required without additional application logic.

Underlying Base Objects

The view is defined over the single base table IGS_GE_REF_CD_TYPE_ALL, which is the multi-organization "ALL" table storing the full set of reference code type definitions across operating units. Each column in the view maps directly, one-to-one, to a column in the base table, with the exception that ROW_ID is derived from the table's ROWID pseudocolumn rather than being a stored column. Documentation for the referenced base objects is limited, but the naming convention and the presence of ORG_ID confirm the standard multi-org partitioning model used throughout the IGS schema. Because the view does not join to any additional tables, it functions as a thin, governed access layer rather than a denormalized reporting structure.

Key Columns

• ROW_ID — the physical ROWID of the underlying base table row, exposed for update-through-view and optimistic locking scenarios.
• ORG_ID — the operating unit identifier used by the view's WHERE clause to enforce multi-org security.
• REFERENCE_CD_TYPE and S_REFERENCE_CD_TYPE — the code and its short/system code for the reference code type.
• DESCRIPTION — the descriptive text displayed to users.
• CLOSED_IND — indicates whether the reference code type is closed and therefore unavailable for new assignments.
• SELF_SERVICE_FLAG — controls availability of the type within self-service (web) user interfaces.
• PROGRAM_FLAG, PROGRAM_OFFERING_OPTION_FLAG, UNIT_FLAG, UNIT_SECTION_FLAG, UNIT_SECTION_OCCURRENCE_FLAG — flags indicating the levels of the academic hierarchy to which the reference code type applies (program, offering option, unit, unit section, and occurrence).
• MANDATORY_FLAG and RESTRICTED_FLAG — control whether a reference code of this type must be supplied and whether the available values are constrained.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN provide standard EBS audit trail attributes.

Common Use Cases and Queries

Typical use cases include determining which reference code types are available for a given operating unit, identifying which types are applicable to a specific academic hierarchy level, and supporting self-service configuration. The following query lists active, self-service-enabled types for the current operating unit:

• SELECT reference_cd_type, description, closed_ind FROM igs_ge_ref_cd_type WHERE closed_ind = 'N' AND self_service_flag = 'Y' ORDER BY reference_cd_type;
• SELECT reference_cd_type, description FROM igs_ge_ref_cd_type WHERE program_flag = 'Y' AND restricted_flag = 'Y';
• SELECT reference_cd_type, unit_flag, unit_section_flag, unit_section_occurrence_flag FROM igs_ge_ref_cd_type WHERE mandatort_flag = 'Y';

Because the view relies on USERENV('CLIENT_INFO') for its ORG_ID filter, queries executed outside a properly initialized EBS session may return only the -99 (global) rows or no rows at all; integrations should therefore invoke the view from within an initialized EBS database session using the standard FND client-info initialization APIs.