Search Results key_program




Overview
Explore in AI Chat

Overview

The IGS_AS_SCAH_EFFECTIVE_H_V view belongs to the Oracle EBS Student System (IGS) product family and resides in the APPS schema. Its documented purpose is to create effective student program attempt history records that account for back-dated commencement and discontinuation dates. In practice, this view exposes a computed, "effective-dated" projection of student course attempt history rather than a raw table snapshot.

Unlike a plain extraction view, IGS_AS_SCAH_EFFECTIVE_H_V does not simply return stored column values. Each significant attribute is passed through a PL/SQL function that resolves the correct historic value given a person, a course, a history start date, and a course attempt status. The view therefore behaves as a rule-driven derivation layer that reconciles the base history rows with business-effective start and end dates, honouring back-dating corrections recorded against a student's program attempt.

Underlying Base Objects

The supplied ETRM metadata records no documented base objects for this view, and the view text excerpt is truncated before the FROM clause. On the basis of the referenced function signatures and the exposed columns, the view is defined over the student course attempt history table family (the SCAEH history entities that store person, course, history start/end dates, version number, calendar type, location, attendance attributes, commencement date, course attempt status, and derived attendance attributes).

The derivation is driven by IGS_EN_GET_SCAEH_DTL, a package that supplies the effective value resolvers: ENRP_GET_SCAEH_EFF_ST for effective start, ENRP_GET_SCAEH_EFF_END for effective end, and ENRP_GET_SCAEH_COL for the remaining attributed columns. Dates are converted using IGS_GE_DATE.IGSDATE and IGS_GE_DATE.IGSCHARDT. The UNIQUE qualifier indicates that the function call results can produce duplicate combinations from the underlying history rows, which are then collapsed.

Key Columns

  • PERSON_ID – Identifies the student whose attempt history is being projected.
  • COURSE_CD – The course against which the attempt is recorded; this is the column most frequently used as a search key.
  • Effective start / end – Computed by ENRP_GET_SCAEH_EFF_ST and ENRP_GET_SCAEH_EFF_END, resolving the true effective period of the attempt after back-dating.
  • VERSION_NUMBER – Numeric version of the history record returned by the column resolver.
  • CAL_TYPE – Calendar type associated with the attempt (truncated to 10 characters).
  • LOCATION_CD – Location of the attempt (truncated to 10 characters).
  • ATTENDANCE_MODE / ATTENDANCE_TYPE – Attendance attributes, truncated to 2 characters each.
  • STUDENT_CONFIRMED_IND – Single-character confirmation flag.
  • COMMENCEMENT_DT – Commencement date converted through IGSDATE/IGSCHARDT.
  • COURSE_ATTEMPT_STATUS – Status of the attempt, itself resolved and truncated to 10 characters.
  • DERIVED_ATT_TYPE / DERIVED_ATT_MODE – Derived attendance attributes returned by the resolver.

Common Use Cases and Queries

The view is typically used for reporting and integration where the true effective dates matter — for example, reconstructing a student's programme attempt history for statutory returns, or validating that back-dated commencement and discontinuation corrections have been applied consistently.

To retrieve all effective attempt history for a given student and course:

SELECT person_id, course_cd, course_attempt_status, commencement_dt
FROM apps.igs_as_scah_effective_h_v
WHERE person_id = :p_person_id
AND course_cd = :p_course_cd;

Because COURSE_CD is the key search column, a filter on it (optionally combined with PERSON_ID) is the standard access route. Note that the values returned are function-derived, so the view carries a performance cost relative to a direct table query and should be filtered as tightly as possible.