Search Results igs_sv_empl_info




Overview
Explore in AI Chat

Overview

The IGS_SV_EMPL_INFO table is a core data repository within the Oracle E-Business Suite Student System (IGS) module, specifically for versions 12.1.1 and 12.2.2. Its primary function is to store employment-related information pertaining to Foreign students and Exchange Visitors. This data is critical for compliance with the U.S. Student and Exchange Visitor Information System (SEVIS), a government program managed by the Department of Homeland Security. The table acts as a staging or transactional area where employment details are assembled and managed before being transmitted to SEVIS, ensuring educational institutions maintain accurate and reportable records for visa and employment authorization purposes.

Key Information Stored

Based on the provided metadata, the table's structure is centered on a composite primary key and foreign key relationships that link employment data to broader person and batch records. The key columns include:

  • BATCH_ID: A critical identifier linking the employment record to a specific batch or grouping of SEVIS data, likely for processing and transmission control.
  • PERSON_ID: The unique identifier for the Foreign student or Exchange Visitor, connecting the employment information to the individual's master record.

While the specific employment data columns (e.g., employer name, address, work authorization type, start/end dates) are not detailed in the excerpt, the table's description confirms it holds all employment information required for SEVIS reporting. This typically encompasses details on Curricular Practical Training (CPT), Optional Practical Training (OPT), and other work authorization types.

Common Use Cases and Queries

The primary use case for this table is the generation and validation of SEVIS employment reports. Administrators use it to review, update, and certify employment data before submission. Common SQL operations include extracting employment records for a specific batch to prepare a SEVIS transmission file or querying all active employment authorizations for a given student. A typical reporting query might join this table to person details to generate a compliance audit list:

SELECT empl.*, pers.sevis_id, pers.full_name
FROM igs_sv_empl_info empl, igs_sv_persons pers
WHERE empl.person_id = pers.person_id
AND empl.batch_id = :batch_number
ORDER BY pers.full_name;

Data maintenance tasks, such as correcting employer information or updating an authorization end date, are also performed directly on this table, often through dedicated application screens that enforce business rules.

Related Objects

The IGS_SV_EMPL_INFO table has a defined dependency on the IGS_SV_PERSONS table, which serves as the master record for individuals in the SEVIS context. The foreign key relationship is explicitly documented as:

  • Foreign Key to IGS_SV_PERSONS: The columns BATCH_ID and PERSON_ID in IGS_SV_EMPL_INFO reference the same composite key in the IGS_SV_PERSONS table. This ensures that every employment record is associated with a valid person record within a specific processing batch.

This relationship is fundamental, as it ties employment data to the correct individual and the correct data submission cycle. Any integration, data load, or custom report concerning SEVIS employment would typically involve joining these two tables on these key columns.