Search Results igs_en_spaa_hist_n1

Overview

The IGS_EN_SPAA_HIST table is a core data repository within the Oracle E-Business Suite's Student Administration (Oracle EBS 12.1.1 / 12.2.2) module, specifically under the IGS (iGrants) schema. Its primary function is to maintain a historical record of awards associated with a student's program attempt. This table acts as an audit trail, capturing the lifecycle of an award—such as a degree or certificate—for a specific student and course combination over time. It is essential for tracking academic progression, final outcomes, and compliance reporting, serving as the system of record for conferred academic honors and qualifications.

Key Information Stored

The table's structure is centered on identifying the student, the program, and the award details. The mandatory key columns (PERSON_ID, COURSE_CD, AWARD_CD, CREATION_DATE) form a unique composite primary key (IGS_EN_SPAA_HIST_PK). Critical data points include temporal markers (START_DATE, END_DATE, CONFERRAL_DATE) and the definitive academic results. Notably, the AWARD_MARK column, as indicated by the user's search, stores the numerical mark or score achieved for the award. The AWARD_GRADE column stores the corresponding letter or descriptive grade, which is linked to a specific GRADING_SCHEMA_CD and GS_VERSION_NUMBER. The COMPLETE_FLAG indicates the final status of the award process.

Common Use Cases and Queries

This table is pivotal for generating official academic transcripts, degree audit reports, and award verification. A common reporting requirement is to retrieve the final awarded mark and grade for a student in a completed program. The following query pattern exemplifies this, filtering for completed awards and including the key result columns:

• Retrieve Award History for a Specific Student and Course:

  SELECT person_id, course_cd, award_cd,
         conferral_date, award_mark, award_grade
  FROM igs.igs_en_spaa_hist
  WHERE person_id = :p_student_id
    AND course_cd = :p_course_code
    AND complete_flag = 'Y'
  ORDER BY conferral_date DESC;

• Analyze Award Marks for a Cohort:

  SELECT course_cd, award_cd,
         AVG(award_mark) as avg_mark,
         COUNT(*) as num_awards
  FROM igs.igs_en_spaa_hist
  WHERE complete_flag = 'Y'
    AND award_mark IS NOT NULL
  GROUP BY course_cd, award_cd;

Related Objects

While the provided dependency information states this table does not reference other objects, it is inherently linked to core student and academic structures. It is logically related to tables storing person details (e.g., PER_ALL_PEOPLE_F), course definitions, and grading schema master data (IGS_AS_GRADING_SCH_VER). The table's primary key suggests it is a child entity of a student's program attempt record. Its data is likely populated and maintained by processes and APIs within the Student Administration module, particularly those handling award conferral and grade processing. The non-unique index IGS_EN_SPAA_HIST_N1 on grade-related columns supports efficient queries for grading analysis and reporting.