Search Results igf_ap_isir_ints_all




Overview
Explore in AI Chat

Overview

The table IGF.IGF_AP_ISIR_INTS_ALL is the ISIR interface staging table within the Oracle E-Business Suite IGF — Financial Aid product family. Its documented purpose is to hold Institutional Student Information Records (ISIRs) received from the Central Processing System (CPS), the federal processor that evaluates Free Application for Federal Student Aid (FAFSA) submissions. In Release 12.1.1 the object is registered as VALID in the IGF schema and is documented with 499 columns, making it one of the widest staging interfaces in the Financial Aid module. As an interface table, it functions as the landing zone for raw inbound federal aid data before validation, transformation, and propagation into the operational financial aid model.

The heuristic Data Vault classification mined from the foreign-key structure is standalone, meaning no outbound foreign keys were detected in the documented metadata. From a modeling perspective, this suggests the object behaves as a satellite-like staging structure keyed by a single surrogate identifier, with no enforced parent hub relationships inside the schema. Analysts should therefore treat it as a self-contained landing table rather than as a conformed dimension or hub participant.

Key Information Stored

The physical key is the surrogate primary key SI_ID, enforced by the unique index IGF_AP_ISIR_INTS_PK. No alternate unique business key is documented beyond this surrogate; the identifying business values (transaction number, SSN, DRN) are stored as attributes rather than as enforced unique keys. The most operationally significant columns include:

Common Use Cases and Queries

Typical usage centers on load verification, rejection remediation, and reconciliation reporting. A common pattern checks staging volume and processing outcome by batch:

  • Load reconciliation: SELECT BATCH_YEAR_NUM, BATCH_NUMBER_TXT, RECORD_STATUS, COUNT(*) FROM IGF.IGF_AP_ISIR_INTS_ALL GROUP BY BATCH_YEAR_NUM, BATCH_NUMBER_TXT, RECORD_STATUS;
  • Rejected ISIR review: SELECT SI_ID, TRANSACTION_NUM_TXT, CURRENT_SSN_TXT, REJECT_REASON_CODES_TXT FROM IGF.IGF_AP_ISIR_INTS_ALL WHERE REJECT_REASON_CODES_TXT IS NOT NULL;
  • Pell eligibility extract: filtering on PELL_GRANT_ELIG_FLAG = 'Y' and a target BATCH_YEAR_NUM.
  • Duplicate detection: grouping by CURRENT_SSN_TXT and TRANSACTION_NUM_TXT to identify repeated CPS submissions, supported by the documented DUP_SSN_INDICATOR_FLAG and DUPLICATE_DATE columns.
  • Audit trending: joining REQUEST_ID to concurrent request history to correlate load performance with inbound volume.

Related Objects

Although the documented relationship classification is standalone, in practice the interface integrates with the surrounding Financial Aid model. Significant related objects include the ISIR load and validation concurrent programs driven by REQUEST_ID, the student financial aid application and applicant records resolved against CURRENT_SSN_TXT and TRANSACTION_NUM_TXT, NSLDS match and verification tables populated from the NSLDS_* column set, and Pell/award processing structures that consume PRIMARY_EFC_AMT and PELL_GRANT_ELIG_FLAG. Because no formal foreign keys are documented, joins to downstream objects should be established on business identifiers (SSN, transaction number, DRN) rather than on SI_ID, and should be validated against the specific ISIR load routine in use.