Search Results igs_sv_depdnt_info




Overview
Explore in AI Chat

Overview

The IGS_SV_DEPDNT_INFO table is a core data structure within the Oracle E-Business Suite Student System (IGS) module, specifically designed to support SEVIS (Student and Exchange Visitor Information System) compliance. It serves as the primary repository for storing dependent information associated with foreign students (F-1 visa holders) and exchange visitors (J-1 visa holders). The table's role is critical for managing and reporting the details of a student's or visitor's legal dependents, such as a spouse or children, to U.S. government authorities as mandated by immigration regulations. Its existence is integral to the SEVIS-related functionality in both EBS releases 12.1.1 and 12.2.2, ensuring the institution can maintain accurate records for regulatory reporting and student visa management.

Key Information Stored

The table stores dependent records linked to a specific student or exchange visitor within a processing batch. Its structure is defined by a composite primary key, which uniquely identifies each dependent record. The key columns are BATCH_ID, which groups records for a specific SEVIS data submission or process; PERSON_ID, which links to the primary student or visitor; and DEPDNT_ID, which uniquely identifies the dependent within the context of that person and batch. While the provided metadata does not list all columns, the table typically holds dependent demographic details such as name, date of birth, relationship to the primary visa holder, citizenship, and SEVIS-specific status indicators necessary for generating accurate SEVIS forms and reports.

Common Use Cases and Queries

The primary use case is the generation and maintenance of SEVIS records for dependents (F-2 or J-2 visa holders). This includes creating new dependent records upon a student's initial SEVIS registration, updating records for life events (like the birth of a child), and reporting dependent information in batch transmissions to SEVIS. Common reporting involves listing all dependents for a specific student or within a processing batch for audit purposes. A typical query pattern would join this table to the primary student information table using the foreign key columns.

SELECT d.*
FROM igs.igs_sv_depdnt_info d
WHERE d.person_id = :student_person_id
AND d.batch_id = :current_batch_id;

Another critical use case is data validation before SEVIS submission, ensuring all required dependent fields are populated and consistent with the primary visa holder's status.

Related Objects

The IGS_SV_DEPDNT_INFO table has defined relationships with other central EBS objects, as per the provided foreign key metadata.

  • IGS_SV_PERSONS: This is a primary foreign key relationship. The columns (BATCH_ID, PERSON_ID) in IGS_SV_DEPDNT_INFO reference the IGS_SV_PERSONS table. This links a dependent record to the specific SEVIS batch and person record of the primary student or exchange visitor.
  • HZ_PARTIES: The PERSON_ID column in IGS_SV_DEPDNT_INFO also references the HZ_PARTIES table. This relationship ties the dependent's record to the universal party definition within Oracle Trading Community Architecture (TCA), which is the master repository for all person and organization entities in EBS.

The table's primary key constraint is named IGS_SV_DEPDNT_INFO_PK. These relationships ensure data integrity, linking dependent information to both the SEVIS-specific processing context (IGS_SV_PERSONS) and the foundational person record in the application (HZ_PARTIES).