Search Results igs_ps_stdnt_apv_alt_pk

Overview

IGS_PS_STDNT_APV_ALT is a transactional table in the Oracle E-Business Suite Student System (IGS) product family, owned by the IGS schema. In the ETRM 12.1.1 and 12.2.2 releases, the table is documented as VALID and is described as an "entity to capture the exit details from a program." In practical terms, the table stores the relationship between a student's approved program of study and the alternative or exit program (course and version) that the student transitions into. This makes it a core record for institutions that support articulation, transfer, or exit-award scenarios, where a learner begins in one program and completes or departs with credentials tied to a different program.

From a data-modeling perspective, the heuristic Data Vault classification mined from the foreign-key structure is link. The table therefore functions as an associative entity that connects a student's program attempt to an exit program definition, rather than as a hub of independent business keys or a satellite of descriptive attributes.

Key Information Stored

The documented physical schema contains 13 columns. The most significant are:

• PERSON_ID — the student (person) identifier; part of the composite primary key and a foreign key to IGS_EN_STDNT_PS_ATT_ALL.
• COURSE_CD — the program/course code of the original attempt; part of the primary key and a foreign key to IGS_PE_ALTERNATV_EXT and IGS_PS_VER_ALL.
• EXIT_COURSE_CD — the course code of the exit program; part of the primary key and a foreign key to IGS_PS_VER_ALL.
• EXIT_VERSION_NUMBER — the version of the exit program; part of the primary key and a foreign key to IGS_PS_VER_ALL.
• VERSION_NUMBER — the version of the originating course/program; a foreign key component to IGS_PS_VER_ALL.
• RQRMNTS_COMPLETE_IND — indicator that requirements were completed for the exit context.
• RQRMNTS_COMPLETE_DT — the date on which those requirements were completed.
• S_COMPLETED_SOURCE_TYPE — the source type describing how completion was recorded.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns.

The primary key is IGS_PS_STDNT_APV_ALT_PK (PERSON_ID, COURSE_CD, EXIT_COURSE_CD, EXIT_VERSION_NUMBER). A unique index, IGS_PS_STDNT_APV_ALT_U1, carries the same four columns and is the documented business-key candidate. There is no separate single-column surrogate key documented; the composite key itself serves as the unique identifier.

Common Use Cases and Queries

Typical reporting scenarios include identifying students who exit one program into another, validating completion of exit requirements, and auditing program-to-program articulation. A representative query joins the exit program to its version definition:

• SELECT a.PERSON_ID, a.COURSE_CD, a.EXIT_COURSE_CD, a.EXIT_VERSION_NUMBER, a.RQRMNTS_COMPLETE_DT FROM igs.igs_ps_stdnt_apv_alt a WHERE a.RQRMNTS_COMPLETE_IND = 'Y';
• Joining to IGS_PS_VER_ALL on EXIT_COURSE_CD and EXIT_VERSION_NUMBER to resolve exit program titles and attributes.
• Joining to IGS_EN_STDNT_PS_ATT_ALL on PERSON_ID and COURSE_CD to reconstruct a student's program attempt history.
• Linking to IGS_PE_ALTERNATV_EXT to trace the originating alternative program context.

Because audit columns are present, change-tracking and data-warehouse population queries (for example, extracting rows where LAST_UPDATE_DATE exceeds a watermark) are also standard.

Related Objects

• IGS_EN_STDNT_PS_ATT_ALL — referencing parent of PERSON_ID and COURSE_CD; holds student program attempt records.
• IGS_PE_ALTERNATV_EXT — referencing parent of COURSE_CD (and VERSION_NUMBER in the documented FK); holds alternative extension definitions.
• IGS_PS_VER_ALL — referenced twice, for (COURSE_CD, VERSION_NUMBER) and (EXIT_COURSE_CD, EXIT_VERSION_NUMBER); the program version master.
• IGS_PS_STDNT_APV_ALT_PK — the primary key constraint on the composite key columns.
• IGS_PS_STDNT_APV_ALT_U1 — the unique business-key index.

Together these objects form the dependency chain through which exit-program details are validated and reported within the Student System.