Results for “igs_he_stdnt_dlhe”

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

Overview

The IGS_HE_STDNT_DLHE table resides in the IGS schema within the Oracle E-Business Suite Student System (IGS) module. Its documented purpose is to store Student Destination of Leavers from Higher Education (DLHE) details for each Submission Return Qualifying Period. In practice, this table acts as the primary repository for the survey responses that higher education institutions collect from graduates approximately six months after award, which are then submitted to statutory returns bodies such as HESA. Each row represents one student's DLHE record tied to a specific submission and return configuration.

The table is delivered with 86 columns in the documented 12.1.1 physical schema and retains a VALID status. From a heuristic Data Vault modeling perspective, the mined foreign key structure classifies this object as a link table. This classification reflects the fact that the table primarily connects a party (the student) to a submission/return qualifying context, with the descriptive survey attributes attached as dependent data. Implementers building downstream analytical models may therefore treat it as a connective entity rather than an independent hub.

Key Information Stored

The primary key is defined by the constraint IGS_HE_STDNT_DLHE_PK, which comprises three columns: PERSON_ID, SUBMISSION_NAME, and RETURN_NAME. These same three columns constitute the unique business-key candidate documented for the table. PERSON_ID is a foreign key to HZ_PARTIES, identifying the student, while SUBMISSION_NAME and RETURN_NAME link the record to the submission return qualifying definition.

The most significant columns include:

• PERSON_ID — Identifies the graduate whose DLHE activity is recorded; joins to the party model.
• SUBMISSION_NAME and RETURN_NAME — Together with USER_RETURN_SUBCLASS and QUAL_PERIOD_CODE, they scope the record to a particular return cycle and qualifying period.
• DLHE_RECORD_STATUS and VALIDATION_STATUS — Track the workflow state of the record from collection through validation.
• DATE_STATUS_CHANGED — Audit point for status transitions.
• EMPLOYMENT and FURTHER_STUDY — Core destination indicators distinguishing employed leavers from those continuing study.
• EMPLOYER_NAME, JOB_TITLE, JOB_CLASSIFICATION, JOB_SALARY, and JOB_DURATION — Employment outcome attributes used for reporting.
• COURSE_NAME, FURTHER_STUDY_TYPE, and FURTHER_STUDY_PROVIDER — Further study outcome attributes.
• QUALIFIED_TEACHER, TEACHER_TEACHING, and TEACHER_SEEKING — Teacher training destination detail.
• POPDLHE_FLAG — Indicates the population/derivation context for the record.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, and LAST_UPDATE_DATE — Standard WHO audit columns.

Common Use Cases and Queries

Typical use cases include HESA DLHE return preparation, institutional employability reporting, and reconciliation of submission data. A frequent query retrieves all DLHE records for a given return cycle:

SELECT person_id, dlhe_record_status, employment, further_study
FROM   igs.igs_he_stdnt_dlhe
WHERE  submission_name = :submission
AND    return_name = :return
AND    qual_period_code = :qpc;

Reporting extracts frequently aggregate employment outcomes by job classification or salary band, and validation queries filter on VALIDATION_STATUS or DATE_STATUS_CHANGED to identify records requiring intervention before submission. Reconciliation joins against IGS_HE_SUB_RTN_QUAL confirm that each DLHE record maps to a valid qualifying period definition.

Related Objects

The following objects are directly referenced by the documented foreign keys:

• HZ_PARTIES — joined on PERSON_ID to retrieve party/person details for the student.
• IGS_HE_SUB_RTN_QUAL — joined on SUBMISSION_NAME, USER_RETURN_SUBCLASS, RETURN_NAME, and QUAL_PERIOD_CODE to resolve the return qualifying period definition.

Beyond these documented relationships, implementers commonly join IGS_HE_STDNT_DLHE to student enrolment and programme tables in the IGS schema to enrich destination analysis, and to HESA return staging objects where DLHE survey data is consolidated before statutory submission. The tight coupling to HZ_PARTIES means any person-level reporting or data cleansing activity should account for this table's participation in the party model.