Search Results igs_en_sevis_auth_v

Overview

IGS_EN_SEVIS_AUTH_V is a reporting view documented within the Oracle E-Business Suite (EBS) Student System product family, module code IGS. In the ETRM reference for release 12.1.1 and 12.2.2, the object is flagged with a Description of "Obsolete" and an implementation note stating it is "Not implemented in this database." This status reflects the historical lifecycle of the Oracle Student System, a product line that was retired and is no longer shipped or supported in current EBS environments. The view is therefore retained in the ETRM dictionary primarily for lineage and configuration-audit purposes rather than for active functional use.

Functionally, the view presents SEVIS authorization data. SEVIS (the Student and Exchange Visitor Information System) is the U.S. federal system used to track international students and exchange visitors. The view joins an authorization code stored on the base entity to its lookup meaning, providing a denormalized, human-readable representation of SEVIS authorization records—including validity dates, comments, and standard EBS audit columns. Its role in reporting/integration would have been to supply read-only, presentation-ready data to concurrent programs, BI Publisher reports, or external interfaces dealing with international-student compliance.

Underlying Base Objects

The documented view text defines IGS_EN_SEVIS_AUTH_V over two base objects:

• IGS_EN_SEVIS_AUTH ESA — the primary transactional table holding SEVIS authorization records. The view selects ESA.ROWID as ROW_ID and carries forward the entity's descriptive, date, and audit attributes.
• IGS_LOOKUPS_VIEW LKV — the lookup view used to resolve the code to a meaning. The join is defined on LKV.LOOKUP_TYPE = 'IGS_EN_SEVIS_AUTH_CODES' and LKV.LOOKUP_CODE = ESA.SEVIS_AUTHORIZATION_CD.

ETRM metadata for release 12.2.2 records the Owner as blank and the Referenced base objects as "none documented," meaning the dictionary does not formally register the underlying tables for this obsolete definition. The authoritative relationship is therefore the join encoded in the view text itself. Because this is an inner join against the lookup view, only authorization codes with a matching lookup entry are returned; codes lacking a lookup row are suppressed.

Key Columns

• ROW_ID — the ROWID of the underlying IGS_EN_SEVIS_AUTH row, available as a unique physical identifier.
• SEVIS_AUTHORIZATION_CD — the authorization code stored on the base entity.
• SEVIS_AUTH_CD_MEANING — the decoded meaning obtained from IGS_LOOKUPS_VIEW for lookup type IGS_EN_SEVIS_AUTH_CODES.
• START_DT / END_DT — the effective start and end dates of the authorization.
• COMMENTS — free-text remarks attached to the authorization record.
• ELGB_OVERRIDE_ID — identifier of a related eligibility override record.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS auditing columns.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — concurrent program context columns identifying the process that last touched the row.

Common Use Cases and Queries

In legacy Student System implementations, this view supported compliance reporting on international-student authorizations, audit extraction of authorization periods, and integration feeds requiring decoded lookup values. A typical query retrieves active authorizations for a point in time:

• SELECT sevis_authorization_cd, sevis_auth_cd_meaning, start_dt, end_dt FROM igs_en_sevis_auth_v WHERE TRUNC(SYSDATE) BETWEEN start_dt AND end_dt;
• SELECT sevis_auth_cd_meaning, COUNT(*) FROM igs_en_sevis_auth_v GROUP BY sevis_auth_cd_meaning;
• SELECT row_id, comments, created_by, creation_date FROM igs_en_sevis_auth_v ORDER BY creation_date DESC;

Given the "Not implemented" and "Obsolete" designations, these queries are relevant only to archived or historical environments. On supported 12.1.1 or 12.2.2 instances, the object is generally absent, and any dependency on it should be treated as a defect requiring remediation.