Search Results igs_ps_awd




Overview
Explore in AI Chat

Overview

The IGS_PS_AWD table is a core data object within the Oracle E-Business Suite (EBS) Student System (IGS) module, specifically for versions 12.1.1 and 12.2.2. It serves as the master repository for defining academic awards offered by an educational institution. An award, in this context, represents a formal qualification conferred upon a student, such as a degree, diploma, or certificate. The table's primary role is to establish the foundational definitions for all awards, which are then referenced throughout the student lifecycle in areas like program enrollment, progression, and graduation. Notably, the provided ETRM metadata explicitly labels the IGS - Student System as "Obsolete," indicating this table belongs to a legacy component that may have been superseded in later application versions or architectural updates.

Key Information Stored

The central piece of information stored is the award code (AWARD_CD), which serves as the table's primary key and the unique identifier for each award record. Based on the foreign key relationships documented, the table likely contains several other critical attributes. These include a link to the grading schema (GRADING_SCHEMA_CD and GS_VERSION_NUMBER), which defines the set of grades applicable to the award. It also references a testamur type (TESTAMUR_TYPE), which pertains to the physical certificate or parchment issued. While the full column list is not provided in the excerpt, typical data would encompass the award's full name, abbreviation, academic level, active status, and other configuration flags governing its rules and appearance on official documents.

Common Use Cases and Queries

This table is central to administrative and reporting functions concerning academic qualifications. Common operational use cases include setting up new awards for a curriculum, maintaining award rules, and generating official transcripts or testamurs. From a reporting perspective, queries often join IGS_PS_AWD to student enrollment or achievement tables to analyze award distributions. A fundamental query pattern involves retrieving active awards: SELECT award_cd, award_name FROM igs_ps_awd WHERE closed_ind = 'N';. Another critical use case is validating student progression by joining to tables like IGS_PS_AWARD (for program-award links) or IGS_EN_SPA_AWD_AIM (for student award aims) to ensure a student's enrolled award is valid and configured correctly within the system.

Related Objects

The IGS_PS_AWD table has extensive relationships with other entities in the Student System, as evidenced by its numerous foreign keys. Key dependent tables include:

  • IGS_PS_AWARD: Links awards to specific academic programs (courses of study).
  • IGS_EN_SPA_AWD_AIM: Stores a student's intended award aim within a program attempt.
  • IGS_AS_STU_TRN_CMTS: Holds student transcript comments potentially specific to an award.
  • IGS_PR_STDNT_PR_AWD: Records awards associated with student progression rules.
  • IGS_HE_UT_* tables (e.g., IGS_HE_UT_PRT_AWARD): Related to Higher Education (HE) utility functions, such as award hierarchies and reporting.
It also references master tables like IGS_AS_GRD_SCHEMA for grading rules and IGS_GR_TESTAMUR_TYPE for certificate types, forming a integral part of the student data model.