Search Results oss_spec_stud




Overview
Explore in AI Chat

Overview

IGS_HE_AD_DTL2_V is an Oracle E-Business Suite view owned by the APPS schema and defined within the Oracle Student System (OSS) module of the Education and Training vertical (ETRM). Its name follows the module convention: "IGS" identifies the Student System product family, "HE_AD_DTL2" denotes a Higher Education admissions detail entity presented in a denormalized second variant, and the "_V" suffix confirms it is a read-only view rather than a base table.

The view serves as a reporting and integration layer over the IGS_HE_AD_DTL table. Rather than requiring report authors or downstream interfaces to understand the internal code values stored in the transactional table, it joins four internal lookup tables and resolves coded attributes into human-readable descriptions. This makes it suitable for concurrent programs, discoverer workbooks, OBIEE extracts, and outbound data feeds that must present legacy admissions data in a legible form. The view is registered in ETRM under the 12.2.2 documentation set.

Underlying Base Objects

The view is defined as a five-table join with outer joins against the code-value lookup table:

  • IGS_HE_AD_DTL (alias A) — the primary transactional table holding admission application detail records. Provides all coded columns and audit columns.
  • IGS_HE_CODE_VALUES (aliases B, C, D, E) — the same lookup table is referenced four times, once per coded attribute, each with an outer join (+) and a distinct CODE_TYPE filter.

Four code types are used: OSS_DOM for domicile, OSS_OCC for occupation, OSS_SOC for social class, and OSS_SPEC_STUD for special student. The user's search term "oss_spec_stud" corresponds directly to the fourth code type, which is filtered on alias E and produces the SPECIAL_STUDENT_DESC column. Because outer joins are used throughout, records whose codes have no matching lookup entry are still returned, with description columns set to null.

Key Columns

Common Use Cases and Queries

Typical scenarios include validating admissions extracts before submission to statutory bodies, producing data quality reports that highlight records with unresolvable codes, and feeding a reporting schema.

Records flagged for the special student code:

SELECT person_id, admission_appl_number, special_student_cd, special_student_desc
FROM   apps.igs_he_ad_dtl2_v
WHERE  special_student_cd IS NOT NULL;

Detecting orphans where the lookup failed:

SELECT person_id, admission_appl_number, domicile_cd, domicile_desc
FROM   apps.igs_he_ad_dtl2_v
WHERE  domicile_cd IS NOT NULL AND domicile_desc IS NULL;

Distinct decoded distributions across all four attributes:

SELECT social_class_desc, COUNT(*)
FROM   apps.igs_he_ad_dtl2_v
GROUP  BY social_class_desc;

Because ROW_ID exposes the base table ROWID, the view can also be joined back to IGS_HE_AD_DTL for update-driven incremental extracts.