Search Results no_show_flag




Overview
Explore in AI Chat

Overview

IGS_SV_EV_STATUS_BLK_V is an Oracle E-Business Suite view owned by the APPS schema within the IGS (Student System) product. It is defined in both EBS 12.1.1 and 12.2.2 and holds status VALID. Per the ETRM documentation, the view exists for the purpose of "fetching status information for Exchange Visitor students," a functional area tied to SEVIS (Student and Exchange Visitor Information System) processing and regulatory reporting for foreign nationals in J-1 exchange visitor programs at an institution.

The view is one of the interface components used to assemble the data payloads transmitted to the SEVIS system, specifically the status-block segment of a batch submission. Its central mechanism is a filter on completed person records, combined with a conditional predicate on the NO_SHOW_FLAG column, the term the searching user referenced. Rather than listing every person in an SEVIS batch, the view returns only those records that either carry the no-show indicator or have a corresponding batch tag with a SEND administrative action.

Underlying Base Objects

ETRM does not document any dependent base objects for this view, but the embedded view text identifies the source relations explicitly. The primary FROM clause references IGS_SV_PERSONS (aliased PERS), the table that stores SEVIS person-level records including batch identifiers, SEVIS identifiers, record numbers, and the NO_SHOW_FLAG. The WHERE clause also references IGS_SV_BTCH_SUMMARY (aliased STATSUMM) through an EXISTS subquery, correlating on PERSON_ID and BATCH_ID and testing for TAG_CODE = 'SV_STATUS' and ADM_ACTION_CODE = 'SEND'. Together these two tables govern which rows surface through the view.

Key Columns

  • BATCH_ID — the SEVIS batch identifier to which the person record belongs; sourced from IGS_SV_PERSONS.BATCH_ID.
  • PDSO_SEVIS_ID — the principal designated school official SEVIS identifier associated with the record.
  • PERSON_ID — the internal party identifier used to link back to student and person records.
  • NO_SHOW_FLAG — the indicator (typically 'Y') denoting a person as a no-show for the exchange visitor program; this is the column driving the user's search and the primary OR predicate in the view.
  • SEVIS_USER_ID — the SEVIS user identifier for the record.
  • RECORD_NUMBER — the SEVIS record number assigned to the person.
  • PERSON_NUMBER — a zero-padded, ten-character representation of the first ten characters of PERSON_ID.
  • PERSON_ID_LONG — the same construction padded to fourteen characters.
  • OTHER_REMARKS — decodes REPRINT_RSN_CODE; where the value is '05', the view returns REPRINT_REMARKS, otherwise NULL.

Common Use Cases and Queries

Typical usage centers on batch validation and reconciliation for SEVIS transmissions. Administrators query the view to confirm which records are included in a status batch, to identify no-show cases requiring special handling, or to reconcile the transmitted payload against the summary table. A representative query follows:

SELECT batch_id, person_id, person_number, no_show_flag, record_number, other_remarks
FROM apps.igs_sv_ev_status_blk_v
WHERE batch_id = :p_batch_id;

To isolate no-show records specifically:

SELECT batch_id, person_id, person_number
FROM apps.igs_sv_ev_status_blk_v
WHERE no_show_flag = 'Y';

Because the view is filtered to RECORD_STATUS = 'C' (completed) and excludes SEND-tagged rows unless the no-show predicate is satisfied, it should not be treated as a general-purpose person listing. Queries that need the full population must target IGS_SV_PERSONS directly.