Search Results igf_sl_resp_f_smry

Overview

The IGF_SL_RESP_F_SMRY table resides in the IGF (Financial Aid) product family, a module that Oracle has designated as obsolete in the EBS 12.1.1 and 12.2.2 releases. Its documented purpose is to store the Response Financial Summary Tag Elements parsed from an incoming response XML file, typically the federal Title IV response payload exchanged between the institution and the federal aid processing infrastructure. Each row records the aggregated financial aid counts, award amounts, and disbursement amounts associated with a specific response to a school code submission.

The ETRM metadata notes that the object is not implemented in the reference database, meaning installations may not physically deploy this table unless the older Student Loan or Title IV response processing flows are active. Under a heuristic Data Vault classification mined from the foreign key structure, the table leans toward a satellite modeling role. This suggests it should be treated as a descriptive child that captures measurable attributes tied to a parent response, rather than as an independent hub of unique business entities.

Key Information Stored

The primary key is defined by the unique index IGF_SL_RESP_F_SMRY_PK on FIN_SMRY_RESP_ID, a system-assigned surrogate identifier for each summary response record. The single documented foreign key column, REP_SCHL_RESP_ID, links the row back to the parent school-level response, making it the principal business-key candidate for join purposes.

The remaining meaningful columns fall into two categories. The first captures counts of student records within the response: TOT_CNT_NUM (total count), TOT_CNT_ACPT_NUM, TOT_CNT_REJ_NUM, TOT_CNT_DUP_NUM, TOT_CNT_CORR_NUM, TOT_CNT_VER_SLCTD_NUM, and TOT_CNT_SSADMIN_NUM, distinguishing accepted, rejected, duplicate, correction, verification-selected, and SSA-administrative populations. The second captures monetary aggregates: TOT_REP_AWD_AMT, TOT_REP_DISB_AMT, TOT_FIN_AWD_ACPT_AMT, TOT_FIN_DISB_ACPT_AMT, TOT_FUND_DISB_ACPT_AMT, TOT_NONFUND_DISB_ACPT_AMT, and TOT_FIN_AWD_CORR_AMT. FIN_AWARD_TYPE and FIN_AWARD_YEAR provide the categorical dimensions for the summary. Standard audit and concurrency columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, REQUEST_ID) support traceability back to the concurrent program execution that inserted the row.

Common Use Cases and Queries

The primary use case is reconciliation of federal response totals against internally computed aid figures. Financial aid administrators and reporting developers query this table to confirm that award and disbursement amounts reported by the federal processor match institutional records. A typical join pattern retrieves the full response context:

• SELECT s.REP_SCHL_RESP_ID, s.FIN_AWARD_YEAR, s.FIN_AWARD_TYPE, s.TOT_REP_AWD_AMT, s.TOT_REP_DISB_AMT FROM IGF_SL_RESP_F_SMRY s WHERE s.FIN_AWARD_YEAR = :year
• Aggregation by award type and year to produce trend reports on accepted versus rejected counts across processing cycles.
• Discrepancy detection comparing TOT_FIN_AWD_ACPT_AMT with corresponding detail records to isolate parsing or transmission errors.
• Audit trails that reconcile rows back to the originating concurrent request using REQUEST_ID and PROGRAM_APPLICATION_ID.

Because the table is marked obsolete, queries typically appear only in legacy migration scripts or in historical reporting where earlier award years must be preserved.

Related Objects

The most direct relationship is with the parent response table referenced by the foreign key column REP_SCHL_RESP_ID, which anchors the school-level response header. Because the documented metadata exposes only that single foreign-key join, the surrounding object set is inferred from the IGF response-parsing family, which typically includes:

• IGF_SL_RESP_F_SMRY (this table) — joined to its parent on REP_SCHL_RESP_ID.
• Parent response header table — the school response entity supplying REP_SCHL_RESP_ID.
• Award-level detail tables — holding the per-student records summarized by the TOT_CNT and TOT_*_AMT columns here.
• Disbursement detail tables — reconciling against TOT_FUND_DISB_ACPT_AMT and TOT_NONFUND_DISB_ACPT_AMT.
• Concurrent program and request metadata tables — linked through REQUEST_ID and PROGRAM_ID for execution traceability.
• Student aid award entities — providing the FIN_AWARD_TYPE and FIN_AWARD_YEAR dimension values.

Each of these connections reinforces the satellite classification: the summary table hangs off a parent response and carries the additive measures used for reconciliation and reporting rather than defining new business keys of its own.