Search Results igs_as_sc_attempt_h_all

Overview

The IGS_AS_SC_ATTEMPT_H_ALL table is a core data object within the Oracle E-Business Suite Student System (IGS). It functions as a historical audit table, systematically recording all changes made to a student's program (or course) attempt over time. In the context of academic administration, a program attempt represents a student's enrollment and progression in a specific academic program. This table is critical for maintaining a complete, immutable audit trail, enabling institutions to reconstruct the state of a student's academic record at any point in the past. Its role is essential for compliance, reporting, troubleshooting data issues, and supporting complex academic processes where understanding the evolution of a student's status is required.

Key Information Stored

The table's structure is designed to capture the historical snapshot of a student program attempt. The primary key uniquely identifies each historical record and consists of the PERSON_ID (identifying the student), the COURSE_CD (identifying the academic program), and the HIST_START_DT (the effective date when this historical version became valid). Other significant columns, as indicated by the foreign key relationships, include IGS_PR_CLASS_STD_ID, which links to the student's class standing or progression level, and COO_ID, which links to the specific Course Offering Option that defines the program's version and rules the student is attempting. The table will inherently contain copies of all relevant attributes from the main student course attempt record at the time of each change, such as academic load, status, and key dates.

Common Use Cases and Queries

Primary use cases involve auditing and historical analysis. A common scenario is investigating the sequence of status changes for a student who has withdrawn or been discontinued from a program. Another is generating reports on program attempt trends over specific periods for accreditation. Sample SQL patterns typically involve querying the table for a specific student and program, ordered by historical date to see the progression.

• Audit Trail for a Student: SELECT hist_start_dt, sca_status, academic_load FROM igs_as_sc_attempt_h_all WHERE person_id = 12345 AND course_cd = 'BSC-CS' ORDER BY hist_start_dt DESC;
• Finding a Record's State at a Past Date: Queries often use a subquery to find the most recent historical record on or before a given date.
• Data Repair: The table is referenced to understand incorrect data flows and to validate corrective scripts by comparing current and historical values.

Related Objects

This history table is intrinsically linked to the main transactional table for student course attempts (typically named IGS_AS_SC_ATTEMPT_ALL). It maintains direct foreign key relationships to other fundamental tables in the Student System, as documented. The foreign key to IGS_PR_CLASS_STD links student progression data, while the foreign key to IGS_PS_OFR_OPT_ALL (via COO_ID) ties the attempt to the specific offering of the program. It is also commonly referenced by institutional reports, data warehouse extracts, and APIs responsible for student academic history. Understanding these relationships is crucial for writing accurate joins in complex historical reports.