Search Results igs_en_spa_awd_aim




Overview
Explore in AI Chat

Overview

The table IGS_EN_SPA_AWD_AIM is a core data object within the Oracle E-Business Suite Student System (IGS), now marked as obsolete. It serves as a transactional repository for managing a student's targeted academic awards within a specific program attempt. Its primary role is to track the lifecycle of an intended award—such as a degree or certificate—for a student enrolled in a course, recording its planned progression from initiation to completion. The table establishes critical relationships between a student's program enrollment, the defined award structures, and associated grading data, forming a central link in the academic records model.

Key Information Stored

The table's structure is defined by its composite primary key and supporting attributes. The primary key uniquely identifies a record through the combination of AWARD_CD, COURSE_CD, and PERSON_ID, directly linking a specific award to a specific student in a specific program. Essential data points stored include start and end dates for the targeted award, which define its active period, and a completion flag indicating whether the award objective has been met. The table also holds references to grading information via the GRADING_SCHEMA_CD, GS_VERSION_NUMBER, and AWARD_GRADE columns, which link to the institutional grading schema to define the grade associated with the award.

Common Use Cases and Queries

This table supports operational and reporting functions related to student academic planning and progression analysis. A common use case is generating a list of all active, targeted awards for students in a given program to monitor progress toward completion. Administrators might query this table to identify students whose award target end dates are approaching for proactive advising. A typical reporting query would join this table with student personal and program attempt details.

Sample Query Pattern:
SELECT spa.person_id, spa.course_cd, aim.award_cd, aim.start_dt, aim.completion_dt
FROM igs_en_spa_awd_aim aim,
igs_en_stdnt_ps_att_all spa
WHERE aim.person_id = spa.person_id
AND aim.course_cd = spa.course_cd
AND aim.completion_ind = 'N'
AND aim.end_dt > SYSDATE;

Related Objects

The table IGS_EN_SPA_AWD_AIM is integral to the Student System's data model, with defined foreign key relationships to and from other core tables.

  • Referenced Tables (Foreign Keys):
    • IGS_PS_AWD: Via AWARD_CD. Validates the award code against the institution's defined awards.
    • IGS_EN_STDNT_PS_ATT_ALL: Via PERSON_ID and COURSE_CD. Links the award target to the specific student program attempt record.
    • IGS_AS_GRD_SCH_GRADE: Via GRADING_SCHEMA_CD and GS_VERSION_NUMBER. References the grading schema to validate the AWARD_GRADE.
  • Referencing Table (Primary Key):
    • IGS_EN_SPAA_HIST: Via AWARD_CD, COURSE_CD, and PERSON_ID. This table likely stores historical changes or audit trails for records in IGS_EN_SPA_AWD_AIM.