Search Results igs_en_svs_auth_cal




Overview
Explore in AI Chat

Overview

The IGS_EN_SVS_AUTH_CAL table is a core data object within the Oracle E-Business Suite IGS – Student System product. It stores SEVIS Authorization Calendar records used to track Student and Exchange Visitor Information System (SEVIS) authorization windows associated with international student processing. In Oracle EBS 12.1.1 and 12.2.2, this table is owned by the IGS schema and is documented as VALID.

From a Data Vault modeling perspective, the heuristic classification derived from the foreign key structure suggests this object functions as a link table. This is appropriate given that it associates SEVIS authorizations (via SEVIS_AUTH_ID) with academic calendar instances (via CAL_TYPE and CI_SEQUENCE_NUMBER), rather than standing alone as an independent hub or purely descriptive satellite.

Key Information Stored

The table contains eight documented columns. The most significant are:

  • SEVIS_AUTH_ID – Identifier referencing the parent SEVIS authorization record in IGS_EN_SVS_AUTH; part of the composite primary key.
  • CAL_TYPE – The calendar type code; both a primary key component and a foreign key to IGS_CA_INST_ALL.
  • CI_SEQUENCE_NUMBER – Sequence number identifying the specific calendar instance; also a primary key component and FK element into IGS_CA_INST_ALL.
  • CREATED_BY – Standard EBS WHO column capturing the user who created the row.
  • CREATION_DATE – Timestamp of row creation.
  • LAST_UPDATED_BY – User who last modified the record.
  • LAST_UPDATE_DATE – Timestamp of the most recent modification.
  • LAST_UPDATE_LOGIN – Login identifier associated with the last update.

The surrogate/business key is represented by the unique index IGS_EN_SVS_AUTH_CAL_PK, defined across (SEVIS_AUTH_ID, CAL_TYPE, CI_SEQUENCE_NUMBER). No separate single-column surrogate key is documented; the composite unique index serves as the business-key candidate. The remaining columns are the standard audit/WHO attributes present on nearly all transactional EBS tables.

Common Use Cases and Queries

Typical reporting scenarios involve reconciling SEVIS authorizations with campus academic calendars to validate that international student authorizations fall within valid calendar windows. A representative query joining to the parent authorization table:

  • Authorization lookup: SELECT a.sevis_auth_id, c.cal_type, c.ci_sequence_number FROM igs_en_svs_auth_cal c, igs_en_svs_auth a WHERE c.sevis_auth_id = a.sevis_auth_id;
  • Calendar validation: join to igs_ca_inst_all on (CAL_TYPE, CI_SEQUENCE_NUMBER) to retrieve calendar instance descriptions and date ranges.
  • Audit reporting: filter on CREATION_DATE / LAST_UPDATE_DATE to identify recently added or modified authorization calendar records.

Related Objects

The following objects are directly related through documented FK/PK relationships:

  • IGS_EN_SVS_AUTH – Parent table supplying SEVIS_AUTH_ID; this link table depends on it.
  • IGS_CA_INST_ALL – Referenced via CAL_TYPE and CI_SEQUENCE_NUMBER to resolve calendar instance details.
  • IGS_EN_SVS_AUTH_CAL_PK – The unique index enforcing row uniqueness across the composite key columns.

Additional dependent objects in the SEVIS and academic calendar modules (such as SEVIS batch processing views and calendar reporting views) may reference these tables indirectly, but the two foreign-key parents above are the principal related objects.