Search Results igf_sl_ed_prc_rslts




Overview
Explore in AI Chat

Overview

IGF_SL_ED_PRC_RSLTS is a transaction table in the IGF (Financial Aid) product schema of Oracle E-Business Suite, present in both 12.1.1 and 12.2.2. It stores the results of the edit process applied to financial aid response XML files exchanged with external processors (for example, the Common Origination and Disbursement process used for Title IV student aid). When a response XML file is received and parsed, each edit rule evaluated against the returned data produces one row here, capturing whether the record passed, failed, or was flagged along with the associated error code, message, and reported value.

The object is documented in ETRM as VALID with 17 columns in the 12.1.1 physical schema and is owned by IGF. Under a heuristic Data Vault classification mined from its foreign key structure, this table behaves as a link: it resolves the many-to-many style association between a detailed response record and the edit outcome generated against it. This classification is a modeling suggestion only; the physical table remains a conventional relational child keyed by EDIT_REC_ID.

Key Information Stored

The table is anchored by a surrogate primary key, EDIT_REC_ID, defined by the unique index IGF_SL_ED_PRC_RSLTS_PK. This column holds no business meaning but uniquely identifies each edit-result row and is the documented business-key candidate. No composite alternate unique key is documented.

Common Use Cases and Queries

Typical reporting centers on rejection analysis and reconciliation between the aid system and the external processor. A frequent pattern joins edit results to their parent response detail to find all failed edits for a submission:

  • Select rows where LEVEL_CODE indicates an error and group by RESP_ERR_CODE to profile the most common rejection reasons.
  • Join EDIT_ID back to the originating response detail table to associate an edit outcome with its student, award, or disbursement record.
  • Compare RESP_ERR_VALUE against REPORTED_VALUE to detect discrepancies between what was submitted and what the processor reported.
  • Audit which concurrent request produced a result by filtering on REQUEST_ID and PROGRAM_ID.
  • Build extracts of unremediated edits for a remediation queue or downstream correspondence.

Related Objects

IGF_SL_ED_PRC_RSLTS.EDIT_ID is documented as a foreign key to multiple response detail tables, reflecting the different aid response types handled by the module. The most significant referenced objects are:

Because multiple parent detail tables share the EDIT_ID column, joins should be scoped to the specific aid type in scope; the metadata lists additional references with unresolved target names. Editing logic that populates these rows is driven by the Financial Aid edit process rather than a single public API, so integrations typically read this table for reporting and exception handling.