Search Results igf_sl_st_resp_dtls




Overview
Explore in AI Chat

Overview

IGF_SL_ST_RESP_DTLS is a Financial Aid module table in Oracle E-Business Suite that stores Student Tag Response Elements parsed from a Student Aid response XML file. The table resides in the IGF schema, which historically supported the U.S. federal student loan and Title IV financial aid processing flows. Within the context of EBS 12.1.1 and 12.2.2, the object is documented as obsolete and is flagged as not implemented in the ETRM reference database, meaning no runtime evidence of its population exists in the examined environment. Any EBS 12.1.1 or 12.2.2 implementation should therefore treat IGF_SL_ST_RESP_DTLS as a historical artifact rather than an active processing table.

From a Data Vault modeling perspective, the heuristic classification derived from the foreign-key structure is satellite-leaning. The table carries a single surrogate primary key plus descriptive attributes and a foreign key to a parent response record, a pattern consistent with a dependent satellite chained off an aggregate response entity. Its 47 documented columns are organized as a single-row-per-response payload.

Key Information Stored

The table holds the student-level components of a federal aid response file. Notable columns include:

Common Use Cases and Queries

Because the table is documented as obsolete, the primary use cases are retrospective: historical reconciliation audits, data migration inventory, and impact analysis for customization cleanup. Where a legacy instance still holds data, a typical join retrieves student detail alongside the parent response record:

  • Parent-child retrieval: SELECT s.STDNT_RESP_ID, s.S_SSN, s.S_LAST_NAME, a.* FROM IGF_SL_ST_RESP_DTLS s, IGF_SL_AS_RESP_DTLS a WHERE s.ATD_SCHL_RESP_ID = a.ATD_SCHL_RESP_ID;
  • Repository activity check: query DBA_TABLES and DBA_TAB_COLUMNS for owner IGF to confirm whether the object is instantiated.
  • Change-flag reporting: select rows where any S_CHG_* flag is set to identify demographic discrepancies between application and response.
  • Audit traceability: filter by CREATION_DATE, LAST_UPDATE_DATE, or REQUEST_ID to tie records back to a concurrent program run.

Related Objects

The dominant relationship is the foreign key to IGF_SL_AS_RESP_DTLS on ATD_SCHL_RESP_ID, defining the applicant/attending-school response as the parent of this student detail. Related sourcing and processing objects in the same functional area include the response-file staging tables that feed IGF_SL_AS_RESP_DTLS, and the Financial Aid concurrent programs that parse inbound XML responses. Because the module is marked obsolete in EBS 12.1.1 and 12.2.2, downstream consumers should verify dependencies through the ETRM and DBA_DEPENDENCIES rather than assuming active integration.