Search Results open_for_enrollments

Overview

IGS_LOOKUPS_VIEW is an APPS-owned database view in the Oracle E-Business Suite Student System (IGS) product. It joins Oracle Application Object Library lookup values against IGS-specific lookup extension attributes to produce a single, denormalized result set describing every lookup code used throughout the Student System. The view carries a VALID status in both 12.1.1 and 12.2.2 and is identified by view application ID 8405, with the filter SECURITY_GROUP_ID = 0 and LANGUAGE = USERENV('LANG'), which restricts output to the session language and the standard (non-secured) lookup set.

Because IGS functionality is driven almost entirely by lookup codes (enrollment statuses, progression outcomes, step types, fee assessment rules, and so on), this view acts as a reference dictionary for the module. It is used in reports, forms, concurrent programs, and integration interfaces to resolve a stored LOOKUP_CODE into its display MEANING and to expose behavioral flags that determine how each code is processed by the Student System engine. The column SYSTEM_GENERATED_IND in particular indicates whether a given lookup value is created and managed by the application rather than by a user, which is central to controlling which codes are selectable in setup and data-entry screens.

Underlying Base Objects

The view is defined over two base objects:

• FND_LOOKUP_VALUES (aliased LV) — the standard EBS lookup values table, supplying LOOKUP_TYPE, LOOKUP_CODE, MEANING, ENABLED_FLAG, DESCRIPTION, and the active date range.
• IGS_LOOKUPS_VAL (aliased LT) — the IGS extension table that stores Student System-specific attributes keyed by LOOKUP_TYPE and LOOKUP_CODE.

The join is an outer join on both key columns (LT.LOOKUP_TYPE(+) and LT.LOOKUP_CODE(+)), so every enabled IGS lookup value returned from FND_LOOKUP_VALUES appears even where no IGS extension row exists. The view is filtered to VIEW_APPLICATION_ID = 8405, isolating the Student System application's lookups from other EBS products that share the same underlying lookup tables. The CLOSED_IND column is a derived value produced by a DECODE on ENABLED_FLAG — 'Y' when the lookup is disabled and 'N' when it is enabled — providing an inverted flag for consumers that expect a "closed" rather than "enabled" indicator.

Key Columns

• LOOKUP_TYPE / LOOKUP_CODE — the composite key identifying each lookup value.
• MEANING / DESCRIPTION — the translatable, user-facing label and longer description.
• ENABLED_FLAG and derived CLOSED_IND — active/retired state of the lookup value.
• SYSTEM_GENERATED_IND — indicates a value created and maintained by the application rather than entered by a user; typically used to protect system codes from modification or deletion.
• SYSTEM_CALCULATED, SYSTEM_MANDATORY_IND — flags controlling whether the value is computed by the system or is required during processing.
• SECURITY_ALLOWED_IND, STEP_TYPE_RESTRICTION_NUM_IND — control exposure of the value in secured and step-restricted contexts.
• DISPLAY_NAME, DISPLAY_ORDER, DEFAULT_DISPLAY_SEQ — govern presentation order and labeling in the UI.
• Behavioral indicators such as UNIT_OUTCOME_IND, ACADEMIC_TRANSCRIPT_IND, FINAL_RESULT_IND, FEE_ASS_IND, CMPLTN_REQUIREMENTS_IND, STEP_ORDER_APPLICABLE_IND, OPEN_FOR_ENROLLMENTS, ENCUMBRANCE_LEVEL, and TRANSACTION_CAT — each drives a specific Student System processing rule.
• Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) — audit trail.

Common Use Cases and Queries

The principal use case is resolving codes to meanings and inspecting system-controlled attributes during reporting or troubleshooting. Typical scenarios include listing all system-generated values for a lookup type, auditing which codes are enabled, or joining the view to transactional IGS tables to present readable labels.

SELECT lookup_type, lookup_code, meaning, enabled_flag,
       system_generated_ind, system_mandatory_ind
FROM   apps.igs_lookups_view
WHERE  lookup_type = '&LOOKUP_TYPE'
AND    system_generated_ind = 'Y'
ORDER  BY display_order, lookup_code;

To identify all IGS lookup values that remain active for the current session language, the ENABLED_FLAG column can be filtered directly; the inverted CLOSED_IND is provided for legacy consumers that test for a closed state:

SELECT lookup_type, lookup_code, meaning
FROM   apps.igs_lookups_view
WHERE  enabled_flag = 'Y'
AND    closed_ind = 'N'
ORDER  BY lookup_type, display_order;

Integration interfaces commonly select the behavioral flags alongside the descriptive columns so that downstream systems receive both the code and the processing rules — for example, extracting all enrollment-related values where OPEN_FOR_ENROLLMENTS = 'Y', or all transcript-bearing outcomes where ACADEMIC_TRANSCRIPT_IND = 'Y'. Because the view already applies the language and application filters, callers do not need to re-implement those predicates, which reduces drift between custom reports and the delivered Student System logic.