Search Results igs_ps_award




Overview
Explore in AI Chat

Overview

The IGS_PS_AWARD table is a core data entity within the Oracle E-Business Suite Student System (IGS). It serves as a critical junction table that defines the relationship between academic programs and the specific awards (e.g., degrees, diplomas, certificates) conferred upon a student's successful completion. The table's design explicitly supports the academic model where a single program version can lead to zero, one, or multiple distinct awards. This flexibility is essential for accurately modeling complex academic structures, such as dual-degree programs or programs with nested exit qualifications. Its role is to formally link a program's curriculum definition to its official academic outcomes, forming a foundational element for degree audit, graduation processing, and academic reporting.

Key Information Stored

The table's structure is defined by a composite primary key that uniquely identifies each program-to-award mapping. The key columns are COURSE_CD and VERSION_NUMBER, which together identify the specific program version from the IGS_PS_VER_ALL table, and AWARD_CD, which identifies the award code from the IGS_PS_AWD table. Beyond this key, the table may contain additional descriptive or control columns (not fully detailed in the provided metadata) such as creation dates, who created the record, and potentially sequence numbers or status indicators to manage multiple awards for a single program. The integrity of the data is enforced by foreign key constraints back to the parent tables for programs and awards.

Common Use Cases and Queries

This table is central to queries that determine what a student is eligible to receive upon completing their studies. Common use cases include generating a list of all awards offered by a specific program, validating award eligibility during the graduation clearance process, and supporting academic catalog reports. A typical reporting query would join IGS_PS_AWARD to the program version and award description tables. For example, to list all awards for a given program, one might use: SELECT awd.award_cd, awd.description FROM igs_ps_award a, igs_ps_awd awd WHERE a.award_cd = awd.award_cd AND a.course_cd = :p_course_cd AND a.version_number = :p_version_number; Another critical use is within batch processes for degree conferral, where the system references this table to identify which award records to create for graduating students based on their completed program.

Related Objects

  • IGS_PS_VER_ALL: The parent table for program versions. The foreign key (COURSE_CD, VERSION_NUMBER) in IGS_PS_AWARD references this table, establishing the "program" side of the relationship.
  • IGS_PS_AWD: The parent table containing the master definition of all award codes (e.g., BSc, MA, PhD). The foreign key AWARD_CD in IGS_PS_AWARD references this table.
  • IGS_PS_AWD_OWN: A child table that likely stores additional ownership or responsibility details specific to an award within the context of a program, as it references the full primary key of IGS_PS_AWARD.