Search Results igs_en_svs_auth




Overview
Explore in AI Chat

Overview

IGS_EN_SVS_AUTH is a table within the IGS (Student System) product family, which Oracle has classified as obsolete in the EBS 12.1.1 and 12.2.2 releases. The table stores SEVIS (Student and Exchange Visitor Information System) authorization records — the regulatory authorizations that permit an institution to issue and manage immigration-related documents for international students and exchange visitors under U.S. Department of Homeland Security rules. Within the historical IGS schema, this table functioned as the authoritative register of institutional SEVIS authorizations, capturing the authorization number, code, validity window, and cancellation state for each authorized campus or program.

The ETRM metadata does not document this object as implemented in the current database, and it carries the "Obsolete" designation, meaning it is retained for historical and upgrade-reference purposes rather than active transactional use. From a data modeling perspective, the mined foreign-key structure suggests a satellite-leaning classification: the table hangs off a parent party record (via PERSON_ID to HZ_PARTIES) and is itself referenced by downstream child tables. This heuristic classification is a modeling suggestion only, not an enforced constraint — practitioners should validate before adopting it in any warehouse or integration design.

Key Information Stored

The table's documented physical schema comprises 17 columns under the IGS schema owner. The most significant are:

Common Use Cases and Queries

Because the object is obsolete, use cases are primarily historical reporting, migration validation, and audit reconstruction. A typical query joins the authorization to its parent party to resolve the responsible person:

SELECT a.sevis_authorization_no,
       a.sevis_authorization_code,
       a.start_dt,
       a.end_dt,
       a.cancel_flag,
       p.party_name
FROM   igs_en_svs_auth a,
       hz_parties p
WHERE  a.person_id = p.party_id
AND    NVL(a.cancel_flag,'N') = 'N'
AND    SYSDATE BETWEEN a.start_dt AND a.end_dt;

Reporting scenarios include identifying authorizations active at a point in time, listing cancelled authorizations for compliance review, and reconciling authorization numbers against external SEVIS records during data migration. Correlation with IGS_EN_SVS_AUTH_CAL supports calendar-based analysis of authorization cycles.

Related Objects

The documented relationships include:

  • HZ_PARTIES — referenced via IGS_EN_SVS_AUTH.PERSON_ID; the parent party record.
  • IGS_EN_SVS_AUTH_CAL — references this table through SEVIS_AUTH_ID, holding associated calendar data.
  • IGS_SV_PRGMS_INFO — references this table through SEVIS_AUTH_ID, tying authorizations to program information.

These three objects constitute the core dependency set. No additional views or public APIs are documented in the supplied ETRM metadata for this obsolete object.