Search Results igs_ad_visa_type




Overview
Explore in AI Chat

Overview

IGS_AD_VISA_TYPE is a secured (ORG_ID–filtered) view owned by the APPS schema in Oracle E-Business Suite, belonging to the IGS – Student System product family. Its name maps to the "Admissions" (AD) functional area, where it exposes the institution's catalogue of visa types — the coded values used to record a prospective or enrolled student's immigration or residency status (for example, student visa, permanent resident, or citizen categories). In EBS 12.1.1 and 12.2.2 the view is reported as VALID.

The view does not store data itself. It presents, in a multi-tenant–safe form, the rows of a single underlying table, hiding the base table's ORG_ID partitioning through a client-info–based predicate so that each operating unit sees only its own visa-type definitions. Because the object collapses the "_ALL" table into a logically single-organization view, it is the object typically queried by reports, concurrent programs, and forms that must be run in the context of one operating unit rather than across the whole enterprise.

Underlying Base Objects

The documented definition is a simple projection of the base table IGS_AD_VISA_TYPE_ALL. The view selects every column of that table plus the table's ROWID, aliased ROW_ID, and constrains the result to the current organization using the standard Multi-Org view mechanism. The predicate compares the row's ORG_ID to an ORG_ID derived from USERENV('CLIENT_INFO'): the first ten characters of CLIENT_INFO are converted to a number, with the special value –99 substituted when CLIENT_INFO is blank or begins with a space (that is, when no operating-unit context has been set). In effect, the view returns rows for the operating unit currently established for the session, and it returns the ORG_ID = –99 (or NULL-defaulted) rows when the session is not globalized. No other referenced base objects are documented.

Key Columns

  • ROW_ID — the base table ROWID, exposed for direct row identification and for use by downstream views or APIs.
  • ORG_ID — the operating unit that owns the visa-type definition; the primary Multi-Org discriminator for the row.
  • VISA_TYPE — the code identifying the visa category; the principal business key presented by the view.
  • DESCRIPTION — the descriptive text for the visa type, used for display and reporting.
  • CLOSED_IND — a flag indicating whether the visa type is closed to new use; closed values are normally excluded from list-of-values but retained for historical records.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard WHO audit columns recording creation and last modification of the row.

Common Use Cases and Queries

Typical uses include validating or displaying a visa type on an admissions record, populating list-of-values restricted to active entries, and joining visa types to applicant or person data for statutory reporting on international students. The following samples assume the session has already initialized the operating-unit context (for example, via FND_GLOBAL.APPS_INITIALIZE), since the ORG_ID predicate depends on the client-info setting.

SELECT visa_type, description FROM igs_ad_visa_type WHERE closed_ind = 'N' ORDER BY visa_type;

SELECT org_id, visa_type, description, closed_ind FROM igs_ad_visa_type WHERE visa_type = :visa_type;

For cross-operating-unit or diagnostic queries, the base table IGS_AD_VISA_TYPE_ALL should be used instead, because the secured view deliberately filters the result set. Queries against IGS_AD_VISA_TYPE executed without an established client-info context will resolve to the –99 organization and may return no rows, which is a frequent source of confusion in ad-hoc reporting.