Search Results igs_sv_crt_stdt_other_v




Overview
Explore in AI Chat

Overview

IGS_SV_CRT_STDT_OTHER_V is a reporting view belonging to the IGS - Student System product within Oracle E-Business Suite. The IGS module is documented by Oracle as obsolete, meaning it is retained for backward compatibility but is no longer part of the actively supported Oracle Student System functionality in release 12.1.1 or 12.2.2. The view is described in the Electronic Technical Reference Manual as a mechanism "for fetching other informations for new Non-Immigrant students." Its purpose is therefore narrowly scoped: it assembles supplementary personal data — driver's license details, Social Security Number, and tax identifier — alongside immigration admission information for individuals being processed as new non-immigrant students.

The view functions as a denormalized read layer over the batch-driven SEVIS/non-immigrant processing tables. Rather than requiring a report or interface to join several summary and detail tables manually, it returns a single flattened result set keyed by batch and person. This makes it suitable for extract generation and reconciliation reporting. The ETRM metadata explicitly records "Not implemented in this database," indicating that in the specific environment documented, the view exists as metadata only and has not been instantiated. Implementers verifying its availability should confirm the object's presence in their own instance before relying on it.

Underlying Base Objects

The ETRM metadata lists no documented referenced base objects, but the view text itself identifies exactly four:

The legal and other information are attached through outer joins to IGS_SV_PERSONS on both BATCH_ID and PERSON_ID, so a person row is retained even when one of the supplementary data sets is absent. The EXISTS clause restricts output to persons who have at least one batch summary entry with TAG_CODE 'SV_LEGAL' or 'SV_OTHER' and ADM_ACTION_CODE 'SEND', ensuring only actively transmitted records are returned.

Key Columns

  • BATCH_ID — the processing batch identifier, forming half of the composite key.
  • PERSON_ID — the person identifier, forming the other half of the key.
  • ADMISSION_NUMBER — aliased from LEGL.I94_NUMBER; the I-94 admission number for the non-immigrant student.
  • DRIVERS_LICENSE — the individual's driver's license number.
  • DRIVERS_LICENSE_STATE — the issuing state for that license.
  • SSN — the Social Security Number.
  • TAX_ID — the tax identification number.

Common Use Cases and Queries

Typical uses include populating non-immigrant student extract files, validating that identity data is complete before transmission, and reconciling transmitted batches. A representative query retrieves all rows for a given batch:

SELECT person_id, admission_number, drivers_license, drivers_license_state, ssn, tax_id FROM igs_sv_crt_stdt_other_v WHERE batch_id = :batch_id;

A second pattern identifies records missing critical identifiers:

SELECT person_id FROM igs_sv_crt_stdt_other_v WHERE batch_id = :batch_id AND (ssn IS NULL OR admission_number IS NULL);

Because the IGS module is obsolete, these queries should be treated as legacy support artifacts. Organizations still running them should plan migration to supported student data structures, as Oracle no longer maintains this view or its base tables.