Search Results igs_ad_visa_type_v




Overview
Explore in AI Chat

Overview

IGS_AD_VISA_TYPE_V is a reporting view owned by the APPS schema within the IGS (Student System) product family of Oracle E-Business Suite, valid in releases 12.1.1 and 12.2.2. Its purpose is to present a unified, profile-driven list of visa type values used in the admissions and student visa-tracking processes of the Oracle Student System. Rather than maintaining a single static list, the view dynamically selects its source based on the value of the IGS_EN_VISA_TYPE profile option, allowing institutions to choose between their own internally defined visa types and the seeded United States visa lookup values.

Because visa type codes are referenced throughout admissions processing—applicant registration, student records, and regulatory reporting—the view provides a normalized lookup layer that abstracts the physical source of the data. Reporting tools, concurrent programs, and integration interfaces can query the view without concern for which underlying table actually stores the active set of values.

Underlying Base Objects

The ETRM documentation for this view identifies two referenced data sources within its view text, though the documented base-object list is minimal:

These two branches are combined with a UNION, so each query against the view executes only one branch depending on the current profile value. The profile option acts as the switch that determines whether the institution's home-grown visa designations or the predefined US visa categories are surfaced. No additional join objects are documented in the ETRM metadata.

Key Columns

The view exposes two columns, both aliased consistently across the UNION branches so the result set has a uniform shape:

  • DESCRIPTION — the descriptive text for the visa type. In the 'O' branch this is the DESCRIPTION column from IGS_AD_VISA_TYPE; in the 'H' branch it is the MEANING column from FND_COMMON_LOOKUPS.
  • VISA_TYPE — the code or identifier for the visa type. In the 'O' branch this is the VISA_TYPE column; in the 'H' branch it is the LOOKUP_CODE.

Because both columns are character strings derived from lookup or descriptive data, the view is suited for presentation and selection lists rather than for transactional key resolution.

Common Use Cases and Queries

Typical scenarios include populating visa type list-of-values in admissions forms, joining to applicant or student visa records for regulatory extracts, and generating reference listings for administrative review. A simple query retrieving all active values is:

SELECT visa_type, description
FROM   apps.igs_ad_visa_type_v
ORDER  BY description;

To confirm which profile-driven branch is active for the current session:

SELECT fnd_profile.value('IGS_EN_VISA_TYPE') FROM dual;

Because the view's output depends on a profile option, any query invoked from a different responsibility or user context may return a different set of rows. Developers integrating with this view should therefore set or verify the profile option explicitly when deterministic results are required, and should account for the fact that the underlying sources—IGS_AD_VISA_TYPE and FND_COMMON_LOOKUPS—are the authoritative tables for maintenance and validation.