Search Results fall_enrl_status_type

Overview

IGF_AP_ISIR_INTS is an Oracle E-Business Suite view owned by the APPS schema and delivered as part of the Financial Aid module within Oracle Student System / Student Financial Aid (the IGF product family, "IGF" denoting the ISIR generation functionality). The view exposes the institutional, student-supplied values carried on an ISIR (Institutional Student Information Record) — the record produced from the U.S. Department of Education's FAFSA processing — for a specific student and aid application year. The object name suffix "INTS" indicates it is the institutional (ISIR) segment of the financial aid data model, distinct from the applicant (FAA) and correction (CORR) segments.

The view is used primarily for federal need analysis: it presents dependency status, household and marital attributes, income and asset figures, tax return data, citizenship and eligibility flags, selective service and drug conviction indicators, and enrollment status for each academic term. Report developers and integration routines query it to populate ISIR detail pages, need-analysis extracts, verification worksheets, and downstream packaging or disbursement calculations.

Underlying Base Objects

The ETRM metadata for this object does not document any referenced base objects, and no base tables are exposed. The view text is a single flat SELECT projecting roughly one hundred columns from a ROWID-identified source entity, exposing the surrogate key ROWID ROW_ID alongside the business identifiers. In practice the columns align to the institutional ISIR staging table maintained by the Financial Aid ISIR load process, where each row corresponds to an ISIR transaction for a student in a processing cycle. Because the exact FROM clause is not published in the dictionary metadata, the view should be treated as a denormalized projection layer: one row per ISIR record, keyed by SI_ID, with all demographic, financial, and enrollment attributes flattened onto that row. Consumers should rely only on the documented columns rather than assuming further join paths.

Key Columns

• SI_ID — student identifier linking the ISIR record to the student/person record; the principal join key.
• BATCH_YEAR_NUM, TRANSACTION_NUM_TXT — the award/processing year and ISIR transaction sequence for that year.
• SSN_NAME_CHANGE_TYPE, ORIGINAL_SSN_TXT, CURRENT_SSN_TXT, name and address fields — identity and demographic data submitted on the FAFSA.
• CITIZENSHIP_STATUS_TYPE, ALIEN_REG_NUMBER_TXT — citizenship/eligible non-citizen status.
• S_MARITAL_STATUS_TYPE / P_MARITAL_STATUS_TYPE — student and parent marital status, with associated status dates.
• SUMM_ENRL_STATUS_TYPE, FALL_ENRL_STATUS_TYPE, WINTER_ENRL_STATUS_TYPE, SPRING_ENRL_STATUS_TYPE, SUMM2_ENRL_STATUS_TYPE — this is the group relevant to the search term spring_enrl_status_type: planned/actual enrollment status per term, used in enrollment-intensity and cost-of-attendance logic.
• S_ELIG_1040EZ_TYPE, S_ADJUSTED_GROSS_INCOME_AMT, S_FED_TAXES_PAID_AMT, S_EXEMPTIONS_AMT, income-from-work, WSA/WSB/WSC totals, investment and net-worth amounts, and cash/savings — the student and, where present, parent financial figures.
• LEGAL_DEPENDENTS_FLAG, S_VETERAN_FLAG, DRUG_OFFENCE_CONVICT_TYPE, SELECTIVE_SERVICE_REG_FLAG — eligibility and dependency indicators.

Common Use Cases and Queries

Typical uses include reviewing a student's term-by-term enrollment status for a packaging run, verifying reported income for verification, and extracting dependency and citizenship data for reporting. A representative query retrieving identity and the enrollment status columns for a given student and year:

• SELECT si_id, batch_year_num, transaction_num_txt, last_name, first_name, citizenship_status_type, spring_enrl_status_type, fall_enrl_status_type FROM apps.igf_ap_isir_ints WHERE si_id = :p_si_id AND batch_year_num = :p_year;
• SELECT si_id, s_adjusted_gross_income_amt, s_fed_taxes_paid_amt, s_exemptions_amt, legal_dependents_flag FROM apps.igf_ap_isir_ints WHERE batch_year_num = :p_year AND citizenship_status_type = 'A';
• SELECT spring_enrl_status_type, COUNT(*) FROM apps.igf_ap_isir_ints WHERE batch_year_num = :p_year GROUP BY spring_enrl_status_type;

All queries should be issued with the APPS schema context and appropriate MO/security predicates for the institution. Because the view is a projection over financial aid ISIR data, accesses should be restricted to the Financial Aid responsibility supporting the corresponding award year.