Results for “ssn_match_flag”

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

Overview

IGF_AP_ISIR_MATCHED_V is an Oracle E-Business Suite database view owned by the APPS schema and associated with the IGF (Financial Aid) product. It exposes records drawn from the Institutional Student Information Record (ISIR) data set, which federal financial aid processing loads into EBS to support student eligibility determination. The view presents a wide, denormalized projection of applicant and ISIR attributes — identity, citizenship, Selective Service registration, marital status, enrollment status, and the detailed income and asset figures used in needs analysis — in a single read interface.

Within Oracle EBS 12.1.1 and 12.2.2, this view serves reporting and integration consumers rather than transactional forms. Because it consolidates matched ISIR records, it is a convenient source for institution-side extracts, downstream verification routines, and reconciliation of loaded ISIR data against student records.

Underlying Base Objects

The ETRM documentation for this object does not enumerate specific base tables, and no referenced base objects are documented. In practice, a view of this type is defined over the ISIR staging and matched-record tables in the IGF schema, joined to person and student records to produce the consolidated row exposed through the APPS synonym. The view text selects the full column list directly, confirming it is a straightforward projection over one primary ISIR-based source rather than a heavily transformed aggregation.

Because the base objects are not documented in the ETRM metadata, consumers should treat the view as a stable reporting surface and avoid assumptions about underlying join cardinality. Verify row uniqueness against ISIR_ID and ROW_ID before relying on the view for one-row-per-applicant processing.

Key Columns

• ROW_ID, ISIR_ID, BASE_ID — Surrogate and business identifiers for the ISIR record and the applicant base record.
• BATCH_YEAR, TRANSACTION_NUM — The processing cycle and ISIR transaction sequence used to identify the active version.
• SSN_NAME_CHANGE, ORIGINAL_SSN, CURRENT_SSN, ORIG_NAME_ID — Fields supporting SSN changes and name reconciliation, the area most closely associated with the sec_ins_match_flag search term.
• Selective Service columns (SS_R_U_MALE, SELECTIVE_SERVICE_REG) — Registration status used for Title IV eligibility checks.
• CITIZENSHIP_STATUS, ALIEN_REG_NUMBER — Citizenship and eligible non-citizen data.
• Enrollment status columns (SUMM_ENRL_STATUS, FALL_ENRL_STATUS, WINTER_ENRL_STATUS, SPRING_ENRL_STATUS, SUMM2_ENRL_STATUS) — Term-by-term enrollment expectations.
• Income and asset columns (S_ADJUSTED_GROSS_INCOME, S_FED_TAXES_PAID, S_INVESTMENT_NETWORTH, P_ADJUSTED_GROSS_INCOME, P_CASH_SAVING) — Student and parent needs-analysis inputs.
• Household columns (P_NUM_FAMILY_MEMBER, P_NUM_IN_COLLEGE, S_NUM_FAMILY_MEMBERS) — Family size and college attendance counts.

Common Use Cases and Queries

Typical uses include verifying that matched ISIR records were loaded correctly, extracting applicant data for packaging and verification, and auditing SSN or name changes flagged during matching. A representative query retrieving identity and eligibility fields follows:

• SELECT isir_id, current_ssn, last_name, first_name, citizenship_status, s_m...

For reconciliation by batch year, filter on BATCH_YEAR and TRANSACTION_NUM to isolate the current ISIR version, and join to student records on ISIR_ID. Always constrain the query to the appropriate award year to limit full-table scans on this wide view.