Search Results psprt_issuing_cntry_code

Overview

IGS_SV_EV_TRAVEL_BLK_V is an Oracle E-Business Suite view owned by the APPS schema within the IGS (Student System) product family. It is defined as a view for fetching legal information for Exchange Visitor students, exposing passport, visa, and entry-related data that institutions must report when managing international student records under the Exchange Visitor program. In Oracle EBS 12.1.1 and 12.2.2, the view serves as a read-only reporting and integration layer, presenting a denormalized, business-friendly projection of legal information rather than requiring callers to join the underlying staging tables directly. The view is marked VALID, indicating that it resolves cleanly against its base objects in the documented environment.

Because the view filters its results by batch tag and administrative action code, it is oriented toward batch-driven processes — specifically records that have been tagged as legal information and whose administrative action has been set to "SEND". This makes it suitable for downstream processes such as SEVIS-related batch extracts, travel block reporting, and letter or form generation where only actionable, ready-to-send legal records should be considered.

Underlying Base Objects

The view is defined over two tables in the IGS schema: IGS_SV_LEGAL_INFO (aliased LGL) and IGS_SV_BTCH_SUMMARY (aliased LEGALSUMM). The two are joined on both PERSON_ID and BATCH_ID, establishing a one-to-one (or at least keyed) relationship between a person's legal record and the corresponding batch summary row.

The join is further constrained by two predicates on IGS_SV_BTCH_SUMMARY: TAG_CODE must equal the literal 'SV_LEGAL' and ADM_ACTION_CODE must equal 'SEND'. Consequently, the view does not expose all legal records; it exposes only those legal records whose associated batch summary carries the legal tag and is in the send administrative state. The columns are projected directly from IGS_SV_LEGAL_INFO without transformation, so the view is a filtered, keyed join rather than an aggregated or computed result set.

Key Columns

The view exposes fifteen columns, all sourced from IGS_SV_LEGAL_INFO:

• BATCH_ID and PERSON_ID — the batch and person identifiers forming the join keys to IGS_SV_BTCH_SUMMARY.
• PRINT_FORM — indicator governing form printing for the record.
• PSPRT_NUMBER, PSPRT_ISSUING_CNTRY_CODE, PSPRT_EXP_DATE — passport number, issuing country, and expiry date.
• VISA_NUMBER, VISA_ISSUING_POST, VISA_ISSUING_CNTRY_CODE, VISA_ISSUE_DATE, VISA_EXPIRATION_DATE — visa identification and issuance details. VISA_ISSUING_CNTRY_CODE is the column most commonly targeted by searches for visa issuing country information.
• I94_NUMBER, PORT_OF_ENTRY, DATE_OF_ENTRY — arrival and entry documentation details.
• REMARKS — free-text remarks associated with the legal record.

Common Use Cases and Queries

Typical uses include batch extraction of Exchange Visitor legal data for regulatory reporting, generation of travel/visa documentation, and audit queries that reconcile legal information against batch summary states. A common scenario is retrieving all send-ready legal records for a batch:

• SELECT person_id, psprt_number, visa_number, visa_issuing_cntry_code FROM igs_sv_ev_travel_blk_v WHERE batch_id = :batch_id;
• SELECT person_id, visa_issuing_cntry_code, visa_issue_date, visa_expiration_date FROM igs_sv_ev_travel_blk_v WHERE visa_expiration_date < SYSDATE;
• SELECT * FROM igs_sv_ev_travel_blk_v WHERE person_id = :person_id;

Because the view already applies the 'SV_LEGAL' tag and 'SEND' action filters, queries against it inherently return only actionable records, simplifying both reporting logic and integration code.