Search Results igf_sl_rep_stdnt_v

Overview

IGF_SL_REP_STDNT_V is a reporting view within the Oracle E-Business Suite Financial Aid module (IGF), historically associated with the Direct Loan processing subsystem. Its documented purpose is to supply the data required to populate the Student tag in the outbound XML payload transmitted to the Common Origination and Disbursement (COD) system for Direct Loan origination and disbursement. In the context of Oracle EBS 12.1.1 and 12.2.2, this view represents a presentation-layer construct that flattens and formats student-level demographic and permanent-address attributes so that the outbound XML generation process can consume a single, pre-formatted result set rather than joining multiple base tables at runtime.

The view is catalogued under the IGF - Financial Aid product, which is marked obsolete in later releases. As a consequence, it is typically absent from fresh 12.1.1 and 12.2.2 installations, and the ETRM metadata explicitly records "Not implemented in this database." Its presence is therefore generally limited to legacy environments that were upgraded from earlier Financial Aid implementations and in which Direct Loan processing remained configured.

Underlying Base Objects

The ETRM metadata documents no referenced base objects, but the view text embedded in the definition clearly identifies a single source object: IGF_SL_LOR_LOC_ALL. All columns projected by the view are drawn from this table, and the query applies a GROUP BY clause over every projected expression, effectively producing a distinct set of student records. The reliance on a single base table simplifies lineage analysis, though the absence of documented foreign-key relationships means that join semantics to student, person, or address entities must be inferred from the underlying Financial Aid data model.

Because the view is not instantiated as a physical object in many databases, DBAs should verify its existence with a query against ALL_VIEWS before attempting to reference it in custom reports or concurrent programs.

Key Columns

The view exposes a broad set of student identity, address, and eligibility attributes. Notable columns include:

• BASE_ID — the primary identifier linking the record to the originating Financial Aid entity.
• S_SSN and S_CHG_SSN — the student's Social Security Number and any changed SSN value reported to COD.
• S_LAST_NAME, S_FIRST_NAME, S_MIDDLE_INITIAL — name components, with the middle name reduced to a single initial via SUBSTR.
• S_PERMT_ADDR1, S_PERMT_ADDR2, S_PERMT_CITY, S_PERMT_STATE, S_PERMT_ZIP, S_PERMT_COUNTY, S_PERMT_COUNTRY — the permanent address block, which is the focus of the user's s_permt_city search term.
• S_PERMT_PHONE, S_EMAIL_ADDR — contact details.
• S_DATE_OF_BIRTH, S_CHG_BIRTH_DATE — dates formatted as YYYY-MM-DD for XML compatibility.
• S_LICENSE_NUM, S_LICENSE_STATE — driver's license data.
• S_DEPNCY_STATUS, S_CITIZENSHIP_STATUS — dependency and citizenship indicators.
• S_FOREIGN_POSTAL_CODE — foreign address support.
• ATD_ENTITY_ID_TXT, REP_ENTITY_ID_TXT, DOCUMENT_ID_TXT — entity and document identifiers used in the COD transmission.

All textual columns are wrapped in TRIM to remove padding, ensuring clean values in the outbound XML.

Common Use Cases and Queries

The primary use case is extraction of Student-tag data for Direct Loan outbound XML. A typical query filtering on the permanent city would be:

• SELECT base_id, s_ssn, s_last_name, s_first_name, s_permt_city, s_permt_state FROM igf_sl_rep_stdnt_v WHERE s_permt_city = 'BOSTON';
• SELECT base_id, s_permt_city, s_permt_zip FROM igf_sl_rep_stdnt_v WHERE s_permt_state = 'MA' ORDER BY s_permt_city;
• SELECT COUNT(*) FROM igf_sl_rep_stdnt_v WHERE s_permt_city IS NULL; — used to identify records that would produce an empty XML tag.

Because the view is obsolete in 12.1.1 and 12.2.2, any query must be validated against the specific instance; where the view is absent, equivalent logic must be reconstructed directly from IGF_SL_LOR_LOC_ALL.