Search Results intl_org2_code

Overview

IGS_PE_EV_FORM_V is a database view in the Oracle E-Business Suite IGS — Student System product family, historically associated with the Oracle Student System (legacy) and processes relating to international student/visitor forms, including SEVIS-related evidentiary forms (EV forms). The object is documented in the ETRM reference material under the "Obsolete" classification, meaning that subsequent EBS releases (12.1.1 and 12.2.2) no longer implement this object in supported databases. The ETRM record explicitly states "Not implemented in this database," signalling that customer databases on these releases will not contain the compiled view.

The view's purpose is to present the evidentiary form record (base table IGS_PE_EV_FORM) in denormalized, descriptive form, by joining each coded attribute to its corresponding IGS_LOOKUP_VALUES meaning via outer joins, and by joining to HZ_PARTIES to resolve the sponsoring school's party name. It is therefore a reporting-friendly projection intended for inquiry screens, concurrent-program extracts, and integration payloads that require human-readable descriptions alongside raw codes.

Underlying Base Objects

Although the ETRM documented metadata records no explicit referenced base objects, the view text embedded in the source record defines the underlying objects precisely. The primary base table is IGS_PE_EV_FORM, aliased PV, which holds the evidentiary form rows keyed by EV_FORM_ID and PERSON_ID. Supporting lookup decoding is performed against IGS_LOOKUP_VALUES, referenced ten times (aliases L1 through L10), each outer-joined on a distinct LOOKUP_TYPE. The external organization/party name is sourced from HZ_PARTIES (alias HP), joined to resolve the SEVIS school identifier to a party name. All lookups other than FORM_STATUS use Oracle-style outer joins (+), so form rows are retained even where a code has no lookup definition.

Key Columns

• EV_FORM_ID, PERSON_ID, EV_FORM_NUMBER — primary identifiers of the evidentiary form and the person (student/visitor) it belongs to.
• PRINT_FORM, FORM_EFFECTIVE_DATE, FORM_STATUS, FORM_STATUS_DESC — print indicator, effective date and status of the form, with status description decoded from lookup type PE_SV_FM_STAT_TYPE.
• GOVT_ORG1_CODE / GOVT_ORG1_AMT / GOVT_ORG1_DESC and the corresponding ORG2 columns — U.S. government agency contributions and their decoded meanings (lookup type PE_US_GVT_AGENCY).
• INTL_ORG1_CODE / INTL_ORG1_AMT / INTL_ORG1_DESC and the corresponding ORG2 columns — international organization contributions. The intl_org2_code element is exposed as INTL_ORG2_CODE with its decoded meaning INTL_ORG2_DESC, resolved from lookup type PE_SV_INTL_ORG.
• EV_GOVT_AMT, BI_NATNL_COM_AMT, OTHER_GOVT_AMT, PERSONAL_FUNDS_AMT, PRGM_SPONSOR_AMT — funding breakdown amounts by source.
• SEVIS_SCHOOL_IDENTIFIER, SEVIS_SCHOOL — the school identifier and its party name from HZ_PARTIES.
• REPRINT_REASON, POSITION_CODE, SUBJECT_FIELD_CODE, MATRICULATION, CATEGORY_CODE — each accompanied by a decoded _DESC column from its respective lookup type.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, plus ROW_ID exposed from the base table ROWID.

Common Use Cases and Queries

Because the view supplies decoded descriptions, the most frequent usage is providing readable listings of evidentiary forms for a person, filtered by status or international organization. A representative query for the search term follows:

SELECT ev_form_number, person_id, intl_org2_code, intl_org2_desc, intl_org2_amt
FROM igs_pe_ev_form_v
WHERE intl_org2_code IS NOT NULL
AND form_status = 'ACTIVE';

Additional scenarios include joining to person or party tables to produce a student funding report, extracting forms with SEVIS_SCHOOL resolved via HZ_PARTIES, and driving concurrent programs that generate printed forms (PRINT_FORM, LAST_REPRINT_DATE, REPRINT_REASON_DESC). Reports on fund composition typically aggregate the government, international, and personal funds columns by category or program sponsor.

When upgrading to 12.1.1 or 12.2.2, the ETRM classification of Obsolete should be treated as authoritative: the view is not implemented, so existing customizations, reports, and interfaces referencing IGS_PE_EV_FORM_V, INTL_ORG2_CODE, or its companion columns must be revalidated against the currently supported Student System objects before deployment.