Search Results igs_pe_nonimg_form




Overview
Explore in AI Chat

Overview

IGS_PE_NONIMG_FORM is a transactional table in the IGS (Student System) product module of Oracle E-Business Suite, owned by the IGS schema. It stores non-immigrant student information that is captured on the SEVIS-related non-immigrant reporting form, driven by Visa Type and other regulatory attributes. Records in this table represent the financial, academic, and program data required by the Student and Exchange Visitor Information System (SEVIS); the data is subsequently transmitted to SEVIS for federal compliance reporting.

The table is classified as hub-leaning under a heuristic Data Vault model. In practice, this suggests treating IGS_PE_NONIMG_FORM as a hub-style entity keyed by NONIMG_FORM_ID, with PERSON_ID and SEVIS_SCHOOL_IDENTIFIER acting as references to external business entities (parties) and dependent detail captured in satellite-style child tables such as IGS_PE_NONIMG_EMPL and IGS_PE_NONIMG_STAT.

Key Information Stored

The table contains 47 documented columns in ETRM 12.1.1. The most significant include:

Common Use Cases and Queries

Typical usage revolves around SEVIS form preparation, financial certification, and compliance auditing. A representative query joining the form to its child status and employment records:

  • Listing active non-immigrant forms for a given person: SELECT * FROM IGS_PE_NONIMG_FORM WHERE PERSON_ID = :person_id AND FORM_STATUS = 'A';
  • Aggregating funding totals for SEVIS reporting: SELECT NONIMG_FORM_ID, SUM(TUITION_AMT + LIVING_EXP_AMT) FROM IGS_PE_NONIMG_FORM GROUP BY NONIMG_FORM_ID;
  • Retrieving associated status and employment detail via NONIMG_FORM_ID from IGS_PE_NONIMG_STAT and IGS_PE_NONIMG_EMPL.
  • Auditing reprint activity through LAST_REPRINT_DATE, REPRINT_REASON, and REPRINT_REMARKS.

Related Objects

  • HZ_PARTIES — referenced by PERSON_ID and SEVIS_SCHOOL_IDENTIFIER; the source of party and school identity.
  • IGS_PE_NONIMG_EMPL — child table joined on NONIMG_FORM_ID, holding employment information for the form.
  • IGS_PE_NONIMG_STAT — child table joined on NONIMG_FORM_ID, holding status detail; appears twice in the documented FK list, consistent with multiple status roles.
  • IGS_PE_NONIMG_FORM_PK — primary key index on NONIMG_FORM_ID, driving joins and lookups.

Together, these relationships position IGS_PE_NONIMG_FORM as the central hub for non-immigrant SEVIS reporting within the IGS Student System.