Search Results stdnt_person_id




Overview
Explore in AI Chat

Overview

IGS_SV_EV_CRT_EV_BLK_V is an Oracle E-Business Suite view owned by the APPS schema within the IGS (Student System) product. Its documented purpose is to support the creation of an Exchange Visitor (EV) block, which is the SEVIS batch record used to register J-1 exchange visitors sponsored by an institution. The view draws information from the SEVIS person and batch summary tables and presents a row per person per batch that is pending transmission to SEVIS.

In the reporting and integration context, the view acts as a staging projection. It exposes the identifying attributes required to build the EV create transaction block, while columns that are populated by the SEVIS batch generation process rather than stored in EBS are returned as NULL placeholders. When a user searches for form_number against this object, the relevant column is FORM_NUMBER, which is surfaced from IGS_SV_PERSONS.EV_FORM_NUMBER and carries the SEVIS Form DS-2019 number associated with the exchange visitor.

Underlying Base Objects

The view is defined over four references: the base table IGS_SV_PERSONS aliased as PERS, and three separate references to IGS_SV_BTCH_SUMMARY aliased as BIOSUMM, UADDSUMM, PRGMUMM and FINSUMM. Although the ETRM metadata does not enumerate these as documented referenced base objects, they are plainly visible in the view text and constitute the physical join path.

Each IGS_SV_BTCH_SUMMARY alias is filtered by a distinct TAG_CODE representing a SEVIS record segment, such as SV_BIO for biographical data, SV_US_ADDR for the U.S. address, program data, and financial data. A fourth summary alias, FINSUMM, is declared in the FROM clause even though the excerpt does not show its join predicate. The ADM_ACTION_CODE constraint of 'SEND' on BIOSUMM distinguishes records intended for transmission. The join keys are PERSON_ID and BATCH_ID, meaning each output row is scoped to one person within one SEVIS batch.

Key Columns

Common Use Cases and Queries

Typical usage is to enumerate exchange visitors ready for SEVIS create processing, or to verify the form number and program dates for a given person or batch before transmission. A representative query is:

SELECT BATCH_ID, PERSON_ID, FORM_NUMBER, CREATE_REASON_CODE, INITIAL_PRGM_DATE, PRGM_START_DATE, PRGM_END_DATE FROM APPS.IGS_SV_EV_CRT_EV_BLK_V WHERE FORM_NUMBER = :p_form_number;

A broader query joining to IGS_SV_PERSONS on PERSON_ID is common when additional person detail is required beyond the placeholder NULL columns exposed here. Parameters are bound rather than concatenated to keep the query sargable and to support the standard EBS concurrent program pattern. Because the view already enforces the RECORD_STATUS and ADM_ACTION_CODE filters, callers should not re-filter on those attributes.