Search Results igs_ps_awd_hnr_base

Overview

The IGS_PS_AWD_HNR_BASE table is a core data object within the Oracle E-Business Suite Student System (IGS) module. It serves a critical function in the academic awards process by defining the precise calculation basis for determining a student's honors level for a specific academic award or program. The table stores configuration rules that specify how to derive an honors classification, such as First Class or Second Class Honors, by weighting marks from different unit levels (e.g., introductory, advanced). This configuration is essential for automating and standardizing honors calculations across the institution, ensuring consistency and adherence to academic policy within the EBS ecosystem.

Key Information Stored

The table's primary purpose is to store the relationship between an award, a unit level, and the statistical weight assigned to that level for honors calculation. The key columns include AWD_HNR_BASIS_ID, which is the unique primary key identifier for each rule. The AWARD_CD column links the rule to a specific academic award defined in the IGS_PS_AWD table. The UNIT_LEVEL column references a defined unit level from IGS_PS_UNIT_LEVEL_ALL, indicating which level of coursework is being weighted. The table also links to statistical type elements (via S_STAT_ELEMENT and STAT_TYPE referencing IGS_PR_STA_TYPE_ELE), which likely define the specific mark or grade element to be used in the calculation. Additional columns, implied by the table's purpose, would store the numerical weight or percentage contribution of the specified unit level toward the final honors determination.

Common Use Cases and Queries

The primary use case is the batch or real-time calculation of a student's prospective or final honors classification for their program. A system process would query this table for all rules associated with a student's award, retrieve the student's marks for the corresponding unit levels and statistical elements, apply the configured weightages, and compute an aggregate score to map to an honors level. Common reporting queries involve auditing the calculation rules for an award. A sample SQL pattern to list all calculation bases for an award would be:

• SELECT awhb.unit_level, awhb.weight, ul.unit_level_name FROM igs_ps_awd_hnr_base awhb JOIN igs_ps_unit_level_all ul ON awhb.unit_level = ul.unit_level WHERE awhb.award_cd = '&AWARD_CODE';

Another critical query would join with student mark data to perform the actual calculation or to validate configuration against student records.

Related Objects

The IGS_PS_AWD_HNR_BASE table is centrally connected to several key tables via foreign key relationships, as documented in the ETRM metadata. The primary key (AWD_HNR_BASIS_ID) uniquely identifies each rule. The table references the following objects:

• IGS_PS_AWD via AWARD_CD: This is the master table for academic awards. The relationship ensures that an honors calculation basis is always defined for a valid, existing award.
• IGS_PS_UNIT_LEVEL_ALL via UNIT_LEVEL: This table defines the academic unit levels (e.g., 100-level, 200-level) within the institution. The link specifies which level of units contributes to the honors calculation.
• IGS_PR_STA_TYPE_ELE via the composite foreign key (S_STAT_ELEMENT, STAT_TYPE): This table defines statistical type elements, which represent specific types of marks or grades (e.g., final mark, exam mark). This relationship defines the precise grade element from the unit attempt that should be used in the weighted calculation.

These relationships ensure data integrity and form the foundation for the honors derivation engine within the Student System.