Search Results igs_ps_stdnt_apv_alt_u1

Overview

The table IGS.IGS_PS_STDNT_APV_ALT is a foundational Student System (IGS) transactional table in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to capture the exit details from a program — that is, the alternate exit award or exit program that a student is approved to receive in place of, or in addition to, the program in which the student is enrolled. Records in this table link a person to an enrolled program and to an approved exit program, together with the completion status of that exit program.

Under the heuristic Data Vault classification derived from its foreign-key structure, this object is best modeled as a link. It resolves a many-to-many style relationship between a person/program enrollment and an approved exit program, carrying descriptive completion attributes rather than acting as a standalone hub of a business entity. The table stores the association plus the qualifying detail (completion indicator, completion date, and source type), which is consistent with a link joined to a lightweight satellite of status attributes.

Key Information Stored

The physical schema in the 12.1.1 ETRM documentation defines 13 columns. The most significant are:

• PERSON_ID — the identifier of the person (student) for whom the alternate exit is recorded. This is a mandatory component of the primary key.
• COURSE_CD — the code identifying the program in which the student is enrolled; part of the business key.
• EXIT_COURSE_CD — the unique code of the approved exit program; the program being exited into.
• EXIT_VERSION_NUMBER — the version of the alternate exit program.
• VERSION_NUMBER — the version of the program in which the student is enrolled.
• RQRMNTS_COMPLETE_IND — indicates whether the student has completed the requirements of the exit program.
• RQRMNTS_COMPLETE_DT — the date on which the exit program requirements were completed.
• S_COMPLETED_SOURCE_TYPE — records whether the completion flag was applied by the system or manually.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Who audit columns present on almost all Oracle EBS tables.

The surrogate/business key is the primary key IGS_PS_STDNT_APV_ALT_PK (PERSON_ID, COURSE_CD, EXIT_COURSE_CD, EXIT_VERSION_NUMBER), which is also enforced through the unique index IGS_PS_STDNT_APV_ALT_U1. This composite uniquely identifies each student-to-exit-program approval.

Common Use Cases and Queries

Typical uses center on alternate exit reporting and student progression monitoring. A common pattern retrieves all alternate exits for a student, joining to the exit program definition via EXIT_COURSE_CD and EXIT_VERSION_NUMBER:

• Retrieving all students approved for a specific exit course: SELECT PERSON_ID, COURSE_CD FROM IGS_PS_STDNT_APV_ALT WHERE EXIT_COURSE_CD = :course AND EXIT_VERSION_NUMBER = :ver;
• Listing students whose exit requirements are complete: SELECT PERSON_ID, RQRMNTS_COMPLETE_DT FROM IGS_PS_STDNT_APV_ALT WHERE RQRMNTS_COMPLETE_IND = 'Y';
• Identifying manually completed cases for audit: SELECT * FROM IGS_PS_STDNT_APV_ALT WHERE S_COMPLETED_SOURCE_TYPE = 'MANUAL';
• Reporting alternate-exit counts per enrolled course using COURSE_CD and VERSION_NUMBER grouped by institution.

Related Objects

The table depends on several IGS objects through its foreign keys, and these relationships define its joins:

• IGS_PE_ALTERNATV_EXT — joined on COURSE_CD; provides the alternate exit configuration.
• IGS_PS_VER_ALL — referenced via EXIT_COURSE_CD and via COURSE_CD; supplies program version detail.
• IGS_EN_STDNT_PS_ATT_ALL — referenced via PERSON_ID; the student program attempt record that anchors enrollment context.

Reporting against this table usually joins these parents to resolve program names, versions, and person attributions. Because the table is a link rather than a hub, its rows are meaningful only in combination with the referenced program and person entities.