Search Results education_level_desc

Overview

The view IGS_PE_NONIMG_FORM_V belongs to the IGS – Student System product family within Oracle E-Business Suite. It is a reporting and integration view built over the IGS_PE_NONIMG_FORM base table, which stores non-immigrant (SEVIS-related) student form data used by institutions tracking international students and their visa-related reporting obligations. In ETRM metadata for release 12.2.2, the object is flagged as Obsolete and is documented as Not implemented in this database, meaning it is retained only for historical reference and is not created in the standard 12.1.1 or 12.2.2 installation.

The view's primary role is to denormalize coded lookup values into readable descriptions and to join party name information, so that downstream reports and interfaces do not need to resolve lookup codes themselves. This is characteristic of IGS reporting views, which package join logic against shared lookup and party tables into a single queryable object. Because the object is obsolete, it is not available for new development in either 12.1.1 or 12.2.2.

Underlying Base Objects

The ETRM metadata documents no referenced base objects, but the view text reveals that it is defined over the following objects:

• IGS_PE_NONIMG_FORM — the primary base table (aliased PV) holding the non-immigrant form records.
• IGS_LOOKUP_VALUES — referenced six times (L1 through L6) to decode form status, primary major, education level, reprint reason, secondary major, and minor.
• HZ_PARTIES — joined as HP to supply the PARTY_NAME used as the SEVIS school name.

All joins to the lookup values table are equijoins on LOOKUP_CODE and LOOKUP_TYPE, with outer joins ((+)) applied to the reprint reason, secondary major, and minor lookups, since those fields are optional on the base record.

Key Columns

The view exposes the full column set of the base table plus derived description columns and the party name. Notable columns include:

• NONIMG_FORM_ID, PERSON_ID — primary key and the associated person identifier.
• FORM_STATUS / FORM_STATUS_DESC — the coded status and its meaning from lookup type PE_SV_FM_STAT_TYPE.
• OTHER_EXP_AMT / OTHER_EXP_DESC — the amount and free-text description of other expenses declared on the form. The OTHER_EXP_DESC column is the field most commonly searched, as it captures narrative expense detail unique to each record.
• PRIMARY_MAJOR_DESC, SECONDARY_MAJOR_DESC, MINOR_DESC — decoded major and minor descriptions from PE_US_COURSE_SUBJECT.
• EDUCATION_LEVEL_DESC — decoded from PE_SV_EDUC_LEVEL.
• REPRINT_REASON_DESC — decoded from PE_SV_REPRINT_REASON.
• SEVIS_SCHOOL — the school name sourced from HZ_PARTIES.PARTY_NAME.
• Financial columns — TUITION_AMT, LIVING_EXP_AMT, PERSONAL_FUNDS_AMT, DEPDNT_EXP_AMT, SCHOOL_FUNDS_AMT, OTHER_FUNDS_AMT, EMPL_FUNDS_AMT.

Common Use Cases and Queries

Because the view resolves lookup descriptions and joins party names, it is typically used in SEVIS reporting extracts and financial-aid style summaries of international student declarations. A representative query retrieving other-expense detail is:

• SELECT person_id, form_status_desc, other_exp_amt, other_exp_desc FROM igs_pe_nonimg_form_v WHERE other_exp_desc IS NOT NULL;
• SELECT sevis_school, primary_major_desc, education_level_desc, other_exp_amt FROM igs_pe_nonimg_form_v ORDER BY sevis_school;

Given the object's obsolete status and its absence from standard databases in 12.1.1 and 12.2.2, these queries serve as documentation reference rather than production guidance. Implementations requiring equivalent functionality should consult the current replacement objects supplied by Oracle for the Student System.