Search Results tot_cnt_rej_num

Overview

IGF.IGF_SL_RESP_F_SMRY is a transactional table within the Oracle E-Business Suite 12.1.1 and 12.2.2 environments, owned by the IGF schema. It stores Response Financial Summary Tag Elements extracted from student financial aid response XML files, functioning as the consolidated financial summary layer within the Title IV aid processing pipeline. The table resides in the APPS_TS_TX_DATA tablespace with a PCTFREE of 10, while its unique index IGF_SL_RESP_F_SMRY_PK is housed in APPS_TS_TX_IDX. The physical schema documented in ETRM 12.1.1 records 27 columns. Heuristic Data Vault modeling suggests a satellite-leaning classification, given its reliance on a single-column primary key and a foreign-key reference to a parent reporting school response record; this places it as a dependent detail object whose grain is one row per financial award type per award year within a response document.

Key Information Stored

The primary key is FIN_SMRY_RESP_ID, a system-generated NUMBER that uniquely identifies each financial summary response record and anchors the unique index IGF_SL_RESP_F_SMRY_PK. The business linkage to the parent document is carried by REP_SCHL_RESP_ID, a foreign key that references the reporting school response record; this pairing of keys qualifies FIN_SMRY_RESP_ID as the surrogate identifier rather than a business key.

• FIN_AWARD_TYPE — the financial award type grouping the summarized metrics.
• FIN_AWARD_YEAR — the award year to which the summary aggregates apply.
• TOT_CNT_NUM — the total number of student tags in the document, summarized by award type and award year.
• TOT_CNT_ACPT_NUM — total accepted awards, summarized by award type and award year.
• TOT_CNT_REJ_NUM — total rejected awards within the document.
• TOT_CNT_DUP_NUM — total duplicate awards detected.
• TOT_CNT_CORR_NUM — total corrected awards reported.
• TOT_CNT_VER_SLCTD_NUM — total students reported selected for verification by CPS.
• TOT_CNT_SSADMIN_NUM — the column matched by the user's search "tot_cnt_ssadmin_num"; it records the total number of students reported by CPS to have an SSA match not equal to 4, summarized by award type and award year.
• TOT_REP_AWD_AMT — the total reported award dollar amount.
• TOT_REP_DISB_AMT — the total reported disbursement amount.
• TOT_FIN_AWD_ACPT_AMT — accepted financial award amount.
• TOT_FIN_DISB_ACPT_AMT — accepted financial disbursement amount.

Standard audit and concurrent-program columns are also present: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, and REQUEST_ID.

Common Use Cases and Queries

The table is primarily consumed by financial aid reporting and reconciliation processes. A typical query aggregates acceptance ratios by award year:

SELECT FIN_AWARD_YEAR, FIN_AWARD_TYPE, SUM(TOT_CNT_ACPT_NUM) accepted, SUM(TOT_CNT_NUM) total FROM IGF.IGF_SL_RESP_F_SMRY GROUP BY FIN_AWARD_YEAR, FIN_AWARD_TYPE;

Verification and SSA exception reporting frequently targets TOT_CNT_VER_SLCTD_NUM and TOT_CNT_SSADMIN_NUM to isolate populations flagged by CPS. Joining to the parent response record via REP_SCHL_RESP_ID allows reporting school identity and document-level attributes to be layered onto these summaries. Disbursement reconciliation compares TOT_REP_DISB_AMT against TOT_FIN_DISB_ACPT_AMT, with REQUEST_ID enabling traceability back to the originating concurrent program run.

Related Objects

The dominant relationship is the foreign-key reference from REP_SCHL_RESP_ID to the parent reporting school response table, which supplies document context. The accompanying response detail tables in the IGF schema — including school, student, and award-level response entities — share this same parent and join naturally on REP_SCHL_RESP_ID. The unique index IGF_SL_RESP_F_SMRY_PK governs access paths on FIN_SMRY_RESP_ID. Concurrent program and request metadata objects are referenced through PROGRAM_APPLICATION_ID, PROGRAM_ID, and REQUEST_ID, supporting process lineage and audit. Because the table stores summarized CPS-derived values rather than raw tag data, it is typically queried alongside, not instead of, the granular award and student response tables that populate the same response document.