Search Results intl_org2_amt

Overview

IGS.IGS_PE_EV_FORM is the core transaction table within the Oracle E-Business Suite Student Systems / Exchange Visitor (SEVIS) module for storing the Exchange Visitor (EV) form data captured from end users through the EV form interface. It is owned by the IGS schema and is registered as VALID FND design data under IGS.IGS_PE_EV_FORM. The table resides in the APPS_TS_TX_DATA tablespace with a PCTFREE of 10 and holds the master information about an individual student's Exchange Visitor submission, including financial sponsorship amounts, program dates, position and subject information, and reprint history.

From a Data Vault modeling perspective, the mined relationship structure classifies this object as satellite-leaning (satellite). This is a heuristic suggestion: the table's grain is one row per EV form event keyed by a surrogate identifier, with descriptive and financial attributes that describe a parent business entity (the student/person), rather than a hub of uniquely identified business keys or a many-to-many link between hubs. Designers building a warehouse layer should treat EV_FORM_ID as a satellite-style attribute carrier attached to the PERSON_ID hub.

Key Information Stored

The table contains 46 documented columns. The most significant attributes include:

• EV_FORM_ID — NUMBER(15), the surrogate primary key and the unique index IGS_PE_EV_FORM_PK. It uniquely identifies each EV form record. There is no documented business-key candidate other than this surrogate; PERSON_ID is supported by the nonunique index IGS_PE_EV_FORM_N1.
• PERSON_ID — NUMBER(15), the foreign key to HZ_PARTIES identifying the student/person for whom the form is created.
• FORM_EFFECTIVE_DATE, FORM_STATUS, PRINT_FORM, IS_VALID — control attributes indicating the effective date, lifecycle status, print flag, and validity flag of the form.
• CREATE_REASON — VARCHAR2(30), the reason the EV form was created.
• PRGM_SPONSOR_AMT, GOVT_ORG1_AMT, GOVT_ORG2_AMT, INTL_ORG1_AMT, INTL_ORG2_AMT, EV_GOVT_AMT, BI_NATNL_COM_AMT, OTHER_GOVT_AMT, PERSONAL_FUNDS_AMT — NUMBER(10) financial support amounts expressed in US dollars, each tied to a funding source.
• GOVT_ORG1_CODE, GOVT_ORG2_CODE, INTL_ORG1_CODE, INTL_ORG2_CODE — agency codes identifying the supporting government or international organization.

The searched term govt_org2_amt maps directly to the GOVT_ORG2_AMT column, which records the US-dollar financial support provided by the second US government agency supporting the Exchange Visitor, paired with GOVT_ORG2_CODE.

Common Use Cases and Queries

Typical usage centers on SEVIS reporting, financial sponsorship reconciliation, and student visa compliance. A frequent pattern joins the form to its status history and to the person record:

SELECT f.EV_FORM_ID, f.PERSON_ID, f.FORM_STATUS, f.GOVT_ORG2_CODE, f.GOVT_ORG2_AMT
FROM IGS.IGS_PE_EV_FORM f
WHERE f.PERSON_ID = :p_person_id
ORDER BY f.FORM_EFFECTIVE_DATE DESC;

Aggregate queries sum sponsorship categories to validate total funding versus program requirements, for example grouping by GOVT_ORG2_CODE to report government-sponsored students. Reprint auditing queries select LAST_REPRINT_DATE, REPRINT_REASON, and REPRINT_REMARKS. Status transitions are tracked by joining IGS_PE_EV_FORM_STAT on EV_FORM_ID.

Related Objects

• IGS.IGS_PE_EV_FORM_STAT — child table referencing EV_FORM_ID; holds form status history and is the primary dependent object.
• HZ_PARTIES — parent of PERSON_ID; supplies person/party details for the student.
• HZ_PARTIES (SEVIS_SCHOOL_IDENTIFIER) — second FK on the school identifier, linking the form to the school party record.
• IGS_PE_EV_FORM_PK / IGS_PE_EV_FORM_N1 — supporting indexes on EV_FORM_ID and PERSON_ID respectively, driving lookup and join performance.