Search Results igs_sv_persons

Overview

The IGS_SV_PERSONS table is a core transactional table within the Oracle E-Business Suite Student System (IGS) module, specifically supporting the batch processing of student information for regulatory submissions. Its primary role is to serve as a staging and control table, identifying the specific students (persons) included in a given batch request for processing. The table functions as a junction between a batch header and detailed student data, ensuring that only designated individuals are processed during a batch run. This is critical for operations such as generating regulatory reports or transmitting data to external systems like SEVIS (Student and Exchange Visitor Information System), where submissions must be accurate and auditable.

Key Information Stored

The table's structure is defined by a composite primary key and several foreign key relationships. The primary key consists of BATCH_ID and PERSON_ID, which together uniquely identify a student record within a specific batch. The BATCH_ID column links to the IGS_SV_BATCHES table, which defines the parameters and control information for the batch submission itself. The PERSON_ID column is a foreign key to the HZ_PARTIES table in Oracle Trading Community Architecture (TCA), anchoring the student record to the central party repository. An additional notable column is PDSO_SEVIS_PERSON_ID, which is also a foreign key to HZ_PARTIES and likely stores a reference to a designated school official (PDSO) or an alternate SEVIS identifier associated with the person.

Common Use Cases and Queries

The primary use case for IGS_SV_PERSONS is managing and reporting on the population of students selected for a batch submission process. Common operational queries involve listing all students in a pending batch, verifying batch composition before submission, and troubleshooting batch errors. A typical reporting query would join to batch header and party information:

• SELECT sp.batch_id, sp.person_id, hp.party_name, sb.batch_status FROM igs_sv_persons sp JOIN hz_parties hp ON sp.person_id = hp.party_id JOIN igs_sv_batches sb ON sp.batch_id = sb.batch_id WHERE sb.batch_status = 'PENDING';

Data maintenance scripts might also target this table to clean up orphaned records or to analyze submission history by joining with the various child detail tables (e.g., IGS_SV_PRGMS_INFO).

Related Objects

IGS_SV_PERSONS sits at the center of a hierarchical data model for batch student submissions. It has a direct parent-child relationship with IGS_SV_BATCHES and HZ_PARTIES. Crucially, it acts as the parent table for numerous detail tables that store specific categories of information for each batched student, including:

• IGS_SV_BIO_INFO (Biographical Information)
• IGS_SV_CONVICTIONS (Conviction Information)
• IGS_SV_DEPDNT_INFO (Dependent Information)
• IGS_SV_EMPL_INFO (Employment Information)
• IGS_SV_FINANCE_INFO (Financial Information)
• IGS_SV_LEGAL_INFO (Legal Information)
• IGS_SV_OTH_INFO (Other Information)
• IGS_SV_PRGMS_INFO (Program Information)

This structure allows the system to assemble a complete student record for submission by aggregating data from the central IGS_SV_PERSONS entry and its related child tables, all scoped to a specific BATCH_ID.