Search Results igs_pe_ev_form




Overview
Explore in AI Chat

Overview

IGS_PE_EV_FORM is the primary table within the Oracle E-Business Suite Student System (IGS) module responsible for storing student EV (Enrollment Verification / SEVIS-related) form data. It captures input provided by users through the EV form interface and serves as the central repository for student information collected during the EV form process. The table resides in the IGS schema and is classified as VALID in the ETRM repository for both Oracle EBS 12.1.1 and 12.2.2.

From a Data Vault modeling perspective, the heuristic classification derived from the foreign key structure suggests this table is satellite-leaning. This indicates that IGS_PE_EV_FORM primarily holds descriptive attributes and transactional details tied to a business key, rather than acting as a pure hub or link entity. The table contains 46 documented columns, reflecting a broad set of attributes related to financial sponsorship, program participation, and regulatory reporting.

Key Information Stored

The table's surrogate primary key is EV_FORM_ID, enforced through the unique index IGS_PE_EV_FORM_PK. This column uniquely identifies each EV form record and is the only documented business-key candidate. The remaining columns capture the substantive details of each form.

Common Use Cases and Queries

IGS_PE_EV_FORM is typically queried to retrieve a student's current or historical EV form details for SEVIS reporting, financial aid verification, and enrollment status confirmation.

  • Retrieve forms for a student: SELECT * FROM IGS.IGS_PE_EV_FORM WHERE PERSON_ID = :person_id;
  • List active forms by status: SELECT EV_FORM_ID, EV_FORM_NUMBER, FORM_STATUS, FORM_EFFECTIVE_DATE FROM IGS.IGS_PE_EV_FORM WHERE FORM_STATUS = 'ACTIVE';
  • Join with status history: SELECT f.EV_FORM_ID, s.FORM_STATUS FROM IGS.IGS_PE_EV_FORM f, IGS.IGS_PE_EV_FORM_STAT s WHERE f.EV_FORM_ID = s.EV_FORM_ID;
  • Financial sponsorship reporting: Aggregate sponsorship amounts by organization code for regulatory submissions.

Related Objects

The following objects are most significant in relation to IGS_PE_EV_FORM based on documented foreign key relationships:

  • HZ_PARTIES — Referenced through IGS_PE_EV_FORM.PERSON_ID and IGS_PE_EV_FORM.SEVIS_SCHOOL_IDENTIFIER, providing the student and school party records.
  • IGS_PE_EV_FORM_STAT — References this table via EV_FORM_ID, storing status history for each EV form.

These relationships define the core data model surrounding EV form processing, linking student identity (HZ_PARTIES) and form lifecycle tracking (IGS_PE_EV_FORM_STAT) to the central IGS_PE_EV_FORM record.