Search Results last_session_flag




Overview
Explore in AI Chat

Overview

IGS_SV_STDNT_REG_BLK_V is a Self-Service Web view owned by the APPS schema within the Oracle E-Business Suite. It is registered under the FND Design Data application short name IGS and is catalogued with a status of VALID. The view is classified as a Web view designed to simplify access from Oracle Self-Service Web Applications, and its stated purpose is to obtain information for the XML block describing a student's registration information. In practice, this view serves as a presentation and extraction layer that assembles student registration, address, immigration, and identity attributes into a single relational shape suitable for XML generation and downstream integration. It is most closely associated with SEVIS-related data exchange, where registration records must be formatted for reporting to external agencies and internal compliance processes.

Underlying Base Objects

The ETRM metadata for version 12.2.2 records no documented referenced base objects for this view. The dependency section identifies only the view itself, and no underlying tables are enumerated. The view is registered as an FND Design Data object under IGS.IGS_SV_STDNT_REG_BLK_V, which confirms it is a deployed dictionary object rather than a transient construct. Because the base object lineage is not documented, the view should be treated as an encapsulation layer: consumers are expected to query the view directly rather than reconstructing its join logic. Columns such as PERSON_ID and BATCH_ID indicate that the view is driven by a batch-processing context and keyed to the person (student) entity, while the inclusion of both SEVIS-specific and general registration attributes shows it consolidates data from multiple functional areas—student registration, address, and person/identification records—into one row per student per batch run.

Key Columns

Regarding the searched term last_session_flag: this column is not present in the documented column list for the view. The session-related attributes exposed are CURRENT_SESSION_END_DATE and NEXT_SESSION_START_DATE. Users searching for last_session_flag may be conflating it with a column on a related registration or SEVIS base object, or with a flag used in a different block view.

Common Use Cases and Queries

The principal use case is generating the XML block for student registration information, particularly for SEVIS form printing and reporting. A second use case is ad hoc compliance reporting where registration, address, and immigration attributes for a batch must be reviewed together.

Typical query by batch:

  • SELECT batch_id, person_id, pdso_sevis_id, print_form FROM apps.igs_sv_stdnt_reg_blk_v WHERE batch_id = :p_batch_id;

Query for a specific student across batches:

  • SELECT batch_id, person_id, current_session_end_date, next_session_start_date, commuter FROM apps.igs_sv_stdnt_reg_blk_v WHERE person_id = :p_person_id ORDER BY batch_id;

Filtering on form printing and commuter status:

  • SELECT person_id, pdso_sevis_id, print_form, commuter FROM apps.igs_sv_stdnt_reg_blk_v WHERE print_form = 'Y' AND commuter = 'Y';

Because date values are exposed as VARCHAR2(10), date comparisons should use the documented string format, for example WHERE current_session_end_date > '2024-01-01', or convert explicitly when performing range filtering.