Search Results igs_sv_persons_n1

Overview

IGS.IGS_SV_PERSONS is a transaction table within the Oracle E-Business Suite Student System (IGS) schema that stores the working set of student and exchange-visitor records staged for submission to the SEVIS (Student and Exchange Visitor Information System) interface. Each row represents a single person included in a batch run, carrying the demographic reference, the SEVIS processing identifiers, and the status indicators required to build and transmit the federal filing. The table is populated by the batch request process and read by the downstream SEVIS extract and reporting programs.

The table resides in the APPS_TS_TX_DATA tablespace with PCT FREE 10, and its indexes are placed in APPS_TS_TX_IDX, consistent with standard Oracle EBS transactional data storage conventions. From a Data Vault modeling perspective, the mined foreign-key structure classifies this object as hub-leaning: it holds durable business keys (BATCH_ID, PERSON_ID) and acts as the parent anchor for a family of dependent information tables. It is not modeled as a satellite, since several child tables reference it directly by BATCH_ID.

Key Information Stored

• BATCH_ID and PERSON_ID — the composite primary key (IGS_SV_PERSONS_PK) and the unique business-key candidate exposed through index IGS_SV_PERSONS_U1. BATCH_ID identifies the SEVIS request run; PERSON_ID links to HZ_PARTIES.
• RECORD_NUMBER — sequence position within the batch, capped at approximately 250 records per batch; indexed by IGS_SV_PERSONS_N1.
• RECORD_STATUS — indicates whether the row is an Update or Create operation; indexed by IGS_SV_PERSONS_N2 and frequently used as a filter.
• PERSON_NUMBER — the person number assigned when the HZ_PARTIES record is created.
• SEVIS_USER_ID, PDSO_SEVIS_ID, and PDSO_SEVIS_PERSON_ID — the SEVIS identifier assigned to the user, the SEVIS identifier of the responsible PDSO, and its HZ_PARTIES foreign-key reference.
• ADJUDICATED_FLAG — the flag requested in the originating search; it tracks whether the person's record has completed adjudication within the SEVIS workflow.
• ISSUING_REASON, OTHER_REASON, and EV_CREATE_REASON — reason codes and free-text explanations accompanying the submission.
• CURR_SESSION_END_DATE, NEXT_SESSION_START_DATE, and INIT_PRGM_START_DATE — program and session date values carried as VARCHAR2 strings.
• NO_SHOW_FLAG, LAST_SESSION_FLAG, and STATUS_CODE — additional status indicators governing the filing.
• SEVIS_ERROR_CODE and SEVIS_ERROR_ELEMENT — error diagnostics returned when a submission is rejected.
• REPRINT_RSN_CODE, REPRINT_REMARKS, REMARKS, and PRINT_FORM — reprint and annotation controls.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard EBS audit columns.

Common Use Cases and Queries

The most frequent reporting pattern is to inspect the state of a batch before or after transmission, filtering on RECORD_STATUS and the error columns to isolate failed or pending records.

• List adjudicated persons in a batch: SELECT person_id, person_number, record_status FROM igs.igs_sv_persons WHERE batch_id = :batch_id AND adjudicated_flag = 'Y';
• Identify rejected submissions: SELECT person_id, sevis_error_code, sevis_error_element FROM igs.igs_sv_persons WHERE batch_id = :batch_id AND sevis_error_code IS NOT NULL;
• Order records for pagination or audit: use index IGS_SV_PERSONS_N1 on (BATCH_ID, RECORD_NUMBER) to retrieve rows in batch sequence.
• Reconciliation reporting against HZ_PARTIES to confirm person numbers and names for a submission batch.

Related Objects

• IGS.IGS_SV_BATCHES — parent batch definition; join on IGS_SV_PERSONS.BATCH_ID = IGS_SV_BATCHES.BATCH_ID.
• HZ.HZ_PARTIES — party master; joined through PERSON_ID and through the separate PDSO_SEVIS_PERSON_ID foreign key.
• IGS.IGS_SV_BIO_INFO, IGS.IGS_SV_CONVICTIONS, IGS.IGS_SV_DEPDNT_INFO, IGS.IGS_SV_EMPL_INFO — dependent detail tables joined on BATCH_ID.
• IGS.IGS_SV_FINANCE_INFO, IGS.IGS_SV_LEGAL_INFO, IGS.IGS_SV_OTH_INFO, IGS.IGS_SV_PRGMS_INFO — additional child tables that collectively supply the SEVIS payload for each person in the batch.