Search Results pe_sv_educ_level

Overview

IGS_PE_NONIMG_FORM_V is a reporting view in the Oracle E-Business Suite Student System (formerly Oracle Student System / IGS product family) that presents non-immigrant (non-image) SEVIS-related form data for international students and applicants. In EBS 12.1.1 and 12.2.2 the view is owned by the APPS schema and is intended for query and reporting purposes rather than as a transactional entity. Its principal role is to expose denormalized, human-readable representations of coded attributes on the IGS_PE_NONIMG_FORM record — statuses, majors, education levels, and reprint reasons — by resolving them against IGS_LOOKUP_VALUES, and to associate each form with the SEVIS school party name held in HZ_PARTIES.

The name the user searched for, pe_sv_fm_stat_type, is the lookup type referenced in the view definition. It is joined to the base table's FORM_STATUS column and its resolved meaning is surfaced as the derived column FORM_STATUS_DESC. This makes the view the natural access point when reporting on the state of a non-immigrant form.

Underlying Base Objects

The view is defined over a single base table, IGS_PE_NONIMG_FORM (aliased PV), enriched by six instances of IGS_LOOKUP_VALUES (L1–L6) and one outer join to HZ_PARTIES (HP). The lookup joins are keyed as follows:

• L1 — FORM_STATUS against lookup type PE_SV_FM_STAT_TYPE (inner join).
• L2 — PRIMARY_MAJOR against PE_US_COURSE_SUBJECT (inner join).
• L3 — EDUCATION_LEVEL against PE_SV_EDUC_LEVEL (inner join).
• L4 — REPRINT_REASON against PE_SV_REPRINT_REASON (outer join).
• L5 — SECONDARY_MAJOR against PE_US_COURSE_SUBJECT (outer join).
• L6 — MINOR against PE_US_COURSE_SUBJECT (outer join).
• HP — SEVIS_SCHOOL_IDENTIFIER against PARTY_ID, restricted to PARTY_TYPE = 'ORGANIZATION' (outer join).

The ETRM metadata documents no additional base objects; the row identity exposed as ROW_ID is the base table's ROWID.

Key Columns

The view returns the form's technical keys (NONIMG_FORM_ID, PERSON_ID, ROW_ID) alongside a substantial set of descriptor and financial columns. Notable attributes include:

• FORM_STATUS / FORM_STATUS_DESC — coded status and its resolved meaning from PE_SV_FM_STAT_TYPE.
• PRINT_FORM, FORM_EFFECTIVE_DATE, LAST_REPRINT_DATE, REPRINT_REASON / REPRINT_REASON_DESC, REPRINT_REMARKS — printing and reissue tracking.
• ACAD_TERM_LENGTH, TUITION_AMT, LIVING_EXP_AMT, PERSONAL_FUNDS_AMT, DEPDNT_EXP_AMT, OTHER_EXP_AMT, SCHOOL_FUNDS_AMT, OTHER_FUNDS_AMT, EMPL_FUNDS_AMT and their accompanying description columns — the financial certification detail.
• PRIMARY_MAJOR / PRIMARY_MAJOR_DESC, SECONDARY_MAJOR / SECONDARY_MAJOR_DESC, MINOR / MINOR_DESC, EDUCATION_LEVEL / EDUCATION_LEVEL_DESC — academic intent.
• PRGM_START_DATE, PRGM_END_DATE, LENGTH_OF_STUDY, CURR_SESSION_END_DATE, NEXT_SESSION_START_DATE — program timing.
• ADJUDICATED_FLAG, LAST_SESSION_FLAG, SEVIS_SCHOOL_IDENTIFIER, SEVIS_SCHOOL — SEVIS processing and school identity.
• CREATION_DATE, CREATED_BY, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns.

Common Use Cases and Queries

Typical usage includes monitoring form status distribution, reconciling financial certifications, and generating SEVIS-oriented extracts. Because the lookup joins for FORM_STATUS, PRIMARY_MAJOR, and EDUCATION_LEVEL are inner joins, rows whose codes do not resolve in IGS_LOOKUP_VALUES are excluded.

To count forms by status:

• SELECT form_status, form_status_desc, COUNT(*) FROM apps.igs_pe_nonimg_form_v GROUP BY form_status, form_status_desc;

To list pending forms for a person with school detail:

• SELECT person_id, print_form, form_effective_date, sevis_school FROM apps.igs_pe_nonimg_form_v WHERE form_status = 'PENDING' AND person_id = :p_person_id;

To report certified funds by major:

• SELECT primary_major_desc, SUM(tuition_amt + living_exp_amt + personal_funds_amt) total_funds FROM apps.igs_pe_nonimg_form_v GROUP BY primary_major_desc;

All queries should be run against the APPS synonym and, in accordance with EBS security practice, at the reporting schema level rather than the base table.