Search Results igs_uc_app_stats




Overview
Explore in AI Chat

Overview

The IGS_UC_APP_STATS table is a core data object within the Oracle E-Business Suite (EBS) Student System (IGS) module, specifically for versions 12.1.1 and 12.2.2. Its primary role is to store applicant-level statistical data mandated for reporting to the Higher Education Statistics Agency (HESA) in the United Kingdom. The table acts as a critical integration point, synchronizing its data with external HESA reporting systems, denoted as 'ivStarH' and 'ivStarX' in the documentation. This ensures the institution can accurately compile and submit legally required statistical returns on its applicant population.

Key Information Stored

The table is designed to hold applicant data specifically curated for HESA purposes. While a full column list is not provided in the metadata, the documented primary and unique keys reveal its fundamental structure. Each record is uniquely identified by a system-generated APP_STAT_ID (primary key). Crucially, the table also enforces a unique constraint on the APP_NO (application number), ensuring a one-to-one relationship with a specific applicant. The foreign key column APP_ID links directly to the base applicant record in the IGS_UC_APPLICANTS table, anchoring the statistical data to a real applicant entity within the system.

Common Use Cases and Queries

The principal use case for this table is the generation and validation of HESA applicant returns. Data from this table is extracted, transformed, and loaded into the ivStar systems for official submission. Common operational and reporting activities include auditing data completeness, reconciling records between EBS and the HESA submission tools, and analyzing applicant demographics for statutory reporting. A typical query would join this table to the main applicant table to retrieve a consolidated record for HESA processing.

SELECT apps.app_no, apps.person_id, stats.*
FROM igs_uc_applicants apps,
     igs_uc_app_stats stats
WHERE apps.app_id = stats.app_id
AND apps.admission_cat = '<CATEGORY>';

Related Objects

The table maintains a direct and essential relationship with the core applicant table, as documented in the provided metadata.

  • IGS_UC_APPLICANTS: This is the primary parent table. The foreign key relationship is defined as IGS_UC_APP_STATS.APP_ID references IGS_UC_APPLICANTS. This ensures every statistical record is associated with a valid applicant. The join condition for queries is typically IGS_UC_APPLICANTS.APP_ID = IGS_UC_APP_STATS.APP_ID.

Its synchronization with the external 'ivStarH' and 'ivStarX' systems, while not a database object relationship, represents a critical data flow for regulatory compliance.