Search Results igs_pr_ou_awd

Overview

The IGS_PR_OU_AWD table is a core data object within the Oracle E-Business Suite Student System (IGS). It functions as a junction table, specifically designed to manage the relationship between progression rules for positive outcomes and the academic awards (e.g., degrees, certificates) to which those rules apply. Its primary role is to store the specific awards that are associated with a defined progression rule, thereby enabling the system to enforce academic standards and determine eligibility for particular qualifications based on a student's performance against established criteria.

Key Information Stored

The table's structure is defined by its composite primary key, which uniquely identifies each award-rule association. The key columns are PROGRESSION_RULE_CAT, PRA_SEQUENCE_NUMBER, and PRO_SEQUENCE_NUMBER, which together form a foreign key reference to a specific progression rule for a positive outcome in the IGS_PR_RU_OU_ALL table. The fourth primary key column, AWARD_CD, stores the code for the specific award and is a foreign key reference to the IGS_PS_AWD (Awards) table. This design ensures that for any given progression rule, the system can maintain a definitive list of applicable awards.

Common Use Cases and Queries

This table is central to processes involving academic progression and award eligibility. A primary use case is during the batch or real-time evaluation of a student's academic standing against progression rules; the system queries this table to determine which awards are governed by a specific rule. For reporting, administrators may query it to audit or list all awards linked to particular academic regulations. A typical SQL pattern involves joining to the parent rule and award tables:

• To list all awards for a specific progression rule: SELECT awd.AWARD_CD FROM IGS_PR_OU_AWD awd WHERE awd.PROGRESSION_RULE_CAT = :1 AND awd.PRA_SEQUENCE_NUMBER = :2 AND awd.PRO_SEQUENCE_NUMBER = :3;
• To find all rules associated with a specific award: SELECT rou.* FROM IGS_PR_OU_AWD awd JOIN IGS_PR_RU_OU_ALL rou ON awd.PROGRESSION_RULE_CAT = rou.PROGRESSION_RULE_CAT AND awd.PRA_SEQUENCE_NUMBER = rou.PRA_SEQUENCE_NUMBER AND awd.PRO_SEQUENCE_NUMBER = rou.PRO_SEQUENCE_NUMBER WHERE awd.AWARD_CD = :1;

Related Objects

The IGS_PR_OU_AWD table maintains critical referential integrity through documented foreign key relationships with two primary tables in the Student System:

• IGS_PR_RU_OU_ALL (Progression Rule Outcome): This is the parent table for the progression rule definition. IGS_PR_OU_AWD references it via the composite key (PROGRESSION_RULE_CAT, PRA_SEQUENCE_NUMBER, PRO_SEQUENCE_NUMBER). This link ties the award list to a specific rule instance.
• IGS_PS_AWD (Award): This is the master table for academic awards. IGS_PR_OU_AWD references it via the AWARD_CD column, ensuring that only valid, predefined award codes can be associated with a progression rule.

The table itself is referenced by its primary key constraint, IGS_PR_OU_AWD_PK, which enforces uniqueness for these relationships.