Results for “igs_pe_alternatv_ext”

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

Overview

The IGS.IGS_PE_ALTERNATV_EXT table is a core configuration object in the Oracle E-Business Suite Student System (IGS) product family, present in both release 12.1.1 and 12.2.2. It defines the permissible alternative exit points from a course offering — that is, the alternate award or qualification a student may receive upon early withdrawal from a primary course, typically granted at a lower academic level. Each record associates a primary course and version with an exit course that serves as the substitute exit point. The table is classified heuristically as satellite-leaning under a Data Vault modeling convention, given its descriptive attributes keyed off the course/version business hub and its limited inbound references; this classification is a modeling suggestion rather than a physical implementation constraint.

Key Information Stored

The table contains nine documented columns in the 12.1.1 physical schema. The most significant are:

• COURSE_CD — the code of the primary course from which an alternative exit applies. Part of the composite primary key.
• VERSION_NUMBER — the version of the primary course. Combined with COURSE_CD it pins the specific course version against IGS_PS_VER_ALL.
• EXIT_COURSE_CD — the course code representing the alternative exit award. Part of the primary key and a foreign key to IGS_PS_COURSE.
• EXIT_VERSION_SET — controls version-set selection for the exit course, influencing which version of the exit course is resolved at runtime.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle EBS WHO-column audit attributes tracking row provenance and change history.

The surrogate primary key IGS_PE_ALTERNATV_EXT_PK is defined over (COURSE_CD, VERSION_NUMBER, EXIT_COURSE_CD). A unique index IGS_PE_ALTERNATV_EXT_U1 mirrors the same three columns, confirming the natural business key.

Common Use Cases and Queries

Typical use cases include curriculum configuration validation, student exit-award eligibility checks, and reporting on alternate qualification pathways. A representative query retrieving all exit options for a given course version:

SELECT a.course_cd, a.version_number, a.exit_course_cd, a.exit_version_set
FROM   igs.igs_pe_alternatv_ext a
WHERE  a.course_cd = :course_cd
AND    a.version_number = :version_number;

To resolve the exit course title, join to IGS_PS_COURSE:

SELECT a.course_cd, c.course_title
FROM   igs.igs_pe_alternatv_ext a, igs.igs_ps_course c
WHERE  a.exit_course_cd = c.course_cd;

These patterns support admissions reporting, curriculum catalogues, and audit reviews of exit-point configuration.

Related Objects

• IGS_PS_COURSE — referenced by EXIT_COURSE_CD; supplies the exit course descriptive record.
• IGS_PS_VER_ALL — referenced by COURSE_CD and VERSION_NUMBER; provides the primary course version.
• IGS_PS_STDNT_APV_ALT — references this table via COURSE_CD, VERSION_NUMBER, and EXIT_COURSE_CD; records student-specific alternative approval records tied to the exit configuration.

Together these tables form the exit-award configuration and approval chain within the IGS Student System.