Search Results atd_schl_resp_id




Overview
Explore in AI Chat

Overview

The table IGF.IGF_SL_AS_RESP_DTLS is a transactional table within the Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 environment, owned by the IGF schema (the schema associated with Oracle's Student Systems / Financial Aid and broader Education & Research industry solutions). Its documented purpose is to store the "Attending School Tag Response Elements" captured from an inbound response XML file — in other words, the parsed result of an external agency's or servicer's reply concerning a student's attending-school designation. This table forms part of the data-exchange layer that ingests structured responses and makes each response element queryable by the application, rather than retaining it only as a raw XML payload. Storage resides in the APPS_TS_TX_DATA tablespace with a PCTFREE of 10, which is typical for actively inserted operational tables.

From a modeling perspective, the Data Vault classification mined from the foreign-key structure is hub-leaning. This suggests the table behaves primarily as a hub, keyed on a single surrogate identifier, with dependent detail rows (such as IGF_SL_ST_RESP_DTLS) hanging off it as satellites. The heuristic is offered as a modeling suggestion rather than an EBS-enforced constraint.

Key Information Stored

The table is defined with 13 columns and a single unique index, IGF_SL_AS_RESP_DTLS_PK, built on ATD_SCHL_RESP_ID. This column is the surrogate primary key and identifier for the attending-school response records. Business-key candidates documented via the unique index are limited to this same column; no separate natural key unique index exists.

  • ATD_SCHL_RESP_ID (NUMBER) — Surrogate primary key identifying each attending-school response record; the column the user searched for ("atd_schl_resp_id").
  • REP_SCHL_RESP_ID (NUMBER) — Foreign-key identifier linking to the corresponding reporting school response record, establishing the parent/child relationship in the response structure.
  • ATD_ENTITY_ID_TXT (VARCHAR2(30)) — The Entity ID of the attending school, held as text rather than a numeric ID.
  • RESP_CODE (VARCHAR2(30)) — The response code returned for the attending-school element.
  • Standard Who columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — audit trail of record creation and modification.
  • Concurrent-program context: PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, REQUEST_ID — traceability to the request/program that inserted or updated the row.

Common Use Cases and Queries

Typical use cases include reconciling inbound XML responses, auditing which attending schools were tagged, and joining detail rows to their reporting-school parents. A standard retrieval follows the documented query text:

  • Point lookup by key: SELECT * FROM IGF.IGF_SL_AS_RESP_DTLS WHERE ATD_SCHL_RESP_ID = :id;
  • Response-code reporting: SELECT RESP_CODE, COUNT(*) FROM IGF.IGF_SL_AS_RESP_DTLS GROUP BY RESP_CODE;
  • Parent/child join: SELECT a.ATD_SCHL_RESP_ID, a.ATD_ENTITY_ID_TXT, a.RESP_CODE FROM IGF.IGF_SL_AS_RESP_DTLS a WHERE a.REP_SCHL_RESP_ID = :rep_id;
  • Audit trace by request: SELECT * FROM IGF.IGF_SL_AS_RESP_DTLS WHERE REQUEST_ID = :request_id;

These patterns are useful for troubleshooting reconciliation failures and for operational reporting on response volumes.

Related Objects

Relationship data identifies the following significant dependencies:

  • IGF.IGF_SL_AS_RESP_DTLS itself is exposed as an APPS synonym/view for application access.
  • IGF_SL_ST_RESP_DTLS.ATD_SCHL_RESP_ID references this table — a child satellite carrying status-level response detail.
  • IGF_SL_ED_PRC_RSLTS.EDIT_ID references this table — holding edit/processing results per record.
  • REP_SCHL_RESP_ID acts as the foreign key toward the reporting-school response parent (documented as an internal reference).

Because the table does not itself reference external database objects beyond the parent link, it functions as a focal hub whose dependent detail tables supply the richer, time-variant attributes.