Search Results igs_he_stdnt_dlhe

Overview

The IGS_HE_STDNT_DLHE table is a core data object within the Oracle E-Business Suite (EBS) Student System (IGS) module, specifically designed to support the Destinations of Leavers from Higher Education (DLHE) survey process. This table serves as the central repository for storing individual student DLHE survey details, linking them to specific institutional reporting cycles. Its primary role is to manage and persist the data required for statutory returns related to graduate outcomes, ensuring that information for each qualifying student is accurately captured and associated with the correct submission period and return classification as mandated by regulatory bodies.

Key Information Stored

The table's structure is defined by its composite primary key, which uniquely identifies a student's DLHE record for a specific reporting instance. The key columns are PERSON_ID, SUBMISSION_NAME, and RETURN_NAME. PERSON_ID links to the party (student) in the Trading Community Architecture (TCA) via the HZ_PARTIES table. SUBMISSION_NAME and RETURN_NAME, along with USER_RETURN_SUBCLASS and QUAL_PERIOD_CODE, are foreign keys that anchor the student record to a specific reporting context defined in the IGS_HE_SUB_RTN_QUAL table. While the provided metadata highlights these key structural columns, the table would typically also contain numerous attribute columns capturing the detailed survey responses, such as employment status, job role, further study details, and salary information, which are essential for the aggregated DLHE return.

Common Use Cases and Queries

This table is central to operations involving graduate outcomes reporting. Common use cases include the batch extraction of data for statutory submissions to higher education authorities, the generation of internal institutional reports on graduate destinations, and providing data for student alumni services. A typical query pattern involves joining to related setup and person tables to produce a comprehensive dataset for a submission period.

• Sample Query for a Specific Return:
  SELECT stdnt.*, party.party_name
  FROM igs.igs_he_stdnt_dlhe stdnt
  JOIN hz_parties party ON stdnt.person_id = party.party_id
  WHERE stdnt.submission_name = 'DLHE_SUBMISSION_2023'
  AND stdnt.return_name = 'MAIN_RETURN';
• Reporting Use Case: Integrating this table with the IGS_HE_SUB_RTN_QUAL table allows analysts to report on response rates and outcome statistics for different qualifying periods and return subclasses, facilitating compliance monitoring and strategic analysis.

Related Objects

The IGS_HE_STDNT_DLHE table has defined relationships with other critical EBS objects, primarily serving as a child table that references master data. The documented foreign key relationships are as follows:

• HZ_PARTIES: The table references HZ_PARTIES via the PERSON_ID column. This links each DLHE record to the core person/party entity in Oracle TCA, providing access to the student's biographic and demographic information.
• IGS_HE_SUB_RTN_QUAL: The table references IGS_HE_SUB_RTN_QUAL via a composite foreign key on the columns (SUBMISSION_NAME, USER_RETURN_SUBCLASS, RETURN_NAME, QUAL_PERIOD_CODE). This is the most critical relationship, as it ties the student's survey data to the specific configured submission return and qualifying period, ensuring data integrity for the reporting framework.

As the holder of the primary key IGS_HE_STDNT_DLHE_PK, this table is likely referenced by other objects in the IGS module, such as detail tables for specific survey sections or supporting views for reporting, though these are not specified in the provided metadata.