Results for “personal_funds_amt”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

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:

• NONIMG_FORM_ID — the surrogate primary key defined by index IGS_PE_NONIMG_FORM_PK; it is the sole documented unique business-key candidate.
• PERSON_ID — foreign key to HZ_PARTIES, identifying the student/party to whom the form pertains.
• SEVIS_SCHOOL_IDENTIFIER — foreign key to HZ_PARTIES, designating the SEVIS school associated with the form.
• VISA_TYPE — the visa classification that determines non-immigrant status.
• FORM_STATUS, FORM_EFFECTIVE_DATE, PRINT_FORM, ISSUE_REASON, OTHER_REASON — form lifecycle and issuance attributes.
• TUITION_AMT, LIVING_EXP_AMT, PERSONAL_FUNDS_AMT, SCHOOL_FUNDS_AMT, OTHER_FUNDS_AMT, EMPL_FUNDS_AMT, DEPDNT_EXP_AMT, OTHER_EXP_AMT — financial estimates and funding sources required for SEVIS reporting.
• PRGM_START_DATE, PRGM_END_DATE, ACAD_TERM_LENGTH, LENGTH_OF_STUDY, EDUCATION_LEVEL, PRIMARY_MAJOR, SECONDARY_MAJOR, MINOR — program and academic detail.
• ENGLISH_REQD, ENGLISH_REQD_MET, NOT_REQD_REASON — English proficiency determination.
• Audit columns CREATION_DATE, CREATED_BY, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

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.