Search Results sevis_auth_cd_meaning

Overview

APPS.IGS_EN_SEVIS_AUTH_V is a public Oracle EBS view owned by the APPS schema, registered under FND Design Data as IGS.IGS_EN_SEVIS_AUTH_V. It belongs to the Student System (IGS) product family, specifically the Enrollment (IGS_EN) module, and was designed to expose SEVIS authorization records — the Student and Exchange Visitor Information System authorizations associated with non-immigrant student tracking — for custom reporting and integration purposes. The view is explicitly documented as Obsolete, and every column listed in the ETRM metadata carries the same Obsolete designation. This status applies equally to EBS 12.1.1 and 12.2.2; the object exists in both releases as a VALID database view, but Oracle no longer supports or enhances it. Customers searching on the prompt "sevis_auth_cd_meaning" are typically looking for a way to resolve the SEVIS authorization code into a human-readable description, which this view provides through its SEVIS_AUTH_CD_MEANING column.

Underlying Base Objects

The view is defined over the base table APPS.IGS_EN_SEVIS_AUTH, together with APPS.IGS_LOOKUPS_VIEW, which supplies the decoded meaning for the authorization code. The dependency list in the ETRM documentation names only these two objects; the view itself is not referenced by any other database object, confirming its role as a terminal, report-facing construct rather than a building block in the IGS data model. Because the meaning column is sourced from the lookups view, the descriptive text returned for any given SEVIS_AUTHORIZATION_CD reflects the lookup values configured for the SEVIS authorization lookup type. The base table IGS_EN_SEVIS_AUTH stores the authorization records themselves, including validity dates, free-text comments, and the eligibility override identifier that links the authorization to a specific eligibility override transaction.

Key Columns

• ROW_ID — ROWID pseudo-column identifying the physical row; useful for de-duplication in ad hoc extracts.
• SEVIS_AUTHORIZATION_CD — The stored code value for the SEVIS authorization type.
• SEVIS_AUTH_CD_MEANING — The decoded, user-facing description (up to 80 characters) resolved from IGS_LOOKUPS_VIEW; this is the column most commonly targeted when users search for "sevis_auth_cd_meaning".
• START_DT / END_DT — The effective date range during which the authorization applies.
• COMMENTS — Up to 500 characters of free-text annotation captured against the authorization.
• ELGB_OVERRIDE_ID — Foreign key to the eligibility override record that the authorization supports.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — Standard concurrent program context columns populated when the row was last written by a batch process.

Common Use Cases and Queries

The view is used principally in custom operational reports that need to display SEVIS authorizations with their descriptive meanings, and in data extracts feeding downstream visa and compliance systems. A typical query joining the window of validity to the decoded meaning is:

SELECT sevis_authorization_cd,
      sevis_auth_cd_meaning,
      start_dt, end_dt, elgb_override_id
  FROM apps.igs_en_sevis_auth_v
 WHERE SYSDATE BETWEEN start_dt AND NVL(end_dt, SYSDATE);

A second common pattern lists the distinct authorization codes and meanings available in the institution's configuration, which is useful when validating lookup setup: SELECT DISTINCT sevis_authorization_cd, sevis_auth_cd_meaning FROM apps.igs_en_sevis_auth_v ORDER BY 1. Because the object is obsolete, it should be treated as read-only reference data only; new development should not be built on it, and any reliance on it should be assessed for replacement during upgrade planning from 12.1.1 to 12.2.2, even though the view remains valid in both releases.