Search Results igs_pe_visa_v




Overview
Explore in AI Chat

Overview

IGS_PE_VISA_V is a reporting view in the Oracle E-Business Suite IGS (Student System) product, which is documented as obsolete in ETRM. Its stated purpose is to retrieve all information on the visas that are stored for a person, consolidating visa detail held at the person level with related passport, lookup, territory, agent organization, and agent person descriptive data. The view is intended for read-only reporting and integration rather than transactional maintenance; the underlying visa records are maintained in IGS_PE_VISA, while the view supplies the denormalised presentation layer.

In the context of the user search term "visa_issuing_post", the view is significant because it exposes both the raw code column VISA_ISSUING_POST and a decoded meaning column, VISA_ISSUING_POST_M. That pairing allows reports to show a human-readable issuing post without a separate lookup join.

Underlying Base Objects

The view is defined over six objects using Oracle outer-join (+) syntax:

All joins are outer joins, so visa rows are retained even where agent, passport, lookup, or territory detail is absent. No referenced base objects are separately documented for 12.2.2, and the object is not implemented in this database.

Key Columns

Common Use Cases and Queries

Typical scenarios include visa register reporting, expiry monitoring, and integration extracts to immigration or compliance systems. To list visas by issuing post for a person:

SELECT person_id, visa_number, visa_type,
       visa_issuing_post, visa_issuing_post_m,
       visa_issuing_country_desc
FROM   igs_pe_visa_v
WHERE  person_id = :p_person_id;

To find visas approaching expiry:

SELECT person_id, visa_number, visa_expiry_date
FROM   igs_pe_visa_v
WHERE  visa_expiry_date BETWEEN SYSDATE AND SYSDATE + 90;

Because IGS is obsolete, replacement solutions such as Oracle Campus Solutions should be used for new development; existing queries remain valid against historical data where the view is deployed.