Results for “dl_info_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The IGF_SL_DI_RESP_DTLS table resides in the IGF schema, which supports the Oracle Financial Aid (IGF) module delivered with Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to store the Direct Loan (DL) Loan Information Response Elements parsed from a response XML file returned by an external student loan servicing interface. In practice, the table acts as a staging and persistence layer where inbound loan origination and disbursement responses are decomposed into discrete, queryable columns rather than remaining as raw XML payloads.

From a modeling perspective, the metadata suggests a satellite-leaning classification under a Data Vault heuristic derived from the foreign key structure. The table describes attributes of a single loan information record keyed by a surrogate identifier, with a foreign reference outward to a processing/results parent. It does not itself behave as a hub of business entities or as a many-to-many link. This classification should be treated as a modeling suggestion rather than a documented design decision, but it aligns with the table's role as a descriptive detail store supporting a broader processing event.

Key Information Stored

The table exposes 22 documented columns in the 12.1.1 physical schema. The most significant of these fall into three groups:

• DL_INFO_ID — the primary key, enforced by the unique index IGF_SL_DI_RESP_DTLS_PK, serving as the surrogate identifier for each response detail row.
• STDNT_RESP_ID — the foreign key column referencing the parent student response record; this is the principal business-key candidate linking the detail to its originating response context.
• LOAN_KEY_NUM — identifies the specific loan record within the response, used to correlate individual loan elements.
• ORIG_FEE_PCT_NUM and INT_REB_PCT_NUM — numeric fields holding the origination fee percentage and interest rebate percentage, both critical for loan cost calculations.
• PNOTE_PRINT_CODE and DISCLOSURE_PRINT_CODE — codes governing whether a promissory note and disclosure statement should be printed for the loan.
• GRADE_LEVEL_CODE — records the borrower's grade level, which affects loan limits and eligibility.
• FIN_AWD_BEGIN_DATE / FIN_AWD_END_DATE and ACAD_YR_BEGIN_DATE / ACAD_YR_END_DATE — paired date ranges describing the financial aid award period and the academic year.
• RESP_CODE — the response status or result code returned for the loan information element.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle EBS audit columns tracking who created and last modified each row.
• PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, REQUEST_ID — concurrent program and request context columns identifying the process that loaded the record.

No separate multi-column unique index is documented beyond the primary key, so DL_INFO_ID is the sole documented surrogate key while STDNT_RESP_ID functions as the meaningful foreign business reference.

Common Use Cases and Queries

The table is typically queried when diagnosing loan response processing, reconciling loan awards against servicer responses, or reporting on origination fee and rebate percentages. A common access pattern joins the detail back to its parent response record:

• Retrieve all loan detail rows for a specific student response using STDNT_RESP_ID as the filter predicate.
• Extract fee and rebate percentages by loan key for financial reconciliation, selecting LOAN_KEY_NUM, ORIG_FEE_PCT_NUM, and INT_REB_PCT_NUM.
• Audit print eligibility by inspecting PNOTE_PRINT_CODE and DISCLOSURE_PRINT_CODE across the academic year date ranges.
• Trace loading history and troubleshooting using REQUEST_ID, PROGRAM_ID, and the LAST_UPDATE_DATE audit columns to identify which concurrent request produced a given detail record.

Because it holds decomposed response elements rather than raw XML, the table supports direct SQL reporting without XML parsing, making it suitable for operational dashboards covering loan origination outcomes.

Related Objects

The FK metadata identifies the following significant relationships:

• IGF_SL_ED_PRC_RSLTS — referenced through the relationship where EDIT_ID is associated with this table; the processing-results parent that governs lifecycle and outcome of loan response handling, joined via the shared response identifier.
• IGF_SL_DI_RESP_DTLS itself acts as the child in the STDNT_RESP_ID foreign key relationship, meaning the parent student response record supplies the contextual link to the broader response XML submission.

Additional IGF loan-processing tables and concurrent programs that consume DL loan response XML are logically related, and any integration or extension touching loan response data should honor the DL_INFO_ID primary key and the STDNT_RESP_ID foreign reference to preserve referential integrity within the Financial Aid module.