Results for “igf_ap_isir_intrface”

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

Overview

IGF_AP_ISIR_INTRFACE is a VALID database view owned by the APPS schema within the IGF (Financial Aid) product module of Oracle E-Business Suite, present in both 12.1.1 and 12.2.2. It exposes the staging structure used to load and review Institutional Student Information Record (ISIR) data received from the U.S. Department of Education's Central Processing System under the federal student aid process. The ISIR is the electronic output generated when a student's Free Application for Federal Student Aid (FAFSA) is processed, and it carries demographic, enrollment, dependency, and financial detail required for need analysis and award packaging. In EBS, this view acts as the presentation layer over the interface table that holds foreign ISIR records prior to validation against the person and student records. Because the object name contains the term "INTRFACE" (the abbreviated spelling used throughout the "interface" tables in EBS), it is best understood as the read-only access point that reporting, Extensible Markup Language (XML) publisher layouts, and correction workflows use to inspect inbound federal aid data without touching the raw staging table directly. Its role is primarily integration and reporting: it supports verification, discrepancy comparison against the student's own application data, and archive reporting for audit.

Underlying Base Objects

The ETRM metadata explicitly documents the view as a VIEW with owner APPS and further states that referenced base objects are "none documented." This means the ETRM record does not enumerate a base table in the supplied excerpt, and the view text begins directly with a SELECT list over the ISIR interface columns. In practice, this type of view is typically defined as a single-table projection over the corresponding ISIR interface table in the IGF schema, with the ROWID pseudo-column included to give each staged row a unique identifier for updates and deletes during processing. The columns exposed in the view text mirror the layout of the federal ISIR file record positions, confirming a one-to-one mapping between view columns and staging table columns. No joins, aggregations, or subqueries appear in the documented view text, so the view does not consolidate multiple base tables even though the underlying subject area spans student, spouse, and parent data.

Key Columns

The view begins with ROWID and SI_ID, which identify each staged ISIR row uniquely. BATCH_YEAR and TRANSACTION_NUM track the award year and the ISIR transaction number, both essential for reconciliation. RECORD_STATUS indicates the processing state of the record. Identity columns include SSN_NAME_CHANGE, ORIGINAL_SSN, and CURRENT_SSN, along with ORIG_NAME_ID, LAST_NAME, FIRST_NAME, MIDDLE_INITIAL, and DATE_OF_BIRTH. Contact and personal data appear in PERM_MAIL_ADD, PERM_CITY, PERM_STATE, PERM_ZIP_CODE, and PHONE_NUMBER. Enrollment is captured across SUMM_ENRL_STATUS, FALL_ENRL_STATUS, WINTER_ENRL_STATUS, SPRING_ENRL_STATUS, and SUMM2_ENRL_STATUS. Dependency and household indicators include S_MARITAL_STATUS, S_MARRIED, S_HAVE_CHILDREN, LEGAL_DEPENDENTS, P_NUM_FAMILY_MEMBER, and P_NUM_IN_COLLEGE. Income and asset fields follow the ISIR naming convention with S_ (student), SPOUSE_, P_ (parent), F_ (father), and M_ (mother) prefixes, such as S_ADJUSTED_GROSS_INCOME, P_ADJUSTED_GROSS_INCOME, F_INCOME_WORK, and P_CASH_SAVING. Additional columns cover citizenship (CITIZENSHIP_STATUS, ALIEN_REG_NUMBER), Selective Service, drug conviction, degree certification, and the FIRST_COLLEGE, FIRST_HOUSE_PLAN, SECOND_COLLEGE, SECOND_HOUSE_PLAN, and THIRD_COLLEGE selection fields.

Common Use Cases and Queries

Typical uses include reviewing loaded ISIR batches, comparing reported financials to FAFSA entries, and driving correction or verification reporting. A simple validation query is shown below.

• Batch review: SELECT SI_ID, BATCH_YEAR, TRANSACTION_NUM, CURRENT_SSN, LAST_NAME, RECORD_STATUS FROM IGF_AP_ISIR_INTRFACE WHERE BATCH_YEAR = :year AND RECORD_STATUS = :status ORDER BY TRANSACTION_NUM.
• Need-analysis extract: SELECT CURRENT_SSN, S_ADJUSTED_GROSS_INCOME, P_ADJUSTED_GROSS_INCOME, P_NUM_FAMILY_MEMBER, P_NUM_IN_COLLEGE FROM IGF_AP_ISIR_INTRFACE WHERE CURRENT_SSN = :ssn.
• Household and dependency check: SELECT S_MARITAL_STATUS, S_MARRIED, S_HAVE_CHILDREN, LEGAL_DEPENDENTS FROM IGF_AP_ISIR_INTRFACE WHERE SI_ID = :si_id.
• Enrollment summary: SELECT SUMM_ENRL_STATUS, FALL_ENRL_STATUS, WINTER_ENRL_STATUS, SPRING_ENRL_STATUS, SUMM2_ENRL_STATUS FROM IGF_AP_ISIR_INTRFACE WHERE SI_ID = :si_id.

Because the view is read-oriented and keyed by ROWID, corrections are normally applied to the underlying interface table by concurrent programs, while this object remains the preferred source for query-only reporting in both 12.1.1 and 12.2.2.