Search Results phone_number_2

Overview

IGF.IGF_SL_ST_RESP_DTLS is a transactional table in the Oracle E-Business Suite student financial aid (IGF) schema. It stores Student Tag Response Elements parsed from the response XML file returned by the federal student aid processing cycle, capturing the student-supplied identity, address, contact, and citizenship data submitted on the Free Application for Federal Student Aid (FAFSA) or its renewal. The table is owned by the IGF schema in the ETRM 12.1.1 / 12.2.2 data model and resides in the APPS_TS_TX_DATA tablespace with a PCTFREE of 10. Rows are keyed by STDNT_RESP_ID and reference the corresponding attending-school response record through ATD_SCHL_RESP_ID.

The mined Data Vault classification for this object is satellite-leaning. From a dimensional modeling perspective, this suggests the table behaves as a descriptive satellite attached to a student-response business key rather than as an independent hub or a link between unrelated entities. Its foreign key into IGF_SL_AS_RESP_DTLS reinforces that it carries attribute-level detail subordinate to the broader response structure.

Key Information Stored

The table contains 47 documented columns. The most operationally significant are:

• STDNT_RESP_ID — surrogate primary key, enforced by unique index IGF_SL_ST_RESP_DTLS_PK. This is the sole documented unique-index business-key candidate.
• ATD_SCHL_RESP_ID — foreign key linking each student response row to its parent attending-school response record in IGF_SL_AS_RESP_DTLS.
• S_SSN — current Social Security Number of the student; S_CHG_SSN records a changed SSN.
• FIRST_NAME, MIDDLE_NAME, S_LAST_NAME — student name attributes; S_CHG_LAST_NAME tracks a changed surname.
• S_DATE_OF_BIRTH and S_CHG_DATE_OF_BIRTH — original and corrected date of birth.
• DRIVER_LIC_STATE and DRIVER_LIC_NUMBER — driver's license identity attributes.
• PERMT_ADDR_LINE_1 through PERMT_ADDR_POST_CODE, plus PERMT_ADDR_COUNTRY and PERMT_ADDR_FOREIGN_FLAG — the student's permanent address block.
• TEMP_ADDR_* columns — the temporary address block, mirroring the permanent address structure.
• PHONE_NUMBER_1, PHONE_NUMBER_2, PHONE_NUMBER_3 — student contact telephone numbers, which is the column the searcher referenced.
• EMAIL_ADDRESS, CITZN_STATUS_CODE, and NOTE_MESSAGE — electronic contact, citizenship status, and free-form notes.
• RESP_CODE and the WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, REQUEST_ID) — response status and audit/concurrent-program context.

Common Use Cases and Queries

Typical reporting use cases include verifying corrected student identity data, validating contact information for correspondence, and reconciling address data against the permanent and temporary blocks. A pattern for retrieving contact details by response identifier:

• SELECT STDNT_RESP_ID, FIRST_NAME, S_LAST_NAME, PHONE_NUMBER_1, PHONE_NUMBER_2, PHONE_NUMBER_3, EMAIL_ADDRESS FROM IGF.IGF_SL_ST_RESP_DTLS WHERE STDNT_RESP_ID = :p_resp_id;
• Join to the parent record: SELECT d.STDNT_RESP_ID, d.S_SSN, d.PHONE_NUMBER_3, a.ATD_SCHL_RESP_ID FROM IGF.IGF_SL_ST_RESP_DTLS d, IGF.IGF_SL_AS_RESP_DTLS a WHERE d.ATD_SCHL_RESP_ID = a.ATD_SCHL_RESP_ID;
• Detect changed identity values: SELECT STDNT_RESP_ID FROM IGF.IGF_SL_ST_RESP_DTLS WHERE S_CHG_SSN IS NOT NULL OR S_CHG_LAST_NAME IS NOT NULL OR S_CHG_DATE_OF_BIRTH IS NOT NULL;
• Audit trail by request: SELECT REQUEST_ID, PROGRAM_ID, CREATION_DATE FROM IGF.IGF_SL_ST_RESP_DTLS WHERE REQUEST_ID = :p_request_id;

Because the table is written by the federal response import process, queries are most commonly constrained by STDNT_RESP_ID, ATD_SCHL_RESP_ID, or the concurrent REQUEST_ID, and are balanced against records loaded during the same processing window.

Related Objects

• IGF.IGF_SL_AS_RESP_DTLS — parent attending-school response detail; joined via ATD_SCHL_RESP_ID. This is the documented foreign-key relationship.
• IGF_SL_ST_RESP_DTLS_PK — the supporting unique index on STDNT_RESP_ID in APPS_TS_TX_IDX.
• IGF application APIs — the student response import and correction routines that populate this table during the federal aid response cycle.
• Associated response header and correction tables within the IGF schema that share the STDNT_RESP_ID or ATD_SCHL_RESP_ID lineage and drive downstream needs-analysis and disbursement processing.