Search Results igs_pr_stdnt_pr_awd




Overview
Explore in AI Chat

Overview

The table IGS_PR_STDNT_PR_AWD is a data object within the Oracle E-Business Suite (EBS) Student System (IGS) module. Its primary function is to store the specific awards associated with the positive outcome of a rule applied to a student's program attempt. This table acts as a junction table, linking student progression outcomes to the formal awards (e.g., degrees, certificates) that a student becomes eligible for upon meeting defined academic criteria. It is critical to note that the IGS module is marked as "Obsolete" in the provided metadata, indicating it is a legacy component. Furthermore, the documentation explicitly states the table is "Not implemented in this database," suggesting it may not be present in all deployments or may have been superseded in later versions like 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is defined by its primary key and foreign key relationships. The primary key uniquely identifies each award record for a student's program rule outcome and is a composite of four columns: PERSON_ID, COURSE_CD, SPO_SEQUENCE_NUMBER, and AWARD_CD. The PERSON_ID and COURSE_CD columns identify the specific student and their academic program. The SPO_SEQUENCE_NUMBER links to the specific progression outcome rule that was satisfied. The AWARD_CD is a foreign key that stores the code for the actual award (e.g., BSC, MBA) granted as a result. This design ensures a student can have multiple potential awards recorded for different rule outcomes within the same program attempt.

Common Use Cases and Queries

The primary use case for this table is reporting and process automation related to student graduation and award conferral. It enables institutions to query which students have qualified for which awards based on automated progression rules. A typical query would join this table to student personal, program attempt, and award definition tables to generate a list of pending conferrals. For example, a SQL pattern to identify awards for a specific student might be: SELECT awd.AWARD_CD, ps.AWARD_TITLE FROM IGS_PR_STDNT_PR_AWD spa JOIN IGS_PS_AWD awd ON spa.AWARD_CD = awd.AWARD_CD WHERE spa.PERSON_ID = :student_id AND spa.COURSE_CD = :course_code; Given the "Obsolete" status, direct operational use in active processes in versions 12.1.1/12.2.2 is unlikely; its main utility would be for historical data extraction or migration from legacy implementations.

Related Objects

Based on the documented foreign key relationships, IGS_PR_STDNT_PR_AWD has direct dependencies on two core tables:

  • IGS_PS_AWD: This table defines the valid award codes. The relationship is enforced via the AWARD_CD column in IGS_PR_STDNT_PR_AWD referencing IGS_PS_AWD.AWARD_CD. This ensures referential integrity for the award data.
  • IGS_PR_STDNT_PR_OU_ALL: This table stores the student progression outcome records. The relationship is a composite foreign key where the columns (PERSON_ID, COURSE_CD, SPO_SEQUENCE_NUMBER) in IGS_PR_STDNT_PR_AWD reference the corresponding columns in IGS_PR_STDNT_PR_OU_ALL. This links the awarded credential directly to the specific rule outcome that triggered it.
These relationships are fundamental, positioning IGS_PR_STDNT_PR_AWD as a child table that draws its context from both the award master and the student progression engine.