Search Results sevis_school_identifier




Overview
Explore in AI Chat

Overview

IGS.IGS_PE_NONIMG_FORM is a transactional table in the Oracle E-Business Suite Student Systems (IGS) schema that stores non-immigrant student information required for SEVIS (Student and Exchange Visitor Information System) reporting. The table captures the financial, academic, and biographical data of students holding non-immigrant visa types, and the information recorded here is transmitted to SEVIS for regulatory compliance. The table resides in the APPS_TS_TX_DATA tablespace and is registered under the FND Design Data identifier IGS.IGS_PE_NONIMG_FORM.

From a Data Vault modeling perspective, the relationship structure mined from the foreign key graph suggests a hub-leaning classification. The surrogate primary key NONIMG_FORM_ID anchors the record, while PERSON_ID and SEVIS_SCHOOL_IDENTIFIER serve as business key references to HZ_PARTIES. This pattern is characteristic of a hub entity that centralizes the identity of a non-immigrant form instance, with child tables supplying dependent detail.

Key Information Stored

The table contains 47 documented columns. The most significant are summarized below.

Common Use Cases and Queries

The table is most commonly queried to produce SEVIS reporting extracts, verify financial sufficiency for a student, and monitor form status transitions. A typical query joining to the person and status tables follows.

  • Retrieving all active forms for a person: SELECT * FROM IGS.IGS_PE_NONIMG_FORM WHERE PERSON_ID = :p_person_id AND FORM_STATUS = 'ACTIVE';
  • Aggregating total funds of support: join the financial amount columns (TUITION_AMT, LIVING_EXP_AMT, PERSONAL_FUNDS_AMT, etc.) for a given NONIMG_FORM_ID.
  • Joining to IGS_PE_NONIMG_STAT on NONIMG_FORM_ID to retrieve current SEVIS status history.
  • Joining to IGS_PE_NONIMG_EMPL on NONIMG_FORM_ID to obtain employment records associated with the form.
  • Reporting forms due for reprint after LAST_REPRINT_DATE or by REPRINT_REASON.

Related Objects

  • HZ_PARTIES — Referenced by PERSON_ID and SEVIS_SCHOOL_IDENTIFIER; provides party identity.
  • IGS_PE_NONIMG_EMPL — Child table referencing NONIMG_FORM_ID; stores employment information for non-immigrant students.
  • IGS_PE_NONIMG_STAT — Child table referencing NONIMG_FORM_ID; stores SEVIS status records.
  • IGS_PE_NONIMG_FORM_PK — the unique primary key index on NONIMG_FORM_ID.
  • IGS_PE_NONIMG_FORM_N1 — the non-unique index on PERSON_ID.