Results for “further_study”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The view IGSBV_ST_HESA_DLHE_SURVEY_RECS is a base business view within the Oracle E-Business Suite IGS – Student System product family. It exposes Destination of Leavers from Higher Education (DLHE) survey records, the statutory survey instrument used by UK higher education institutions to capture graduate outcomes approximately six months after qualification. The view is catalogued as part of the obsolete IGS schema footprint and is documented in ETRM as a Base business view to allow queries on student DLHE survey records. Its purpose is to flatten the normalized DLHE survey data model into a single, query-friendly projection suitable for reporting, extract generation, and integration with external bodies such as HESA (the Higher Education Statistics Agency).

Because it is a view rather than a table, no physical storage is allocated to it, and the documented implementation note states that it is not implemented in this database in the reference environment. Organizations running Oracle EBS 12.1.1 or 12.2.2 with the IGS module licensed should validate its presence in their own instance before relying on it.

Underlying Base Objects

ETRM lists no referenced base objects for this view, which reflects the obsoleted status of the surrounding IGS documentation rather than an absence of dependencies. The view text, however, reveals its principal anchor table: the DLHE survey record table accessed through the alias DLHE, joined to the party/person table accessed through the alias PER. The person identifier is carried across from DLHE.PERSON_ID and enriched with PER.PARTY_NUMBER, exposing the human-readable person number alongside the internal surrogate key.

Conceptually, one row in the view corresponds to one DLHE survey return record for one person within one submission. The SUBMISSION_NAME and RETURN_NAME columns confirm this grain: a submission represents a statutory data return period, and the survey record is the individual leaver's response within it.

Key Columns

The view projects a broad set of columns that map directly to the DLHE survey schema. The most significant include:

• DLHE_RECORD_STATUS – the lifecycle status of the survey record itself, governing whether the return has been captured, validated, or finalized. This is the column most frequently searched, typically in the context of dlhe_record_status filtering.
• PERSON_ID / PERSON_NUMBER – the internal party identifier and the exposed party number used to correlate the record with student and person records elsewhere in the system.
• SUBMISSION_NAME / USER_RETURN_SUBCLASS / RETURN_NAME – the statutory return context, defining which HESA submission the record belongs to.
• QUALIFYING_PERIOD_CODE – the academic period against which the leaver qualified.
• DATE_STATUS_CHANGED / VALIDATION_STATUS / ADMIN_CODING – audit and data-quality columns supporting validation and administrative review workflows.
• PARTICIPANT_SOURCE – indicates the source from which the survey participant data was obtained.
• SURVEY_METHOD – the mode of survey response (for example, postal, telephone, or web).

The remaining columns fall into two functional groups: outcomes (EMPLOYMENT, FURTHER_STUDY, QUALIFIED_TEACHER, PT_STUDY) and detailed employment attributes such as employer name, business, classification, location, postcode and country, together with job title, duties, classification, size, duration and salary. Reason and source codes, including the eight JOB_REASON slots and the JOB_SOURCE pairs, support the "why this job" and "how found" survey questions. A PREVIOUS_JOB group captures the leaver's prior employment position.

Common Use Cases and Queries

The view supports statutory return preparation, data-quality dashboards, and ad-hoc analysis of graduate outcomes. A typical starting query retrieves records by status:

• Counting records by status for a given submission: SELECT DLHE_RECORD_STATUS, COUNT(*) FROM IGSBV_ST_HESA_DLHE_SURVEY_RECS WHERE SUBMISSION_NAME = :p_submission GROUP BY DLHE_RECORD_STATUS;
• Identifying records requiring attention: SELECT PERSON_NUMBER, RETURN_NAME, DLHE_RECORD_STATUS, DATE_STATUS_CHANGED FROM IGSBV_ST_HESA_DLHE_SURVEY_RECS WHERE DLHE_RECORD_STATUS IN ('UNVALIDATED','ERROR') ORDER BY DATE_STATUS_CHANGED;
• Analysing employment outcomes: SELECT EMPLOYMENT, JOB_CLASSIFICATION, COUNT(*) FROM IGSBV_ST_HESA_DLHE_SURVEY_RECS WHERE QUALIFYING_PERIOD_CODE = :p_period GROUP BY EMPLOYMENT, JOB_CLASSIFICATION;

Because the view is obsolete and not implemented by default, queries returned to front-end tools or integration interfaces should be wrapped with availability checks, and any replacement to native HESA reporting or the modern Graduate Outcomes framework should be considered where the IGS module is no longer actively maintained.