Search Results igs_re_scholarship_pk

Overview

The IGS_RE_SCHOLARSHIP_ALL table is a core data entity within the Oracle E-Business Suite Student System (IGS) modules, specifically for releases 12.1.1 and 12.2.2. It serves as the master repository for detailed scholarship records associated with student candidatures. Its primary role is to track the assignment and duration of various scholarship types to individual students, forming a critical component of the institution's research and financial aid management. As a multi-organization table, denoted by the "_ALL" suffix, it is designed to store data partitioned by the operating unit, enabling support for complex, multi-org deployment structures within a single installation.

Key Information Stored

The table's structure is defined by a composite primary key that uniquely identifies each scholarship record. The key columns are PERSON_ID, which identifies the student; CA_SEQUENCE_NUMBER, which references a specific candidature (e.g., a research program) for that student; SCHOLARSHIP_TYPE, which classifies the award; and START_DT, which marks the commencement date of the scholarship. This primary key structure allows a student to have multiple scholarship records across different candidatures, of different types, or with different start dates. While the provided metadata does not list all columns, the foreign key relationships imply the storage of critical links to related entities, ensuring data integrity and enabling comprehensive reporting on scholarship tenure and eligibility.

Common Use Cases and Queries

This table is central to administrative processes and reporting in student financial aid and research administration. Common operational use cases include the assignment of a new scholarship to a research candidate, tracking active scholarships for a given academic period, and auditing historical scholarship data. For reporting, it is frequently joined with person and candidature tables to generate lists of funded students. A typical query pattern involves filtering by date ranges to identify current scholarship holders or aggregating data by scholarship type for funding analysis. A foundational SQL pattern to retrieve active scholarship details would join this table with IGS_RE_CANDIDATURE_ALL and IGS_RE_SCHL_TYPE_ALL.

Related Objects

The IGS_RE_SCHOLARSHIP_ALL table maintains defined integrity relationships with other key entities in the Student System, as documented in the ETRM metadata. Its foreign key dependencies are:

• IGS_RE_CANDIDATURE_ALL: The scholarship record is tied to a specific student candidature via the columns PERSON_ID and CA_SEQUENCE_NUMBER. This ensures a scholarship is always associated with a valid academic pursuit.
• IGS_RE_SCHL_TYPE_ALL: The SCHOLARSHIP_TYPE column references a valid code from this lookup table, which defines the categories and rules for different scholarship awards available within the institution.

The table is also the referenced parent for its primary key, IGS_RE_SCHOLARSHIP_PK. Other application modules, custom reports, and APIs will likely depend on this table as the authoritative source for scholarship assignment data.