Search Results derived_completion_perd




Overview
Explore in AI Chat

Overview

The IGS_AS_SC_ATTEMPT_H_ALL table, owned by the IGS schema within the Oracle E-Business Suite Student System product family, records the historical audit trail of changes applied to a student's program or course attempt. Where its sibling attempt table stores the current state of a student's enrollment and progression, IGS_AS_SC_ATTEMPT_H_ALL preserves prior versions of that record so that institutions can reconstruct how a student's attempt status, attendance mode, progression outcome, or completion details evolved over time. It is a date-effective history table: each row represents a distinct period of validity for the attempt, bounded by HIST_START_DT and HIST_END_DT.

In 12.1.1 the table is documented with 62 columns, and remains structurally consistent through 12.2.2. Because it carries reference relationships to IGS_PR_CLASS_STD (via IGS_PR_CLASS_STD_ID) and IGS_PS_OFR_OPT_ALL (via COO_ID), a data-vault heuristic classifies this object as a link — it connects student persons, course attempts, and offering option references across a defined time window. Practitioners modeling the student system should treat it as the historized link between attempts and their reference context rather than as an independent hub.

Key Information Stored

The primary key is IGS_AS_SC_ATTEMPT_H_ALL_PK, composed of PERSON_ID, COURSE_CD, and HIST_START_DT. A unique index, IGS_AS_SC_ATTEMPT_H_ALL_U1, is defined on the same three columns, confirming them as the documented business-key candidate. HIST_START_DT and HIST_END_DT together define the effective dating of each historical version.

The principal informational columns include:

Common Use Cases and Queries

Primary reporting scenarios include point-in-time reconstruction of a student's attempt status, regulatory returns requiring full attempt history, and auditing of status transitions such as discontinuation or lapse. A typical pattern filters by person and orders by history date:

  • Current-as-of query: SELECT * FROM igs_as_sc_attempt_h_all WHERE person_id = :p AND :as_of_dt BETWEEN hist_start_dt AND NVL(hist_end_dt, SYSDATE);
  • Change history: SELECT person_id, course_cd, hist_start_dt, hist_end_dt, course_attempt_status, progression_status FROM igs_as_sc_attempt_h_all WHERE person_id = :p ORDER BY course_cd, hist_start_dt;
  • Status-transition report: joining successive history rows per person/course to identify changes in COURSE_ATTEMPT_STATUS.

Because HIST_END_DT may be null for the most recent version, any as-of query should use NVL(HIST_END_DT, SYSDATE) to correctly capture open-ended rows.

Related Objects

The two documented foreign keys anchor this table to the wider student system:

  • IGS_PR_CLASS_STD — joined via IGS_AS_SC_ATTEMPT_H_ALL.IGS_PR_CLASS_STD_ID = IGS_PR_CLASS_STD.IGS_PR_CLASS_STD_ID, providing class standing context.
  • IGS_PS_OFR_OPT_ALL — joined via IGS_AS_SC_ATTEMPT_H_ALL.COO_ID = IGS_PS_OFR_OPT_ALL.COO_ID, supplying the offering option definition.
  • IGS_AS_SC_ATTEMPT_ALL — the current-state counterpart from which history rows are generated; queries commonly compare the two to identify deltas.
  • IGS_PS_ENR_ALL and IGS_PR_STUDY_ATTEMPT — related enrollment and study-attempt objects referencing the same student and course keys.
  • HZ_PARTIES / PERSON access via PERSON_ID for student biographical reporting.

Each relationship should be verified against the deployed schema, as column availability can vary by patch level.