Search Results original_ssn_txt




Overview
Explore in AI Chat

Overview

IGF_AP_LI_ISIR_INTS is an interface (staging) table owned by the IGF schema within the Oracle E-Business Suite Financial Aid module (IGF). It carries Institutional Student Information Record (ISIR) data — the electronic FAFSA transaction files received from the U.S. Department of Education's Central Processing System (CPS) — before those records are validated and loaded into the permanent financial aid tables. In Oracle EBS 12.1.1 and 12.2.2 the table is documented as VALID with 505 columns, making it one of the widest inbound interfaces in the Financial Aid product line.

The documented primary key is the unique index IGF_AP_LI_ISIR_INTS_PK, defined on the single column ISRINT_ID. This is the surrogate identifier for an interface row, and it is the object of the search term "isrint_id". A second candidate business key is evident in the data: the combination of BATCH_NUM and TRANSACTION_NUM_TXT (or ISIR_TRANSACTION_TYPE) identifies a specific ISIR transaction within a processing batch. The only documented foreign key is IGF_AP_LI_ISIR_INTS.BATCH_NUM → IGF_AP_LI_BAT_INTS, which ties each ISIR row to its parent batch header.

Under the heuristic Data Vault classification supplied with the metadata, this table is satellite-leaning: the ISIR interface is descriptive attribute payload attached to the batch business key, rather than an independent hub of business entities. It also functions as a dependent child of IGF_AP_LI_BAT_INTS in the parent-child batch structure.

Key Information Stored

The 505 columns decompose into four functional groupings. The most operationally significant are:

  • ISRINT_ID — surrogate primary key, populated from a sequence; the unique index IGF_AP_LI_ISIR_INTS_PK.
  • BATCH_NUM — foreign key to IGF_AP_LI_BAT_INTS; identifies the ISIR load batch the row belongs to.
  • PERSON_NUMBER — the student identifier used to match the ISIR against an existing person record.
  • TRANSACTION_NUM_TXT / ISIR_TRANSACTION_TYPE — CPS transaction number and type, the natural key of an ISIR submission.
  • SSN_NAME_CHANGE_TYPE, CURRENT_SSN_NUM, LAST_NAME, FIRST_NAME, BIRTH_DATE — applicant identity and demographic data used for matching.
  • PRIMARY_EFC_AMT, SECONDARY_EFC_AMT, PAID_EFC_AMT, FED_PELL_GRANT_EFC_TYPE — expected family contribution values and Pell eligibility, used for packaging and disbursement.
  • IMPORT_STATUS_TYPE and IMPORT_RECORD_TYPE — control columns driving the import/validation process.
  • Dependency status, reject/override flags, and verification flag columns — determine which ISIRs require follow-up review or correction.

Large blocks of NSLDS_* columns hold loan and grant history returned with the ISIR; these are consumed downstream by the NSLDS integration step rather than by the base ISIR load.

Common Use Cases and Queries

The principal use is batch-controlled bulk loading of ISIR files. Typical patterns include:

  • Listing all ISIR rows in a batch: SELECT * FROM igf.igf_ap_li_isir_ints WHERE batch_num = :p_batch_num;
  • Looking up a single transaction by its surrogate key: SELECT * FROM igf.igf_ap_li_isir_ints WHERE isrint_id = :p_isrint_id;
  • Reconciling loaded versus unprocessed rows using IMPORT_STATUS_TYPE.
  • Reporting applicants whose EFC changed or who carry rejection codes, joining to person records on PERSON_NUMBER.
  • Re-driving failed interface rows after correcting upstream data, without re-receiving the file.

Related Objects

The documented foreign key establishes the primary lineage; the remaining relationships follow normal IGF Financial Aid conventions and should be confirmed against a specific instance.

  • IGF_AP_LI_BAT_INTS — parent batch header; joined on IGF_AP_LI_ISIR_INTS.BATCH_NUM = IGF_AP_LI_BAT_INTS.BATCH_NUM.
  • IGF_AP_LI_ISIR_INTS_PK — the unique index enforcing ISRINT_ID.
  • ISIR load concurrent programs and the IGF Financial Aid ISIR import process, which read and clear this table.
  • Permanent financial aid applicant/tracking tables populated after successful validation.
  • NSLDS result tables consuming the NSLDS_* attribute block.