Results for “igs_en_spaa_hist_pk”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_EN_SPAA_HIST is a table in the Oracle E-Business Suite Student System (IGS) product family, which is documented as obsolete in ETRM for releases 12.1.1 and 12.2.2. The table stores student program attempt award history, capturing the record of awards associated with a student's program attempt and the associated course and grading outcomes. In practical terms, it functions as a historical record of award conferral events tied to a person, a course, and an award code, with timestamps spanning the attempt's start and completion window.

The ETRM metadata notes that the object is "Not implemented in this database," meaning it is documented for reference but is not physically present in the target environment. The Data Vault classification mined from the foreign key structure is a link, which suggests modeling this object as a link table capturing relationships between students, courses, awards, and grading schemas, rather than as a hub or satellite. The physical schema is owned by IGS and consists of 16 documented columns.

Key Information Stored

The table's primary key is IGS_EN_SPAA_HIST_PK, defined on the composite of PERSON_ID, COURSE_CD, AWARD_CD, and CREATION_DATE. This composite uniquely identifies each award history record and is also the sole documented unique index, making it the primary business-key candidate as well as the surrogate identifier.

The most significant columns include: PERSON_ID, identifying the student; COURSE_CD, identifying the course associated with the attempt; and AWARD_CD, identifying the award being recorded. START_DATE and END_DATE bound the attempt period, while CONFERRAL_DATE records when the award was actually conferred. COMPLETE_FLAG indicates whether the attempt was completed. AWARD_MARK and AWARD_GRADE capture the assessed result, with GRADING_SCHEMA_CD and GS_VERSION_NUMBER specifying the grading scale and version applied. Standard audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — provide change tracking. Together these columns describe a student's award outcome for a given course attempt, with the grading schema context needed to interpret AWARD_GRADE.

Common Use Cases and Queries

Typical reporting scenarios include reconstructing a student's award history, verifying conferral dates for graduation audits, and analyzing grade distributions under a specific grading schema version. A representative query retrieves a student's award history ordered by conferral:

• SELECT person_id, course_cd, award_cd, conferral_date, award_grade FROM igs_en_spaa_hist WHERE person_id = :p_person ORDER BY conferral_date DESC;
• SELECT grading_schema_cd, gs_version_number, COUNT(*) FROM igs_en_spaa_hist GROUP BY grading_schema_cd, gs_version_number;
• Joins to IGS_EN_SPA_AWD_AIM via AWARD_CD, PERSON_ID, and COURSE_CD support resolving award aim definitions.

Because the table is not implemented in the documented database, these patterns should be validated against the actual environment before use.

Related Objects

The foreign key metadata identifies two directly referenced tables:

• IGS_EN_SPA_AWD_AIM — referenced through AWARD_CD, COURSE_CD, and PERSON_ID, providing award aim context.
• IGS_AS_GRD_SCH_GRADE — referenced through GRADING_SCHEMA_CD, GS_VERSION_NUMBER, and AWARD_GRADE, providing grading scale definitions.

Other IGS Student System tables related to person, course, and award entities — such as the base person and course definitions — are conceptually linked through PERSON_ID and COURSE_CD and are commonly joined in reporting. Given the obsolete status, related objects should be confirmed against the current data model before building dependencies.