Search Results exit_course_cd




Overview
Explore in AI Chat

Overview

IGS_PE_ALTERNATV_EXT_V is a view owned by the APPS schema in Oracle E-Business Suite, defined within the Student Systems / People Enterprise (IGS) product family. It is a thin, column-for-column projection of the single base table IGS_PE_ALTERNATV_EXT, exposing alternative or "exit" course information associated with a primary course and version. The view forms part of the institution's academic structure configuration, where alternate exit awards, transfer pathways, or replacement course definitions are recorded against a parent course.

Because the view performs no joins, filters, aggregations, or transformations, it exists primarily as a stable, reportable interface onto the underlying table. In Oracle EBS release 12.1.1 and 12.2.2, such views are commonly used to shield external reports, integrations, and custom extensions from direct dependence on the physical table, and to provide a consistent naming and access layer for the IGS data model. The view retains standard WHO column audit attributes, so it can be used in any context requiring creation and update tracking.

Underlying Base Objects

The documented ETRM metadata identifies the source of every column as IGS_PE_ALTERNATV_EXT. The view definition is therefore a straightforward SELECT of all columns from that table, with no WHERE clause, DISTINCT, function, or set operator. No additional base tables, views, or synonyms are documented as referenced objects beyond the source table itself.

  • IGS_PE_ALTERNATV_EXT — the sole underlying table, holding one row per alternative/exit course association.
  • APPS.IGS_PE_ALTERNATV_EXT_V — the public synonym-accessible view defined over the above table.

Because the mapping is one-to-one, row counts and cardinality of the view are identical to the base table. Any DML executed against the view (where permitted) resolves directly to IGS_PE_ALTERNATV_EXT, subject to the standard APPS schema grants and any row-level security applied to the underlying object.

Key Columns

The view exposes nine columns. The first four are the functional academic-structure keys; the remainder are audit columns.

  • COURSE_CD — the parent course code to which the alternative/exit definition applies.
  • VERSION_NUMBER — the version of that parent course, distinguishing effective course catalog revisions.
  • EXIT_COURSE_CD — the course code that serves as the alternate or exit course. This is the column most commonly searched for in this context, as users trace which exit course is linked to a given parent course.
  • EXIT_VERSION_SET — the version set associated with the exit course, qualifying which version range of the exit course applies.
  • CREATED_BY, CREATION_DATE — standard WHO creation audit attributes.
  • LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO update audit attributes.

The composite of COURSE_CD, VERSION_NUMBER, EXIT_COURSE_CD, and EXIT_VERSION_SET effectively identifies each alternative-course relationship and is the natural key for lookup purposes.

Common Use Cases and Queries

Typical reporting scenarios include validating course-catalog configuration, tracing exit award mappings for student progression, and feeding downstream integration extracts. The following sample SQL illustrates common access patterns.

  • Retrieve all exit courses for a parent course:
    SELECT course_cd, version_number, exit_course_cd, exit_version_set FROM apps.igs_pe_alternatv_ext_v WHERE course_cd = :course_cd;
  • Find which parent courses use a given exit course:
    SELECT course_cd, version_number FROM apps.igs_pe_alternatv_ext_v WHERE exit_course_cd = :exit_course_cd;
  • Audit recent configuration changes:
    SELECT * FROM apps.igs_pe_alternatv_ext_v WHERE last_update_date >= :since_date ORDER BY last_update_date DESC;

Because no base objects beyond IGS_PE_ALTERNATV_EXT are documented, query tuning should follow the indexing of that table, and joins to other IGS academic-structure views should be performed by the reporting layer rather than assumed within this view.